final_music_streaming

Tables (11)

ALBUM

  • album_id — INT
  • title — VARCHAR(100) — NOT NULL
  • release_date — DATE
  • artist_id — INT
  • cover_url — VARCHAR(255)

ARTIST

  • artist_id — INT
  • name — VARCHAR(100) — NOT NULL
  • bio — TEXT
  • image_url — VARCHAR(255)

FOLLOW_ARTIST

  • user_id — INT
  • artist_id — INT
  • followed_at — TIMESTAMP

LIKE_SONG

  • user_id — INT
  • song_id — INT
  • liked_at — TIMESTAMP

LISTEN_HISTORY

  • history_id — INT
  • user_id — INT
  • song_id — INT
  • listened_at — TIMESTAMP

LYRICS

  • song_id — INT
  • content — TEXT

PLAYLIST

  • playlist_id — INT
  • title — VARCHAR(100)
  • user_id — INT
  • created_at — TIMESTAMP

PLAYLIST_SONG

  • playlist_id — INT
  • song_id — INT
  • order_num — INT

SONG

  • song_id — INT
  • title — VARCHAR(100) — NOT NULL
  • duration — INT
  • genre — VARCHAR(50)
  • album_id — INT
  • artist_id — INT

SUBSCRIPTION

  • user_id — INT
  • is_active — BOOLEAN
  • start_date — DATE
  • end_date — DATE
  • payment_method — VARCHAR(50)

USER

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • birthdate — DATE
  • gender — VARCHAR(10)
  • created_at — TIMESTAMP