TodoManage

Tables (3)

Comment (comment)

  • comment_id (id) — bigint — Primary key — NOT NULL
  • user_id (id2) — bigint — Foreign key → Users.user_id — NOT NULL
  • todo_id (id3) — bigint — Foreign key → Todo.todo_id — NOT NULL
  • contents (댓글) — String

Todo (todo)

  • todo_id (id) — bigint — Primary key — NOT NULL
  • user_id (id2) — bigint — Foreign key → Users.user_id — NOT NULL
  • todo_name (Todo 제목) — String
  • contents (할일 내용) — String
  • created_at (createdAt) — LocalDateTime
  • modified_at (modifiedAt) — LocalDateTime

Users (users)

  • user_id (id) — bigint — Primary key — NOT NULL
  • username (사용자 이름) — String
  • password (비밀번호) — String