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