innovation_W3_2
Tables (3)
Article (게시글)
- PK (article_id) — bigint — Primary key — NOT NULL
- 생성날짜 (created_at) — datetime
- 수정날짜 (modified_at) — datetime
- 제목 (title) — varchar
- 내용 (content) — varchar
- 작성자 (author) — varchar
- FK (user_id) — bigint — Foreign key → User.PK — NOT NULL
Comment (댓글)
- PK (comment_id) — bigint — Primary key — NOT NULL
- 생성날짜 (created_at) — datetime
- 수정날짜 (modified_at) — datetime
- 내용 (content) — varchar
- 작성자 (author) — varchar
- FK (user_id) — bigint — Foreign key → User.PK — NOT NULL
- FK (article_id) — bigint — Foreign key → Article.PK — NOT NULL
User (사용자)
- PK (user_id) — bigint — Primary key — NOT NULL
- 생성날짜 (created_at) — datetime
- 수정날짜 (modified_at) — datetime
- 아이디 (nickname) — varchar
- 비밀번호 (password) — varchar