ClassyERD

Tables (3)

CREW (Untitled2)

  • PK (crewId) — char(50) — Primary key — NOT NULL
  • (crewName) — char(50)

MEMBER (Untitled)

  • PK (memberId) — char(50) — Primary key — NOT NULL
  • (kakaoId) — Long
  • (email) — Long
  • (password) — char(50)
  • (classyIDName) — Long
  • (classyNickName) — char(50)
  • (authKey) — char(50)
  • (authStatus) — Int
  • (profileImage) — char(50)
  • FK (crewId) — Long — Foreign key → CREW.PK — NOT NULL

VIDEO (CopyOfUntitled2)

  • PK (videoId) — Long — Primary key — NOT NULL
  • (title) — char(50)
  • (views) — Long
  • (Field) — char(20)
  • (uploadDate) — Date
  • FK (memberId) — Long — Foreign key → MEMBER.PK — NOT NULL