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