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