pro

Tables (6)

Options (Untitled5)

  • option_id (Key) — Primary key — NOT NULL
  • question_id (Key2) — Foreign key → questions.question_id — NOT NULL
  • text (Field)
  • value (Field2)

Response (Untitled6)

  • response_id (Key) — Primary key — NOT NULL
  • question_id (Key2) — Foreign key → questions.question_id — NOT NULL
  • user_id (Key3) — Foreign key → users.user_id — NOT NULL
  • value (Field)

Surveys (Untitled3)

  • survey_id (Key) — Primary key — NOT NULL
  • title (Field)

Teams (Untitled)

  • team_id (Key) — Primary key — NOT NULL
  • name (Field)

questions (Untitled4)

  • question_id (Key) — Primary key — NOT NULL
  • survey_id (Key2) — Foreign key → Surveys.survey_id — NOT NULL
  • text (Field)
  • value (Field2)

users (Untitled2)

  • user_id (Key) — Primary key — NOT NULL
  • team_id (Key2) — Foreign key → Teams.team_id — NOT NULL
  • name (Field)