Youtube Music
Tables (12)
album
- album_id — INT
- album_name — VARCHAR(255) — NOT NULL
- release_date — DATE
- img_url — VARCHAR(500)
album_artist
- album_id — INT — Primary key — NOT NULL
- artist_id — INT — Primary key — NOT NULL
album_song
- album_id — INT — Primary key — NOT NULL
- song_id — INT — Primary key — NOT NULL
- track_number — INT
artist
- artist_id — INT
- artist_name — VARCHAR(255) — NOT NULL
- artist_info — TEXT
comment
- comment_id — INT
- user_id — INT — NOT NULL
- song_id — INT — NOT NULL
- comment — TEXT — EX
- comment_date — DATETIME
playlist
- playlist_id — INT — Primary key — NOT NULL
- song_id — INT — Primary key — NOT NULL
- added_date — DATETIME
song
- song_id — INT
- song_title — VARCHAR(255) — NOT NULL
- lyrics — TEXT
- genre — VARCHAR(100)
- views — INT
- duration — INT
- mv_url — TEXT
- mv_thumbnail — TEXT
- bpm — INT
song_artist
- song_id — INT — Primary key — NOT NULL
- artist_id — INT — Primary key — NOT NULL
- role — VARCHAR(100)
song_like
- user_id — INT — Primary key — NOT NULL
- song_id — INT — Primary key — NOT NULL
- like_time — DATETIME
storage
- playlist_id — INT
- user_id — INT — NOT NULL
- playlist_name — VARCHAR(255)
- created_at — DATETIME
user
- user_id — INT
- user_name — VARCHAR(255) — NOT NULL
user_song_history
- user_id — INT — Primary key — NOT NULL
- song_id — INT — Primary key — NOT NULL
- history_cnt — INT
- listened_at — DATETIME