MusicShelf

Tables (5)

Composer (Untitled4)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)

Music (Untitled3)

  • id (Key) — INT — Primary key — NOT NULL
  • composer_id (Key2) — INT — Foreign key → Composer.id — NOT NULL
  • player_id (Key3) — INT — Foreign key → Player.id — NOT NULL
  • title (Field) — VARCHAR(255)
  • category (Field4) — VARCHAR(255)

Player (Untitled5)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)

Review (Untitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — INT — Foreign key → User.id — NOT NULL
  • music_id (Key3) — INT — Foreign key → Music.id — NOT NULL
  • rating (Field3) — INT
  • comment (Field4) — VARCHAR(255)

User (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • username (Field) — VARCHAR(255)
  • password (Field2) — VARCHAR(255)
  • join)_data (Field3) — DATE
  • user_role (Field4) — VARCHAR(255)