pre_capstone

Tables (6)

poll_options (Untitled7)

  • option_id (pk) — serial — Primary key — NOT NULL
  • poll_id (fk) — serial — Foreign key → polls.poll_id — NOT NULL
  • option_text (Field) — text

polls (Untitled6)

  • poll_id (Key) — serial — Primary key — NOT NULL
  • poll_title (Field) — text

profile_questions (Untitled3)

  • question_id (pk) — string — Primary key — NOT NULL
  • question_text (Field) — text
  • question_type (Field2) — string

user_poll_responses (Untitled8)

  • response_id (Key) — serial — Primary key — NOT NULL
  • user_sn (fk1) — string — Foreign key → users.user_sn — NOT NULL
  • poll_id (fk2) — serial — Foreign key → polls.poll_id — NOT NULL
  • option_id (fk3) — serial — Foreign key → poll_options.option_id — NOT NULL

user_profile_answers (Untitled5)

  • answer_id (pk) — serial — Primary key — NOT NULL
  • user_sn (fk1) — string — Foreign key → users.user_sn — NOT NULL
  • question_id (fk2) — string — Foreign key → profile_questions.question_id — NOT NULL
  • answer_text (Field) — text

users (Untitled)

  • user_sn (PK) — string — Primary key — NOT NULL
  • region (Field3) — string
  • birth_date (Field2) — date
  • gender (Field) — string