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