ESM_Happiness

Tables (6)

Copy Of Copy Of Question (option_choices)

  • id — int — Primary key — NOT NULL — choice id
  • id (option_group_id) — int — Foreign key → Copy Of Question.id — NOT NULL — Option group id
  • id (id2) — int — Foreign key → Copy Of Question.id — NOT NULL — Question ID
  • Key (survey_id) — int — Foreign key → Copy Of Question.Key — NOT NULL — Survey ID
  • Field (option_choice_value) — int — answer value
  • Field (option_text) — string — value description

Copy Of Question (option_groups)

  • id — int — Primary key — NOT NULL — Option group id
  • id (question_id) — int — Foreign key → Question.id — NOT NULL — Question ID
  • Key (survey_id) — int — Foreign key → Question.Key — NOT NULL — Survey ID
  • name — string — Group name

Question (question)

  • id — int — Primary key — NOT NULL — Question ID
  • Key (survey_id) — int — Foreign key → Untitled.Key — NOT NULL — Survey ID
  • name — string — Question title
  • text — string — Question text
  • Field2 (option_group_id) — int — Answer option group

Untitled (answers)

  • Key (id) — int — Primary key — NOT NULL — answer id
  • id (question_id) — int — Foreign key → Question.id — NOT NULL — Question ID
  • Key (survey_id) — int — Foreign key → Question.Key — NOT NULL — Survey ID
  • Key (user_id_hashed) — string — Foreign key → Untitled.Key — NOT NULL — hashed emp_id
  • Field (answer_value) — int — chosen answer value (option_choices value)
  • Field (answer_time) — time — response timestamp

Untitled (Survey)

  • Key (id) — int — Primary key — NOT NULL — Survey ID
  • Field (name) — string — Survey set description
  • Field (from_dt) — date — begin date
  • Field (to_dt) — date — end date

Untitled (users)

  • Key (user_id_hashed) — string — Primary key — NOT NULL — hashed emp_id
  • Field (opt_in) — T/F — flag for opt in /out
  • Field (opt_in_time) — time — opt-in timestamp
  • Field (opt_out_time) — time — opt-out timestamp