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