26.03.04
Tables (3)
comment_tbl
- PK (comment_id) — INT — Primary key — NOT NULL — Auto Increment
- PK (topic_id) — INT — Foreign key → topic_tbl.PK — NOT NULL — Auto Increment
- FK (member_id2) — VARCHAR(50) — Foreign key → topic_tbl.FK — NOT NULL — 중복제거
- PK (member_id) — VARCHAR(50) — Foreign key → member_tbl.PK — NOT NULL — 중복제거
- 내용 (content) — VARCHAR(250) — NOT NULL
member_tbl
- PK (member_id) — VARCHAR(50) — Primary key — NOT NULL — 중복제거
- 패스워드 (password) — VARCHAR(50) — NOT NULL
- 이름 (name) — VARCHAR(50)
- 이메일 (email) — VARCHAR(100) — NOT NULL — 중복제거
- 자기소개 (description) — VARCHAR(250)
topic_tbl
- PK (topic_id) — INT — Primary key — NOT NULL — Auto Increment
- FK (member_id) — VARCHAR(50) — Foreign key → member_tbl.PK — NOT NULL — 중복제거
- 제목 (title) — VARCHAR(100)
- 내용 (content) — TEXT