신고 서비스
테이블 (6)
CommonUser
- id — UUID — 기본 키
- username — VARCHAR(255) — NOT NULL
- first_name — VARCHAR(255)
- last_name — VARCHAR(255)
- full_name — VARCHAR(255)
- email — VARCHAR(255)
- phone_number — VARCHAR(255)
- employee_no — VARCHAR(255)
- duty_name — VARCHAR(255)
- department_name — VARCHAR(255)
- status — VARCHAR(50) — NOT NULL
DispatchUser
- id — UUID — 기본 키
- report_id — UUID — 외래 키 → Report.id
- user_id — UUID — 외래 키 → CommonUser.id
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP — NOT NULL
DispatchVehicle
- id — UUID — 기본 키
- report_id — UUID — 외래 키 → Report.id
- vehicle_id — UUID — 외래 키 → Vehicle.id
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP — NOT NULL
Report
- id — UUID — 기본 키
- report_status — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP — NOT NULL
- status — VARCHAR(50) — NOT NULL
- reporter_id — UUID — 외래 키 → CommonUser.id
- receptionist_id — UUID — 외래 키 → CommonUser.id
StarRating
- id — UUID — 기본 키
- report_id — UUID — 외래 키 → Report.id
- rating — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP — NOT NULL
Vehicle
- id — UUID — 기본 키
- number — VARCHAR(255) — NOT NULL
- type — VARCHAR(255)
- vehicle_status — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- modified_at — TIMESTAMP — NOT NULL
- status — VARCHAR(50) — NOT NULL