Comment_CRUD

Tables (3)

comment (댓글)

  • id (댓글 식별자) — BIGINT — Primary key — NOT NULL — Auto Increment
  • id (일정 식별자) — BIGINT — Foreign key → schedule.id — NOT NULL — Auto Increment
  • nickname (작성자) — VARCHAR(255) — NOT NULL
  • contents (내용) — LONGTEXT — NOT NULL
  • created_at (생성시간) — DATETIME — NOT NULL
  • updated_at (수정시간) — DATETIME — NOT NULL

in_comment (대댓글)

  • id (대댓글 식별자) — BIGINT — Primary key — NOT NULL — Auto Increment
  • id (댓글 식별자) — BIGINT — Foreign key → comment.id — NOT NULL
  • nickname (작성자) — VARCHAR(255) — NOT NULL
  • contents (내용) — LONGTEXT — NOT NULL
  • created_at (생성시간) — DATETIME — NOT NULL
  • updated_at (수정시간) — DATETIME — NOT NULL

schedule (일정)

  • id (일정 식별자) — BIGINT — Primary key — NOT NULL — Auto Increment
  • nickname (작성자) — VARCHAR(255) — NOT NULL
  • title (제목) — VARCHAR(255) — NOT NULL
  • contents (내용) — LONGTEXT — NOT NULL
  • created_at (생성시간) — DATETIME — NOT NULL
  • updated_at (수정시간) — DATETIME — NOT NULL