todo

Tables (3)

comment (댓글)

  • id (댓글 식별자) — NOT NULL — Primary key — NOT NULL
  • schedule_id (일정 식별자) — NOT NULL — Foreign key → schedule.id — NOT NULL
  • writer_id (작성자) — NOT NULL
  • content (댓글 내용) — NOT NULL
  • created_at (작성일) — NOT NULL
  • updated_at (수정일) — NOT NULL

reply (대댓글)

  • id (대댓글 식별자) — NOT NULL — Primary key — NOT NULL
  • comment_id (댓글 식별자) — NOT NULL — Foreign key → comment.id — NOT NULL
  • writer_id (작성자) — NOT NULL
  • content (대댓글 내용) — NOT NULL
  • created_at (작성일) — NOT NULL
  • updated_at (수정일) — NOT NULL

schedule (일정)

  • id (일정 식별자) — NOT NULL — Primary key — NOT NULL
  • writer_id (작성자) — NOT NULL
  • title (일정 제목) — NOT NULL
  • content (일정 내용) — NOT NULL
  • created_at (작성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • comment_count (댓글 수) — NOT NULL