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