인터페이스
테이블 (5)
Member Table (회원)
- member_id (INT AUTO_INCREMENT PRIMARY KEY) — 기본 키 — NOT NULL
- name (VARCHAR(50) NOT NULL)
- phone (VARCHAR(15) NOT NULL UNIQUE)
- vehicle_id (INT)
Payment Table (결제)
- payment_id (INT AUTO_INCREMENT PRIMARY KEY) — 기본 키 — NOT NULL
- member_id (INT AUTO_INCREMENT PRIMARY KEY2) — 외래 키 → Member Table.member_id — NOT NULL
- amount (DECIMAL(10,2) NOT NULL)
- payment_status (ENUM('완료', '미결제', '환불') NOT NULL)
Reservation Table (예약)
- reservation_id (INT AUTO_INCREMENT PRIMARY KEY) — 기본 키 — NOT NULL
- member_id (INT AUTO_INCREMENT PRIMARY KEY2) — 외래 키 → Member Table.member_id — NOT NULL
- reservation_date (DATETIME NOT NULL)
- service_type (VARCHAR(50) NOT NULL)
Service History Table (정비 이력)
- service_id (INT AUTO_INCREMENT PRIMARY KEY) — 기본 키 — NOT NULL
- vehicle_number (VARCHAR(20) PRIMARY KEY) — 외래 키 → Vehicle Table.vehicle_number — NOT NULL
- service_details (TEXT NOT NULL)
- service_date (DATETIME NOT NULL)
Vehicle Table (차량)
- vehicle_number (VARCHAR(20) PRIMARY KEY) — 기본 키 — NOT NULL
- member_id (INT AUTO_INCREMENT PRIMARY KEY) — 외래 키 → Member Table.member_id — NOT NULL
- model (VARCHAR(50) NOT NULL)
- year (YEAR NOT NULL)