ssafy_voicelegned

Tables (7)

album_users

  • id — BIGINT
  • album_id — BIGINT — Foreign key → albums.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL

album_videos

  • id — BIGINT
  • album_id — BIGINT — Foreign key → albums.id — NOT NULL
  • video_id — BIGINT — Foreign key → videos.id — NOT NULL
  • created_at — DATETIME — NOT NULL

albums

  • id — BIGINT
  • owner_id — BIGINT — Foreign key → users.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • id — BIGINT
  • kakao_id — BIGINT — NOT NULL
  • user_code — VARCHAR(20) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

video_comments

  • id — BIGINT
  • album_video_id — BIGINT — Foreign key → album_videos.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

video_reactions

  • id — BIGINT
  • album_video_id — BIGINT — Foreign key → album_videos.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • emoji — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

videos

  • id — BIGINT
  • uploader_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • video_url — VARCHAR(500) — NOT NULL
  • thumbnail_url — VARCHAR(500)
  • duration_sec — DECIMAL(10,3)
  • subtitle_file_url — VARCHAR(500)
  • vibration_file_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL