유스센터

테이블 (9)

counseling_chat_sessions

  • session_index — INTEGER — 기본 키 — NOT NULL
  • chat_id — INTEGER — 외래 키 → counseling_user_chatid_mapping.chat_id — NOT NULL
  • user_state — VARCHAR(20)
  • response — TEXT
  • created_at — TIMESTAMP
  • scenario — INTEGER

counseling_cheerup_message

  • index — INTEGER — 기본 키 — NOT NULL
  • category — VARCHAR(50) — 외래 키 → counseling_cheerup_theme.category — NOT NULL
  • cheerup_message — TEXT — NOT NULL

counseling_cheerup_theme

  • category — VARCHAR(50) — 기본 키 — NOT NULL

counseling_counsel_result

  • index — INTEGER — 기본 키 — NOT NULL
  • user_uuid — VARCHAR(20) — 외래 키 → counseling_users.user_uuid — NOT NULL
  • counsel_info — TEXT
  • worry_content — TEXT
  • mood — TEXT
  • severity — INTEGER
  • severity_text — TEXT
  • test_result — TEXT
  • suggestion — TEXT
  • pogny_message — TEXT
  • reference — TEXT
  • created_at — TIMESTAMP

counseling_daily_cheerup

  • index — INTEGER — 기본 키 — NOT NULL
  • user_uuid (user_uuid2) — VARCHAR(20) — 외래 키 → counseling_users.user_uuid — NOT NULL
  • daily_date — DATE — NOT NULL
  • is_viewed — BOOLEAN
  • cheerup_message — VARCHAR(300) — NOT NULL

counseling_psych_assessment_section

  • category — VARCHAR(50) — 기본 키 — NOT NULL
  • subcategory — VARCHAR(50) — 기본 키 — NOT NULL

counseling_role_chat

  • Index — INTEGER — 기본 키 — NOT NULL
  • scenario — INTEGER
  • text — TEXT
  • button1 — VARCHAR(200)
  • button2 — VARCHAR(200)
  • button3 — VARCHAR(200)
  • button4 — VARCHAR(200)
  • button5 — VARCHAR(200)
  • button6 — VARCHAR(200)
  • image_url — VARCHAR(500)
  • title — VARCHAR(200)
  • created_at — TIMESTAMP
  • is_star_active — BOOLEAN
  • is_chat_active — BOOLEAN

counseling_user_chatid_mapping

  • chat_id — INTEGER — 기본 키 — NOT NULL
  • user_uuid — VARCHAR(20) — 외래 키 → counseling_users.user_uuid — NOT NULL

counseling_users

  • user_uuid — VARCHAR(20) — 기본 키 — NOT NULL
  • created_at — TIMESTAMP