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