렌터카
테이블 (4)
customers (고객)
- customer_number — int — 기본 키 — NOT NULL
- customer_name — varchar(10)
- join_date — DATE
- points — INT
maintenance_records (정비기록)
- repair_number — INT — 기본 키 — NOT NULL
- vehicle_number (vehicle_number2) — varchar(10) — 외래 키 → vehicles.vehicle_number — NOT NULL
- customer_number (repair_number2) — int — 외래 키 → vehicles.customer_number — NOT NULL
- vehicle_number — varchar(10)
- customer_number — int
- repair_date — DATE
- description — TEXT
- cost — DECIMAL(10,2)
reservations (예약)
- reservation_id — int — 기본 키 — NOT NULL
- customer_number (repair_number) — int — 외래 키 → customers.customer_number — NOT NULL
- customer_number (customer_number2) — int
- vehicle_number — VARCHAR(10)
- customer_number — INT
- reservation_date — DATE
vehicles (차량)
- vehicle_number — varchar(10) — 기본 키 — NOT NULL
- customer_number (repair_number) — int — 외래 키 → customers.customer_number — NOT NULL
- customer_number — int
- vehicle_type — varchar(50)
- registration_date — DATE