123
Tables (5)
Board
- bId — varchar — Primary key — NOT NULL
- userId — varchar — Foreign key → Users.userId — NOT NULL
- brp — varchar — Foreign key → Reply.brp — NOT NULL
- fno — int — Foreign key → Files.fno — NOT NULL
- title — varchar — NOT NULL
- writer — varchar — NOT NULL
- content — varchar — NOT NULL
- reqDate — timestamp
- ubo — timestamp
- dbo — timestamp
Files
- fno — int — Primary key — NOT NULL
- bId — varchar
- fnm — varchar
- reqDate — timestamp
Members
- userName (userId) — varchar — Primary key — NOT NULL
- 기광우 (kkw180) — varchar
- 정이산 (JIS108) — varchar
- 홍길동 (HGD08) — varchar
- 고길동 (GOG99) — varchar
- 신창섭 (SHS13) — varchar
- 강원기 (GWG) — varchar
Reply
- brp — varchar — Primary key — NOT NULL
- rId — varchar
- writer — varchar
- content — varchar
- reqDate — timestamp
- Field — VARCHAR(255)
Users
- userId — varchar — Primary key — NOT NULL
- userName — varchar — NOT NULL
- pw — varchar — NOT NULL
- tel — int — NOT NULL
- gender — varchar — NOT NULL
- reqDate — timestamp — NOT NULL