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