todolist
Tables (4)
list_result (성공여부)
- res_id — int — Primary key — NOT NULL
- res_name
tag (태그)
- tag_id — int — Primary key — NOT NULL
- tag_name — varchar
todolist (할 일)
- list_id — varchar — Primary key — NOT NULL
- user_id (user_id2) — varchar — Foreign key → user.user_id — NOT NULL
- tag_id — int — Foreign key → tag.tag_id — NOT NULL
- res_id — int — Foreign key → list_result.res_id — NOT NULL
- title — varchar
- content — varchar
- startdate — date
- enddate — date
user (회원)
- user_id — varchar — Primary key — NOT NULL
- password — varchar
- email — varchar
- username — varchar
- regdate — date
- Field