ssy_ssy
Tables (6)
Follow (Following)
- Key (followingId) — VARCHAR(45) — Primary key — NOT NULL
- Key (userId) — VARCHAR(45) — Foreign key → User.Key — NOT NULL
Follower
- Key (followerId) — VARCHAR(45) — Primary key — NOT NULL
- Key (userId) — VARCHAR(45) — Foreign key → User.Key — NOT NULL
Like_List
- Key (userId) — VARCHAR(45) — Foreign key → User.Key — NOT NULL
- Key (videoId) — VARCHAR(45) — Foreign key → Video.Key — NOT NULL
Review
- Key (reviewNumber) — INT — Primary key — NOT NULL
- Field (writer) — VARCHAR(45)
- Field2 (content) — VARCHAR(45)
- Field3 (title) — VARCHAR(45)
- Field (regDate) — Date
- Key (userId) — VARCHAR(45) — Foreign key → User.Key — NOT NULL
- Key (videoId) — VARCHAR(45) — Foreign key → Video.Key — NOT NULL
User
- Key (userId) — VARCHAR(45) — Primary key — NOT NULL
- (userPW) — VARCHAR(45)
- (userName) — VARCHAR(45)
- (userEmail) — VARCHAR(45)
- Field
Video
- Key (videoId) — VARCHAR(45) — Primary key — NOT NULL
- Field (channelName) — VARCHAR(45)
- Field2 (fitPartName) — VARCHAR(45)
- Field3 (title) — VARCHAR(45)
- Field (viewCnt) — INT