신고 서비스

테이블 (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