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