Data Dictionary - Cab Booking System
Table Name Column Name Data Type Description Constraints
Unique identifier for Primary Key, Auto
Drivers DriverID INT
each driver Increment
Name VARCHAR(100) Name of the driver Not Null
LicenseNumber VARCHAR(20) Driver's license number Unique, Not Null
Contact phone number
PhoneNumber VARCHAR(15) Not Null
of the driver
Email address of the
Email VARCHAR(100) Unique
driver
Current status of the
Status VARCHAR(20) driver (e.g., Active, Not Null
Inactive)
Unique identifier for Primary Key, Auto
Cabs CabID INT
each cab Increment
Cab's license plate
LicensePlate VARCHAR(15) Unique, Not Null
number
Model VARCHAR(50) Model of the cab Not Null
Color VARCHAR(20) Color of the cab Not Null
Identifier for the driver Foreign Key
DriverID INT
assigned to the cab (Drivers)
Current status of the
Status VARCHAR(20) cab (e.g., Available, On Not Null
Ride)
Unique identifier for Primary Key, Auto
Rides RideID INT
each ride Increment
Identifier for the driver Foreign Key
DriverID INT
assigned to the ride (Drivers)
Identifier for the cab
CabID INT Foreign Key (Cabs)
used in the ride
Identifier for the
Foreign Key
CustomerID INT customer who booked
(Customers)
the ride
Starting location of the
StartLocation VARCHAR(255) Not Null
ride
Ending location of the
EndLocation VARCHAR(255) Not Null
ride
Time when the ride
StartTime DATETIME Not Null
started
Time when the ride
EndTime DATETIME Null
ended
Fare DECIMAL(10,2) Fare charged for the ride Not Null
Current status of the
Status VARCHAR(20) ride (e.g., Completed, Not Null
Canceled)
Unique identifier for Primary Key, Auto
Customers CustomerID INT
each customer Increment
Name VARCHAR(100) Name of the customer Not Null
Contact phone number
PhoneNumber VARCHAR(15) Not Null
of the customer
Email address of the
Email VARCHAR(100) Unique
customer
Unique identifier for Primary Key, Auto
Payments PaymentID INT
each payment Increment
Identifier for the ride
RideID INT associated with the Foreign Key (Rides)
payment
Date and time when the
PaymentDate DATETIME Not Null
payment was made
Amount paid for the
Amount DECIMAL(10,2) Not Null
ride
Method of payment
PaymentMethod VARCHAR(20) Not Null
(e.g., Credit Card, Cash)
Unique identifier for Primary Key, Auto
Locations LocationID INT
each location Increment
Address VARCHAR(255) Address of the location Not Null
City where the location
City VARCHAR(100) Not Null
is situated
State where the location
State VARCHAR(100) Not Null
is situated
ZIP or postal code of the
ZipCode VARCHAR(10) Not Null
location