Sites
The Sites table represents the highest level in the relationships since all data must be associated with a site. A site is a geographical agglomeration of human activity which took place at some point in the past. In terms of how a site is definied (e.g. is it a settlement, a trench or a particular activity area), we have taken a loose approach, and would argue that what is considered a "site" can, in fact, be all of these things. What we categorize as sites mirrors meaningful differentiations as they appear in the archaeological literature.
Column name	Data type	Column description
SiteID	varchar	Unique Site identification number. Numeric of five digits prefix with "S".
SiteName	varchar	Sitename
Region	varchar	Administrative or geographic region. Purely for distinguishing sites with same names. Optional.
Latitude	decimal	Decimal degrees to 3 dp
Longitude	decimal	Decimal degrees to 3 dp. Negative values are west of Greenwich meridian
Country	varchar	Modern geo-political country
Notes	varchar