real_music_app

Tables (4)

likes

  • user_id — INT — Foreign key → users.id
  • song_id — INT — Foreign key → songs.id
  • created_at — DATETIME
  • updated_at — DATETIME

recent_plays

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id
  • song_id — INT — Foreign key → songs.id
  • played_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

songs

  • id — INT — Primary key
  • title — VARCHAR(30) — NOT NULL
  • cover_url — VARCHAR(255)
  • audio_url — VARCHAR(255) — NOT NULL
  • duration — INT
  • created_at — DATETIME
  • updated_at — DATETIME
  • uploader_id — INT — Foreign key → users.id

users

  • id — INT — Primary key
  • email — VARCHAR(30) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • username — VARCHAR(30) — NOT NULL
  • profile_image_url — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME
  • isVerified — BOOLEAN
  • signup_token — VARCHAR(255)
  • signup_token_expiration — DATETIME
  • Field