asd
Tables (5)
Checklists
- todo_id — INT — NOT NULL
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- task_name — VARCHAR(255) — NOT NULL
- is_completed — BOOLEAN
Dashboards
- dashboard_id — INT — NOT NULL
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- theme_mode — VARCHAR(20)
Records
- record_id — INT — NOT NULL
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- record_date — DATE — NOT NULL
- emotion_score — INT — NOT NULL
- achievement_rate — INT — NOT NULL
- content_memo — TEXT
Users
- user_id — INT — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50)
- created_at — TIMESTAMP
Widgets
- widget_id — INT — NOT NULL
- dashboard_id — INT — Foreign key → Dashboards.dashboard_id — NOT NULL
- widget_type — VARCHAR(50) — NOT NULL
- pos_x — INT — NOT NULL
- pos_y — INT — NOT NULL
- width — INT — NOT NULL
- height — INT — NOT NULL