assignment
Tables (3)
Article (게시글)
- article_id (게시글 고유번호) — BIGINT — Primary key — NOT NULL
- member_id (멤버 고유번호) — BIGINT — Foreign key → Member.member_id — NOT NULL
- title (제목) — VARCHAR
- content (내용) — TEXT
Comment (댓글)
- comment_id (댓글 고유번호) — BIGINT — Primary key — NOT NULL
- article_id (게시글 고유번호) — BIGINT — Foreign key → Article.article_id — NOT NULL
- member_id (멤버 고유번호) — BIGINT — Foreign key → Member.member_id — NOT NULL
- content (내용) — TEXT
Member (회원)
- member_id (멤버 고유번호) — BIGINT — Primary key — NOT NULL
- username (멤버 아이디) — VARCHAR
- nickname (닉네임) — VARCHAR
- password (비밀번호) — VARCHAR