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)