11

Tables (15)

accident

  • accident_id — BIGINT — NOT NULL
  • user_id — BIG — Foreign key → user.user_id
  • injury_self — ENUM('NONE','MINOR','SEVERE')
  • injury_other — ENUM('NONE','MINOR','SEVERE')
  • occurred_at — DAT
  • direction — VARCHAR(50)
  • road_condition — VARCHAR(100)
  • memo — TEX — NOT NULL
  • created_at — DATETIME — NOT NULL

api_usage

  • GOOGLE_STT) — NOT — NOT NULL

capture_decision

  • decision_id — BIGIN — NOT NULL
  • is_required — BOOLEAN — NOT NULL
  • reason — VARCH — NOT NULL
  • created_at — DATETIME — NOT NULL

checklist_item

  • checklist_item_id — "accident_id" — NOT NULL
  • content — VARCHAR(100) — NOT NULL
  • order_no — "source" — NOT NULL
  • is_completed — BOOLEAN — NOT NULL

contact_log

  • contact_id — BIGINT — Primary key — NOT NULL
  • accident_id — BIGINT — NOT NULL
  • contact_type — ENUM(_119','INSURANCE') — NOT NULL

document

  • document_id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • doc_type — ENUM('DRIVER_LICENSE','INSURANCE_POLICY') — NOT NULL
  • extracted_info — JSO — NOT NULL
  • created_at — DATETIME — NOT NULL

insurance_guide

  • guide_id — BIGINT — Primary key — NOT NULL
  • accident_type — ENUM('PERSONAL','VEHNOT NULL, "procedure_content" TEXT NOT NU "required_docs" "updated_at" DATETIME NOT NULL — NOT NULL

photo

  • photo_id — BIGINT — NOT NULL
  • accident_id — BIGINT — Foreign key → accident.accident_id — NOT NULL
  • category — VARCHA

photo_tag

  • tag_id — BIGINT — NOT NULL
  • photo_id — BIGINT — Foreign key → photo.photo_id — NOT NULL
  • label — VARCHAR(100) — NOT NULL
  • confidence — DECIMA — NOT NULL

report

  • report_id — "accident_id" — Primary key — NOT NULL
  • narrative — "summary"
  • unverified_items — "version" — NOT NULL
  • pdf_url — "confirmed_at"

social_auth

  • GOOGLE) — NOT — NOT NULL
  • provider_user_id — V — NOT NULL
  • created_at — DATETIME — NOT NULL

statement

  • statement_id — BIG — NOT NULL
  • audio_file_url — VAR

supplement_

  • ADDITIONAL) — NOT — NOT NULL
  • created_at — DATETIME — NOT NULL

supplement_question

  • question_id — BIGINT — Primary key — NOT NULL
  • accident_id — BIGINT — Foreign key — NOT NULL
  • question — VARCHAR(255) — NOT NULL
  • answer — TEXT
  • round — ENUM — NOT NULL
  • created_at — DATETIME — NOT NULL

user

  • user_id — BIGINT — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100)
  • bike_model — VARCHAR(100)
  • bike_number — VARCHAR(20)
  • created_at — DATETI