Database Fields
The section below documents the structure of the tables in the main comprehensive database. Refer to the Glossary for detailed information about the meaning of selected fields.
ArtifactCatalog
| Field Name | Type | Size |
|---|---|---|
| KeyID | Long Integer | 4 |
| Site | Text | 255 |
| SiteName | Text | 50 |
| ContextNumber | Text | 255 |
| MacCordLot | Text | 255 |
| Count | Double | 8 |
| WeightOz | Text | 255 |
| WeightG | Text | 255 |
| Material | Text | 255 |
| ClassTemper | Text | 255 |
| ObjectType | Text | 255 |
| Element | Text | 255 |
| TechWare | Text | 255 |
| SubTechWare | Text | 255 |
| Glaze | Text | 255 |
| Paste | Text | 255 |
| SurfaceTreatment | Text | 255 |
| Decoration | Text | 255 |
| Color | Text | 255 |
| VarietyAttributes | Text | 255 |
| BoreDiameter | Text | 255 |
| MarkType | Text | 255 |
| MakersMarks | Text | 255 |
| Taxonomy | Text | 255 |
| Dimensions | Text | 255 |
| Condition | Text | 255 |
| Remarks | Text | 255 |
ContextRecords
| Field Name | Type | Size |
|---|---|---|
| KeyID | Long Integer | 4 |
| Site | Text | 50 |
| SiteName | Text | 50 |
| ContextNumber | Text | 50 |
| DepositType | Text | 255 |
| ShortTitle | Text | 255 |
| ContextDescription | Text | 255 |
| CenterX | Double | 8 |
| CenterY | Double | 8 |
| GridNorthCoord | Double | 8 |
| GridEastCoord | Double | 8 |
| NorthingY | Double | 8 |
| EastingX | Double | 8 |
| HorizLoc | Text | 255 |
| ExcavationUnit | Text | 50 |
| FeatureNumber | Text | 50 |
| StratLevel | Text | 50 |
| Provenience | Text | 255 |
| Area | Text | 50 |
| UnitSize | Text | 50 |
| SizeMultiple | Double | 8 |
| SCNumber | Text | 50 |
| SCLetter | Text | 50 |
| MacCordUnit | Text | 50 |
| MacCordAccNumber | Double | 8 |
| JPPMLot | Double | 8 |
| JPPMDistributionMap | Text | 50 |
| ExcavationMethod | Text | 50 |
| ScreenType | Text | 50 |
| FeatureType | Text | 50 |
| BasinType | Text | 50 |
| TemporalPeriod | Text | 50 |
| ContextType | Text | 50 |
| Remarks | Text | 255 |
| ExcavatorsNotes | Text | 255 |
| SupervisorsNotes | Text | 255 |
| ContextLater | Text | 50 |
| ContextEarlier | Text | 50 |
| TPQ | Text | 50 |
| PlanShape | Text | 50 |
| ProfileShape | Text | 50 |
| SoilType | Text | 50 |
| SoilTexture | Text | 50 |
| MunsellColor | Text | 50 |
| Length | Text | 50 |
| Width | Text | 50 |
| Depth | Text | 50 |
| XCoord | Text | 50 |
| YCoord | Text | 50 |
| ZCoord | Text | 50 |
| ExcavatedBy | Text | 50 |
| ExcavatedDate | Date/Time | 8 |
Artifact Counts
| Field Name | Type | Size |
|---|---|---|
| SiteAbbrev | Text | 10 |
| SiteName | Text | 255 |
| WCTP 10-64 | Long Integer | 4 |
| WCTP 9-64 | Long Integer | 4 |
| WCTP 8-64 | Long Integer | 4 |
| WCTP 7-64 | Long Integer | 4 |
| WCTP 6-64 | Long Integer | 4 |
| WCTP 5-64 | Long Integer | 4 |
| WCTP 4-64 | Long Integer | 4 |
| WCTP Total | Long Integer | 4 |
| Terra Cotta Tobacco Pipes | Long Integer | 4 |
| Case Bottle Fragments | Long Integer | 4 |
| Wine Bottle Fragments | Long Integer | 4 |
| Bottle Glass Total | Long Integer | 4 |
| Tin-Glazed Earthenware | Long Integer | 4 |
| North Devon Sgraffito | Long Integer | 4 |
| North Italian Slipware | Long Integer | 4 |
| Staffordshire Slipware | Long Integer | 4 |
| North Devon Gravel-Tempered Earthenware | Long Integer | 4 |
| North Devon Gravel-Free Earthenware | Long Integer | 4 |
| Borderware | Long Integer | 4 |
| Buckley-type | Long Integer | 4 |
| Rhenish Blue and Gray Stoneware | Long Integer | 4 |
| Rhenish Brown Stoneware | Long Integer | 4 |
| Rhenish Stoneware Unidentified | Long Integer | 4 |
| English Brown Stoneware | Long Integer | 4 |
| White Salt-Glazed Stoneware | Long Integer | 4 |
| Porcelain | Long Integer | 4 |
| Ceramics Total | Long Integer | 4 |
| Food Drink Storage | Long Integer | 4 |
| Food Drink Preparation | Long Integer | 4 |
| Food Drink Consumption | Long Integer | 4 |
| Ceramics Native American Late Woodland | Long Integer | 4 |
| Wrought Nails | Long Integer | 4 |
| Window Cames | Long Integer | 4 |
| Locking Mechanisms | Long Integer | 4 |
| Keys Key Hole Covers | Long Integer | 4 |
| Gun Parts Ammunition | Long Integer | 4 |
| Armor Weaponry | Long Integer | 4 |
| Horse Furniture | Long Integer | 4 |
| Personal Adornment | Long Integer | 4 |
| Clothing Sewing Items | Long Integer | 4 |
| Recreational Material | Long Integer | 4 |
| Spoons Forks Knives | Long Integer | 4 |
| Home Beautification Count | Long Integer | 4 |
| Home Beautification Weight Grams | Double | 8 |
| Bone Refuse Count | Long Integer | 4 |
| Shell Refuse Count | Long Integer | 4 |
| Roofing Tile Count | Long Integer | 4 |
| Flooring Tile Count | Long Integer | 4 |
| Yellow Brick Count | Long Integer | 4 |
| Red Brick Count | Long Integer | 4 |
| Brick Total Count | Long Integer | 4 |
| Bone Refuse Weight Grams | Double | 8 |
| Shell Refuse Weight Grams | Double | 8 |
| Roofing Tile Weight Grams | Double | 8 |
| Flooring Tile Weight Grams | Double | 8 |
| Yellow Brick Weight Grams | Double | 8 |
| Red Brick Weight Grams | Double | 8 |
| Brick Total Weight Grams | Double | 8 |
| Bone Refuse Weight Oz | Double | 8 |
| Shell Refuse Weight Oz | Double | 8 |
| Roofing Tile Weight Oz | Double | 8 |
| Flooring Tile Weight Oz | Double | 8 |
| Yellow Brick Weight Oz | Double | 8 |
| Red Brick Weight Oz | Double | 8 |
| Brick Total Weight Oz | Double | 8 |