ChartMetaDataERD

Tables (6)

Album

  • index (albumIndex) — Primary key — NOT NULL
  • Field4 (artistIndex)
  • Field3 (albumName)
  • name (albumBarcode)
  • Field2 (albumReleaseDate)
  • Field2 (albumType)
  • Field (albumGenre)
  • Field3 (albumSummary)
  • Field3 (albumPlanner)
  • Field (albumDistributor)
  • Field5 (albumTrackList)
  • Field (albumIsImported)

Untitled (Artist)

  • Key (artistIndex) — Primary key — NOT NULL
  • Field (artistName)
  • Field6 (artistNation)
  • Field2 (artistType)
  • Field5 (artistBirthdate)
  • Field4 (artistSummary)
  • Field3 (artistEntertainment)
  • Field4 (artistWorkingType)

Untitled (Song)

  • Key (songIndex) — Primary key — NOT NULL
  • Field4 (songName)
  • Field (artistIndex)
  • Field2 (albumIndex)
  • Field3 (songTarcknum)
  • Field5
  • Field6
  • Field7
  • Field8
  • Field9

Untitled (AlbumRelation)

  • Field (LeadingAlbumIndex)
  • Field2 (FollowingAlbumIndex)
  • Field3 (relationType)

Untitled (Genre)

    Untitled (AlbumSong)

    • Key (songIndex) — Primary key — NOT NULL
    • Field
    • Field2
    • Field3
    • Field4
    • Field5
    • Field6
    • Field7
    • Field8