SDH

Tables (5)

Truck (Untitled2)

  • car no (c_no) — varchar2 — Primary key — NOT NULL
  • truck tupe (type) — varchar2
  • last fixed date (fixed_date) — date
  • end date (end_date) — date

contract

    customer

    • customer no (cust_no) — varchar2 — Primary key — NOT NULL
    • customer name (customer_name) — varchar2
    • address — varchar2
    • phone — varchar2
    • c_type — varchar2

    rent office (office)

    • Office No (off_no) — number — Primary key — NOT NULL
    • address — varchar2
    • telephone (phone) — varchar2

    rental (Untitled)

    • contract number (Cno) — varchar2 — Primary key — NOT NULL
    • Office No (rental office) — number — Foreign key → rent office.Office No — NOT NULL
    • car no (c_no) — varchar2 — Foreign key → Truck.car no — NOT NULL
    • customer no (cust_no2) — varchar2 — Foreign key → customer.customer no — NOT NULL
    • rental miles (rent_miles) — number
    • return miles (return_miles) — number
    • Office No (off_no) — number — Foreign key → rent office.Office No — NOT NULL