MML
Tables (4)
Music (음악)
- id (music_id) — big int — Primary key — NOT NULL
- title — varchar(255)
- artist — varchar(255)
- url — varchar(255)
Music_PlayList (음악 플레이리스트)
- id (mp_id) — big int — Primary key — NOT NULL
- id (playlist_id) — big int — Foreign key → Playlist.id — NOT NULL
- id (music_id) — big int — Foreign key → Music.id — NOT NULL
Playlist (플레이리스트)
- id (playlist_id) — big int — Primary key — NOT NULL
- id (user_id) — big int — Foreign key → User.id — NOT NULL
- name — varchar(255)
User (사용자)
- id (user_id) — big int — Primary key — NOT NULL
- email — varchar(255)
- password — varchar(255)