MobilePlatform_Team8
Tables (8)
Choice (7)
- choice_id (Key) — INT — Primary key — NOT NULL
- question_id (FK1) — INT
- choice_text (Field1) — VARCHAR
Group (3)
- group_id (Key) — INT — Primary key — NOT NULL
- group_name (Field1) — INT
Question (6)
- question_id (Key) — INT — Primary key — NOT NULL
- survey_id (FK1) — INT
- required (Field1) — Bool
- question_text (Field2) — VARCHAR
Response (8)
- response_id (Key) — INT — Primary key — NOT NULL
- user_id (FK1) — INT
- question_id (FK2) — INT
- choice_id (FK3) — INT
- response_text (Field1) — VARCHAR
Survey (5)
- survey_id (Key) — INT — Primary key — NOT NULL
- survey_title (Field1) — VARCHAR
- survey_description (Field2) — VARCHAR
- survey_start_date (Field3) — DATE
- survey_end_date (Field4) — DATE
- participants (Field5) — INT
- survey_participants (Field6) — INT
User (1)
- user_id (Key) — INT — Primary key — NOT NULL
- user_name (Field1) — VARCHAR
- user_email (Field2) — VARCHAR
- user_password (Field3) — VARCHAR
UserGroup (2)
- user_id (Key) — INT — Primary key — NOT NULL
- group_id (FK1) — INT
- survey_id (FK2) — INT
UserSurvey (4)
- user_survey_id (Key) — INT — Primary key — NOT NULL
- user_id (FK1) — INT
- survey_id (FK2) — INT
- is_admin (Field1) — Bool
- fee_status (Field2) — Bool