TODO

Tables (3)

Comment (comment)

  • id — Long — Primary key — NOT NULL
  • todo (todo_id) — Long — Foreign key → TODO.Id — NOT NULL
  • member (member_id) — Long? — Foreign key → Member.Id — NOT NULL
  • 내용 (content) — String

Member (member)

  • Id (id) — Long — Primary key — NOT NULL
  • 별명 (nickname) — Long
  • email — Long
  • password — Long
  • 역할 (roel) — Long
  • oauth provider (provider) — String
  • oauth 제공자 측 user id (provider_user_id) — String

TODO (todo)

  • Id (id) — Long — Primary key — NOT NULL
  • member (member_id) — Long? — Foreign key → Member.Id — NOT NULL
  • 제목 (title) — String
  • 내용 (content) — String
  • 작성일 (created_at) — datetime
  • 상태 (status) — String