anysong

Tables (5)

album (Untitled3)

  • Key (id) — int — Primary key — NOT NULL
  • Field (title) — varchar(40)
  • Field (artist) — varchar(20)
  • Field (release_date) — date

album_rating (Untitled5)

  • Key (id) — int — Primary key — NOT NULL
  • Field (user_id) — varchar(50)
  • Key (album_id) — int — NOT NULL
  • Key3 (rating) — float — NOT NULL
  • Field (comment) — text

song (Untitled2)

  • Key (album_id) — int — Primary key — NOT NULL
  • Key (album_number) — int — Primary key
  • Key (id) — int — Primary key — NOT NULL
  • Field (artist) — varchar(20)
  • Field (title) — varchar(40)

song_rating (Untitled4)

  • Key (id) — int — Primary key — NOT NULL
  • Field (user_id) — varchar(50)
  • Field (song_id) — int
  • Field (rating) — float
  • Field (comment) — text

users (Untitled)

  • (email_Id) — varchar(50) — Primary key — NOT NULL
  • Field (nickname) — varchar(20)
  • Field (introduction) — varchar(200)
  • Field (password) — varchar(50)