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 완료/미완료체크)