PJT-G
Tables (3)
Review
- reviewId — int — Primary key — NOT NULL
- userId — varchar(50) — Foreign key → User.userId — NOT NULL
- videoId — int — Foreign key → Video.videoId — NOT NULL
- content — varchar(255)
- regDate — timestamp
User
- userId — varchar(50) — Primary key — NOT NULL
- userPassword — varchar(255)
Video
- videoId — int — Primary key — NOT NULL
- title — varchar(255)
- part — varchar(255)
- chnnelName — varchar(255)
- viewCnt — int
- regDate — timestamp
- url — varchar(255)