DB project
Tables (8)
Agency
- agency_nema (agency_name) — VARCHAR(100) — Primary key — NOT NULL
- agency_phone — VARCHAR(20)
Artist
- artist_id — INT — Primary key — NOT NULL
- artist_name — VARCHAR(100)
- debut_date — DATE
- agency_name — VARCHAR(100)
- agency_nema (agency_name2) — VARCHAR(100) — Foreign key → Agency.agency_nema — NOT NULL
Menbership
- membership_status — VARCHAR(20) — Primary key — NOT NULL
- membership_price — INT
Playlist
- playlist_id — INT — Primary key
- playlist_title — VARCHAR(150)
- description — VARCHAR(255)
- created_date — DATETIME
- user_id — INT — Foreign key → User.user_id
Playlist_Track
- playlist_id — INT — Foreign key → Playlist.playlist_id
- track_id — INT — Foreign key → Track.track_id — NOT NULL
- added_date — DATETIME
Track
- track_id — INT — Primary key — NOT NULL
- title — VARCHAR(150)
- lyrics — TEXT
- genre — VARCHAR(50)
- album_title — VARCHAR(150)
- artists — VARCHAR(255)
Track_Artist
- track_id (track_id2) — INT — Foreign key → Track.track_id — NOT NULL
- artist_id — INT — Foreign key → Artist.artist_id — NOT NULL
User
- user_id — INT — Primary key
- email — VARCHAR(100)
- password — VARCHAR(255)
- nickname — VARCHAR(50)
- membership_stauts (membership_status) — VARCHAR(20)
- membership_status (membership_status2) — VARCHAR(20) — Foreign key → Menbership.membership_status — NOT NULL