ITS
Tables (11)
Availablity
- Flag — CHAR(1) — Primary key — NOT NULL
- Vehicle Id — VARCHAR(10) — Foreign key → Vehicle Assets.Vehicle Id — NOT NULL
Booking Service
- Booking Number — INT — Primary key — NOT NULL
- Flag — CHAR(1) — Foreign key → Availablity.Flag — NOT NULL
- Vehicle Id — VARCHAR(10) — Foreign key → Availablity.Vehicle Id — NOT NULL
- License Number — VARCHAR(18) — Foreign key → Driver.License Number — NOT NULL
Countries
- Country — VARCHAR(10) — Primary key — NOT NULL
- Language — VARCHAR(10) — Primary key — NOT NULL
Date and Odometer
- Booking Number — INT — Foreign key → Booking Service.Booking Number — NOT NULL
- Start_Date_Time — DATETIME
- End_Date_Time — DATETIME
- Start_Odometer — INT
- End_Odometer — INT
Driver
- License Number — VARCHAR(18) — Primary key — NOT NULL
- Language — VARCHAR(10) — Foreign key → Countries.Language — NOT NULL
- Name — VARCHAR(10)
- Clearance Level — INT
FATL
- License Number — VARCHAR(18) — Foreign key → Driver.License Number — NOT NULL
- Level — INT
- Qualification Date — DATE
Location
- Booking Number — INT — Foreign key → Booking Service.Booking Number — NOT NULL
- Pick_UP_Location — VARCHAR(40)
- Drops_Off_Location — VARCHAR(40)
- Location_Type — VARCHAR(10)
MR Service
- Vehicle Id — VARCHAR(10) — Foreign key → Vehicle Assets.Vehicle Id — NOT NULL
- Flag — CHAR(1) — Foreign key → Availablity.Flag — NOT NULL
- MR — CHAR(1)
- Final Cost — INT
- Description — VARCHAR(100)
- Date — DATE
- Odometer — INT
Officials
- Country — VARCHAR(10) — Foreign key → Countries.Country — NOT NULL
- Language — VARCHAR(10) — Foreign key → Countries.Language — NOT NULL
- Booking Number — INT — Foreign key → Booking Service.Booking Number — NOT NULL
- Name — VARCHAR(10)
- Role — VARCHAR(10)
- City Id — VARCHAR(8) — NOT NULL
STLVT
- License Number — VARCHAR(18) — Foreign key → Driver.License Number — NOT NULL
- Level — INT
- Qualification Date — DATE
- Certifying Authority — VARCHAR(30)
Vehicle Assets
- Vehicle Id — VARCHAR(10) — Primary key — NOT NULL
- Registration Id — VARCHAR(10)
- Manufacturer — VARCHAR(10)
- Model — VARCHAR(10)
- Color — VARCHAR(10)
- Current Odometer — INT
- Passenger Capacity — INT