GenesisLab-Task-ERD

Tables (3)

Role (권한)

  • id (user_id) — Long — Foreign key → User.id — NOT NULL
  • Role (role) — ENUM("ADMIN", "USER")

User (회원)

  • id (user_id) — Long — Primary key — NOT NULL
  • email (user_email) — String
  • name (user_name) — String
  • phoneNumber (user_phoneNumber) — String
  • password (user_password) — String
  • refreshToken (user_refreshToken) — String

Video (영상)

  • id (video_id) — Long — Primary key — NOT NULL
  • id (user_id) — Long — Foreign key → User.id — NOT NULL
  • originalVideoName (video_original_name) — String
  • videoPath (video_path) — String