Planner ERD v2
Tables (10)
category
- category_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- color — VARCHAR(20)
- sort_order — INT — NOT NULL
- is_default — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
feedback
- feedback_id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — NOT NULL
- task_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- progress_rate — INT — NOT NULL
- memo — TEXT
- is_completed — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notification_setting
- notification_id — BIGINT — Primary key — NOT NULL
- task_id — BIGINT — NOT NULL
- notify_before — INT — NOT NULL
- is_enabled — TINYINT(1) — NOT NULL
playlist
- playlist_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
playlist_item
- playlist_item_id — BIGINT — Primary key — NOT NULL
- playlist_id — BIGINT — NOT NULL
- task_id — BIGINT — NOT NULL
- sort_order — INT — NOT NULL
- added_at — DATETIME — NOT NULL
task
- task_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- category_id — BIGINT
- title — VARCHAR(255) — NOT NULL
- priority — ENUM('HIGH','MEDIUM','LOW') — NOT NULL
- is_starred — TINYINT(1) — NOT NULL
- deadline — DATE
- estimated_time — INT
- status — ENUM('TODO','IN_PROGRESS','DONE') — NOT NULL
- repeat_type — ENUM('NONE','DAILY','WEEKLY','MONTHLY') — NOT NULL
- is_deleted — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
task_session
- session_id — BIGINT — Primary key — NOT NULL
- task_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- started_at — DATETIME — NOT NULL
- ended_at — DATETIME
- elapsed_time — INT — NOT NULL
- status — ENUM('PLAYING','PAUSED','DONE') — NOT NULL
timetable
- timetable_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- day_of_week — TINYINT — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- is_active — TINYINT(1) — NOT NULL
user
- user_id — BIGINT — Primary key — NOT NULL
- social_provider — VARCHAR(20) — NOT NULL
- social_id — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- email — VARCHAR(255)
- profile_image_url — VARCHAR(500)
- recommended_daily_time — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_notification_settings
- setting_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- service_notification — TINYINT(1) — NOT NULL
- pack_notification — TINYINT(1) — NOT NULL
- updated_at — DATETIME — NOT NULL