SSAFIT
Tables (3)
Review
- reviewID — int — Primary key — NOT NULL
- title — varchar(40)
- content — text
- regDate — timestamp
- viewCnt — int
- No — int — Foreign key → Video.No — NOT NULL
- userID — varchar — Foreign key → User.userID — NOT NULL
User
- userID — varchar — Primary key — NOT NULL
- password — varchar(20) — NOT NULL
- email — varchar(40)
Video
- No — int — Primary key — NOT NULL
- title — Text
- part — varchar(40)
- url — Text
- viewCnt — int