SomeDay
Tables (9)
chat_message
- id — CHAR(36)
- session_id — CHAR(36) — Foreign key → chat_session.id — NOT NULL
- sender_type — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
chat_session
- id — CHAR(36)
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- session_date — DATE — NOT NULL
- started_at — TIMESTAMP — NOT NULL
- ended_at — TIMESTAMP
cheer_message
- id — CHAR(36)
- sender_id — CHAR(36) — Foreign key → users.id — NOT NULL
- receiver_id — CHAR(36) — Foreign key → users.id — NOT NULL
- jenga_block_id — CHAR(36) — Foreign key → jenga_block.id — NOT NULL
- message — TEXT — NOT NULL
- cheer_type — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
jenga_block
- id — CHAR(36)
- tower_id — CHAR(36) — Foreign key → jenga_tower.id — NOT NULL
- analysis_id — CHAR(36) — Foreign key → mental_analysis.id
- floor_index — INT — NOT NULL
- position_index — INT — NOT NULL
- block_type — VARCHAR(20) — NOT NULL
- message — TEXT
- created_at — TIMESTAMP — NOT NULL
jenga_tower
- id — CHAR(36)
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- week_start_date — DATE — NOT NULL
- total_floors — INT — NOT NULL
- stability_score — INT — NOT NULL
- collapsed — BOOLEAN — NOT NULL
mental_analysis
- id — CHAR(36)
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- session_id — CHAR(36) — Foreign key → chat_session.id — NOT NULL
- analysis_date — DATE — NOT NULL
- internal_calculation — TEXT — NOT NULL
- stability_score — INT — NOT NULL
- stacked_blocks — INT — NOT NULL
- extracted_stressors — TEXT — NOT NULL
- mental_state — VARCHAR(100) — NOT NULL
- action_mission — TEXT — NOT NULL
- food_recommendation — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
my_profile
- id — CHAR(36)
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- avatar_emoji — VARCHAR(20)
- title — VARCHAR(50)
- consecutive_days — INT — NOT NULL
- total_layers — INT — NOT NULL
- cheers_sent — INT — NOT NULL
- cheers_received — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
recovery_mission
- id — CHAR(36)
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- analysis_id — CHAR(36) — Foreign key → mental_analysis.id
- mission_date — DATE — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- mission_type — VARCHAR(30) — NOT NULL
- completed — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
users
- id — CHAR(36)
- email — VARCHAR(100) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- gender — VARCHAR(20)
- age — INT
- bad_time — TIMESTAMP