Database Glossary

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