Acci
테이블 (10)
개인정보이용동의 (Term)
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — bigint — 외래 키 → 회원.id — NOT NULL
- term_content (Field) — text
- term_agreed (Field2) — boolean — NOT NULL
- term_version (Field3) — varchar(20) — NOT NULL
- ip_address (Field4) — varchar(20) — NOT NULL
- user_agent (Field5) — varchar(30) — NOT NULL
법률 (Law)
- id (Key) — bigint — 기본 키 — NOT NULL
- law_name (Field) — varchar(50) — NOT NULL
- law_content (Field2) — text — NOT NULL
분석 (Analysis)
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — bigint — 외래 키 → 회원.id — NOT NULL
- accident_rate (Field) — bigint — NOT NULL
- accident_type (Field2) — enum
- accident_image (Field3) — text
분석-법률 중간테이블 (AnalysisToLaw)
- analysis_id (Key) — bigint — 외래 키 → 분석.id — NOT NULL
- law_id (Key2) — bigint — 외래 키 → 법률.id — NOT NULL
수리비 (RepairEstimate)
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — bigint — 외래 키 → 회원.id — NOT NULL
- vehicle_manufacturer (Field) — varchar(20) — NOT NULL
- vehicle_model (Field2) — varchar(50) — NOT NULL
- panel_beating_cost (Field3) — NOT NULL
- part_replacement_cost (Field4) — NOT NULL
- total_repair_cost (Field5) — NOT NULL
저장된 판례 (SavedPrecedent)
- user_id (Key) — bigint — 외래 키 → 회원.id — NOT NULL
- precedent_id (Key2) — bigint — 외래 키 → 판례.id — NOT NULL
토큰 (RefreshToken)
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — bigint — 외래 키 → 회원.id — NOT NULL
- refresh_token (Field) — varchar(255) — NOT NULL
- expires_at (Field2) — localdatetime — NOT NULL
판례 (Precedent)
- id (Key) — bigint — 기본 키 — NOT NULL
- case_number (Field) — varchar(100) — NOT NULL
- court (Field2) — varchar(50) — NOT NULL
- date_of_judgement (Field3) — timestamp — NOT NULL
- accident_rate_a (Field4) — bigint — NOT NULL
- accident_rate_b (Field5) — bigint — NOT NULL
- accident_title (Field6) — varchar(50) — NOT NULL
- accident_overview (Field8) — varchar(255) — NOT NULL
- accident_description (Field9) — text — NOT NULL
- precedent_type (Field7) — enum — NOT NULL
판례-법률 중간테이블 (PrecedentToLaw)
- precedent_id (Key) — bigint — 외래 키 → 판례.id — NOT NULL
- law_id (Key2) — bigint — 외래 키 → 법률.id — NOT NULL
회원 (User)
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(50) — NOT NULL
- email (Field2) — varchar(255) — NOT NULL
- profile_image (Field3) — text
- role (Field4) — enum — NOT NULL