car_rental

Tables (5)

Untitled (customer_request)

  • Key (rental_order_id) — varchar2(100) — Primary key — NOT NULL
  • Key (car_id) — varchar2(100) — Foreign key → car_list.Key — NOT NULL
  • Field (option_id) — Foreign key → Untitled.Field
  • Key (location_id) — Foreign key → car_list.Key — NOT NULL
  • Key (driver_id) — Foreign key → car_list.Key — NOT NULL
  • Field (customer_id) — varchar2(100)

Untitled (car_option_list)

  • Field (option_id) — Primary key
  • Field (option_name)
  • Field2 (option_price)

Untitled (pricing)

  • Key (pricing_id) — Primary key — NOT NULL
  • Key (car_id) — varchar2(100) — Foreign key → car_list.Key — NOT NULL
  • Key (location_id) — Foreign key → car_list.Key — NOT NULL
  • Key (driver_id) — Foreign key → car_list.Key — NOT NULL
  • Field (travelled_distance)
  • Field2 (calculated_price)

Untitled (driver_list)

  • Key (driver_id) — Primary key — NOT NULL
  • Field (driver_name)

car_list

  • Key (car_id) — varchar2(100) — Primary key — NOT NULL
  • Key (location_id) — Foreign key — NOT NULL
  • Key (driver_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (car_model_name) — varchar2(100)
  • Field (car_type) — varchar2(10)
  • Field (rent_available)
  • Field (rented_date)
  • Field2 (returned_date)
  • Field (rented_location)
  • Field2 (returned_location)