mariadb-practices
Tables (6)
album
- id — int — Primary key — NOT NULL
- title — varchar(100)
- artist — varchar(45)
- company — varchar(45)
- song — varchar(45)
- company_id — int — Foreign key → company.id — NOT NULL
artist
- id — int — Primary key — NOT NULL
- name — varchar(45) — NOT NULL
- profile — varchar(45)
company
- id — int — Primary key — NOT NULL
- name — varchar(45)
- ceo — varchar(45)
genre
- id — int — Primary key — NOT NULL
- name — varchar(45) — NOT NULL
- abbr_name — varchar(45) — NOT NULL
genre_song
- genre_id — int — Foreign key → genre.id — NOT NULL
- song_id — int — Foreign key → song.id — NOT NULL
song
- id — int — Primary key — NOT NULL
- title — varchar(45) — NOT NULL
- album_id — int — Foreign key → album.id — NOT NULL
- artist_id — int — Foreign key → artist.id — NOT NULL