DB
Tables (12)
Alubum
- albumid (Key) — Primary key — NOT NULL
- artistid (Field) — Foreign key → Artist.artistid
- jacket (Field2)
- title (Field3)
- song (Field4)
- artist (Field5)
Artist (Untitled)
- artistid (Field) — Primary key
- name (Field2)
- song (Field3)
- albumid (Field4)
- member (Field5)
MainGenre
- maingenreid (Key) — Primary key — NOT NULL
- name (Field2)
PlayLIst
- playlistid (Key) — Primary key — NOT NULL
- userid (Key2) — Foreign key → User.userid — NOT NULL
- date (Field3)
- title (Field4)
- tag (Field5)
- text (Field6)
PlayListSong
- playlistid (Key) — Foreign key → PlayLIst.playlistid — NOT NULL
- userid (Key2) — Foreign key → PlayLIst.userid — NOT NULL
- songid (Key3) — Foreign key → Song.songid — NOT NULL
- albumid (Key22) — Foreign key → Song.albumid — NOT NULL
- artistid (Field3) — Foreign key → Song.artistid
Situation
- situationid (Key) — Primary key — NOT NULL
- name (Field)
Song
- songid (Key) — Primary key — NOT NULL
- albumid (Key2) — Foreign key → Alubum.albumid — NOT NULL
- artistid (Field) — Foreign key → Artist.artistid
- title (Field2)
- artistid (Field3)
- lyric (Field6)
- writer (Field7)
- gender (Field8)
- age (Field9)
- albumid (Field5)
- tag (Field4)
SubGenre
- subgenreid (Key) — Primary key — NOT NULL
- maingenreid (Key2) — Foreign key → MainGenre.maingenreid — NOT NULL
- name (Field2)
Tag
- weatherid (Key) — Foreign key → Weather.weatherid — NOT NULL
- situationid (Key2) — Foreign key → Situation.situationid — NOT NULL
- maingenreid (Key3) — Foreign key → MainGenre.maingenreid — NOT NULL
- playlistid (Key4) — Foreign key → PlayLIst.playlistid — NOT NULL
- userid (Key22) — Foreign key → PlayLIst.userid — NOT NULL
Text
- playlistid (Key) — Foreign key → PlayLIst.playlistid — NOT NULL
- userid (Key2) — Foreign key → PlayLIst.userid — NOT NULL
- content (Field2)
User
- userid (Key) — Primary key — NOT NULL
- password (Field2)
- name (Field3)
- email (Field4)
- favorite (Field5)
Weather
- weatherid (Key) — Primary key — NOT NULL
- name (Field)