게시판
테이블 (3)
board
- bno — int — 기본 키 — NOT NULL
- title — varchar(100) — NOT NULL
- writer — varchar(100) — NOT NULL
- content — text
- readcount — int
- image_file — text
- reg_date — datetime
- id — varchar(100) — 외래 키 → member.id — NOT NULL
member
- id — varchar(100) — 기본 키 — NOT NULL
- Password — varchar(100) — NOT NULL
- Email — varchar(100) — NOT NULL
- Age — int — NOT NULL
- Reg_date — datetime
- Last_login — datetime
reply
- rno — int — 기본 키 — NOT NULL
- user_id — varchar(100) — NOT NULL
- board_bno — int — NOT NULL
- content — text
- reg_date — datetime
- id (id2) — varchar(100) — 외래 키 → member.id — NOT NULL
- bno (bno2) — int — 외래 키 → board.bno — NOT NULL