SSAFIT
Tables (6)
FollowUser
- FollowerID — varchar(40) — Foreign key → User.userID — NOT NULL
- FolloweeID — varchar(40) — Foreign key → User.userID — NOT NULL
- FollowTIme (FollowTime) — DATETIME — NOT NULL
Review
- reviewID — int — Primary key — NOT NULL
- title — varchar(40) — NOT NULL
- content — text — NOT NULL
- regDate — timestamp — NOT NULL
- viewCnt — int — NOT NULL
- No (videoNo) — int — Foreign key → Video.No — NOT NULL
- userID — varchar(40) — Foreign key → User.userID — NOT NULL
User (.)
- userID — varchar(40) — Primary key — NOT NULL
- password — varchar(20) — NOT NULL
- email — varchar(40) — NOT NULL
- nickname — varchar(20) — NOT NULL
- age — int
User
- userID — varchar(40) — Primary key — NOT NULL
- password — varchar(20) — NOT NULL
- email — varchar(40) — NOT NULL
- nickname — varchar(20) — NOT NULL
- age — int
Video
- No — int — Primary key — NOT NULL
- title — Text — NOT NULL
- part — varchar(40) — NOT NULL
- url — Text — NOT NULL
- viewCnt — int — NOT NULL
- Field
VideoPick
- Video_fav — int — Foreign key → Video.No — NOT NULL
- userID — varchar(40) — Foreign key → User.userID — NOT NULL
- PickTime — DATETIME — NOT NULL