PlusTodo

Tables (3)

Comment (댓글)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • userId (유저 아이디) — BIGINT — NOT NULL
  • content (댓글 내용) — VARCHAR — NOT NULL
  • writerId (작성자 ID) — VARCHAR — NOT NULL
  • createdAt (생성일) — LOCALDATETIME — NOT NULL
  • updatedAt (수정일) — LOCALDATETIME — NOT NULL
  • id (일정 ID) — BIGINT — Foreign key → Todo.id — NOT NULL

Reply (대댓글)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • userId (유저 아이디) — BIGINT — NOT NULL
  • content (댓글 내용) — VARCHAR — NOT NULL
  • writerId (작성자) — VARCHAR — NOT NULL
  • createdAt (생성일) — LOCALDATETIME — NOT NULL
  • updatedAt (수정일) — LOCALDATETIME — NOT NULL
  • parentCommentId (Key2) — BIGINT — Foreign key → Comment.id — NOT NULL

Todo (일정)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • userId (유저 아이디) — BIGINT — NOT NULL
  • title (제목) — VARCHAR — NOT NULL
  • content (일정 내용) — VARCHAR — NOT NULL
  • writerId (작성자) — VARCHAR — NOT NULL
  • createdAt (생성일) — LOCALDATETIME — NOT NULL
  • updatedAt (수정일) — LOCALDATETIME — NOT NULL