off-record
Tables (9)
diaries
- diary_id — INT — Primary key
- user_id — INT — Foreign key — NOT NULL
- content — TEXT
- type — VARCHAR(20)
- created_at — TIMESTAMP
emotion_status
- status_id — INT — Primary key
- user_id — INT — Foreign key — NOT NULL
- diary_id — INT — Foreign key → diaries.diary_id
- log_id — INT — Foreign key → logs.log_id
- life_id — INT — Foreign key → life_data.life_id
- report_id — INT — Foreign key → reports.report_id
- emotion_score — INT
- burnout_score — INT
- color — VARCHAR(20)
- created_at — TIMESTAMP
feedback
- feedback_id — INT — Primary key
- user_id — INT — Foreign key — NOT NULL
- status_id — INT — Foreign key → emotion_status.status_id — NOT NULL
- message — TEXT
- type — VARCHAR(20)
- created_at — TIMESTAMP
life_data
- life_id — INT — Primary key
- user_id — INT — Foreign key — NOT NULL
- sleep_time — INT
- steps — INT
- phone_usage — INT
- date — DATE
logs
- log_id — INT — Primary key
- user_id — INT — Foreign key — NOT NULL
- score — INT
- meal — BOOLEAN
- study_time — INT
- date — DATE
notifications
- notification_id — INT — Primary key
- user_id — INT — Foreign key — NOT NULL
- report_id — INT — Foreign key → reports.report_id
- status_id — INT — Foreign key → emotion_status.status_id
- message — TEXT
- type — VARCHAR(20)
- is_read — BOOLEAN
- created_at — TIMESTAMP
reports
- report_id — INT — Primary key
- summary — TEXT
- type — VARCHAR(20)
- created_at — TIMESTAMP
- Key (user_id) — INT — Foreign key → users.Key — NOT NULL
user_responses
- response_id — INT — Primary key
- user_id — INT — Foreign key — NOT NULL
- feedback_id — INT — Foreign key → feedback.feedback_id — NOT NULL
- question — TEXT
- answer — TEXT
- created_at — TIMESTAMP
users
- Key (user_id) — INT — Primary key — NOT NULL
- email — VARCHAR(100)
- password — VARCHAR(100)
- notification_setting — BOOLEAN