차량정보
테이블 (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