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