music

Tables (4)

comments

  • id (Key) — PK, AUTO_INCREMENT — Primary key — NOT NULL
  • review_id (Field)
  • user_id (Field2)
  • content (Field3)
  • created_at (Field4)

music

  • id (Key) — PK, AUTO_INCREMENT — Primary key — NOT NULL
  • title (Field)
  • artist (Field2)
  • genre (Field3)
  • release_date (Field4)
  • cover_url (Field5)

reviews (review)

  • id (Key) — PK, AUTO_INCREMENT — Primary key — NOT NULL
  • user_id (Field)
  • music_id (Field2)
  • content (Field3)
  • rating (Field4)
  • created_at (Field5)

users

  • id (Key) — PK, AUTO_INCREMENT — Primary key — NOT NULL
  • username (Field)