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