todo
Tables (4)
shared_list (Untitled3)
- user_id
- list_id — Foreign key → todo_list.list_id — NOT NULL
todo (Untitled)
- todo_id — varchar(14) — Primary key — NOT NULL
- list_id — Foreign key → todo_list.list_id — NOT NULL
- name — varchar(70)
- detail — varchar(1000)
- note — varchar(500)
- assign_user_id
- approval_user_id
- approval_status — char
- repeat_schedule
- repeat_count — int
- repeat_util_date — date
- create_by
- create_at — DATETIME
- update_by
- update_at — DATETIME
todo_list (Untitled2)
- list_id — Primary key — NOT NULL
- user_id
- title — varchar(30)
- create_by
- create_at — DATETIME
- update_by
- update_at — DATETIME
todo_status (Untitled4)
- todo_status_id — Primary key — NOT NULL
- todo_id — varchar(14) — Foreign key → todo.todo_id — NOT NULL
- status — char
- deadline — date
- update_at — DATETIME