musicLibrary

Tables (5)

Untitled (users)

  • name — VARCHAR(20) — Primary key — NOT NULL
  • email — VARCHAR(30)

Untitled2 (composers)

  • id — int — Primary key — NOT NULL
  • age — int
  • namen (name) — VARCHAR(20)

Untitled3 (album)

  • id — int — Primary key — NOT NULL
  • name — VARCHAR(30)
  • composers (composers_id) — int — Foreign key → Untitled2.id — NOT NULL

Untitled4 (like)

  • users_songs — int — Primary key — NOT NULL
  • song (song_name) — VARCHAR(20) — Foreign key → Untitled5.name — NOT NULL
  • users (users_name) — VARCHAR(20) — Foreign key → Untitled.name — NOT NULL

Untitled5 (songs)

  • name — VARCHAR(20) — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Untitled3.id — NOT NULL