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