TN BUS TRACKING AND MANAGEMENT SYSTEM
Bus
Users
Drivers
Routes
Bus Stops
Booking
Complaints
Duty
⬅ Back to Data
BOOKINGS STRUCTURE
Field
Type
Null
Key
Default
Extra
booking_id
int
NO
PRI
auto_increment
traveler_id
int
YES
MUL
trip_id
int
YES
MUL
booking_date
timestamp
NO
CURRENT_TIMESTAMP
DEFAULT_GENERATED
status
enum('Pending','Confirmed','Cancelled')
YES
Pending