RAG

Tables (5)

CaseLaw

  • CaseID (Key) — number(10) — Primary key — NOT NULL
  • CaseName (Field) — varchar2(255)
  • content (Field2) — varchar2(4000)
  • case_date (Field3) — date
  • RelatedLaw (Field4) — varchar2(255)
  • SearchID (Key2) — number(10) — Foreign key → SearchHistory.SearchID — NOT NULL

GeneratedResult

  • ResultID (Key) — number(10) — Primary key — NOT NULL
  • SearchID (Field) — number(10)
  • GeneratedText (Field2) — clob
  • GeneratedDate (Field3) — date
  • UserID (Key2) — number(10) — Foreign key → User.UserID — NOT NULL

RealTimeUpdate

  • UpdateID (Key) — number(10) — Primary key — NOT NULL
  • Source (Field) — varchar2(255)
  • content (Field2) — clob
  • UpdateDate (Field3) — date
  • CaseID (Key2) — number(10) — Foreign key → CaseLaw.CaseID — NOT NULL

SearchHistory

  • SearchID (Key) — number(10) — Primary key — NOT NULL
  • UserID (Field) — number(10)
  • SearchTerm (Field2) — varchar2(255)
  • SearchDate (Field3) — date
  • CaseID (Field4) — number(10)
  • ResultID (Key2) — number(10) — Foreign key → GeneratedResult.ResultID — NOT NULL

User (user)

  • UserID (Key) — number(10) — Primary key — NOT NULL
  • Name (Field) — varchar2(100)
  • Email (Field2) — varchar2(100)
  • Password (Field3) — varchar2(100)
  • RegistrationDate (Field4) — date
  • SearchID (Key2) — number(10) — Foreign key → SearchHistory.SearchID — NOT NULL