process1
Tables (8)
common_codes (Untitled2)
- code_id (PK) — varchar(30) — Primary key — NOT NULL
- code_group (Field) — varchar(30)
- code_name (Field2) — varchar(100)
- description (Field3) — text
poll_options (Untitled6)
- option_id (PK) — serial — Primary key — NOT NULL
- option_text (Field) — text
- poll_id (FK) — serial — Foreign key → polls.poll_id — NOT NULL
polls (Untitled5)
- poll_id (PK) — serial — Primary key — NOT NULL
- poll_title (Field) — text
profile_options (Untitled8)
- option_id (PK) — serial — Primary key — NOT NULL
- option_code (Field) — varchar(20)
- option_text (Field2) — text
- Field3
- question_id (PK2) — varchar(20) — Foreign key → profile_questions.question_id — NOT NULL
profile_questions (Untitled4)
- question_id (PK) — varchar(20) — Primary key — NOT NULL
- question_text (Field) — text
- question_type (Field2) — varchar(20)
user_poll_responses (Untitled7)
- response_id (PK) — serial — Primary key — NOT NULL
- chosen_option_id (Field) — int
- poll_id (PK2) — serial — Foreign key → polls.poll_id — NOT NULL
- user_sn (PK3) — varchar(255) — Foreign key → users.user_sn — NOT NULL
user_profile_answers (Untitled3)
- answer_id (PK) — serial — Primary key — NOT NULL
- answer_value (Field) — text
- user_sn (FK) — varchar(255) — Foreign key → users.user_sn — NOT NULL
- question_id (FK2) — varchar(20) — Foreign key → profile_questions.question_id — NOT NULL
users (Untitled)
- user_sn (PK) — varchar(255) — Primary key — NOT NULL
- region_code (Field) — varchar(30)
- brith_date (Field2) — date
- gender (Field3) — varchar(10)
- job_code (Field4) — varchar(50)
- code_id (FK) — varchar(30) — Foreign key → common_codes.code_id — NOT NULL