Lawsight_ERD_0508_최종

테이블 (19)

SEARCH_SESSION (TB_SEARCH_SESSION)

  • session_id — BIGSERIAL — 기본 키 — NOT NULL
  • query_text — TEXT — NOT NULL
  • search_type — VARCHAR(20) — NOT NULL
  • filter_params — JSONB
  • result_count — INTEGER
  • searched_at — TIMESTAMP — NOT NULL
  • CHECK — ("search_type" IN ('semantic','hybrid'))

TB_CASE (CASE_)

  • case_id — BIGSERIAL — 기본 키 — NOT NULL
  • case_number — VARCHAR(50) — NOT NULL
  • case_name — VARCHAR(500) — NOT NULL
  • court_name — VARCHAR(100) — NOT NULL
  • court_level — VARCHAR(20) — NOT NULL
  • case_type — VARCHAR(50) — NOT NULL
  • judgment_date — DATE
  • result — VARCHAR(20)
  • plaintiff_info — TEXT
  • defendant_info — TEXT
  • applied_provisions — TEXT
  • source_api — VARCHAR(100)
  • created_at — TIMESTAMP — NOT NULL
  • CHECK — ("court_level" IN ('대법원','고등법원','지방법원','헌재'))
  • CHECK — ("case_type" IN ('민사','형사','행정','헌법'))
  • CHECK — ("result" IN ('원고승','피고승','일부승','기각','각하','화해','취하'))

TB_CASE

  • CASE_ID — BIGSERIAL — 기본 키 — NOT NULL
  • SOURCE_SEQ — VARCHAR(20) — NOT NULL
  • CASE_NAME — VARCHAR(500) — NOT NULL
  • COURT_NAME — VARCHAR(100) — NOT NULL
  • COURT_LEVEL — VARCHAR(20) — NOT NULL
  • CASE_TYPE — VARCHAR(50) — NOT NULL
  • JUDGMENT_DATE — DATE
  • RESULT — VARCHAR(20)
  • PLAINTIFF_INFO — TEXT
  • DEFENDANT_INFO — TEXT
  • APPLIED_PROVISIONS — TEXT
  • SOURCE_API — VARCHAR(100)
  • CREATED_AT — TIMESTAMP — NOT NULL

TB_CASE_CHUNK (CASE_CHUNK)

  • chunk_id — BIGSERIAL — 기본 키 — NOT NULL
  • case_id — BIGINT — 외래 키 → TB_CASE.case_id — NOT NULL
  • chunk_type — VARCHAR(10) — NOT NULL
  • chunk_index — INTEGER — NOT NULL
  • chunk_text — TEXT — NOT NULL
  • chroma_id — VARCHAR(100)
  • embedding_model — VARCHAR(80)
  • embedded_at — TIMESTAMP
  • CHECK — ("chunk_type" IN ('order','claim','reason'))

TB_CASE_CHUNK

  • CHUNK_ID — BIGSERIAL — 기본 키 — NOT NULL
  • CASE_ID — BIGINT — 외래 키 → TB_CASE.CASE_ID — NOT NULL
  • CHUNK_TYPE — VARCHAR(10) — NOT NULL
  • CHUNK_INDEX — INTEGER — NOT NULL
  • CHUNK_TEXT — TEXT — NOT NULL
  • CHROMA_ID — VARCHAR(100)
  • EMBEDDING_MODEL — VARCHAR(80)
  • EMBEDDED_AT — TIMESTAMP

TB_CASE_SUMMARY (CASE_SUMMARY)

  • summary_id — BIGSERIAL — 기본 키 — NOT NULL
  • case_id — BIGINT — 외래 키 → TB_CASE.case_id — NOT NULL
  • overview — TEXT
  • key_issues — JSONB
  • court_decision — TEXT
  • model_used — VARCHAR(80)
  • created_at — TIMESTAMP — NOT NULL

TB_CASE_SUMMARY

  • SUMMARY_ID — BIGSERIAL — 기본 키 — NOT NULL
  • CASE_ID — BIGINT — 외래 키 → TB_CASE.CASE_ID — NOT NULL
  • OVERVIEW — TEXT
  • KEY_ISSUES — JSONB
  • COURT_DECISION — TEXT
  • MODEL_USED — VARCHAR(80)
  • CREATED_AT — TIMESTAMP — NOT NULL

TB_CODE

  • CODE_ID — BIGSERIAL — 기본 키 — NOT NULL
  • CODE_TYPE — VARCHAR(50) — NOT NULL
  • CODE_VALUE — VARCHAR(20) — NOT NULL
  • CODE_NAME — VARCHAR(100) — NOT NULL
  • CODE_ORDER — INTEGER
  • IS_ACTIVE — BOOLEAN — NOT NULL

TB_IRAC_REFERENCE

  • REF_ID — BIGSERIAL — 기본 키 — NOT NULL
  • REPORT_ID — BIGINT — 외래 키 → TB_IRAC_REPORT.REPORT_ID — NOT NULL
  • CASE_ID — BIGINT — 외래 키 → TB_CASE.CASE_ID — NOT NULL
  • REF_TYPE — VARCHAR(20) — NOT NULL

TB_IRAC_REFERENCE (IRAC_REFERENCE)

  • ref_id — BIGSERIAL — 기본 키 — NOT NULL
  • report_id — BIGINT — 외래 키 → TB_IRAC_REPORT.report_id — NOT NULL
  • case_id — BIGINT — 외래 키 → TB_CASE.case_id — NOT NULL
  • ref_type — VARCHAR(20) — NOT NULL
  • CHECK — ("ref_type" IN ('rule','application','conclusion'))

TB_IRAC_REPORT (IRAC_REPORT)

  • report_id — BIGSERIAL — 기본 키 — NOT NULL
  • session_id — BIGINT — 외래 키 → SEARCH_SESSION.session_id — NOT NULL
  • fact_summary — TEXT
  • issue_list — JSONB
  • rule_mapping — JSONB
  • application_analysis — TEXT
  • conclusion_summary — TEXT
  • win_probability — FLOAT
  • risk_factors — JSONB
  • created_at — TIMESTAMP — NOT NULL
  • CHECK — ("win_probability" >= 0.0 AND "win_probability" <= 1.0)

TB_IRAC_REPORT

  • REPORT_ID — BIGSERIAL — 기본 키 — NOT NULL
  • SESSION_ID — BIGINT — 외래 키 — NOT NULL
  • FACT_SUMMARY — TEXT
  • ISSUE_LIST — JSONB
  • RULE_MAPPING — JSONB
  • APPLICATION_ANALYSIS — TEXT
  • CONCLUSION_SUMMARY — TEXT
  • WIN_PROBABILITY — FLOAT
  • RISK_FACTORS — JSONB
  • CREATED_AT — TIMESTAMP — NOT NULL
  • CHECK — ("WIN_PROBABILITY" >= 0.0 AND "WIN_PROBABILITY" <= 1.0)

TB_JUDGMENT

  • JUDGMENT_ID — BIGSERIAL — 기본 키 — NOT NULL
  • CASE_ID — BIGINT — 외래 키 → TB_CASE.CASE_ID — NOT NULL
  • ORDER_TEXT — TEXT
  • CLAIM_TEXT — TEXT
  • REASON_TEXT — TEXT
  • FULL_TEXT — TEXT
  • TEXT_LENGTH — INTEGER
  • KEY_NOUNS — TEXT
  • PROCESSED_AT — TIMESTAMP

TB_JUDGMENT (JUDGMENT)

  • judgment_id — BIGSERIAL — 기본 키 — NOT NULL
  • case_id — BIGINT — 외래 키 → TB_CASE.case_id — NOT NULL
  • order_text — TEXT
  • claim_text — TEXT
  • reason_text — TEXT
  • full_text — TEXT
  • text_length — INTEGER
  • processed_at — TIMESTAMP
  • key_nouns — TEXT

TB_SEARCH_RESULT (SEARCH_RESULT)

  • result_id — BIGSERIAL — 기본 키 — NOT NULL
  • session_id — BIGINT — 외래 키 → SEARCH_SESSION.session_id — NOT NULL
  • case_id — BIGINT — 외래 키 → TB_CASE.case_id — NOT NULL
  • similarity_score — FLOAT
  • rank — INTEGER
  • is_selected — BOOLEAN — NOT NULL

TB_SEARCH_RESULT

  • RESULT_ID — BIGSERIAL — 기본 키 — NOT NULL
  • SESSION_ID — BIGINT — 외래 키 — NOT NULL
  • CASE_ID — BIGINT — 외래 키 → TB_CASE.CASE_ID — NOT NULL
  • SIMILARITY_SCORE — FLOAT
  • RANK — INTEGER
  • IS_SELECTED — BOOLEAN — NOT NULL

TB_USER

  • USER_ID — BIGSERIAL — 기본 키 — NOT NULL
  • GOOGLE_UID — VARCHAR(100) — NOT NULL
  • EMAIL — VARCHAR(200) — NOT NULL
  • NAME — VARCHAR(100)
  • ROLE — VARCHAR(20) — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL
  • LAST_LOGIN_AT — TIMESTAMP
  • REFRESH_TOKEN — TEXT
  • TOKEN_EXPIRES — TIMESTAMP

TB_WIN_LOSS_COMPARISON (WIN_LOSS_COMPARISON)

  • comparison_id — BIGSERIAL — 기본 키 — NOT NULL
  • session_id — BIGINT — 외래 키 → SEARCH_SESSION.session_id — NOT NULL
  • winning_case_ids — JSONB
  • losing_case_ids — JSONB
  • key_difference — TEXT
  • evidence_comparison — TEXT
  • legal_reasoning — TEXT
  • created_at — TIMESTAMP — NOT NULL

TB_WIN_LOSS_COMPARISON

  • COMPARISON_ID — BIGSERIAL — 기본 키 — NOT NULL
  • SESSION_ID — BIGINT — 외래 키 — NOT NULL
  • WINNING_CASE_IDS — JSONB
  • LOSING_CASE_IDS — JSONB
  • KEY_DIFFERENCE — TEXT
  • EVIDENCE_COMPARISON — TEXT
  • LEGAL_REASONING — TEXT
  • CREATED_AT — TIMESTAMP — NOT NULL