유스센터
테이블 (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