Archaeology Catalog Table Definitions
The Archaeology Catalog for the IMNH database consists of two interconnected tables. One is a table designed to contain information specific to just archaeologically collected artifacts. This table is called 'ArchaeologyCatalog.' The other table in this relationship contains information common to all the items contained within the IMNH Anthropology collections, and is called 'AnthropologyCatalog.' The relationship between the two tables is supplied through the common field CatalogNumber.

In order to distinguish between fields, the table name is typically pre-pended to the field name. For example, to select the field 'AccessionNumber' you would select 'AnthropologyCatalog.AccessionNumber.'
Click here for an Authoritative list of database entries.

Table: Anthropology Catalog
Columns
Table: Archaeology Catalog
Columns
Name Type Size
CatalogNumber Text 15
AccessionNumber Text 8
ItemNumber Long Integer 4
TemporaryNumber Text 12
OtherNumber Text 15
Part Text 5
CollectionName Text 50
ObjectName Text 35
Modifier Text 35
AlternateName Text 35
PrimaryFunctionCategory Text 35
SecondaryClassification Text 35
Culture Text 35
Materials Text 20
Decorations Text 50
ProductionMethod Text 35
Measurements Text 50
Attribution Text 50
Condition Text 25
Description Memo -
Associations Memo -
ProvenanceObjectHistory Memo -
Comments Memo -
CataloguedBy Text 35
CatalogueDate Date/Time 8
DataEntryBy Text 35
DataEntryDate Date/Time 8
Name Type Size
CatalogNumber Text 15
SiteNumber Text 12
FieldNumber Text 15
FSNumber Long Integer 4
SubItemNumber Long Integer 4
Grid Text 20
Level Text 15
Feature Text 25
Area Text 20