survey-test

Tables (3)

Survey (survey)

  • id — INT — Primary key — NOT NULL
  • userId (user_id) — INT — Foreign key → User.Id — NOT NULL
  • title — VARCHAR
  • question — VARCHAR
  • option1 — VARCHAR
  • option2 — VARCHAR
  • allVotesCount (all_votes_count) — INT

User (users)

  • Id (id) — INT — Primary key — NOT NULL
  • email — VARCHAR
  • username — VARCHAR
  • password — VARCHAR

Vote (vote)

  • id — INT — Primary key — NOT NULL
  • userId (user_id) — INT — Foreign key → User.Id — NOT NULL
  • surveyId (survey_id) — INT — Foreign key → Survey.id — NOT NULL
  • option — VARCHAR