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