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