todoList
Tables (3)
tbl_member (member)
- id (유저ID) — Primary key — NOT NULL
- pw (유저PW)
- name (유저이름)
- age (유저나이)
- addr (유저주소)
- uuid (고유주소)
tbl_memo (memo)
- tno (메모번호) — Primary key — NOT NULL
- id (메모작성자) — Foreign key → tbl_member.id — NOT NULL
- memo_title (메모제목)
- memo_memo (메모내용)
- memo_dueDate (메모작성날짜)
tbl_todo (todoList)
- tno (todoList 번호) — Primary key — NOT NULL
- id (todoList 작성자) — Foreign key → tbl_member.id — NOT NULL
- todo_title (todoList 제목)
- todo_dueDate (todoList 해야할 날짜)
- todo_finished (todoList 완료/미완료체크)