SINGER
Tables (7)
ALBUM (Untitled2)
- album_id — int — Primary key — NOT NULL
- title — varchar(100)
- release_date — date
- singer_id — int — Foreign key → SINGER.singer_id — NOT NULL
- group_id — int — Foreign key → Group.group_id — NOT NULL
Genre (Untitled5)
- genre_id — int — Primary key — NOT NULL
- genre_name — varchar(100)
Group (Untitled6)
- group_id — int — Primary key — NOT NULL
- group_name — varchar(100)
SINGER (Untitled)
- singer_id — int — Primary key — NOT NULL
- singer_name — VARCHAR(100)
SONG (Untitled3)
- song_id — int — Primary key — NOT NULL
- title — varchar(200)
- duration — int
- album_id (album_id2) — int — Foreign key → ALBUM.album_id — NOT NULL
entertainment (Untitled7)
- id (Key) — Primary key — NOT NULL
- Field
- singer_id — int — Foreign key → SINGER.singer_id — NOT NULL
song_singer (Untitled4)
- song_singer_id (song_singer) — int — Primary key — NOT NULL
- singer_id — INT — Foreign key → SINGER.singer_id — NOT NULL
- song_id — int — Foreign key → SONG.song_id — NOT NULL
- group_id — int — Foreign key → Group.group_id — NOT NULL