모래
테이블 (9)
daily_question
- id — BIGINT
- question_date — DATE — NOT NULL
- question_text — TEXT — NOT NULL
- question_type — VARCHAR(20) — NOT NULL
- interest_id — INT
- created_at — DATETIME — NOT NULL
- CHECK — (question_type IN ('normal','milestone'))
diary_analysis
- id — BIGINT
- diary_entry_id — BIGINT — NOT NULL
- emotions — TEXT
- keywords — TEXT
- sentiment_score — DOUBLE
- color_code — VARCHAR(7)
- analyzed_at — DATETIME — NOT NULL
diary_entry
- id — BIGINT
- user_id — BIGINT — NOT NULL
- question_id — BIGINT — NOT NULL
- entry_date — DATE — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- CHECK — (is_deleted IN (0,1))
friendship
- id — BIGINT
- user_id — BIGINT — NOT NULL
- friend_id — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- CHECK — (user_id <> friend_id)
- CHECK — (status IN ('pending','accepted','rejected'))
interest
- id — INT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
notification_setting
- id — BIGINT
- user_id — BIGINT — NOT NULL
- question_time — TIME
- push_enabled — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- CHECK — (push_enabled IN (0,1))
periodic_analysis
- id — BIGINT
- user_id — BIGINT — NOT NULL
- period_type — VARCHAR(20) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- emotion_trends — TEXT
- keyword_trends — TEXT
- comparison_data — TEXT
- similar_region — TEXT
- contour_data — TEXT
- created_at — DATETIME — NOT NULL
- CHECK — (period_type IN ('daily','weekly','monthly','yearly','total'))
user_interest
- id — BIGINT
- user_id — BIGINT — NOT NULL
- interest_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- nickname — VARCHAR(50)
- provider — VARCHAR(50)
- provider_id — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- is_active — BOOLEAN — NOT NULL
- CHECK — (is_active IN (0,1))