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