MyTodoList
Tables (4)
comment (Untitled4)
- comment_idx (Key3) — int — Primary key — NOT NULL
- user_idx (Key) — int — Foreign key → user.user_idx — NOT NULL
- todolist_idx (Key2) — int — Foreign key → todolist.todolist_idx — NOT NULL
- comment_content (Field) — varchar
- comment_create_at (Field2) — timestamp
listDetail (Untitled3)
- listDetail_idx (Key2) — int — Primary key — NOT NULL
- todolist_idx (Key) — int — Foreign key → todolist.todolist_idx — NOT NULL
- listDetail_content (Field) — varchar
- is_completed (Field2) — boolean
- listDetail_created_at (Field3) — timestamp
todolist (Untitled2)
- todolist_idx (Key) — int — Primary key — NOT NULL
- user_idx (Key2) — int — Foreign key → user.user_idx — NOT NULL
- title (Field) — varchar
- todolist_date (Field2) — date_format
- is_public (Field3) — boolean
- is_pw_protected (Field4) — boolean
- todolist_pw (Field5) — nullable
user (Untitled)
- user_idx (Key) — int — Primary key — NOT NULL
- user_id (Field) — varchar
- user_pw (Field2) — varchar
- user_nickname (Field3) — varchar
- user_intro (Field4) — varchar