LOL #1

Tables (7)

Document (Untitled5)

  • DocumentID (Key) — Primary key — NOT NULL
  • Title (Field)
  • SourceURL (Field2)
  • DocumentType (Field3)
  • Field4

Feedback (Untitled7)

  • Key — Primary key — NOT NULL
  • ResultID (Key2) — Foreign key → GeneratedResult.ResultID — NOT NULL
  • User ID (Key3) — Foreign key → Users.User ID — NOT NULL
  • Rating (Field)
  • ReportFlag (Field2)
  • FeedbackDate (Field3)

GeneratedResult (Untitled6)

  • ResultID (Key) — Primary key — NOT NULL
  • SearchID (Key2) — Foreign key → SearchHistory.SearchID — NOT NULL
  • GeneratedText (Field)
  • GeneratedDate (Field2)
  • SourceLinks (Field3)

RetrievedDocument (Untitled4)

  • RDID (Key) — Primary key — NOT NULL
  • SearchID (Key2) — Foreign key → SearchHistory.SearchID — NOT NULL
  • DocumentID (Key3) — Foreign key → Document.DocumentID — NOT NULL
  • Score (Field)

SearchHistory (Untitled3)

  • SearchID (Key) — Primary key — NOT NULL
  • User ID (Key2) — Foreign key → Users.User ID — NOT NULL
  • QueryText (Field2)
  • QueryDate (Field3)
  • ChampionFilter (Field4)
  • SeasonFilter (Field5)
  • PositionFilter (Field6)

UserProfile (Untitled2)

  • ProfileID (Key) — Primary key — NOT NULL
  • User ID (Key2) — Foreign key → Users.User ID — NOT NULL
  • PreferredRole (Field2)
  • Tier (Field3)
  • OtherPrefs (Field4)

Users (Untitled)

  • User ID (Key) — Primary key — NOT NULL
  • Email (Field)
  • Password (Field2)
  • RegistrationDate (Field3)