It would also be very helpful if I could enter all the notes on each map into the database. At some point in the future, when we have a user interface, this would allow map pages with all the relevant data to be generated automatically.
The Maps section requires the following fields for each map (* means that field may require multiple entries for one map):
- Map Name
- Publication Date
- Hex Scale
- Area shown
First, area shown will be done using a linkage table with the locations section, but since we haven't got that set in stone yet I will leave it alone for now.
A map is defined as a certain area (indicated by the name) shown at a certain scale, in a certain way (type). The other tables will define the different versions of these base maps.
publication_date (year and optionally month too)
Finally, these two tables define the authors and sources of a particular instance of a map.
Some examples of the types I'm defining in all these tables:
Map formats: Poster map, Inside cover map, Trifold cover map, In-book map; PNG file, JPEG file, GIF file, PDF file.
Map types: Geographical, Political, Contour, Town, etc.
Map hex scales: 2 miles per hex, 8 miles per hex, 24 miles per hex, ... ..., Non-hex.
Officialness: Official, Based entirely on official sources, Speculative based on official sources, Unofficial (not based on official sources).