The database schema is outlined below. Individual records (Items) are all related to a single Category. The Category table then needed to be linked to the relevant Thesauri Term and a flag field to show that a relationship exists.

Since the application will also display data from the database that is not part of any thesaurus, such as the latest archaeological digs, or museums with archaeology, the IsFISH (bit field) flag determines whether the Category is capable of being exported to MIDAS XML.

GM_Category

This holds all the Categories. Categories have a relationship to a ParentCategoryID because TreeView is used to display the Categories. The IsFISH bit field can be seen as well as the THE_TE_UID field for linking a Category to a Term.

GM_EH_Terms

This holds the Terms from all EH Thesauri.