Lawsight_ERD_0528
Tables (11)
TB_CASE
- CASE_ID — BIGSERIAL — Primary key — 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
- CHUNK_ID — BIGSERIAL — Primary key — NOT NULL
- CASE_ID — BIGINT — Foreign key → 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
- SUMMARY_ID — BIGSERIAL — Primary key — NOT NULL
- CASE_ID — BIGINT — Foreign key → 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 — Primary key — 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 — Primary key — NOT NULL
- REPORT_ID — BIGINT — Foreign key → TB_IRAC_REPORT.REPORT_ID — NOT NULL
- CASE_ID — BIGINT — Foreign key → TB_CASE.CASE_ID — NOT NULL
- REF_TYPE — VARCHAR(20) — NOT NULL
TB_IRAC_REPORT
- REPORT_ID — BIGSERIAL — Primary key — NOT NULL
- SESSION_ID — BIGINT — Foreign key → TB_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_JUDGMENT
- JUDGMENT_ID — BIGSERIAL — Primary key — NOT NULL
- CASE_ID — BIGINT — Foreign key → 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_SEARCH_RESULT
- RESULT_ID — BIGSERIAL — Primary key — NOT NULL
- SESSION_ID — BIGINT — Foreign key → TB_SEARCH_SESSION.SESSION_ID — NOT NULL
- CASE_ID — BIGINT — Foreign key → TB_CASE.CASE_ID — NOT NULL
- SIMILARITY_SCORE — FLOAT
- RANK — INTEGER
- IS_SELECTED — BOOLEAN — NOT NULL
TB_SEARCH_SESSION
- SESSION_ID — BIGSERIAL — Primary key — NOT NULL
- USER_ID — BIGINT — Foreign key → TB_USER.USER_ID
- QUERY_TEXT — TEXT — NOT NULL
- SEARCH_TYPE — VARCHAR(20) — NOT NULL
- FILTER_PARAMS — JSONB
- RESULT_COUNT — INTEGER
- SEARCHED_AT — TIMESTAMP — NOT NULL
TB_USER
- USER_ID — BIGSERIAL — Primary key — 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
- COMPARISON_ID — BIGSERIAL — Primary key — NOT NULL
- SESSION_ID — BIGINT — Foreign key → TB_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