Mota
Tables (9)
alerts
- alert_id — UUID — Primary key — NOT NULL
- vehicle_id — UUID — NOT NULL
- tire_id — UUID — NOT NULL
- alert_level — ENUM — NOT NULL — WARNING/DANGER
- alert_title — VARCHAR(50)
- alert_time — TIMESTAMP — 발생시간
- created_at — DATETIME
- vehicle_id (vehicle_id2) — UUID — Foreign key → vehicles.vehicle_id — NOT NULL
checklist_answer
- answer_id — UUID — Primary key — NOT NULL
- submission_id — UUID — Foreign key → checklist_submission.submission_id — NOT NULL
- question_id — UUID — Foreign key → checklist_question.question_id — NOT NULL
- is_abnormal — BOOLEAN — NOT NULL
- text — VARCHAR(1000)
- created_at — DATETIME — NOT NULL
checklist_photos
- photo_id — UUID — Primary key — NOT NULL
- answer_id — UUID — Foreign key → checklist_answer.answer_id — NOT NULL
- photo_url — TEXT — NOT NULL
- uploaded_at — TIMESTAMP
checklist_question
- question_id — UUID — Primary key — NOT NULL
- question_text — VARCHAR(255) — NOT NULL
- display_order — INTEGER — NOT NULL
- is_required — BOOLEAN — NOT NULL — 필수항목
- created_at — DATETIME — NOT NULL
checklist_submission
- submission_id — UUID — Primary key — NOT NULL
- vehicle_id — UUID — Foreign key → vehicles.vehicle_id — NOT NULL
- rental_id — UUID — NOT NULL
- phone_number — BOOLEAN
- terms_of_service_agreed — BOOLEAN
- submitted_at — DATETIME — NOT NULL
inspection_report
- report_id — UUID — Primary key — NOT NULL
- rental_id — UUID — Foreign key → rentals.rental_id — NOT NULL
- s3_object_key — STRING
- uploaded_at — DATETIME
- sms_sent_at — DATETIME
rental_checklist_tokens
- token — UUID — Primary key — NOT NULL
- expires_at — DATETIME
- used_at — DATETIME
- created_at — DATETIME
- vehicle_id — UUID — Foreign key → vehicles.vehicle_id — NOT NULL
- rental_id — UUID — Foreign key → rentals.rental_id — NOT NULL
rentals
- rental_id — UUID — Primary key — NOT NULL
- vehicle_id — UUID — Foreign key → vehicles.vehicle_id — NOT NULL
- start_date — DATETIME — NOT NULL
- end_date — DATETIME
- status — ENUM — 예약, 이용중, 완료
- contact — VARCHAR(20)
- renter_name — STRING
- created_at — TIMESTAMP — NOT NULL
vehicles
- vehicle_id — UUID — Primary key — NOT NULL
- plate_number — VARCHAR(50) — NOT NULL
- model — VARCHAR(30) — SONATA/GENESIS/..
- model_code — VARCHAR(50) — NOT NULL
- model_year — INT — NOT NULL
- manufacturer — VARCHAR(20) — NOT NULL
- vehicle_type — ENUM — SEDAN/SUV/HATCHBACK
- fuel_type — ENUM — GASOLINE/DIESEL/HYBRID/ELECTRIC
- status — ENUM — AVAILABLE/RENTED/REPAIR
- mileage — INT — 주행거리
- last_inspected_at — DATE
- created_at — DATETIME