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