Database Glossary

Definitions for tables in the overall database. Field names, field types, field sizes, and field descriptions are given.

GeneralSiteInformation (General Site Information)

SiteID Long Integer 4 Site ID
SiteNumber Short Text 255 Site number
SiteOrder Short Text 255 Site number, fixed format
County Short Text 255 County
SiteName Short Text 255 Site name
BriefDescription Short Text 255 Brief description
SiteType Short Text 255 Site type
SiteNotes Long Text - Site notes
Ethnicity Short Text 255 Ethnicity
OtherEthnic Short Text 255 Other ethnicity
OtherPrehistoricContext Short Text 255 Other prehistoric context
OtherHistoricContext Short Text 255 Other historic context
LocationEast Short Text 255 Location east
LocationNorth Short Text 255 Location north
HasSiteSummary Yes/No 1 Has site summary?
LinkToSynthesis Short Text 255 Link to Synthesis Project file

SiteFunction (Site Function)

ID Long Integer 4 ID
SiteID Long Integer 4 Site ID
SiteFunction Short Text 255 Site function
HistoricPH Short Text 255 Historic or prehistoric

SiteDate (Site Date)

ID Long Integer 4 ID
SiteID Long Integer 4 Site ID
SiteDate Short Text 255 Site date
HistoricPH Short Text 255 Historic or prehistoric

FeatureInformation (Feature Information)

FeatureID Long Integer 4 Feature ID
FeatureIDText Short Text 255 Feature name
FeatureOrder Short Text 255 Feature name, fixed format
SiteNumber Short Text 255 Associated site number
Macrofeature Short Text 255 Macrofeature
HistoricPrehistoric Short Text 255 Historic or prehistoric
FeatureNotes Long Text - Feature notes
AssociatedFeatures Long Text - Associated features
NoOfArtifacts Long Integer 4 Number of artifacts
Catalog Yes/No 1 Has artifact catalog?
ExcavType Short Text 255 Excavation type
ReportID Short Text 255 Report ID
PrehistoricFeatureDate Long Text - Prehistoric feature date
HistoricFeatureDate Long Text - Historic feature date
SpecializedAnalysis Yes/No 1 Specialized analysis?
SocialStatus Short Text 255 Social status
EthnicStatus Short Text 255 Ethnic status
HouseholdOrName Short Text 255 Household or name
Radiocarbon Yes/No 1 Radiocarbon analysis?
RadiocarbonNotes Short Text 255 Radiocarbon notes
CeramicVessel Yes/No 1 Ceramic vessel analysis?
CeramicVesselNotes Short Text 255 Ceramic vessel notes
GlassVessel Yes/No 1 Glass vessel analysis?
GlassVesselNotes Short Text 255 Glass vessel notes
TobaccoPipeBoreDiameter Yes/No 1 Tobacco pipe bore diameter analysis?
TobaccoPipeBoreDiameterNotes Short Text 255 Tobacco pipe bore diamete notes
FaunalAnalysis Yes/No 1 Faunal analysis?
PaleobotanicalAnalysis Yes/No 1 Paleobotanical analysis?
LithicAnalysis Yes/No 1 Lithic analysis?
FTIR Yes/No 1 FTIR analysis?
XRF Yes/No 1 XRF analysis?
SoilScreened Short Text 255 Soil screened?
SoilChemicalAnalysis Yes/No 1 Soil chemical analysis?
ShellWeighed Yes/No 1 Shell weighed but not counted?
BrickWeighed Yes/No 1 Brick weighed but not counted?
OtherAnalysis Short Text 255 Other analysis?
LooseEnds Yes/No 1 To be further investigated?
NonFeatureCollection Yes/No 1 Non-feature collection?
HistoricOtherText Short Text 255 Historic other text
PrehistoricOtherText Short Text 255 Prehistoric other text
Assemblage Short Text 10 Assemblage? (posthole or larger feature)

FeatureFunction (Feature Function)

ID Long Integer 4 ID
FeatureID Long Integer 4 Feature ID
FeatureFunction Short Text 255 Feature function
HistoricPH Short Text 255 Historic or prehistoric

FeatureDate (Feature Date)

ID Long Integer 4 ID
FeatureID Long Integer 4 Feature ID
FeatureDate Short Text 255 Feature date
HistoricPH Short Text 255 Historic or prehistoric

FeatureEthnicity (Feature Ethnicity)

FeatureID Long Integer 4 Feature ID
EthnicStatus Short Text 255 Ethnic status
FullText Short Text 255 Full text

SynthOnline (Synthesis Online)

CLASS Short Text 10 Site number
SITENAME Short Text 30 Site name
ALTNAME Short Text 55 Alternate name
SITETYPE Short Text 110 Site type
PREHISTORIC Yes/No 1 Prehistoric?
HISTORIC Yes/No 1 Historic?
MARU Decimal 16 Maryland Archeological Research Unit
MARINE Yes/No 1 Marine?
SOILCODE Short Text 12 Soil code
STMULTI Yes/No 1 Multicomponent?
STSLAVE Yes/No 1 Slave-related?
DATEFEAT Yes/No 1 Feature date
KEYWORDS Short Text 255 Keywords
SUMMARY Long Text - Summary
PDF_URL Long Text - URL of PDF file
PDF_REFERENCES Long Text - URL of References PDF file
PDF_URL_STRIPPED Short Text 255 URL of PDF file, fixed format
PDF_REFERENCES_STRIPPED Short Text 255 URL of References PDF file, fixed format
CLASS_FORMATTED Short Text 40 Site number, fixed format

Reports (Reports)

ReportID Long Integer 4 Report ID
ReportOrder Short Text 255 Report order
Author Short Text 255 Author(s)
Title Short Text 255 Title
Imprint Short Text 255 Imprint
ArticleDate Short Text 255 Date produced
Comments Short Text 255 Comments
Caption Short Text 255 Caption for short reference
AuthoredBy Short Text 255 Author(s), bibliography format
ThumbImage Short Text 255 Thumb image
SummaryText Short Text 255 Summary text
PDFFile Short Text 255 Name of PDF file
ReportLocation Short Text 255 Location of report

ReportsToFeatures (Reports To Features)

FeatureID Long Integer 4 Feature ID
FeatureIDText Short Text 255 Feature name
ReportID Short Text 255 Report ID

Links (Other Links)

LinkID Text 255 Link ID
SiteAbbrev Text 255 Standard site abbreviation for project
LinkURL Text 255 Full URL to link
Caption Text 255 Caption
Reference Text 255 Reference
ToDo Text 255 Notes for to do

About the MAC Lab

The MAC Lab
Visiting the MAC Lab

Contact Us