WeTube

Tables (3)

Comment (Untitled3)

  • text (comment_text) — STR — Primary key — NOT NULL
  • creatorAt (comment_creatorAt) — Date
  • creator (comment_creator) — User — Foreign key → Video.fileUrl — NOT NULL

User (Untitled)

  • name (user_name) — STR — Primary key — NOT NULL
  • email (user_email) — STR — Primary key — NOT NULL
  • avatarUrl (user_avatart) — STR
  • kakaoId (user_kakaoId) — NUM
  • githubId (user_githubId) — NUM
  • comments (user_comments) — Comment
  • videos (user_videos) — Video

Video (Untitled2)

  • fileUrl (video_fileUrl) — STR — Primary key — NOT NULL
  • title (video_title) — STR
  • description (video_description) — STR
  • views (video_views) — STR
  • createdAt (video_createdAt) — Date
  • comments (video_comments) — Comment
  • creator (user_name) — User — Foreign key → User.name — NOT NULL