The Before State

The original schema had three separate author join tables:

TableDomain FKNotes
BlogAuthorsBlogIdNo Role field
GalleryAuthorsAlbumIdNo Role field
TrackAuthorsTrackIdHad Role (e.g. “producer”, “vocalist”)