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