blog
Tables (3)
User (사용자)
- id — int — Primary key — NOT NULL
- 이름 (name) — varchar(30)
- 닉네임 (nick) — varchar(30)
- 비번 (password) — varchar(30)
bord (게시글)
- id — int — Primary key — NOT NULL
- 제목 (title) — varchar(100)
- 내용 (content) — varchar(200)
- id (user_id) — int — Foreign key → User.id — NOT NULL
- Field
comment (댓글)
- Key (id) — int — Primary key — NOT NULL
- id (user_id) — int — Foreign key → User.id — NOT NULL
- id (bord_id) — int — Foreign key → bord.id — NOT NULL
- 내용 (content) — varchar(200)
- 날짜 (insertdate) — datetime