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)