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