rental
Tables (4)
customer
- customer no (cust_no) — varchar2 — Primary key — NOT NULL
- customer name (customer_name) — varchar2
- address — varchar2
- phone (phonr) — varchar2
- c_type — varchar2
rent office (office)
- Office No (off_no) — number — Primary key — NOT NULL
- address — varchar2
- telephone (phone) — varchar2 — NOT NULL
rental
- contract number (Cno) — varchar2 — Primary key — NOT NULL
- Office No (off_no) — number — Foreign key → rent office.Office No — NOT NULL
- car no (c_no) — varchar — Foreign key → truck.car no — NOT NULL
- customer no (cust_no) — varchar2 — Foreign key → customer.customer no — NOT NULL
- customer no (Cust_no) — varchar2
- rental office (rent_office) — number
- rental miles (rent_miles) — number
- return office (return _ffice) — number
- return_miles — number
- Office No (off_no2) — number — Foreign key → rent office.Office No — NOT NULL
truck
- car no (c_no) — varchar — Primary key — NOT NULL
- Truck type (type) — varchar
- last fixed date (fixed_date) — date
- end date — date