수리 예약 (Ver.1)
테이블 (7)
Appliance
- id — INT
- user_id — INT — NOT NULL
- type — VARCHAR(50) — NOT NULL
- brand — VARCHAR(50) — NOT NULL
- model — VARCHAR(50) — NOT NULL
- serial_number — VARCHAR(50) — NOT NULL
Appointment
- id — INT
- repair_request_id — INT — NOT NULL
- technician_id — INT — NOT NULL
- scheduled_date — DATETIME — NOT NULL
- status — ENUM('예정', '완료') — NOT NULL
Payment
- id — INT
- repair_request_id — INT — NOT NULL
- amount — DECIMAL(10,2) — NOT NULL
- payment_date — DATETIME
- method — ENUM('카드', '현금') — NOT NULL
Repair_Request
- id — INT
- user_id — INT — NOT NULL
- appliance_id — INT — NOT NULL
- description — TEXT — NOT NULL
- request_date — DATETIME
- status — ENUM('대기', '진행 중', '완료') — NOT NULL
Technician
- id — INT
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- skill_level — VARCHAR(50) — NOT NULL
User
- id — INT
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL