EDS_TONY_MUSIC_TRAVEL

Tables (12)

Album (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — char
  • release_date (Field2) — datetime

Artist (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — char

Genre (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — char

Hashtag (Untitled11)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — char

Music (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • album (Key2) — int — Foreign key → Album.id — NOT NULL
  • title (Field) — char

Review (Untitled10)

  • id (Key) — int — Primary key — NOT NULL
  • music (Key2) — int — Foreign key → Music.id — NOT NULL
  • content (Field) — text
  • score (Field2) — int

Tag (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — char

music_artists (Untitled6)

  • artists (Key) — int — Foreign key → Artist.id — NOT NULL
  • musics (Key2) — int — Foreign key → Music.id — NOT NULL

music_featuring_artists (Untitled7)

  • featuring_musics (Key2) — int — Foreign key → Music.id — NOT NULL
  • featuring_artists (Key) — int — Foreign key → Artist.id — NOT NULL

music_genres (Untitled8)

  • genre (Key) — int — Foreign key → Genre.id — NOT NULL
  • musics (Key2) — int — Foreign key → Music.id — NOT NULL

music_tags (Untitled9)

  • tags (Key) — int — Foreign key → Tag.id — NOT NULL
  • musics (Key2) — int — Foreign key → Music.id — NOT NULL

review_hashtags (Untitled12)

  • reviews (Key) — int — Foreign key → Review.id — NOT NULL
  • hashtags (Key2) — int — Foreign key → Hashtag.id — NOT NULL