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 (닉네임)