Todolist
테이블 (9)
Untitled (BaseEntity)
- Field (created_at) — datetime
- Field (updated_at) — datetime
Untitled (member_images)
- Field (member_id) — bigint — 외래 키 → 회원.Field — NOT NULL
- Field (name) — varchar(50)
- Field (type) — enum('JPG', 'JPEG', 'PNG')
Untitled (tasks)
- Key (task_id) — bigint — 기본 키 — NOT NULL
- Key (task_group_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (member_id) — bigint — 외래 키 → 회원.Field — NOT NULL
- Field (name) — varchar(30)
- Field (flag) — boolean
- Field (status) — enum('BACKLOG', 'COMPLETED', 'CANCLED')
- Field (order) — int
- Field (memo) — varchar(500)
- Field (start_time) — time
- Field (alarm_time) — time
- Field (due_date) — date
Untitled (sub_tasks)
- Key (sub_task_id) — bigint — 기본 키 — NOT NULL
- Key (task_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — varchar(30)
- Field (status) — enum('BACKLOG', 'COMPLETED', 'CANCLED')
- Field (order) — int
Untitled (task_categories)
- Key (task_category_id) — bigint — 기본 키 — NOT NULL
- Field (member_id) — bigint — 외래 키 → 회원.Field — NOT NULL
- Key (task_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — varchar(30)
Untitled (task_groups)
- Key (task_group_id) — bigint — 기본 키 — NOT NULL
- Field (name) — varchar(30)
Untitled (oauth2_credentials)
- Field (member_id) — bigint — 외래 키 → 회원.Field — NOT NULL
- Field (vendor) — enum('KAKAO')
Untitled (member_settings)
- Field (member_id) — bigint — 외래 키 → 회원.Field — NOT NULL
- Field (theme_mode) — enum('LIGHT', 'DARK')
회원 (members)
- Field (member_id) — bigint — 기본 키 — NOT NULL
- Field (username) — varchar(20)
- Field (password) — varchar(20)
- Field (nickname) — varchar(10)