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