Users
Tables (8)
Answers (Untitled8)
- AnswersID (Key) — Primary key — NOT NULL
- AnswersContent (Field2)
- AnswersDate (Field3)
- UserSatisfaction (Field4)
- AnswerFeedback (Field5)
- QuestionsID (Key2) — Foreign key → Questions.QuestionsID — NOT NULL
Election (Untitled6)
- ElectionID (Key) — Primary key — NOT NULL
- ElectionName (Field)
- ElectionDate (Field2)
- ElectionType (Field3)
- ElectionResult (Field5)
- PoliticianID (Key2) — Foreign key → Politician.PoliticianID — NOT NULL
Party (Untitled4)
- PartyID (Key) — Primary key — NOT NULL
- PartyName (Field)
- PartyIdeology (Field2)
- PoliticianID (Key2) — Foreign key → Politician.PoliticianID — NOT NULL
- PolicyID (Key3) — Foreign key → Policy.PolicyID — NOT NULL
Policy (Untitled5)
- PolicyID (Key) — Primary key — NOT NULL
- PolicyName (Field)
- Ministry (Field2)
- PolicyContent (Field3)
- PartyID (FK) (Field4)
- PublicOpinion (Field5)
Politician (Untitled3)
- PoliticianID (Key) — Primary key — NOT NULL
- PoliticianName (Field)
- PoliticianCareer (Field3)
- PoliticianPledge (Field4)
- PoliticianImage (Field5)
- PartyID (Key2) — Foreign key → Party.PartyID — NOT NULL
Questions (Untitled7)
- QuestionsID (Key) — Primary key — NOT NULL
- QuestionsContent (Field2)
- QuestionsCategory (Field3)
- QuestionsDate (Field4)
- SearchWord (Field5)
- UserID (Key2) — Foreign key → Users.UserID — NOT NULL
UserPolitics (Untitled2)
- UserID (Key) — Foreign key → Users.UserID — NOT NULL
- PoliticalOrientation (Field)
- PoliticalTopic (Field2)
- PoliticianID (Key2) — Foreign key → Politician.PoliticianID — NOT NULL
Users (Untitled)
- UserID (Key) — Primary key — NOT NULL
- UserName (Field)
- BirthDate (Field2)
- Email (Field3)
- PasswordHash (Field4)
- SignUpDate (Field5)
- LastLoginDate (Field6)
- SocialMediaPlatform (Field7)
- SocialMediaID (Field8)