scheduler-personal project

Tables (4)

Comment (댓글)

  • id (댓글 id) — NOT NULL — Primary key — NOT NULL
  • scheduleId (일정 id) — NOT NULL — Foreign key → Schdule.id — NOT NULL
  • userId (유저 id) — NOT NULL — Foreign key → Schdule.userId — NOT NULL
  • comment (댓글 내용) — NOT NULL — NOT NULL
  • writerID (작성자 ID) — NOT NULL — NOT NULL
  • createdAt (작성일) — NOT NULL — NOT NULL
  • updatedAt (수정일) — NOT NULL — NOT NULL

Reply (대댓글)

  • id (대댓글 id) — NOT NULL — Primary key — NOT NULL
  • scheduleId (일정 id) — NOT NULL — Foreign key → Comment.scheduleId — NOT NULL
  • commentId (댓글 id) — NOT NULL — Foreign key → Comment.id — NOT NULL
  • userId (유저 id) — NOT NULL — Foreign key → Comment.userId — NOT NULL
  • reply (대댓글 내용) — NOT NULL — NOT NULL
  • writerID (작성자 ID) — NOT NULL — NOT NULL
  • createdAt (작성일) — NOT NULL — NOT NULL
  • updatedAt (수정일) — NOT NULL — NOT NULL

Schdule (일정)

  • id (일정 id) — NOT NULL — Primary key — NOT NULL
  • userId (유저 id) — NOT NULL — Foreign key → User.id — NOT NULL
  • title (일정 제목) — NOT NULL — NOT NULL
  • content (일정 내용) — NOT NULL — NOT NULL
  • writerID (작성자 ID) — NOT NULL — NOT NULL
  • createdAt (작성일) — NOT NULL — NOT NULL
  • updatedAt (수정일) — NOT NULL — NOT NULL
  • commentCount (댓글 개수) — NULL

User (유저)

  • id (유저 id) — NOT NULL — Primary key — NOT NULL
  • name (유저명) — NOT NULL