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)