dd
Tables (11)
interview_note
- note_id — BIGINT — Primary key
- interview_session_id — BIGINT — NOT NULL
- note_text — TEXT
- created_at — TIMESTAMP
interview_session
- interview_session_id — BIGINT — Primary key
- session_id — BIGINT — NOT NULL
- context — TEXT
question
- question_id — BIGINT — Primary key
- group_id — BIGINT — NOT NULL
- question_text — TEXT — NOT NULL
- question_type — ENUM('text','number','single_choice','multi_choice','scale') — NOT NULL
- is_fixed — BOOLEAN
- version — INT
- order_no — INT — NOT NULL
question_group
- group_id — BIGINT — Primary key
- survey_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- order_no — INT — NOT NULL
question_option
- option_id — BIGINT — Primary key
- question_id — BIGINT — NOT NULL
- option_label — VARCHAR(255) — NOT NULL
- option_value — VARCHAR(50) — NOT NULL
- order_no — INT — NOT NULL
session_base
- session_id — BIGINT — Primary key
- user_id (user_id2) — BIGINT — Foreign key → users.user_id
- session_type — ENUM('survey', 'interview', 'both') — NOT NULL
- partner_id — BIGINT — NOT NULL
- start_time — TIMESTAMP
- end_time — TIMESTAMP
- note — TEXT
session_video
- video_id — BIGINT — Primary key
- session_id — BIGINT — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- duration — INT
- file_size — BIGINT
- uploaded_at — TIMESTAMP
survey
- survey_id — BIGINT — Primary key
- name — VARCHAR(255) — NOT NULL
- version — VARCHAR(20) — NOT NULL
- is_active — BOOLEAN
- created_at — TIMESTAMP
survey_response
- response_id — BIGINT — Primary key
- survey_session_id — BIGINT — NOT NULL
- question_id — BIGINT — NOT NULL
- answer_value — VARCHAR(255)
- answer_text — TEXT
- recorded_time — INT
- created_at — TIMESTAMP
survey_session
- survey_session_id — BIGINT — Primary key
- session_id — BIGINT — NOT NULL
- survey_id — BIGINT — NOT NULL
users
- user_id — BIGINT — Primary key
- name — VARCHAR(100)
- birth_date — DATE
- gender — ENUM('male', 'female', 'other')
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- user_type — ENUM('elder', 'partner') — NOT NULL