Todo

Tables (4)

Authority (권한)

  • id — bigint — Primary key — NOT NULL
  • userId — bigint — Foreign key → Customer.id — NOT NULL
  • name (권한) — char(10)

Customer (유저)

  • id — bigint — Primary key — NOT NULL
  • username (유저이름) — char(10)
  • password (비밀번호) — char(15)

Todo (할일)

  • id — bigint — Primary key — NOT NULL
  • title (제목) — char(50)
  • content (내용) — text
  • createdAt (작성일) — datetime
  • isComplete (완료 상태) — boolean
  • author (작성자) — char(10)

comment (댓글)

  • id — bigint — Primary key — NOT NULL
  • todoId (할일 식별자) — bigint — Foreign key → Todo.id — NOT NULL
  • content (내용) — text
  • createdAt (작성일) — datetime
  • author (작성자) — char(10)