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