camping
Tables (6)
CampingCar
- car_num — VARCHAR(8) — Primary key — NOT NULL
- rental_co — VARCHAR (80) — Foreign key → RentalCo.name — NOT NULL
- model — VARCHAR(20)
Customer
- id — VARCHAR(13) — Primary key — NOT NULL
- name — VARCHAR(30)
- contact — VARCHAR(11)
- address — VARCHAR(80)
Rental
- car_num — VARCHAR(8) — Foreign key → CampingCar.car_num — NOT NULL
- customer_id — VARCHAR(13) — Foreign key → Customer.id — NOT NULL
- start_date — DATE
- end_date — INTEGER
- price — INTEGER
- Insurance — VARCHAR(30)
RentalCo
- name — VARCHAR(80) — Primary key — NOT NULL
- address — VARCHAR(80)
- contact — VARCHAR(11)
RepairInfo
- car_num — VARCHAR(8) — Foreign key → CampingCar.car_num — NOT NULL
- repair_shop — VARCHAR(80) — Foreign key → RepairShop.name — NOT NULL
- detail — VARCHAR(200)
- start_date — DATE
- duration — INTEGER
- cost — INTEGER
RepairShop
- name — VARCHAR(80) — Primary key — NOT NULL
- address — VARCHAR(80)
- contact — VARCHAR(11)