rhkwp
Tables (7)
ConsultRequest (Untitled7)
- requestID (Key) — number — Primary key — NOT NULL
- userID (Key2) — number — Foreign key → Users.userID — NOT NULL
- requestDate (Field) — date
- status (Field2) — varchar2(50)
- type (Field3) — varchar2(100)
EmothionCheck (Untitled5)
- responseID (Key) — number — Primary key — NOT NULL
- userID (Key2) — number — Foreign key → Users.userID — NOT NULL
- questionID (Field2) — number — NOT NULL
- answerText (Field) — varchar2(500)
- emotionLabel (Field3) — vrchar2(50)
- checkDate (Field4) — date
- sessionToken (Field5) — varchar2(100)
ExternalReference (Untitled6)
- refID (Key) — number — Primary key — NOT NULL
- title (Field) — varchar2(250)
- sourceURL (Field2) — varchar2(500)
- publishedDate (Field3) — date
Feedback (Untitled4)
- feedbackID (Key) — number — Primary key — NOT NULL
- resultID (Key2) — number — Foreign key → GeneratedResult.resultID — NOT NULL
- userID (Key3) — number — Foreign key → Users.userID — NOT NULL
- helpfulFlag (Field) — char(1)
- satisfaction (Field2) — number(1~5)
- comment (Field3) — varchar2(500)
GeneratedResult (Untitled3)
- resultID (Key) — number — Primary key — NOT NULL
- searchID (Key2) — number — Foreign key → searchHistory.searchID — NOT NULL
- generatedText (Field) — clob
- generatedDate (Field2) — date
Users (Untitled)
- userID (Key) — number — Primary key — NOT NULL
- name (Field) — varchar2(100)
- email (Field2) — varchar2(100) unique
- password (Field3) — varchar2(100)
- registrationDate (Field4) — date
- consentFlag (Field5) — char(1)
searchHistory (Untitled2)
- searchID (Key) — number — Primary key — NOT NULL
- userID (Key2) — number — Foreign key → Users.userID — NOT NULL
- searchTeam (Field) — varchar2(250)
- searchDate (Field2) — date