jsp_project4
Tables (3)
board (Untitled2)
- bno (Key) — int — Primary key — NOT NULL — auto_increment
- title (Field) — varchar(100)
- writer (Field2) — varchar(100)
- content (Field3) — text
- reg_date (Field4) — datetime
- read_count (Field5) — int
- image_file (Field6)
comment (Untitled3)
- cno (Key) — int — Primary key — NOT NULL
- bno (Key2) — int — Foreign key → board.bno — NOT NULL — auto_increment
- writer (Field2) — varchar(100)
- content (Field3) — varchar(1000) — NOT NULL
- reg_date (Field4)
member (Untitled)
- mno (Key) — int — Primary key — NOT NULL — auto_increment
- id (Field) — varchar(100) — NOT NULL
- password (Field2) — varchar(100) — NOT NULL
- email (Field3) — varchar(100) — NOT NULL
- age (Field4) — int
- reg_date (Field5) — datetime
- last_login (Field6) — datetime