시나리오

테이블 (5)

GeneratedResult (Untitled4)

  • ResultID (Key) — number — 기본 키 — NOT NULL
  • GeneratedText (Field2) — varchar2(500)
  • GeneratedDate (Field3) — date
  • SearchID (Key2) — number — 외래 키 → SearchHistory.SearchID — NOT NULL

Questions (Untitled2)

  • QuestionID (Key) — number — 기본 키 — NOT NULL
  • QuestionText (Field2) — varchar2(255)
  • CreationDate (Field3) — date
  • UserID (Field4) — number — 외래 키 → Users.UserID

SearchHistory (Untitled3)

  • SearchID (Key) — number — 기본 키 — NOT NULL
  • SearchTerm (Field2) — varchar2(100)
  • SearchDate (Field3) — date
  • UserID (Field4) — number — 외래 키 → Users.UserID

UserFeedback (Untitled5)

  • FeedbackID (Key) — number — 기본 키 — NOT NULL
  • Rating (Field2) — varchar2(255)
  • Comments (Field3) — varchar2(100)
  • UserID (Field4) — number — 외래 키 → Users.UserID

Users (Untitled)

  • UserID (Field) — number — 기본 키
  • Name (Field2) — varchar2(100)
  • Email (Field3) — varchar2(100)
  • Password (Field4) — varchar2(100)
  • RegistrationDate (Field5) — date