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