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