I'm just mapping out what I have so far from AC, based on our recent discussions. This will probably change a lot before implementation.
- Convert "authors" to "people", so it can also include engravers and illustrators. They will therefore inherit all the fields already available for authors automatically.
- Add an "illustrations" table consisting of:
- id
- illustration title (if there is one)
- illustration description
- medium (MdhStrLookupField)
- organ
- vol
- num
- page(s)
- illustrators (one-to-many link to "people" table)
- engravers (ditto)
- associated poem(s) (one-to-many link to "poems" table)
(Possibly also "anonymous" and "unsigned", as we have for the poems?)
- Add a one-to-many "illustrations" field to the "poems" table.
- Remove the following fields from the "poems" table:
- illustrator
- illustrations