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)