차량정보

테이블 (4)

car_information

  • car_number — int — 기본 키
  • type_car — varchar(255) — NOT NULL
  • registration_date — date — NOT NULL

customer_information

  • customer_number — int — 기본 키
  • customer_name — varchar(100) — NOT NULL
  • Date_of_subscription — date — NOT NULL
  • point — INT

maintenance_records

  • record_id — int — 기본 키 — NOT NULL
  • car_number — int — 외래 키 → car_information.car_number
  • repair_date — date
  • details — text
  • costs — number(38)

reservations

  • reservation_number — int — 기본 키
  • car_number (car_number2) — int — 외래 키 → car_information.car_number
  • customer_number (customer_number2) — int — 외래 키 → customer_information.customer_number
  • period — date
  • cost_won — int