practice1
Tables (6)
Untitled (CAR)
- Key (CAR_ID) — BIGINT — Primary key — NOT NULL
- Field (TYPE) — VARCHAR
Untitled (LOCATION)
- Key (LOCATION_ID) — BIGINT — Primary key — NOT NULL
- Field (CITY) — VARCHAR
Untitled (CAR_LOCATION)
- Key (LOCATION_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (CAR_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (CUSTOMER)
- Key (CUSTOMER_ID) — BIGINT — Primary key — NOT NULL
- Field (NAME) — VARCHAR
- Field (ADDRESS) — VARCHAR
Untitled (RETURN)
- Key (RETURN_ID) — BIGINT — Primary key — NOT NULL
- Key (CUSTOMER_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (LOCATION_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (TIME) — DATE
- Field (ODOMETER) — INT
- Field (FULL_TANK) — INT
- Field (CITY) — VARCHAR
- Field (PHONE_NUMBER) — VARCHAR
Untitled (RESERVE)
- Key (RESERVE_ID) — BIGINT — Primary key — NOT NULL
- Key (LOCATION_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (CUSTOMER_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (VEHICLE_TYPE) — VARCHAR
- Field (PICKUP_DATE) — DATE
- Field (RETURN_DATE) — DATE
- Field (PHONE_NUMBER) — VARCHAR