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)