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)