streaming

Tables (7)

Album (album)

  • album_id — bigint — Primary key — NOT NULL
  • artist_id — bigint — Foreign key → Artist.artist_id — NOT NULL
  • genre_id — bigint — Foreign key → Genre.genre_id — NOT NULL
  • album_name — varchar(30)
  • release_date — date

Artist (artist)

  • artist_id — bigint — Primary key — NOT NULL
  • artist_name — varchar(30)

Genre (genre)

  • genre_id — bigint — Primary key — NOT NULL
  • genre_name — varchar(30)

Member (member)

  • member_id — bigint — Primary key — NOT NULL
  • name (username) — varchar(30)
  • email — varchar(40)
  • phone — varchar(30)
  • password — varchar(30)

Music (music)

  • music_id — bigint — Primary key — NOT NULL
  • album_id — bigint — Foreign key → Album.album_id — NOT NULL
  • genre_id — bigint — Foreign key → Genre.genre_id — NOT NULL
  • music_name — varchar(30)
  • running_time — varchar(30)
  • streaming_count — bigint

Playlist_Item (playlist_item)

  • playlist_name — varchar(30) — Foreign key → playlist.playlist_name — NOT NULL
  • member_id — bigint — Foreign key → playlist.member_id — NOT NULL
  • music_id — bigint — Foreign key → Music.music_id — NOT NULL

playlist

  • playlist_name — varchar(30) — Primary key — NOT NULL
  • member_id — bigint — Foreign key → Member.member_id — NOT NULL