Example

Tables (3)

article (게시글)

  • article_id (게시글 고유번호) — Primary key — NOT NULL
  • member_id (유저 고유번호) — Foreign key → member.member_id — NOT NULL
  • title (게시글 제목)
  • content (게시글 내용)

comment (댓글)

  • comment_id (댓글 고유번호) — Primary key — NOT NULL
  • article_id (게시글 고유번호) — Foreign key → article.article_id — NOT NULL
  • member_id (유저 고유번호) — Foreign key → member.member_id — NOT NULL
  • content (댓글 내용)

member (사용자)

  • member_id (유저 고유번호) — Primary key — NOT NULL
  • username (아이디)
  • password (비밀번호)
  • nickname (닉네임)