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