Malpaso Database
Part of the La Quemada-Malpaso Valley Archaeological Project (LQ-MVAP) project
Year: 2008
Summary
no description provided
Cite this Record
Malpaso Database. 2008 ( tDAR id: 1266) ; doi:10.6067/XCV87P8X92
Data Set Structure
Table Information: _adHoc_element nameLU
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
adhoc_element_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
element name | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ArtCatAnalyticalClasses
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
AnalyticalClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
AnalyticalClass | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ArtCatFunctionalClasses
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
FunctClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FunctionalClass | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ArtCatManufacturingClasses
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ManufacturingClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ManufacturingClass | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
GenAnalyticalClass | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ArtCatMaterialClasses
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
MaterialClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Material | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ArtifactCatTypes
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ArtCatTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
TypePrefix | TEXT | Uncoded Value | uncategorized | none | none | true |
Type | TEXT | Uncoded Value | uncategorized | none | none | true |
Sort order | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _AU_Phase3
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Phase3_ID | Phase3 unique identifier - | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Phase_Name | phase name | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _AUCultSpace
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
CultSpaceId | Cultural Space unique identifier | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
CultSpace | Cultural space name | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SubChapterId | Sub-chapter FK | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _AUGroupLvl1
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
GroupLvl1Id | Group Level1 unique identifier | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
GroupLvl1 | Group Level1 name | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SiteId | Site Fk | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _AUGroupLvl2
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
GroupLvl2Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
GroupLvl2 | TEXT | Uncoded Value | uncategorized | none | none | true |
SiteID | BIGINT | Uncoded Value | uncategorized | none | none | true |
AuAreaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _AUPhase
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
PhaseId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Phase | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _AUPhase2
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Phase2Id | Phase2 unique identifier | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Phase2 | phase2 name | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _AUReportArea
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ReportAreaId | Report area unique identifier | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
SiteID | Site identifier and FK to sites lookup table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ReportArea | Report area name | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SortOrder | numeric field for sorting records | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _Botan_Types
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Botan_type_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Botan_type | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _Botanical_Types
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Botanical_type_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Botanical_type | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _BotTaxaPaula
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
name | TEXT | Uncoded Value | uncategorized | none | none | true |
s_ColLineage | BLOB | Uncoded Value | uncategorized | none | none | true |
s_Generation | BIGINT | Uncoded Value | uncategorized | none | none | true |
s_GUID | TEXT | Uncoded Value | uncategorized | none | none | true |
s_Lineage | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: _CarbonSampleConcentration
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ConcentrationId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Concentration | TEXT | Uncoded Value | uncategorized | none | none | true |
ConcentrationSp | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CarbonSampleComposition
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
CompositionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Composition | TEXT | Uncoded Value | uncategorized | none | none | true |
CompositionSp | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CarbonSamplePriority
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
PriorityId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Priority | TEXT | Uncoded Value | uncategorized | none | none | true |
PrioritySp | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CarbonSampleSize
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SampleSizeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Size | TEXT | Uncoded Value | uncategorized | none | none | true |
SizeSp | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _Cer_Element_Groups
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Element_group_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Element_group | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _Cer_Elements
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Desccription | TEXT | Uncoded Value | uncategorized | none | none | true |
Cer_element_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Element | TEXT | Uncoded Value | uncategorized | none | none | true |
Element_Group | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CerForm
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
FormId | BIGINT | Uncoded Value | uncategorized | none | none | true |
OrderId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FormName | TEXT | Uncoded Value | uncategorized | none | none | true |
FormCode | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CerPortion
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
OrderId | BIGINT | Uncoded Value | uncategorized | none | none | true |
PortionName | TEXT | Uncoded Value | uncategorized | none | none | true |
PortionCode | TEXT | Uncoded Value | uncategorized | none | none | true |
SpGroupPortion | TEXT | Uncoded Value | uncategorized | none | none | true |
EnGroupPortion | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CerRprtGrps
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ReportGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ReportGroups | TEXT | Uncoded Value | uncategorized | none | none | true |
ReportGroupsSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
ReportGroupOrder | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CerTrtmnt
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
TrtmntId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Treatment | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CerType
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
OrderId | DOUBLE | Uncoded Value | uncategorized | none | none | true |
WareId | BIGINT | Uncoded Value | uncategorized | none | none | true |
TypeName | TEXT | Uncoded Value | uncategorized | none | none | true |
TypeNameSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
TypeLabel | TEXT | Uncoded Value | uncategorized | none | none | true |
ReportGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
TrtmntId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CerType_Old_Bak
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
type_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
order_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
decoration_type | TEXT | Uncoded Value | uncategorized | none | none | true |
type_name | TEXT | Uncoded Value | uncategorized | none | none | true |
type_label | TEXT | Uncoded Value | uncategorized | none | none | true |
s_ColLineage | left over from synch no longer needed - cant delete | |||||
BLOB | Uncoded Value | uncategorized | none | none | true | |
s_Generation | left over from synch no longer needed - cant delete | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
s_GUID | left over from synch no longer needed - cant delete | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
s_Lineage | left over from synch no longer needed - cant delete | |||||
BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: _CerTypeWare
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
WareId | BIGINT | Uncoded Value | uncategorized | none | none | true |
WareName | TEXT | Uncoded Value | uncategorized | none | none | true |
WareNameSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ChapterGroups
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ChapterGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ChapterGroup | TEXT | Uncoded Value | uncategorized | none | none | true |
SiteID | BIGINT | Uncoded Value | uncategorized | none | none | true |
AreaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CulturalSpace
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
CultSpaceId | BIGINT | Uncoded Value | uncategorized | none | none | true |
CultSpace | TEXT | Uncoded Value | uncategorized | none | none | true |
SubGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _DebCortex
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
CotexId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Cortex | TEXT | Uncoded Value | uncategorized | none | none | true |
CortexSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _DebMaterial
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
MaterialId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Material | TEXT | Uncoded Value | uncategorized | none | none | true |
MaterialSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _DebStage
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
StageId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Stage | TEXT | Uncoded Value | uncategorized | none | none | true |
StageSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _DebStageIdx
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
StageIdxId | BIGINT | Uncoded Value | uncategorized | none | none | true |
StageIndex | TEXT | Uncoded Value | uncategorized | none | none | true |
StageIndexSP | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _DebType
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Type | TEXT | Uncoded Value | uncategorized | none | none | true |
TypeSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _DebTypeB
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
TypeBId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Typeb | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FieldNotebooks_old
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
NotebookId | BIGINT | Uncoded Value | uncategorized | none | none | true |
NotebookPrefix | TEXT | Uncoded Value | uncategorized | none | none | true |
NoteBookNumber | BIGINT | Uncoded Value | uncategorized | none | none | true |
Year | BIGINT | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FNTPDF | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FieldNotebooks
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
NotebookId | BIGINT | Uncoded Value | uncategorized | none | none | true |
NotebookPrefix | TEXT | Uncoded Value | uncategorized | none | none | true |
NoteBookNumber | BIGINT | Uncoded Value | uncategorized | none | none | true |
Year | BIGINT | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FNTPDF | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FigFinish
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
FinishId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Finish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FigPortion
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Portion | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FigSex
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SexId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Sex | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FigType
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Type | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FnaBurn
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
BurnId | BIGINT | Uncoded Value | uncategorized | none | none | true |
BurnCode | BIGINT | Uncoded Value | uncategorized | none | none | true |
CodeLabel | TEXT | Uncoded Value | uncategorized | none | none | true |
CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FnaElement
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Utilindex | TEXT | Uncoded Value | uncategorized | none | none | true |
UtilindexSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
ElementId | BIGINT | Uncoded Value | uncategorized | none | none | true |
CodeLabel | TEXT | Uncoded Value | uncategorized | none | none | true |
CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FnaFusion
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
FusionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Code | TEXT | Uncoded Value | uncategorized | none | none | true |
CodeLabel | TEXT | Uncoded Value | uncategorized | none | none | true |
CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FnaHumMod
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
HumModId | BIGINT | Uncoded Value | uncategorized | none | none | true |
HumModCode | TEXT | Uncoded Value | uncategorized | none | none | true |
CodeLabe | TEXT | Uncoded Value | uncategorized | none | none | true |
CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
DescriptionSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FnaNatMod
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
NatModID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Code | TEXT | Uncoded Value | uncategorized | none | none | true |
CodeLabel | TEXT | Uncoded Value | uncategorized | none | none | true |
CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FnaProxDist
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ProxDistId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Code | TEXT | Uncoded Value | uncategorized | none | none | true |
CodeLabel | TEXT | Uncoded Value | uncategorized | none | none | true |
CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FnaTaxa
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Taxa | TEXT | Uncoded Value | uncategorized | none | none | true |
TaxaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
CodeLabel | TEXT | Uncoded Value | uncategorized | none | none | true |
CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
DescriptionSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _GndstnCond
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
CondId | BIGINT | Uncoded Value | uncategorized | none | none | true |
CondCode | TEXT | Uncoded Value | uncategorized | none | none | true |
Condition | TEXT | Uncoded Value | uncategorized | none | none | true |
ConditionSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _GndstnMat
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
MatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
RawMatCode | TEXT | Uncoded Value | uncategorized | none | none | true |
RawMaterial | TEXT | Uncoded Value | uncategorized | none | none | true |
RawMaterialSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _GndstnMTM
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
MTMId | BIGINT | Uncoded Value | uncategorized | none | none | true |
MTMCode | Mano Trough Metate | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ManoTroughMetate | TEXT | Uncoded Value | uncategorized | none | none | true |
ManoTroughMetateSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _GndstnWear
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
WearId | BIGINT | Uncoded Value | uncategorized | none | none | true |
WearCode | TEXT | Uncoded Value | uncategorized | none | none | true |
Wear | TEXT | Uncoded Value | uncategorized | none | none | true |
WearSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _GrndstnCat
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
CatCode | TEXT | Uncoded Value | uncategorized | none | none | true |
Category | TEXT | Uncoded Value | uncategorized | none | none | true |
CategorySpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _HmOsLvl1Grp
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Lvl1GrpId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Lvl1Group | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _HmOstEleNorm
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ElementId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Element | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _HmOstLvl2Grp
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Lvl2GrpId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Lvl2Group | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _IE_Element_Fill_revised
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ElementFillId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FIll | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _IE_Element_Fill
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ElementFillId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FIll | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _IE_Elements
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
IE_ElementId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ElementName | TEXT | Uncoded Value | uncategorized | none | none | true |
ElementDescription | TEXT | Uncoded Value | uncategorized | none | none | true |
ElementTypeId | FK to ElementType Lookup table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
adhocEleType_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
HyperlinkedDrawing | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
cer_element_group_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _IE_Elements_revised
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
IE_ElementId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ElementName | TEXT | Uncoded Value | uncategorized | none | none | true |
ElementDescription | TEXT | Uncoded Value | uncategorized | none | none | true |
ElementTypeId | FK to ElementType Lookup table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ElementGroups | TEXT | Uncoded Value | uncategorized | none | none | true |
HyperlinkedDrawing | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _IE_ElementType_revised
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Element Type | TEXT | Uncoded Value | uncategorized | none | none | true |
ElementTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _IE_ElementType
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ElementTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Element Type | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _LPGeneralSiteAreas
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
SiteArea | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _LPMound1SubAreas
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Mound1SubArea | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _LPPlaza1SubAreas
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Plaza1SubArea | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _MbotFrctnId
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
FractionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Fraction | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _MbotPrtn
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
MbotPortId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Portion | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _MbotTaxa
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
TaxaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Taxa | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RimContourType
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
contour_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Contour type | TEXT | Uncoded Value | uncategorized | none | none | true |
Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RimLipForm
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
lip_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Lip form | TEXT | Uncoded Value | uncategorized | none | none | true |
Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RimLipTreatment
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
lip_treat_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Lip treatment | TEXT | Uncoded Value | uncategorized | none | none | true |
Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RimRimForm
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
rim_form_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Rim form | TEXT | Uncoded Value | uncategorized | none | none | true |
Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RimVsslShp
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
shape_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Shape | TEXT | Uncoded Value | uncategorized | none | none | true |
Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
bowl_jar1 | all vessel shapes classified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
bowl_jar2 | only definitives classified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSContourType
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ContourType | TEXT | Uncoded Value | uncategorized | none | none | true |
example | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSDecoration
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Decoration | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSLipForm
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
LipForm | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSLipTreatment
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
LipTreatment | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSRimForm
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
RimForm | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSSlipConsistency
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SlipConsistency | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSVesselShape_DELETE
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
VesselShape | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSWare_DELETE
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Ware | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ShellClass
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Class | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ShellGenera
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
GeneraId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Genera | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _Sites
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SiteCode | TEXT | Uncoded Value | uncategorized | none | none | true |
SiteName | TEXT | Uncoded Value | uncategorized | none | none | true |
SttlmntAffltn | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _SpecArtClass
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FunctionalClass | TEXT | Uncoded Value | uncategorized | none | none | true |
FunctionalClassSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _SpecArtDec
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
DecTechId | BIGINT | Uncoded Value | uncategorized | none | none | true |
DecTech | TEXT | Uncoded Value | uncategorized | none | none | true |
DecTechSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _SpecArtMat
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SpecArtMatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Material | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _STMatGrpId
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
MatGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
MaterialGroup | TEXT | Uncoded Value | uncategorized | none | none | true |
MaterailGroupSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _STType
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ToolType | TEXT | Uncoded Value | uncategorized | none | none | true |
ToolTypeSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _SubGroups
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SubGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SubGroupName | TEXT | Uncoded Value | uncategorized | none | none | true |
ChapterGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _TableGroups
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
TableGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
TableGroupName | TEXT | Uncoded Value | uncategorized | none | none | true |
TableGroupNamesSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
SiteID | BIGINT | Uncoded Value | uncategorized | none | none | true |
SortOrder | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Table Information: _TypeCllctnFunctClass
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
FunctionalClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
TypeCllctnId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FunctClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _UnitYear
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
UnitYearId | BIGINT | Uncoded Value | uncategorized | none | none | true |
UnitId | BIGINT | Uncoded Value | uncategorized | none | none | true |
YearExcavated | BIGINT | Uncoded Value | uncategorized | none | none | true |
NotebookId | BIGINT | Uncoded Value | uncategorized | none | none | true |
PDFURL | TEXT | Uncoded Value | uncategorized | none | none | true |
PageNumbers | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _UnitYear_old
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
PageNumbers | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
UnitYearId | BIGINT | Uncoded Value | uncategorized | none | none | true |
UnitId | BIGINT | Uncoded Value | uncategorized | none | none | true |
YearExcavated | BIGINT | Uncoded Value | uncategorized | none | none | true |
NotebookId | BIGINT | Uncoded Value | uncategorized | none | none | true |
PDFURL | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _WoodTaxa
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
WoodtaxaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Taxa | TEXT | Uncoded Value | uncategorized | none | none | true |
TaxaSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Area_labels_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Area_name | TEXT | Uncoded Value | uncategorized | none | none | true |
Area_label | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: ArtCatAnalyticalClasses
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
AnalyticalClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: ArtCatFunctionalClasses
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FunctionalClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Priority | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: ArtCatVesselAnalysis
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
WareId | BIGINT | Uncoded Value | uncategorized | none | none | true |
TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
VesselShapeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: ArtifactCat_Bags
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
BagId | BIGINT | Uncoded Value | uncategorized | none | none | true |
BagName | TEXT | Uncoded Value | uncategorized | none | none | true |
BoxId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SummaryDescription | The inventory summary for the Artifact Catalog | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: ArtifactCat_BoxInventory
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
BoxId | BIGINT | Uncoded Value | uncategorized | none | none | true |
BoxNo | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Cataloged | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
SortOrder | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: ArtifactCatalog
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Item | BIGINT | Uncoded Value | uncategorized | none | none | true |
BagId | The bag number is unique and assigned to a unique box number in the ArtifactCat_Bags table - the bag and box number must already exist before this id can be assigned | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Other Prov | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
count | BIGINT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Other Description | TEXT | Uncoded Value | uncategorized | none | none | true |
DetailSheetDescription | 250 word limit | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
CatalogName | TEXT | Uncoded Value | uncategorized | none | none | true |
DetailSheet | Does this item require a Detail catalog sheet? | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
SummarySheet | Is this item in the general catalog summary for its respective box? | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
YearExcavated | TEXT | Uncoded Value | uncategorized | none | none | true |
ArtifactCatType | BIGINT | Uncoded Value | uncategorized | none | none | true |
MaterialId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Site | TEXT | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash # | TEXT | Uncoded Value | uncategorized | none | none | true |
BulkSheetDescription | 250 word limit | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ware | TEXT | Uncoded Value | uncategorized | none | none | true |
type | TEXT | Uncoded Value | uncategorized | none | none | true |
form | TEXT | Uncoded Value | uncategorized | none | none | true |
2007comments | TEXT | Uncoded Value | uncategorized | none | none | true |
INAHCatNum | TEXT | Uncoded Value | uncategorized | none | none | true |
INAHBoxNum | TEXT | Uncoded Value | uncategorized | none | none | true |
WareId | BIGINT | Uncoded Value | uncategorized | none | none | true |
TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
VesselShapeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FunctionalClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ManufacturingClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
AnalyticalClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
MaterialClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: AUs
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
PhaseId | AUs gouped by inferred phases (Early, Late, Terrace FIll, N/A) FK to _TableGroup table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
AUId | PK identifier | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
SiteId | FK to SITE_ID in _SITE table - the Site ID is also avalaible in the ULL table - Field is provided only as a convenience for manipulating this table directly | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
AUNum | Official Analytical Unit Number as appears in final report | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
SortNumber | Nymber used to perform numeric sorts on the text field AUNum | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
new num | temp field used for renumbering aus on the fly | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
BriefDesc | Abbreviated brief description of the AU | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ShortDesc | Contains some abbreviations | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
FullDesc | No abbreviations - Fully written out description of the AU | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SPFullDesc | Spanish translation of FullDesc | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TerraceFill | AUs related to terrace fill | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
Mixed | AUs for which the provenience is not known in more detail than the unit | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
SurfHum | AUs that contain surface and humus deposits | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
BoneConc | AUs related to Bone Concentrations | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
FloorDeposits | All AUs that include floor matrices, and firmes, and fill immediate above floors (ca 10 cm) - doesn't include AUs with other kinds of fill | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
FF | AUs that include pure fill immediately above floors | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
Hearth | AUs related to hearths | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
Midden | AUs related to trash or midden deposits | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
MidNonmid | FK to MidNonmid MidNonmidId - can be used to determine if the AU is from a Midden or Non-Midden context | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
TableGroupId | FK to TableGroup TableGroupId - Initially built to accomodate the organization of artifact counts in the final report tables | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Phase2Id | AUs grouped by inferred phases and deposit type (eg Early, Late, Post-occupational fill, Fill above floor etc). Needs work to be more consistent - FK to _AU Phase2 table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Phase3Id | AUs grouped by phases with midden trash included with early contexts - only includes early terrace contexts and late Fill above floor and no PO | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
DepNotes | Notes about the depositional contexts | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
MiddenPhases | Midden phases and architectural phases are independent of one another. This field applies only to relative strata position within each midden | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
MiddenPhasewithDetail | Used to help further break down phase information by the nature of the context (eg PO, Late, etc.) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
GroupLvl1Id | Useful AU grouping by cultural spaces - needs additional work to be fully consistent and should be moved to separate table - FK to _GroupLvl1 table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
GroupLvl2Id | Useful AU grouping by cultural spaces - needs additional work to be fully consistent and should be moved to separate table - FK to _GroupLvl2 table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
CultSpaceId | AUs grouped by somewhat useful cultural spaces such as room # and the like may need additional work for consistency - FK _CultSpace table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
CeremonialStatus | Is the context ceremonial or non-ceremonial - constructed from Jaime H's groundstone analysis | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Comments | General comments about the AU | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ReportAreaId | AUs grouped by the areas discussed in the Informe Final - FK to _ReportArea table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ChapterId | AUs grouped by the chapters of the informe final (each midden included - even though there is one chapter for all the middens) | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: BoxInv
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ID | unique box indentifier | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Collection | Which artifact collection does the box hold | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Site | What site does the material come from | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Box number | Box Number | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Bag number | Bag Number | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Material | Material | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Size | Size | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Year | Year | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Locality | Locality | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Locus | Locus | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Horizontal | Horizontal | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Vertical | Vertical | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Recorder | Recorder | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Bag count | Bag Count | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Comments | Comments | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: CADLabels
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ID | Unique label identifier | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
FileName | AutoCad file to which the label belongs | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
EnglishLabels | English label text | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SpanishLabels | Spanish label text | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: CarbonSamples
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SampleSize | Sample Size - not a necessary field - used to check accuracy of the SampleSizeID field | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SampleSizeId | Sample Size identifier and FK | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
CarbonSampleId | Unique carbon sample identifier | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
SiteId | Site ID FK | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Unit | Unit | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Level | Level | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Locus | Locus | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Slash | Slash number or letter | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULL | Unit-Level-Locus - not a necessary field - was for checking accuracy of ULLID | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULLId | Unit-Level-Locus identifier and FK | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
PointLocation | Point provenience information | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
DateExcavated | Date sample was excavated | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SizeNotes | Comments from the field notes regarding sample size | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Composition | Composition - not a necessary field - was used for checking accuracy of the CompositionID | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
CompositionId | Composition identifier and FK | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
CompNotes | Comments from the field notees regarding the sample's composition | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Associations | Comments from the field notes regarding other artifact or feature associations with the sample | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Concentration | Category referring to the degree of dispersion or concentration of the sample | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ConcentrationId | Concentration Fk to lookup | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ConcNotes | Comments in the field notes regarding the nature of the sample's concentration | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Contamination | Potential sources of sample contamination | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Priority | Scale of 1 to 10 (1 being highest) of the excavator's opinion on whether the sample should be sent to C14 lab for dating | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
PriorityId | Priority FK to lookup table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
PriorityNotes | Comments in the field note regarding the importance and datability of the sample | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Soil | Nature of the soil matrix within which the sample was found | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Comments | Comments | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
DateId | Has value if the sample was dated - this is the FK link to the Dates table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Ceramics
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Collection | LQ-MVAP - from our excavations, Armillas - from the Armillas collection | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Year | Year specimens were excavated | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SiteId | Site at which specimens derived - FK to _Site table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ULL | Redundant data left for purposes of crosschecking for reassigned ULLs - do not delet yet | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
CerId | Ceramic idenitification Number | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ULLId | ULL identification number creating link to ULL tabl - FK to ULL table (displays the ULL, but underlying value is the ULLId value) | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Unit | Unit designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Level | Level designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Locus | Locus Designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Slash | Slash number or letter | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TypeId | Type designation - FK to _CerType table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
TypeCnfdnc | C - Confident, U - Unconfident | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
FormId | Form Designation - FK to _CerForm table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
FormCnfdnc | C - Confident, U - Unconfident | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
PortionId | Portion Designation - FK to _CerPortionId | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Count | Artifact count | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Sorter | Name of ceramic sorter | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Comments | General comments | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TypeOld | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Ceramics_old_del
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
CerId | Ceramic idenitification Number | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Year | Year specimens were excavated | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Collection | LQ-MVAP - from our excavations, Armillas - from the Armillas collection | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SiteId | Site at which specimens derived - FK to _Site table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ULL | Redundant data left for purposes of crosschecking for reassigned ULLs - do not delet yet | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULLId | ULL identification number creating link to ULL tabl - FK to ULL table (displays the ULL, but underlying value is the ULLId value) | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Unit | Unit designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Level | Level designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Locus | Locus Designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Slash | Slash number or letter | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TypeId | Type designation - FK to _CerType table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
TypeCnfdnc | C - Confident, U - Unconfident | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
FormId | Form Designation - FK to _CerForm table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
FormCnfdnc | C - Confident, U - Unconfident | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
PortionId | Portion Designation - FK to _CerPortionId | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Count | Artifact count | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Sorter | Name of ceramic sorter | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Comments | General comments | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TypeOld | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Dates
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
StanDevCon | TEXT | Uncoded Value | uncategorized | none | none | true |
IntCal | TEXT | Uncoded Value | uncategorized | none | none | true |
Cal1sig | TEXT | Uncoded Value | uncategorized | none | none | true |
Lab | TEXT | Uncoded Value | uncategorized | none | none | true |
LabId | TEXT | Uncoded Value | uncategorized | none | none | true |
DateId | BIGINT | Uncoded Value | uncategorized | none | none | true |
RadiocarbonFormId | BIGINT | Uncoded Value | uncategorized | none | none | true |
DateType | TEXT | Uncoded Value | uncategorized | none | none | true |
Submitted | TEXT | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
Level | TEXT | Uncoded Value | uncategorized | none | none | true |
Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
ExcArea | TEXT | Uncoded Value | uncategorized | none | none | true |
Material | TEXT | Uncoded Value | uncategorized | none | none | true |
StratPos | TEXT | Uncoded Value | uncategorized | none | none | true |
MeasC14 | BIGINT | Uncoded Value | uncategorized | none | none | true |
StanDevMeas | BIGINT | Uncoded Value | uncategorized | none | none | true |
13C/12C | TEXT | Uncoded Value | uncategorized | none | none | true |
ConC14 | TEXT | Uncoded Value | uncategorized | none | none | true |
Cal2sig | TEXT | Uncoded Value | uncategorized | none | none | true |
OxCal1sig | TEXT | Uncoded Value | uncategorized | none | none | true |
OxCal2sig | TEXT | Uncoded Value | uncategorized | none | none | true |
Reference | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: DatesListLQ(old)_del
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
+/-* | BIGINT | Uncoded Value | uncategorized | none | none | true |
id | BIGINT | Uncoded Value | uncategorized | none | none | true |
beta sample # | TEXT | Uncoded Value | uncategorized | none | none | true |
site | TEXT | Uncoded Value | uncategorized | none | none | true |
unit | BIGINT | Uncoded Value | uncategorized | none | none | true |
level | BIGINT | Uncoded Value | uncategorized | none | none | true |
locus | TEXT | Uncoded Value | uncategorized | none | none | true |
slash | TEXT | Uncoded Value | uncategorized | none | none | true |
measured C14 age | BIGINT | Uncoded Value | uncategorized | none | none | true |
+/- | BIGINT | Uncoded Value | uncategorized | none | none | true |
C13/C12 ratio | TEXT | Uncoded Value | uncategorized | none | none | true |
conventional C14 age | BIGINT | Uncoded Value | uncategorized | none | none | true |
calibrated results (2 sigma, 95% prob) | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Debitage
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
DebId | Debitage identification number | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Site | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SiteId | Site from which the samples derive - FK _Sites table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ULL | Unit-Level-Locus | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULLId | Unit Level Locus Id - FK to ULL table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Slash | Slash number or letter of the specimen | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TypeId | Flake Type - FK to _DebType table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
TypeBId | Flake TypeB - FK to _DebTypeB table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
StageIndexId | Reduction stage index - FK to _DebStageIndex Table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
StageId | Reduction stage - FK to _DebStage table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
CortexId | Presence or absence of cortex - FK to _DebCortex table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
MatId | Raw material of specimen - FK to _DebMaterial table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Tool | ??? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Count | Specimen count by row | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Comment | General comments | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: elements
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SiteCode | TEXT | Uncoded Value | uncategorized | none | none | true |
ReportAreaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Phase_Name | TEXT | Uncoded Value | uncategorized | none | none | true |
ReportArea | TEXT | Uncoded Value | uncategorized | none | none | true |
Element_group | TEXT | Uncoded Value | uncategorized | none | none | true |
Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
Type | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: elements3_delete
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SiteCode | TEXT | Uncoded Value | uncategorized | none | none | true |
ReportAreaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Phase_Name | TEXT | Uncoded Value | uncategorized | none | none | true |
ReportArea | TEXT | Uncoded Value | uncategorized | none | none | true |
Element_group | TEXT | Uncoded Value | uncategorized | none | none | true |
count | BIGINT | Uncoded Value | uncategorized | none | none | true |
type | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: EP_ULL_VOL_EST_del
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
VOL_EST_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | all valid Ulls from La Qemada | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
unit | used to sort/order ulls | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
level | used to sort/order ulls | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
locus | used to sort/order ulls | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
TOP_BOT_IRREG | is the top shape different from the bottom shape (YES or NO)? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
U_SHAPE | combo box of acceptable shapes - not based on a table | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
L_SHAPE | TEXT | Uncoded Value | uncategorized | none | none | true |
U_LENGTH | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
U_WIDTH | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
U_HEIGHT | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
U_BASE | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
SIDE_A | DOUBLE | Uncoded Value | uncategorized | none | none | true |
SIDE_B | DOUBLE | Uncoded Value | uncategorized | none | none | true |
L_LENGTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
L_WIDTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
L_HEIGHT | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
L_BASE | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
RADIUS | DOUBLE | Uncoded Value | uncategorized | none | none | true |
AREA | shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc]) | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
DEPTH | average depth measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
VOL | measurement in cubic meters (AREA * DEPTH) | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
NOTES | note any unusual steps needed in orde rto make your calculation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: ExcvtdUnits_del
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
UnitId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
UnitNum | TEXT | Uncoded Value | uncategorized | none | none | true |
Location | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Fauna
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ID | Identification number | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Bag | Specimens were pulled from a Bag with this identifier | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Site | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SiteId | FK to SitesId column of the _Sites table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ULL | Unit Level Locus - to be deleted eventually | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULLId | FK to ULLId of the ULL table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
AU | to be deleted? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Sorter | Person who sorted, coded and counted the information | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Comments | General comments | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SecondaryAU | to be deleted? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unit | Unit designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Level | Level designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Locus | Locus designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Slash | Slash number or letter | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Taxa | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TaxaId | FK to the TaxaId column of the _FnaTaxa table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
TaxaDesc | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ElementId | FK to ElementId column of the _FnaElement table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ProxDist | to be delted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ProxDistId | FK to the ProxDistId column of the _FnaProxDist table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Fusion | to be delted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
FusionId | FK to the FusionId column of the _FnaFusion table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
BurnId | FK to the BurnId column of the _FnaBurn table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
BurnDesc | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
HumModId | FK to the HumModId column of the _FnaHumMod table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
HumModDesc | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
NatModId | FK to the NatModId column of the _FnaNatMod table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Count | Count of items in row | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TypeSpecimen | Is the specimen useful for comparison or as a type? - see Rebekah Parks for details | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Fauna_Old_Bak_del
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
AU | TEXT | Uncoded Value | uncategorized | none | none | true |
ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Bag | TEXT | Uncoded Value | uncategorized | none | none | true |
Site | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
Secondary AU | TEXT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
Level | TEXT | Uncoded Value | uncategorized | none | none | true |
Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
Taxa | TEXT | Uncoded Value | uncategorized | none | none | true |
taxa desc | TEXT | Uncoded Value | uncategorized | none | none | true |
Element | TEXT | Uncoded Value | uncategorized | none | none | true |
Prox-dist | TEXT | Uncoded Value | uncategorized | none | none | true |
Fusion | TEXT | Uncoded Value | uncategorized | none | none | true |
Burn | BIGINT | Uncoded Value | uncategorized | none | none | true |
burn desc | TEXT | Uncoded Value | uncategorized | none | none | true |
Hum_mod | TEXT | Uncoded Value | uncategorized | none | none | true |
hum_mod desc | TEXT | Uncoded Value | uncategorized | none | none | true |
Nat_mod | TEXT | Uncoded Value | uncategorized | none | none | true |
Count | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Figurines before removal of 4 items_del
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Figurine_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Site | TEXT | Uncoded Value | uncategorized | none | none | true |
Site_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Com3 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com4 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com5 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com6 | TEXT | Uncoded Value | uncategorized | none | none | true |
Finish | TEXT | Uncoded Value | uncategorized | none | none | true |
FinishId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Com1 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com2 | TEXT | Uncoded Value | uncategorized | none | none | true |
Prim_id | TEXT | Uncoded Value | uncategorized | none | none | true |
F_numb | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Williams_Type | TEXT | Uncoded Value | uncategorized | none | none | true |
LQ_Type | New Types based on Jaime H's classification of 2006 | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Old_Type_Id | Kim Goldstein's original type - no longer used | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
Part | TEXT | Uncoded Value | uncategorized | none | none | true |
PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
FullDesc | TEXT | Uncoded Value | uncategorized | none | none | true |
Sex | TEXT | Uncoded Value | uncategorized | none | none | true |
SexId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Paint | TEXT | Uncoded Value | uncategorized | none | none | true |
PaintId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Com7 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com 8 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com9 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com10 | TEXT | Uncoded Value | uncategorized | none | none | true |
Other_com | TEXT | Uncoded Value | uncategorized | none | none | true |
Count | TEXT | Uncoded Value | uncategorized | none | none | true |
KimsComments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Figurines_legacy_del
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FigurineId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
Com4 | TEXT | Uncoded Value | uncategorized | none | none | true |
ID_name | TEXT | Uncoded Value | uncategorized | none | none | true |
F_numb | BIGINT | Uncoded Value | uncategorized | none | none | true |
Item_numb | TEXT | Uncoded Value | uncategorized | none | none | true |
Site | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
Level | TEXT | Uncoded Value | uncategorized | none | none | true |
Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
Part | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Type | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Sex | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SexId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Paint | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
PaintId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Finish | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
FinishId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Com1 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com2 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com3 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com5 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com6 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com7 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com 8 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com9 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com10 | TEXT | Uncoded Value | uncategorized | none | none | true |
Other_com | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Figurines_new
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Sex | TEXT | Uncoded Value | uncategorized | none | none | true |
SexId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Paint | TEXT | Uncoded Value | uncategorized | none | none | true |
PaintId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Finish | TEXT | Uncoded Value | uncategorized | none | none | true |
FinishId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Com1 | TEXT | Uncoded Value | uncategorized | none | none | true |
Figurine_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Site | TEXT | Uncoded Value | uncategorized | none | none | true |
Site_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Prim_id | TEXT | Uncoded Value | uncategorized | none | none | true |
F_numb | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Williams_Type | TEXT | Uncoded Value | uncategorized | none | none | true |
LQ_Type | New Types based on Jaime H's classification of 2006 | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Old_Type_Id | Kim Goldstein's original type - no longer used | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
Part | TEXT | Uncoded Value | uncategorized | none | none | true |
PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
FullDesc | TEXT | Uncoded Value | uncategorized | none | none | true |
Com2 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com3 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com4 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com5 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com6 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com7 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com 8 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com9 | TEXT | Uncoded Value | uncategorized | none | none | true |
Com10 | TEXT | Uncoded Value | uncategorized | none | none | true |
Other_com | TEXT | Uncoded Value | uncategorized | none | none | true |
Count | TEXT | Uncoded Value | uncategorized | none | none | true |
KimsComments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Grndstn
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
GrndstnId | BIGINT | Uncoded Value | uncategorized | none | none | true |
CatId | FK to the Artifact Catalog Table where possible | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
TypeCatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Year | BIGINT | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
Level | TEXT | Uncoded Value | uncategorized | none | none | true |
Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
ConId | BIGINT | Uncoded Value | uncategorized | none | none | true |
PrcntPrsnt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Length | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Width | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Thinnest | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Thickest | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Weight | TEXT | Uncoded Value | uncategorized | none | none | true |
WearId | BIGINT | Uncoded Value | uncategorized | none | none | true |
MatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ManoSurfaces | DOUBLE | Uncoded Value | uncategorized | none | none | true |
MTMId | BIGINT | Uncoded Value | uncategorized | none | none | true |
TypeCllctn | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
MatCnfdnc | TEXT | Uncoded Value | uncategorized | none | none | true |
AnalyticGroup | special category created for Jaime to help her sort out the specimens she wished to include in her analysis | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TypeCnfdnc | TEXT | Uncoded Value | uncategorized | none | none | true |
Count | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Table Information: Grndstn_Old_Bak_del
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
AU | TEXT | Uncoded Value | uncategorized | none | none | true |
percent_present | BIGINT | Uncoded Value | uncategorized | none | none | true |
id | BIGINT | Uncoded Value | uncategorized | none | none | true |
year | BIGINT | Uncoded Value | uncategorized | none | none | true |
site | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
unit | TEXT | Uncoded Value | uncategorized | none | none | true |
level | TEXT | Uncoded Value | uncategorized | none | none | true |
locus | TEXT | Uncoded Value | uncategorized | none | none | true |
slash | TEXT | Uncoded Value | uncategorized | none | none | true |
locale | TEXT | Uncoded Value | uncategorized | none | none | true |
analytica_unit | TEXT | Uncoded Value | uncategorized | none | none | true |
type | TEXT | Uncoded Value | uncategorized | none | none | true |
tool_category | TEXT | Uncoded Value | uncategorized | none | none | true |
condition | TEXT | Uncoded Value | uncategorized | none | none | true |
length | DOUBLE | Uncoded Value | uncategorized | none | none | true |
width | DOUBLE | Uncoded Value | uncategorized | none | none | true |
wear | TEXT | Uncoded Value | uncategorized | none | none | true |
degree_of_wear | TEXT | Uncoded Value | uncategorized | none | none | true |
material | TEXT | Uncoded Value | uncategorized | none | none | true |
raw_material | TEXT | Uncoded Value | uncategorized | none | none | true |
count | BIGINT | Uncoded Value | uncategorized | none | none | true |
thinnest | DOUBLE | Uncoded Value | uncategorized | none | none | true |
thickest | DOUBLE | Uncoded Value | uncategorized | none | none | true |
manopolish_#wearsurfaces | BIGINT | Uncoded Value | uncategorized | none | none | true |
manopolish_shapedbytroughmetate? | TEXT | Uncoded Value | uncategorized | none | none | true |
comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: IE_SherdElemJunct
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
IESherdId | FK to IESherdId | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
IE_ElementId | FK to IE_Element table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
IE_ElementFillId | FK to Element Fill table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: IE_Sherds
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Coder | TEXT | Uncoded Value | uncategorized | none | none | true |
IESherdsIdD | BIGINT | Uncoded Value | uncategorized | none | none | true |
RimStudyId | FK to RimStudy RimStudyId | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
RNumber | FK to RimStudy R number field | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
SiteId | FK to _Sites | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Site | Site Name | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULL | Only necessary if there is no RNumber (unit-level-locus) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULL_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Slash | Only necessary if there is no RNumber (unit-level-locus) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
DateCoded | DATETIME | Uncoded Value | uncategorized | none | none | true |
BoxNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
BagNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
VNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
YearExcavated | Only necessary if there is no RNumber (unit-level-locus) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: iesherds_copy
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
IESherdsIdD | BIGINT | Uncoded Value | uncategorized | none | none | true |
RimStudyId | FK to RimStudy RimStudyId | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
RNumber | FK to RimStudy R number field | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
VNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
SiteId | FK to _Sites | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ULL | Only necessary if there is no RNumber (unit-level-locus) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULL_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Slash | Only necessary if there is no RNumber (unit-level-locus) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Coder | TEXT | Uncoded Value | uncategorized | none | none | true |
DateCoded | DATETIME | Uncoded Value | uncategorized | none | none | true |
BoxNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
BagNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
YearExcavated | Only necessary if there is no RNumber (unit-level-locus) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULL_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: IllstArtfcts
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
IllustId | BIGINT | Uncoded Value | uncategorized | none | none | true |
CodeId | This code is the lookup to the physical drawings stored in portfolios and notebooks | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
TypeCllctnId | FK to TypeCllctnId column in the TypeCllctn table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Link | This is a hyperlink to the illustration living on the server | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Status | TEXT | Uncoded Value | uncategorized | none | none | true |
SiteId | FK to SiteId column of _Sites tables | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ULL | to be deleted? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Illustration | BLOB | Uncoded Value | uncategorized | none | none | true |
SelectForReport | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
SelectedForCat | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Table Information: IllstOthers
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
IlustId | BIGINT | Uncoded Value | uncategorized | none | none | true |
IllustNum | TEXT | Uncoded Value | uncategorized | none | none | true |
Site | TEXT | Uncoded Value | uncategorized | none | none | true |
SiteId | TEXT | Uncoded Value | uncategorized | none | none | true |
Type | TEXT | Uncoded Value | uncategorized | none | none | true |
TypeId | TEXT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
Area | TEXT | Uncoded Value | uncategorized | none | none | true |
Report/Figure | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: INAH_CAT_EXT_REF_del
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
INAH_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
CATNO | TEXT | Uncoded Value | uncategorized | none | none | true |
BOXNO | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Legacy_BotTaxaMich_del
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Fraction | TEXT | Uncoded Value | uncategorized | none | none | true |
taxa_id | Taxa unique identifier | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Phase | TEXT | Uncoded Value | uncategorized | none | none | true |
ID | Old unique identifier -kept in for legacy purposes but too hard to maintain (not an auto-number) - taxa_id replaced this ID | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Site | TEXT | Uncoded Value | uncategorized | none | none | true |
SiteID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Area | TEXT | Uncoded Value | uncategorized | none | none | true |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
Level | TEXT | Uncoded Value | uncategorized | none | none | true |
Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
FractionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
TaxonId | TEXT | Uncoded Value | uncategorized | none | none | true |
Taxon | TEXT | Uncoded Value | uncategorized | none | none | true |
Portion | No values | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
Weight | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Charred | No values | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Comment | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: LP_ULL_VOL_EST_del
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
RADIUS | DOUBLE | Uncoded Value | uncategorized | none | none | true |
VOL_EST_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | all valid Ulls from La Qemada | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
unit | used to sort/order ulls | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
level | used to sort/order ulls | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
locus | used to sort/order ulls | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
TOP_BOT_IRREG | is the top shape different from the bottom shape (YES or NO)? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
U_SHAPE | combo box of acceptable shapes - not based on a table | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
L_SHAPE | TEXT | Uncoded Value | uncategorized | none | none | true |
U_LENGTH | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
U_WIDTH | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
U_HEIGHT | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
U_BASE | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
SIDE_A | DOUBLE | Uncoded Value | uncategorized | none | none | true |
SIDE_B | DOUBLE | Uncoded Value | uncategorized | none | none | true |
L_LENGTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
L_WIDTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
L_HEIGHT | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
L_BASE | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
AREA | shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc]) | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
DEPTH | average depth measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
VOL | measurement in cubic meters (AREA * DEPTH) | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
NOTES | note any unusual steps needed in orde rto make your calculation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: LPHumBone
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SpecimenId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SPNum | TEXT | Uncoded Value | uncategorized | none | none | true |
Box | TEXT | Uncoded Value | uncategorized | none | none | true |
AnalyticUnit | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Site | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Unit | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Prov | TEXT | Uncoded Value | uncategorized | none | none | true |
Level | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Locus | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
Element | TEXT | Uncoded Value | uncategorized | none | none | true |
ElementST | TEXT | Uncoded Value | uncategorized | none | none | true |
ElementId | FK to _HmOstEleNorm | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Lvl1Group | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Lvl1GrpId | FK to _HmOstLvl1Grp | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Lvl2Group | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Lvl2GrpId | FK to _HmOstLvl2Grp | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Side | TEXT | Uncoded Value | uncategorized | none | none | true |
Segment | TEXT | Uncoded Value | uncategorized | none | none | true |
Age | TEXT | Uncoded Value | uncategorized | none | none | true |
Sex | TEXT | Uncoded Value | uncategorized | none | none | true |
Compl | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Intextsurf | TEXT | Uncoded Value | uncategorized | none | none | true |
Perimortem | TEXT | Uncoded Value | uncategorized | none | none | true |
Taphonomy | TEXT | Uncoded Value | uncategorized | none | none | true |
Size | TEXT | Uncoded Value | uncategorized | none | none | true |
ConjSets | TEXT | Uncoded Value | uncategorized | none | none | true |
PolPho | TEXT | Uncoded Value | uncategorized | none | none | true |
Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: LPHumTeeth
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
LPHumTeethId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Site | TEXT | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SpNum | DOUBLE | Uncoded Value | uncategorized | none | none | true |
AnalyticUnit | TEXT | Uncoded Value | uncategorized | none | none | true |
Box | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
UNIT | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Prov | TEXT | Uncoded Value | uncategorized | none | none | true |
Level | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Locus | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
NumFfound | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Art | TEXT | Uncoded Value | uncategorized | none | none | true |
UpLo | TEXT | Uncoded Value | uncategorized | none | none | true |
Tooth | TEXT | Uncoded Value | uncategorized | none | none | true |
Side | TEXT | Uncoded Value | uncategorized | none | none | true |
Aged/Up | TEXT | Uncoded Value | uncategorized | none | none | true |
AgeYr | TEXT | Uncoded Value | uncategorized | none | none | true |
Pathology | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: LQ_Commingled_Human_Bone
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
b | DOUBLE | Uncoded Value | uncategorized | none | none | true |
id | DOUBLE | Uncoded Value | uncategorized | none | none | true |
bone | TEXT | Uncoded Value | uncategorized | none | none | true |
side | TEXT | Uncoded Value | uncategorized | none | none | true |
segment | TEXT | Uncoded Value | uncategorized | none | none | true |
% | DOUBLE | Uncoded Value | uncategorized | none | none | true |
n | DOUBLE | Uncoded Value | uncategorized | none | none | true |
age | TEXT | Uncoded Value | uncategorized | none | none | true |
box | TEXT | Uncoded Value | uncategorized | none | none | true |
Site_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
unit | DOUBLE | Uncoded Value | uncategorized | none | none | true |
level | BIGINT | Uncoded Value | uncategorized | none | none | true |
locus | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
Ull_rect_comments | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
other info | TEXT | Uncoded Value | uncategorized | none | none | true |
slash | TEXT | Uncoded Value | uncategorized | none | none | true |
comments | TEXT | Uncoded Value | uncategorized | none | none | true |
end | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Table Information: LQ_Cut_Marks_Human_Bone
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
CM # | TEXT | Uncoded Value | uncategorized | none | none | true |
Loc | TEXT | Uncoded Value | uncategorized | none | none | true |
Cast | TEXT | Uncoded Value | uncategorized | none | none | true |
Pos | TEXT | Uncoded Value | uncategorized | none | none | true |
Sort # | TEXT | Uncoded Value | uncategorized | none | none | true |
Cast # | TEXT | Uncoded Value | uncategorized | none | none | true |
Length | TEXT | Uncoded Value | uncategorized | none | none | true |
Width | TEXT | Uncoded Value | uncategorized | none | none | true |
Depth | TEXT | Uncoded Value | uncategorized | none | none | true |
Shape | TEXT | Uncoded Value | uncategorized | none | none | true |
Dir | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Site_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
other info | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
Provience | TEXT | Uncoded Value | uncategorized | none | none | true |
Bone | TEXT | Uncoded Value | uncategorized | none | none | true |
Field # | TEXT | Uncoded Value | uncategorized | none | none | true |
Side | TEXT | Uncoded Value | uncategorized | none | none | true |
CM Total | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: LQ_Processed_Human_Bone
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ps | TEXT | Uncoded Value | uncategorized | none | none | true |
id | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Site_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
unit | DOUBLE | Uncoded Value | uncategorized | none | none | true |
level | TEXT | Uncoded Value | uncategorized | none | none | true |
locus | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
Ull_rect_comments | TEXT | Uncoded Value | uncategorized | none | none | true |
otherinfo | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
slash | TEXT | Uncoded Value | uncategorized | none | none | true |
side | TEXT | Uncoded Value | uncategorized | none | none | true |
frag | TEXT | Uncoded Value | uncategorized | none | none | true |
bone | TEXT | Uncoded Value | uncategorized | none | none | true |
age | TEXT | Uncoded Value | uncategorized | none | none | true |
% | DOUBLE | Uncoded Value | uncategorized | none | none | true |
peri fract | TEXT | Uncoded Value | uncategorized | none | none | true |
ivr | TEXT | Uncoded Value | uncategorized | none | none | true |
sc1 | DOUBLE | Uncoded Value | uncategorized | none | none | true |
cr | TEXT | Uncoded Value | uncategorized | none | none | true |
pt | TEXT | Uncoded Value | uncategorized | none | none | true |
fl | TEXT | Uncoded Value | uncategorized | none | none | true |
pe | TEXT | Uncoded Value | uncategorized | none | none | true |
ct | TEXT | Uncoded Value | uncategorized | none | none | true |
ch | TEXT | Uncoded Value | uncategorized | none | none | true |
pp | TEXT | Uncoded Value | uncategorized | none | none | true |
sc2 | TEXT | Uncoded Value | uncategorized | none | none | true |
gn | TEXT | Uncoded Value | uncategorized | none | none | true |
cd | TEXT | Uncoded Value | uncategorized | none | none | true |
b | TEXT | Uncoded Value | uncategorized | none | none | true |
box | TEXT | Uncoded Value | uncategorized | none | none | true |
measurement | TEXT | Uncoded Value | uncategorized | none | none | true |
comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: LQ_ULL_VOL_EST
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
VOL_EST_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | all valid Ulls from La Qemada | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
unit | used to sort/order ulls | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
level | used to sort/order ulls | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
locus | used to sort/order ulls | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
TOP_BOT_IRREG | is the top shape different from the bottom shape (YES or NO)? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
U_SHAPE | combo box of acceptable shapes - not based on a table | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
L_SHAPE | TEXT | Uncoded Value | uncategorized | none | none | true |
U_LENGTH | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
U_WIDTH | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
U_HEIGHT | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
U_BASE | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
SIDE_A | DOUBLE | Uncoded Value | uncategorized | none | none | true |
SIDE_B | DOUBLE | Uncoded Value | uncategorized | none | none | true |
L_LENGTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
L_WIDTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
L_HEIGHT | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
L_BASE | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
RADIUS | DOUBLE | Uncoded Value | uncategorized | none | none | true |
AREA | shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc]) | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
DEPTH | average depth measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
VOL | measurement in cubic meters (AREA * DEPTH) | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
NOTES | note any unusual steps needed in orde rto make your calculation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: LQVolEstsOld
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
U_SHAPE | combo box of acceptable shapes - not based on a table | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
L_SHAPE | TEXT | Uncoded Value | uncategorized | none | none | true |
U_LENGTH | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
U_WIDTH | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
VOL_EST_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | all valid Ulls from La Qemada | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
unit | used to sort/order ulls | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
level | used to sort/order ulls | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
locus | used to sort/order ulls | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
TOP_BOT_IRREG | is the top shape different from the bottom shape (YES or NO)? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
U_HEIGHT | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
U_BASE | upper shape measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
SIDE_A | DOUBLE | Uncoded Value | uncategorized | none | none | true |
SIDE_B | DOUBLE | Uncoded Value | uncategorized | none | none | true |
L_LENGTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
L_WIDTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
L_HEIGHT | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
L_BASE | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
RADIUS | DOUBLE | Uncoded Value | uncategorized | none | none | true |
AREA | shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc]) | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
DEPTH | average depth measurement in meters | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
VOL | measurement in cubic meters (AREA * DEPTH) | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
NOTES | note any unusual steps needed in orde rto make your calculation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Macrobot
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SampleId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Site | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Area | to be deleted? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
Level | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Locus | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
Fraction | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
FractionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ID | to be deleted? | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Taxa | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
MbotTaxaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Portion | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
Weight | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Charred | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Comment | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Mbot_Type_Analysis
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Mbot_type_anal_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
speci_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
botanical_type_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: MD_Fields
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Field_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Field_name | TEXT | Uncoded Value | uncategorized | none | none | true |
Table_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
Doc_Object | BLOB | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
MetaData_Desc | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: MD_Tables
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Table_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table_Name | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
MetaData | TEXT | Uncoded Value | uncategorized | none | none | true |
Doc_object | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: NewFlots
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Unid 6 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 7 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 3 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 4 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ID | NewFlots unique identifier - data set created by Paula Turkon summer of 2006 | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Site | Site name | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SiteId | Site ID and FK to sites table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Area | delete | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULL | Unit-Level-Locus | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULLId | Unit-Leve-LLocus ID | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Unit | Unit | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Level | Level | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Locus | Locus | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Slash | Slash number or letter | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Phase | delete - these phases inlcude those from middens based on their specific stratigraphy and are not necessarliy the same phases as those in architectural areas | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
AU(old) | delete | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
AU Description(old) | delete | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Wood Charcoal (in grams) | TEXT | Uncoded Value | uncategorized | none | none | true |
Maize cupule-count | TEXT | Uncoded Value | uncategorized | none | none | true |
Cupule Weight (in grams) | TEXT | Uncoded Value | uncategorized | none | none | true |
Maize kernel-count | TEXT | Uncoded Value | uncategorized | none | none | true |
Kernel Weight (in grams) | TEXT | Uncoded Value | uncategorized | none | none | true |
Phaseolus | TEXT | Uncoded Value | uncategorized | none | none | true |
Curcurbita | TEXT | Uncoded Value | uncategorized | none | none | true |
Opuntia | TEXT | Uncoded Value | uncategorized | none | none | true |
Opuntia sp 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
Agave Tissue (in grams) | TEXT | Uncoded Value | uncategorized | none | none | true |
Wild Legume | TEXT | Uncoded Value | uncategorized | none | none | true |
Chenopodium | TEXT | Uncoded Value | uncategorized | none | none | true |
Chenopodium sp 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
Chenopodium sp 3 | TEXT | Uncoded Value | uncategorized | none | none | true |
Chenopodium album | TEXT | Uncoded Value | uncategorized | none | none | true |
Chenopodium-tiny | TEXT | Uncoded Value | uncategorized | none | none | true |
Amaranthus | TEXT | Uncoded Value | uncategorized | none | none | true |
Mammalaria | TEXT | Uncoded Value | uncategorized | none | none | true |
Cactaceae | TEXT | Uncoded Value | uncategorized | none | none | true |
Physalis | TEXT | Uncoded Value | uncategorized | none | none | true |
Solanaceae | TEXT | Uncoded Value | uncategorized | none | none | true |
Euphorbiaceae | TEXT | Uncoded Value | uncategorized | none | none | true |
Brassica | TEXT | Uncoded Value | uncategorized | none | none | true |
Portulaca | TEXT | Uncoded Value | uncategorized | none | none | true |
Compositae | TEXT | Uncoded Value | uncategorized | none | none | true |
Compositae sp 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
Helianthus | TEXT | Uncoded Value | uncategorized | none | none | true |
Pinus nut frag | TEXT | Uncoded Value | uncategorized | none | none | true |
Prosopis | TEXT | Uncoded Value | uncategorized | none | none | true |
Stellaria | TEXT | Uncoded Value | uncategorized | none | none | true |
Setaria | TEXT | Uncoded Value | uncategorized | none | none | true |
Leguminoseae sp 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
Gramineae | TEXT | Uncoded Value | uncategorized | none | none | true |
Polygonum | TEXT | Uncoded Value | uncategorized | none | none | true |
Lychnis | TEXT | Uncoded Value | uncategorized | none | none | true |
Labiateae | TEXT | Uncoded Value | uncategorized | none | none | true |
Unid 1 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 2 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 8 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 9 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 10 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 11 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 12 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid13 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 14 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 16 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 17 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 18 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 20 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 21 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 22 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 23 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 24 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 25 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid 26 | Unidentified | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid Fruit 1 | Unidentified fruit | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid Fruit 2 | Unidentified fruit | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid Fruit 3 | Unidentified fruit | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid Fruit 4 | Unidentified fruit | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid Fruit 5 | Unidentified fruit | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unid Spines | Unidentified spines | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Reeds | TEXT | Uncoded Value | uncategorized | none | none | true |
Misc Stems | TEXT | Uncoded Value | uncategorized | none | none | true |
Misc tissue (grams) | TEXT | Uncoded Value | uncategorized | none | none | true |
Unid Fragments | Unidentified Fragments | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Land Snails (100=more not pulled) | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Obsidian 97
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
obs_id | Primary key | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
bag_id | Bag number (Zacatecas only) | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
analytical_unit | Analytical unit | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
site | La Quemada or Los Pilarillos | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Site_ID_FK | BIGINT | Uncoded Value | uncategorized | none | none | true |
Area_name | Portion of Site | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
midden_phase | Midden phase (early, middle, late, mixed) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
unit | Excavation Unit | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
level | Level | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
locus | Locus | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL_ID_FK | BIGINT | Uncoded Value | uncategorized | none | none | true |
/ | Slash - Number=Point Proveniece, Letter=Special Find | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
mg | Weight in mg +-10mg | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
count | Number of flakes | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
flake | Flake type: Primary Flake, Secondary Flake, Tertiary Flake, Primary RETouch flake, Secondary RETouch flake, Tertiary RETouch flake, CORE, COBBLE, Fragmentary Flake, FRAGment | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
edge | U=used, PL= likely usable/used, PD=doubtful usable/used, N=not usable | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
cortex | + or - (TF's with cortex on platform and cores) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
cortex_surface | Cortex surface - 1=smooth and flat, 2 = smooth and ridged, 3 = rough and flat, 4 = rough and ridged, 5 = very rough | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
color | Flake Color, Loni's categories/classification: Lustrous Black; Dull Black; Translucent Black; Translucent Green; Dull Green; Dull Grey; Lustrous Dark Grey; Lustrous Red | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
luster | Luster: GReasy; GLassy; Lustrous (not types as GR or GL); UNknown | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
surface | Surface Quality: Rough or Calcified, no entry = smooth and clean | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
clarity | Clarity 1=Clear; 2= Clear with cloudiness; 3= cloudy but translucent; 4= Part opaque, part cloudy/translucent; 5= Fully opaque, possible translucent at thin edges; 6= Special; 7= Unknown | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
inclusions | STRiations, SHMutz, BUBbles, SPLotches, RIBbons, CLOuds, FLEcks, MOTtling, SPEckles | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
primary_clr | Primary Color: Black; Black-Dark Grey; Dark Grey; Grey; Light Grey; White; Green; Light Green; Dark Green; Grey-Green; Red; Red-Brown; Brown; Brown-Green; Red-Orange; Dark Red-Brown; Ochre; UNknown | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
secondary_clr | Secondary Color: Grey; Black; Dark Grey; Black-Dark Grey; Light Grey; Light Green; White; Red; Brown-Green; Dark Red; Red-Orange; Brown | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
tertiary_clr | Tertiary Color: Black; Grey; Brown | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
opalescent | + is yes, = is maybe, - is no | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
special | Special qualities | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
color_group | Color group | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
mvp_id | MURR sample number | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
analysis | Type of Analysis | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
naa_source | Sub source based on color association | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
chemical_source | Greatest detail, only recorded if only one source associates with the group | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
source_area | Less detail, only similar source areas are recoded | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
means_of_procurement | Least detail, only similarly acquisition - Unk E and Noch for example | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
drawn | Drawn? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
photo | Photogrpahed? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
location | Where curated? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: OtherArtifacts
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
OtherId | Unique identifier | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
TypeCllcntID | Type Collection ID and FK to the Type Collection table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Material | Material | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Material subclass | Material subclass | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Class | Class | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Functional subclass | Functional subclass | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Details | Details | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
count | count | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Photo_Artifacts
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
PhotoArtifactsId | BIGINT | Uncoded Value | uncategorized | none | none | true |
PhotoId | Link back to traditional prints in Photolog table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Exposure | TEXT | Uncoded Value | uncategorized | none | none | true |
CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
PrimId | TEXT | Uncoded Value | uncategorized | none | none | true |
RimNumber | TEXT | Uncoded Value | uncategorized | none | none | true |
ULLInfo | TEXT | Uncoded Value | uncategorized | none | none | true |
SelectedForArtCat | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
SelectedForReport | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Image | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: Photo_ULLS
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
IdPhotoNum_ULL | BIGINT | Uncoded Value | uncategorized | none | none | true |
PohotoId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
SIte_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
AUId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Photologs
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
PhotoId | Unique identifier | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Page | Page | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
BinderNum | Note book binder number | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Roll | Roll identifier | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Film | Film Type | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Speed | Film speed | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Exp | Exposure number | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Sort | Sort number | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Site | Site | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Subject | Subject | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Date | Date photo was taken | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Description | Description | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Direction | Direction facing when photo taken | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Photographer | Photographer | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Hyperlink | Hyperlink to digital copy of photograph | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Item1 | TEXT | Uncoded Value | uncategorized | none | none | true |
Item2 | TEXT | Uncoded Value | uncategorized | none | none | true |
Item3 | TEXT | Uncoded Value | uncategorized | none | none | true |
Item4 | TEXT | Uncoded Value | uncategorized | none | none | true |
Item5 | TEXT | Uncoded Value | uncategorized | none | none | true |
Item6 | TEXT | Uncoded Value | uncategorized | none | none | true |
Item7 | TEXT | Uncoded Value | uncategorized | none | none | true |
Item8 | TEXT | Uncoded Value | uncategorized | none | none | true |
Item9 | TEXT | Uncoded Value | uncategorized | none | none | true |
Item10 | TEXT | Uncoded Value | uncategorized | none | none | true |
Item11 | TEXT | Uncoded Value | uncategorized | none | none | true |
Item12 | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: RimStudy
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
Level | TEXT | Uncoded Value | uncategorized | none | none | true |
Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
Site | TEXT | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
R number | TEXT | Uncoded Value | uncategorized | none | none | true |
AndrewComment | TEXT | Uncoded Value | uncategorized | none | none | true |
Sort number | BIGINT | Uncoded Value | uncategorized | none | none | true |
V number | BIGINT | Uncoded Value | uncategorized | none | none | true |
CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
PrimId | TEXT | Uncoded Value | uncategorized | none | none | true |
BoxId_new | BIGINT | Uncoded Value | uncategorized | none | none | true |
Box number | BIGINT | Uncoded Value | uncategorized | none | none | true |
Bag number | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
Year | TEXT | Uncoded Value | uncategorized | none | none | true |
Coder | TEXT | Uncoded Value | uncategorized | none | none | true |
Date coded | DATETIME | Uncoded Value | uncategorized | none | none | true |
Ware | Incised-engraved, Painted, Plain, Negative, Pseudo-cloisonné, Indeterminate, Historic, Slipped | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
WareId | FK to _CerTypeWare | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Type | Look to "Ceramics: type lookup" for more information | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TypeId | FK to _CerType | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Vessel shape | Look to "Rim study: vessel shape lookup" for possible values, definitions, and examples | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
VesselShapeId | FK to _RimVsslShape | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Contour type | Look to "Rim study: contour type lookup" for possible values, definitions, and examples | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ContourTypeId | FK to _RimContourType | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Rim form | Look to "Rim study: rim form lookup" for possible values, definitions, and examples | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
RimFormId | FK to _RimRimForm | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Rim thickening | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Neck-shoulder thickness | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Lip form | Tapered, Rounded, Squared | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
LipFormId | FK to _RimLipForm | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Lip thickening | Yes or No | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
Lip treatment | Ticking, Notching, Continuous lines, Discontinuous line, Zig-Zag, Wavy, Diagonal lines, Combination | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
LipTreatmentId | FK to _RimLipTreatment | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Decoration | Decorated, Undecorated | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
DecorationId | FK to _CerTrtmnt | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Surface finish ext | Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Surface finish int | Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Slip consistency | Washy, Complete | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Orifice radius ext | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Arc ext | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Orifice radius int | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Arc int | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Rim | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Lip | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Neck | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Shoulder | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Body | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Base | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Rim tab | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Tripod facet | Scar where tripod broke off, but effectively no tripod remaining. | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
Tripod frag | Only a portion of the tripod remains - either shape, length, and/or width measurement would be missing. | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
Tripod whole | Presence of the entire tripod - shape, length, and width measurements should be possible. | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
Handle | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Handle orientation | Vertical, Horizontal | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Handle position | Rim, Neck, Shoulder, Body | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Lip to brushing | The measurement on brushed wares from the top of the lip to the point at which brushing begins - measures the amount of obliterated brushing at rim. | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
Brushed ware neck treat | Simple, Smoothed, Burnished, Highly burnished/Self-slipped, Polished | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Support xsection | Circular, Elliptical | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Support shaft type | Simple, Kneed, Bulbuous | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Support attachment | Simple, Complex | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Foot type | Flared, Direct, Clawed, Pointed | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Carbon streak width | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Carbon sym | Centered, Exteriorly biased, Interiorly biased | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Firing ext | Reduced, Oxidized, Both | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Firing int | Reduced, Oxidized, Both | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Gen_Comments | BIGINT | Uncoded Value | uncategorized | none | none | true |
s_ColLineage | BLOB | Uncoded Value | uncategorized | none | none | true |
s_Generation | BIGINT | Uncoded Value | uncategorized | none | none | true |
s_GUID | TEXT | Uncoded Value | uncategorized | none | none | true |
s_Lineage | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: RimStudy_old
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SortNumber | BIGINT | Uncoded Value | uncategorized | none | none | true |
VNumber | BIGINT | Uncoded Value | uncategorized | none | none | true |
BoxNumber | BIGINT | Uncoded Value | uncategorized | none | none | true |
RimId | BIGINT | Uncoded Value | uncategorized | none | none | true |
RNumber | TEXT | Uncoded Value | uncategorized | none | none | true |
Body | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
BagNumber | TEXT | Uncoded Value | uncategorized | none | none | true |
Site | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
Level | TEXT | Uncoded Value | uncategorized | none | none | true |
Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL | to be deleted? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Year | TEXT | Uncoded Value | uncategorized | none | none | true |
Coder | TEXT | Uncoded Value | uncategorized | none | none | true |
DateCoded | DATETIME | Uncoded Value | uncategorized | none | none | true |
Ware | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
WareId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Type | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
VesselShape | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
VesselShapeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ContourType | to be delted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ContourTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
RimForm | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
RimFormId | BIGINT | Uncoded Value | uncategorized | none | none | true |
RimThickening | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
NeckSsoulderThickness | DOUBLE | Uncoded Value | uncategorized | none | none | true |
LipForm | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
LipFormId | BIGINT | Uncoded Value | uncategorized | none | none | true |
LipThickening | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
LipTreatment | to be delted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
LipTreatmentId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Decoration | to be delted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
DecorationId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SurfaceFinishExt | TEXT | Uncoded Value | uncategorized | none | none | true |
SurfaceFinishInt | TEXT | Uncoded Value | uncategorized | none | none | true |
SlipConsistency | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SlipConsistencyId | BIGINT | Uncoded Value | uncategorized | none | none | true |
OrificeRadiusExt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
ArcExt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
OrificeRadiusInt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
ArcInt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Rim | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Lip | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Neck | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Shoulder | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Base | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
RimTab | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
TripodFacet | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
TripodFrag | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
TripodWhole | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Handle | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
HandleOrientation | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
HandelPositionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
HandlePosition | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
HandlePositionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
LipToBrushing | DOUBLE | Uncoded Value | uncategorized | none | none | true |
BrushedWareNeckTreat | TEXT | Uncoded Value | uncategorized | none | none | true |
SupportXSection | TEXT | Uncoded Value | uncategorized | none | none | true |
SupportShaftType | TEXT | Uncoded Value | uncategorized | none | none | true |
SupportAttachment | TEXT | Uncoded Value | uncategorized | none | none | true |
FootType | TEXT | Uncoded Value | uncategorized | none | none | true |
CarbonStreakWidth | DOUBLE | Uncoded Value | uncategorized | none | none | true |
CarbonSym | TEXT | Uncoded Value | uncategorized | none | none | true |
FiringExt | TEXT | Uncoded Value | uncategorized | none | none | true |
FiringInt | TEXT | Uncoded Value | uncategorized | none | none | true |
Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
GenComments | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: RimStudyold_2
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Handle position | Rim, Neck, Shoulder, Body | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Handle orientation | Vertical, Horizontal | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
R number | TEXT | Uncoded Value | uncategorized | none | none | true |
Sort number | BIGINT | Uncoded Value | uncategorized | none | none | true |
V number | BIGINT | Uncoded Value | uncategorized | none | none | true |
Box number | BIGINT | Uncoded Value | uncategorized | none | none | true |
Bag number | TEXT | Uncoded Value | uncategorized | none | none | true |
Site | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
Level | TEXT | Uncoded Value | uncategorized | none | none | true |
Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
Year | TEXT | Uncoded Value | uncategorized | none | none | true |
Coder | TEXT | Uncoded Value | uncategorized | none | none | true |
Date coded | DATETIME | Uncoded Value | uncategorized | none | none | true |
Ware | Incised-engraved, Painted, Plain, Negative, Pseudo-cloisonné, Indeterminate, Historic, Slipped | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Type | Look to "Ceramics: type lookup" for more information | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Vessel shape | Look to "Rim study: vessel shape lookup" for possible values, definitions, and examples | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Contour type | Look to "Rim study: contour type lookup" for possible values, definitions, and examples | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Rim form | Look to "Rim study: rim form lookup" for possible values, definitions, and examples | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Rim thickening | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Neck-shoulder thickness | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Lip form | Tapered, Rounded, Squared | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Lip thickening | Yes or No | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
Lip treatment | Ticking, Notching, Continuous lines, Discontinuous line, Zig-Zag, Wavy, Diagonal lines, Combination | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Decoration | Decorated, Undecorated | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Surface finish ext | Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Surface finish int | Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Slip consistency | Washy, Complete | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Orifice radius ext | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Arc ext | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Orifice radius int | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Arc int | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Rim | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Lip | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Neck | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Shoulder | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Body | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Base | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Rim tab | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Tripod facet | Scar where tripod broke off, but effectively no tripod remaining. | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
Tripod frag | Only a portion of the tripod remains - either shape, length, and/or width measurement would be missing. | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
Tripod whole | Presence of the entire tripod - shape, length, and width measurements should be possible. | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
Handle | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Lip to brushing | The measurement on brushed wares from the top of the lip to the point at which brushing begins - measures the amount of obliterated brushing at rim. | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
Brushed ware neck treat | Simple, Smoothed, Burnished, Highly burnished/Self-slipped, Polished | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Support xsection | Circular, Elliptical | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Support shaft type | Simple, Kneed, Bulbuous | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Support attachment | Simple, Complex | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Foot type | Flared, Direct, Clawed, Pointed | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Carbon streak width | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Carbon sym | Centered, Exteriorly biased, Interiorly biased | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Firing ext | Reduced, Oxidized, Both | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Firing int | Reduced, Oxidized, Both | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Gen_Comments | BIGINT | Uncoded Value | uncategorized | none | none | true |
s_ColLineage | BLOB | Uncoded Value | uncategorized | none | none | true |
s_Generation | BIGINT | Uncoded Value | uncategorized | none | none | true |
s_GUID | TEXT | Uncoded Value | uncategorized | none | none | true |
s_Lineage | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: Romos2001Blk
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Page | DOUBLE | Uncoded Value | uncategorized | none | none | true |
AnDate | DATETIME | Uncoded Value | uncategorized | none | none | true |
Box | TEXT | Uncoded Value | uncategorized | none | none | true |
Coder | TEXT | Uncoded Value | uncategorized | none | none | true |
Bag | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Portion | TEXT | Uncoded Value | uncategorized | none | none | true |
Site | TEXT | Uncoded Value | uncategorized | none | none | true |
Unit | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Level | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Locus | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
Form | TEXT | Uncoded Value | uncategorized | none | none | true |
PaintLoc | TEXT | Uncoded Value | uncategorized | none | none | true |
Indet | TEXT | Uncoded Value | uncategorized | none | none | true |
FnStr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
FnOtr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
ThnStr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
ThnOtr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
ThkStr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
ThkOtr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
BrdStr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
BrdOtr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
RimInt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
RimExt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
RimIntExt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
AllInt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
AllExt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
AllBoth | DOUBLE | Uncoded Value | uncategorized | none | none | true |
RimInt_AllExt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
RimExt_AllInt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Romos_Sherd_Band_Assoc
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Sherd_band_assoc_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Sherd_id_fk | links to ID in the Romos Study table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Band_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
type_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
cer_element_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
cer_element_group_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: RomosStudy_new
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
1-subinfratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype4_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subinfratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-additional_type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-motif_morphology_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL_ID_FK | BIGINT | Uncoded Value | uncategorized | none | none | true |
TestID | BIGINT | Uncoded Value | uncategorized | none | none | true |
armillas collection | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
site | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
unit | TEXT | Uncoded Value | uncategorized | none | none | true |
level | TEXT | Uncoded Value | uncategorized | none | none | true |
locus | TEXT | Uncoded Value | uncategorized | none | none | true |
slash | TEXT | Uncoded Value | uncategorized | none | none | true |
area | TEXT | Uncoded Value | uncategorized | none | none | true |
count | BIGINT | Uncoded Value | uncategorized | none | none | true |
ware | TEXT | Uncoded Value | uncategorized | none | none | true |
form | TEXT | Uncoded Value | uncategorized | none | none | true |
portion | TEXT | Uncoded Value | uncategorized | none | none | true |
firing_ interior | TEXT | Uncoded Value | uncategorized | none | none | true |
firing_ exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
fire_ clouding_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
fire_ clouding_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
slip_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
slip_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
surface_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
surface_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
core oxidation | TEXT | Uncoded Value | uncategorized | none | none | true |
core color | TEXT | Uncoded Value | uncategorized | none | none | true |
smearing_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
smearing_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
red rim | TEXT | Uncoded Value | uncategorized | none | none | true |
Coyo-like | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Coyo-like comment | TEXT | Uncoded Value | uncategorized | none | none | true |
comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Residue? | TEXT | Uncoded Value | uncategorized | none | none | true |
Illustrated | TEXT | Uncoded Value | uncategorized | none | none | true |
Digital Photo | TEXT | Uncoded Value | uncategorized | none | none | true |
Photo | TEXT | Uncoded Value | uncategorized | none | none | true |
vessel motif complexity | TEXT | Uncoded Value | uncategorized | none | none | true |
line_width_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-motif_morphology_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
Band1_Band_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
1-geometric type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
band1_type_int_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Band_1_Element_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
1-line_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-fret_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-fret_scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-element_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-indeterminate type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-Life Form Type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-life_form_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype1_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype2_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype3_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype4_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-additional_type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-motif_morphology_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
Band2_band_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Band_2_Element_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
2-geometric type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
band2_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
2-line_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-fret_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-fret_scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-element_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-indeterminate type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-Life Form Type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-life_form_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype1_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype2_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype3_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype4_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subinfratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-additional_type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
line_width_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-motif_morphology_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
Band3 | BIGINT | Uncoded Value | uncategorized | none | none | true |
1-geometric type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
band3_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
Band_3_element_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
1-line_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-fret_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-fret_scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-element_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-indeterminate type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-Life Form Type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-life_form_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype1_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype2_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype3_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype4_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subinfratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-additional_type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-motif_morphology_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
Band4 | BIGINT | Uncoded Value | uncategorized | none | none | true |
2-geometric type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
Band4_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
Band_4_Element_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
2-line_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-fret_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-fret_scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-element_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-indeterminate type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-Life Form Type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-life_form_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype1_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype2_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype3_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
Band5 | BIGINT | Uncoded Value | uncategorized | none | none | true |
3-geometric type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
Band5_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
Band_5_Element_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
3-line_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-fret_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-fret_scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-element_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-indeterminate type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-Life Form Type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-life_form_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-subtype1_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-subtype2_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-subtype3_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-subtype4_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-subinfratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-additional_type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: RomosStudy_old
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
1-additional_type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
Band5 | BIGINT | Uncoded Value | uncategorized | none | none | true |
TestID | BIGINT | Uncoded Value | uncategorized | none | none | true |
armillas collection | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
site | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
unit | TEXT | Uncoded Value | uncategorized | none | none | true |
level | TEXT | Uncoded Value | uncategorized | none | none | true |
locus | TEXT | Uncoded Value | uncategorized | none | none | true |
slash | TEXT | Uncoded Value | uncategorized | none | none | true |
area | TEXT | Uncoded Value | uncategorized | none | none | true |
count | BIGINT | Uncoded Value | uncategorized | none | none | true |
ware | TEXT | Uncoded Value | uncategorized | none | none | true |
form | TEXT | Uncoded Value | uncategorized | none | none | true |
portion | TEXT | Uncoded Value | uncategorized | none | none | true |
firing_ interior | TEXT | Uncoded Value | uncategorized | none | none | true |
firing_ exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
fire_ clouding_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
fire_ clouding_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
slip_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
slip_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
surface_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
surface_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
core oxidation | TEXT | Uncoded Value | uncategorized | none | none | true |
core color | TEXT | Uncoded Value | uncategorized | none | none | true |
smearing_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
smearing_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
red rim | TEXT | Uncoded Value | uncategorized | none | none | true |
Coyo-like | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Coyo-like comment | TEXT | Uncoded Value | uncategorized | none | none | true |
comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Residue? | TEXT | Uncoded Value | uncategorized | none | none | true |
Illustrated | TEXT | Uncoded Value | uncategorized | none | none | true |
Digital Photo | TEXT | Uncoded Value | uncategorized | none | none | true |
Photo | TEXT | Uncoded Value | uncategorized | none | none | true |
vessel motif complexity | TEXT | Uncoded Value | uncategorized | none | none | true |
line_width_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-fret_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-motif_morphology_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
Band1_Band_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
1-geometric type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
band1_type_int_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
1-line_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-fret_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-fret_scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-element_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-indeterminate type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-Life Form Type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-life_form_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype1_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype2_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype3_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype4_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subinfratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-additional_type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-motif_morphology_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
Band2_band_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
2-geometric type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
band2_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
2-line_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-fret_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-fret_scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-element_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-indeterminate type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-Life Form Type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-life_form_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype1_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype2_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype3_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype4_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subinfratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-additional_type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
line_width_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-motif_morphology_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
Band3 | BIGINT | Uncoded Value | uncategorized | none | none | true |
1-geometric type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
band3_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
1-line_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-fret_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-fret_scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-element_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-indeterminate type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-Life Form Type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-life_form_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype1_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype2_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype3_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subtype4_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
1-subinfratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-motif_morphology_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
Band4 | BIGINT | Uncoded Value | uncategorized | none | none | true |
2-geometric type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
Band4_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
2-line_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-fret_scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-element_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-indeterminate type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-Life Form Type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-life_form_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype1_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype2_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype3_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subtype4_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-subinfratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
2-additional_type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-motif_morphology_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-geometric type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
Band5_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
3-line_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-fret_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-fret_scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-element_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-indeterminate type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-Life Form Type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-life_form_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-subtype1_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-subtype2_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-subtype3_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-subtype4_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-subinfratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
3-additional_type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
Vws ULL Update | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: ShapedTools
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Date Recorded | DATETIME | Uncoded Value | uncategorized | none | none | true |
StoneToolId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Page | BIGINT | Uncoded Value | uncategorized | none | none | true |
Box Number | TEXT | Uncoded Value | uncategorized | none | none | true |
CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Tool Number | BIGINT | Uncoded Value | uncategorized | none | none | true |
Recorder | TEXT | Uncoded Value | uncategorized | none | none | true |
Date Collected | DATETIME | Uncoded Value | uncategorized | none | none | true |
Site | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
UllId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
Level | TEXT | Uncoded Value | uncategorized | none | none | true |
Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
MaterialGroup | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
MatGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Material | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
MaterialId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Form | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
FormId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Tool type | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Handled | TEXT | Uncoded Value | uncategorized | none | none | true |
Retouch Loc | TEXT | Uncoded Value | uncategorized | none | none | true |
Point form | TEXT | Uncoded Value | uncategorized | none | none | true |
Pnt base shape | TEXT | Uncoded Value | uncategorized | none | none | true |
Pnt base type | TEXT | Uncoded Value | uncategorized | none | none | true |
Point notch | TEXT | Uncoded Value | uncategorized | none | none | true |
Length | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Pct len | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Width | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Pct wid | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Thickness | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Weight | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
Comments 1 | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
Tracing | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Table Information: Shell
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
L | DOUBLE | Uncoded Value | uncategorized | none | none | true |
ShellId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Vic's ID | DOUBLE | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Unit | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Level | TEXT | Uncoded Value | uncategorized | none | none | true |
Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
Spec Art Inv? | TEXT | Uncoded Value | uncategorized | none | none | true |
MNI | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Abs# | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Wt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
W | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Thick | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Dia | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Province | TEXT | Uncoded Value | uncategorized | none | none | true |
Class | TEXT | Uncoded Value | uncategorized | none | none | true |
ClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Genera | TEXT | Uncoded Value | uncategorized | none | none | true |
GeneraId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Species | TEXT | Uncoded Value | uncategorized | none | none | true |
SpeciesId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Type | TEXT | Uncoded Value | uncategorized | none | none | true |
TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Sub-type | TEXT | Uncoded Value | uncategorized | none | none | true |
SubTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Infra-type | TEXT | Uncoded Value | uncategorized | none | none | true |
InfraTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Shape | TEXT | Uncoded Value | uncategorized | none | none | true |
ShapeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Perf | TEXT | Uncoded Value | uncategorized | none | none | true |
PerfId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Stage | TEXT | Uncoded Value | uncategorized | none | none | true |
StageId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Infra-stage | TEXT | Uncoded Value | uncategorized | none | none | true |
InfraStageId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Condition | TEXT | Uncoded Value | uncategorized | none | none | true |
ConditionId | TEXT | Uncoded Value | uncategorized | none | none | true |
Incising? | TEXT | Uncoded Value | uncategorized | none | none | true |
Burned? | TEXT | Uncoded Value | uncategorized | none | none | true |
Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: SoilsByULLFromPaulaByAU
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
AUId | BIGINT | Uncoded Value | uncategorized | none | none | true |
AUNum | DOUBLE | Uncoded Value | uncategorized | none | none | true |
SOIL | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: SpecArtfcts
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SpecArt_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Site | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Year | BIGINT | Uncoded Value | uncategorized | none | none | true |
Locale | to be deleted? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
AU | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Unit | BIGINT | Uncoded Value | uncategorized | none | none | true |
Level | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Locus | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
ULLSNum | TEXT | Uncoded Value | uncategorized | none | none | true |
SpecArtMatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
MatCnfdnc | TEXT | Uncoded Value | uncategorized | none | none | true |
Worked | TEXT | Uncoded Value | uncategorized | none | none | true |
ClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ObjRepsntd | TEXT | Uncoded Value | uncategorized | none | none | true |
DecTech | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
DecTechId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ApprxPerct | BIGINT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: SurveySites
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
MV_sites_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
order_id | TEXT | Uncoded Value | uncategorized | none | none | true |
site | TEXT | Uncoded Value | uncategorized | none | none | true |
site_name | TEXT | Uncoded Value | uncategorized | none | none | true |
settlement_affiliation | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: tempDetail
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
AUId | BIGINT | Uncoded Value | uncategorized | none | none | true |
AUNum | DOUBLE | Uncoded Value | uncategorized | none | none | true |
FullDesc | TEXT | Uncoded Value | uncategorized | none | none | true |
DetailName | TEXT | Uncoded Value | uncategorized | none | none | true |
ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: test_macroBot
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Articulation_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ArticulationId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ArticulationType | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Band_Motif
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
typeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Banding_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
BandingId | BIGINT | Uncoded Value | uncategorized | none | none | true |
BandingName | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Band_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
band | TEXT | Uncoded Value | uncategorized | none | none | true |
Band_type | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_CoreOxidation_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
CoreOxidationId | BIGINT | Uncoded Value | uncategorized | none | none | true |
CoreOxidation | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_CoreColor_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
CoreColorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
CoreColor | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Firing_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
FiringId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Firing | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_FireClouding_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
FireCloudingId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FireClouding | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Form_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
FormId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Form | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_GeometricElement_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
geometricElementsid | BIGINT | Uncoded Value | uncategorized | none | none | true |
geometricElement | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_GeoElementTypes_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
GeoElementTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
GeoElementType | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_LineWidth_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
LineWidthId | BIGINT | Uncoded Value | uncategorized | none | none | true |
LineWidth | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Linkage_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
LinkageId | BIGINT | Uncoded Value | uncategorized | none | none | true |
LinkageType | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Line_Infratype
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
typeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
line_infratypeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_MotifElement
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
elementId | BIGINT | Uncoded Value | uncategorized | none | none | true |
geoElementTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
geoElementSubTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Motif_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
motif | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Portion_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Portion | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_RedRim_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
RedRimId | BIGINT | Uncoded Value | uncategorized | none | none | true |
RedRim | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Repeating_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
RepeatingId | BIGINT | Uncoded Value | uncategorized | none | none | true |
RepeatingType | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_SubType_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
subtypeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
subtype name | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Slip_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SlipId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Slip | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Smearing_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SmearingId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Smearing | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_SubType
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
typeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
subtypeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Surface_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SurfaceId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Surface | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Type_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Type_name | TEXT | Uncoded Value | uncategorized | none | none | true |
SuperTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SuperType | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Type
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
typeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
ST_2_Articulation_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
ST_3_Linkage_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
ST_4_Repeating_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
SubInfraType_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
AdditionalType | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_VesselMotifComplexity_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
MotifComplexityId | BIGINT | Uncoded Value | uncategorized | none | none | true |
MotifComplexity | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Ware_lookup
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
WareId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Ware | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_RomosSherds
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
RedRimId | BIGINT | Uncoded Value | uncategorized | none | none | true |
DestId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ArmillasCollection | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
Level | TEXT | Uncoded Value | uncategorized | none | none | true |
Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
SlashNo | TEXT | Uncoded Value | uncategorized | none | none | true |
PrimId | TEXT | Uncoded Value | uncategorized | none | none | true |
Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
WareId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FormId | BIGINT | Uncoded Value | uncategorized | none | none | true |
PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FiringInteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FiringExteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FireCloudingInteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
FireCloudingExteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SlipInteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SlipExteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SurfaceInteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SurfaceExteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
CoreOxidationId | BIGINT | Uncoded Value | uncategorized | none | none | true |
CoreColorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SmearingInteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SmearingExteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Coyo-Like | TEXT | Uncoded Value | uncategorized | none | none | true |
Coyo-LikeComments | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Residue | TEXT | Uncoded Value | uncategorized | none | none | true |
Illustrated | TEXT | Uncoded Value | uncategorized | none | none | true |
DigitalPhoto | TEXT | Uncoded Value | uncategorized | none | none | true |
Photo | TEXT | Uncoded Value | uncategorized | none | none | true |
VesselMotifComplexityId | BIGINT | Uncoded Value | uncategorized | none | none | true |
LineWidthInteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
LineWidthExteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
BandingTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: testExposures2
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
PhotoId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Exposure | TEXT | Uncoded Value | uncategorized | none | none | true |
Exp | TEXT | Uncoded Value | uncategorized | none | none | true |
CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
placeOfDash | BIGINT | Uncoded Value | uncategorized | none | none | true |
characRightOfDash | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: testSherdBand
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: TypeCllctn
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Level | DOUBLE | Uncoded Value | uncategorized | none | none | true |
TypeCllcntID | BIGINT | Uncoded Value | uncategorized | none | none | true |
PrimID | TEXT | Uncoded Value | uncategorized | none | none | true |
Material Code | TEXT | Uncoded Value | uncategorized | none | none | true |
MaterialId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Item | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Number | TEXT | Uncoded Value | uncategorized | none | none | true |
Photo | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
PhotoId | Should be linked to the PhotoLog table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Roll | Once link has been made to photo table - this field should be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Exp | Once link has been made to photo table - this field should be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Photographer | Once link has been made to photo table - this field should be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
to be photo | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Manuscript | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Fig Number | TEXT | Uncoded Value | uncategorized | none | none | true |
Gen desc | TEXT | Uncoded Value | uncategorized | none | none | true |
Status | TEXT | Uncoded Value | uncategorized | none | none | true |
IllustrationId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Illustration | Should be linked to Illustration table | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Priority | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Site | TEXT | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULLSNum | TEXT | Uncoded Value | uncategorized | none | none | true |
AU | TEXT | Uncoded Value | uncategorized | none | none | true |
Unit | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Locus | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Photograph | Once link has been made to photo table - this field should be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Link | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash # | TEXT | Uncoded Value | uncategorized | none | none | true |
PHOTO EXT | TEXT | Uncoded Value | uncategorized | none | none | true |
Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Other Type | TEXT | Uncoded Value | uncategorized | none | none | true |
count | BIGINT | Uncoded Value | uncategorized | none | none | true |
To be photo'd temp | TEXT | Uncoded Value | uncategorized | none | none | true |
To be illustr -temp | TEXT | Uncoded Value | uncategorized | none | none | true |
Preliminary | TEXT | Uncoded Value | uncategorized | none | none | true |
Ill date | Once link has been made to illustration table - this field should be deleted | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
Artist | TEXT | Uncoded Value | uncategorized | none | none | true |
Final | TEXT | Uncoded Value | uncategorized | none | none | true |
Date1 | TEXT | Uncoded Value | uncategorized | none | none | true |
Field18 | TEXT | Uncoded Value | uncategorized | none | none | true |
Needs Revision | TEXT | Uncoded Value | uncategorized | none | none | true |
Revised Preliminary | TEXT | Uncoded Value | uncategorized | none | none | true |
Date2 | TEXT | Uncoded Value | uncategorized | none | none | true |
Field22 | TEXT | Uncoded Value | uncategorized | none | none | true |
Revised Final | TEXT | Uncoded Value | uncategorized | none | none | true |
Date3 | TEXT | Uncoded Value | uncategorized | none | none | true |
Field25 | TEXT | Uncoded Value | uncategorized | none | none | true |
Field26 | TEXT | Uncoded Value | uncategorized | none | none | true |
Box Number | TEXT | Uncoded Value | uncategorized | none | none | true |
Other Prov | TEXT | Uncoded Value | uncategorized | none | none | true |
Publication | TEXT | Uncoded Value | uncategorized | none | none | true |
Date | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Gen_Illustration | BIGINT | Uncoded Value | uncategorized | none | none | true |
Gen_PHOTO EXT | BIGINT | Uncoded Value | uncategorized | none | none | true |
Gen_Photograph | BIGINT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
pathtophoto | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: ULL_Utility_for_Unit60s
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
UtilULL | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: ULLs
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ULLId | Identification number | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
SiteId | FK to SiteId in _Sites lookup table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
AUId | FK to AUId in the AU table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ULL | Unit-Level-Locus | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
DateExc | What is the beginning date that the ULL was excavated | |||||
DATETIME | Uncoded Value | uncategorized | none | none | true | |
SecondDate | This is here because there is a ULL that was excavated in 2 separate years | |||||
DATETIME | Uncoded Value | uncategorized | none | none | true | |
Datum | What datums were used for measurements of this ULL - info taken from field notes | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULLValidity | valid means that the ull can be found in the field notes - reassigned means the ULL was derived from "errors" during artifact coding or bag mislabelling | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unit | Unit designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
UnitId | FK to UnitList lookup table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Level | Level designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Locus | Locus designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
VolumeExpected | Volumes are not expected for surface ULLs, reassigned ULLs, or mixed ULLs | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Volume | Estimated volume for the ULL (see Nawa S. for details) | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
FieldNotes | link to a pdf of the field notes - the pdf file resides on the server - may need to be restablished if the link gets broken | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Comments | General comments | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: ULLs_old
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
ULLId | Identification number | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
SiteId | FK to SiteId in _Sites lookup table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
AUId | FK to AUId in the AU table | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
ULLValidity | valid means that the ull can be found in the field notes - reassigned means the ULL was derived from "errors" during artifact coding | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unit | Unit designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Level | Level designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Locus | Locus designation | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
VolumeExpected | TEXT | Uncoded Value | uncategorized | none | none | true |
Volume | Estimated volume for the ULL (see Nawa for details) | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
Comments | General comments | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: UnitList
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
UnitListId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
Validity | TEXT | Uncoded Value | uncategorized | none | none | true |
SortOrder | DOUBLE | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
BeginingSize | TEXT | Uncoded Value | uncategorized | none | none | true |
EndingSize | TEXT | Uncoded Value | uncategorized | none | none | true |
UnitDetails | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: UnitList_old
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
UnitListId | BIGINT | Uncoded Value | uncategorized | none | none | true |
SortOrder | BIGINT | Uncoded Value | uncategorized | none | none | true |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
BeginingSize | TEXT | Uncoded Value | uncategorized | none | none | true |
EndingSize | TEXT | Uncoded Value | uncategorized | none | none | true |
UnitDetails | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: volsbychapt
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
GroupLvl2 | TEXT | Uncoded Value | uncategorized | none | none | true |
SumOfSumOfVolume | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Table Information: WoodChrcl
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
WoodId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Phase | To be deleted? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Site | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Area | to be deleted? | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Unit | BIGINT | Uncoded Value | uncategorized | none | none | true |
Level | TEXT | Uncoded Value | uncategorized | none | none | true |
Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
Fraction | TEXT | Uncoded Value | uncategorized | none | none | true |
Taxa | to be deleted | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TaxaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
Weight | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Comment | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: zBandMotifType
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
typeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: zzSheet1
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
BoxId | BIGINT | Uncoded Value | uncategorized | none | none | true |
BagNo | TEXT | Uncoded Value | uncategorized | none | none | true |
Rim | TEXT | Uncoded Value | uncategorized | none | none | true |
Vessel | TEXT | Uncoded Value | uncategorized | none | none | true |
Prim-ID | TEXT | Uncoded Value | uncategorized | none | none | true |
tempNo | BIGINT | Uncoded Value | uncategorized | none | none | true |
temp_bulk | TEXT | Uncoded Value | uncategorized | none | none | true |
CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Year | TEXT | Uncoded Value | uncategorized | none | none | true |
Site | TEXT | Uncoded Value | uncategorized | none | none | true |
Unit-level-locus | TEXT | Uncoded Value | uncategorized | none | none | true |
Material | TEXT | Uncoded Value | uncategorized | none | none | true |
Category | TEXT | Uncoded Value | uncategorized | none | none | true |
Bulk | TEXT | Uncoded Value | uncategorized | none | none | true |
Count | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: zzSheet3
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
V# | TEXT | Uncoded Value | uncategorized | none | none | true |
R# | TEXT | Uncoded Value | uncategorized | none | none | true |
RB# | TEXT | Uncoded Value | uncategorized | none | none | true |
BagId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Box# | TEXT | Uncoded Value | uncategorized | none | none | true |
BoxId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Year | TEXT | Uncoded Value | uncategorized | none | none | true |
Site | TEXT | Uncoded Value | uncategorized | none | none | true |
ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
Level | TEXT | Uncoded Value | uncategorized | none | none | true |
Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
Ware | TEXT | Uncoded Value | uncategorized | none | none | true |
Type | TEXT | Uncoded Value | uncategorized | none | none | true |
Form | TEXT | Uncoded Value | uncategorized | none | none | true |
Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Count | TEXT | Uncoded Value | uncategorized | none | none | true |
Roll | TEXT | Uncoded Value | uncategorized | none | none | true |
Frame 1 | TEXT | Uncoded Value | uncategorized | none | none | true |
Frame 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
Frame 3 | TEXT | Uncoded Value | uncategorized | none | none | true |
Frame 4 | TEXT | Uncoded Value | uncategorized | none | none | true |
Frame 5 | TEXT | Uncoded Value | uncategorized | none | none | true |
Frame 6 | TEXT | Uncoded Value | uncategorized | none | none | true |
Frame 7 | TEXT | Uncoded Value | uncategorized | none | none | true |
Frame 8 | TEXT | Uncoded Value | uncategorized | none | none | true |
Frame 9 | TEXT | Uncoded Value | uncategorized | none | none | true |
Frame 10 | TEXT | Uncoded Value | uncategorized | none | none | true |
Frame 11 | TEXT | Uncoded Value | uncategorized | none | none | true |
Data Table Relationships:
Type | Local Table | Foreign Table | Column Relationships |
---|---|---|---|
ONE_TO_MANY | Test_Romos_Form_lookup | Test_RomosSherds | FormId FormId |
ONE_TO_MANY | _FnaElement | Fauna | ElementId ElementId |
ONE_TO_MANY | ULLs | Dates | ULLId ULLId |
ONE_TO_MANY | Test_Romos_VesselMotifComplexity_lookup | Test_RomosSherds | MotifComplexityId VesselMotifComplexityId |
ONE_TO_MANY | ULLs | LPHumBone | ULLId ULLId |
ONE_TO_MANY | _ArtCatFunctionalClasses | ArtifactCatalog | FunctClassId FunctionalClassId |
ONE_TO_MANY | Test_Romos_Band_lookup | Test_Romos_Band_Motif | bandid bandid |
ONE_TO_MANY | Test_Romos_Surface_lookup | Test_RomosSherds | SurfaceId SurfaceExteriorId |
ONE_TO_MANY | _CerTypeWare | RimStudy | WareId WareId |
ONE_TO_MANY | IE_Sherds | IE_SherdElemJunct | IESherdsIdD IESherdId |
MANY_TO_ONE | _STType | ShapedTools | TypeId TypeId |
ONE_TO_MANY | ULLs | Figurines_new | ULLId ULL_Id |
ONE_TO_MANY | _CerTrtmnt | _CerType | TrtmntId TrtmntId |
ONE_TO_MANY | _WoodTaxa | WoodChrcl | WoodtaxaId TaxaId |
ONE_TO_MANY | _AUGroupLvl2 | AUs | GroupLvl2Id GroupLvl2Id |
ONE_TO_MANY | _HmOstLvl2Grp | LPHumBone | Lvl2GrpId Lvl2GrpId |
ONE_TO_MANY | _Sites | RimStudy_old | SiteId SiteId |
ONE_TO_MANY | Test_Romos_Articulation_lookup | Test_Romos_Type | ArticulationId ST_2_Articulation_id |
ONE_TO_MANY | _FnaFusion | Fauna | FusionId FusionId |
ONE_TO_MANY | Photologs | Photo_ULLS | PhotoId PohotoId |
ONE_TO_MANY | _DebCortex | Debitage | CotexId CortexId |
ONE_TO_MANY | _IE_Elements | IE_SherdElemJunct | IE_ElementId IE_ElementId |
ONE_TO_MANY | _AUPhase2 | AUs | Phase2Id Phase2Id |
ONE_TO_MANY | Test_Romos_LineWidth_lookup | Test_RomosSherds | LineWidthId LineWidthInteriorId |
ONE_TO_MANY | _CerType | ArtifactCatalog | TypeId TypeId |
ONE_TO_MANY | _RimLipTreatment | RimStudy | lip_treat_id LipTreatmentId |
ONE_TO_MANY | ULLs | NewFlots | ULLId ULLId |
ONE_TO_MANY | ULLs | RimStudy_old | ULLId ULLId |
ONE_TO_MANY | _IE_ElementType_revised | _IE_Elements_revised | ElementTypeId ElementTypeId |
ONE_TO_MANY | ULLs | LQ_Processed_Human_Bone | ULLId ULL_ID |
ONE_TO_MANY | _CerTypeWare | ArtifactCatalog | WareId WareId |
ONE_TO_MANY | Test_Romos_Slip_lookup | Test_RomosSherds | SlipId SlipExteriorId |
ONE_TO_MANY | _Sites | NewFlots | SiteId SiteId |
ONE_TO_MANY | _ArtCatAnalyticalClasses | ArtifactCatalog | AnalyticalClassId AnalyticalClassId |
ONE_TO_MANY | UnitList | _UnitYear | UnitListId UnitId |
ONE_TO_MANY | _Sites | Shell | SiteId SiteId |
ONE_TO_MANY | _AU_Phase3 | AUs | Phase3_ID Phase3Id |
ONE_TO_MANY | Test_Romos_SubType_lookup | Test_Romos_SubType | subtypeid subtypeid |
ONE_TO_MANY | Test_Romos_Type_lookup | Test_Romos_Band_Motif | TypeId typeid |
ONE_TO_MANY | Test_Romos_Firing_lookup | Test_RomosSherds | FiringId FiringInteriorId |
ONE_TO_MANY | _HmOstEleNorm | LPHumBone | ElementId ElementId |
ONE_TO_MANY | _GrndstnCat | Grndstn | CatId TypeCatId |
ONE_TO_MANY | _CerForm | Ceramics_old_del | FormId FormId |
ONE_TO_MANY | ArtifactCat_BoxInventory | ArtifactCat_Bags | BoxId BoxId |
ONE_TO_MANY | _CerTrtmnt | RimStudy | TrtmntId DecorationId |
ONE_TO_MANY | AUs | ULLs | AUId AUId |
ONE_TO_MANY | _CarbonSampleConcentration | CarbonSamples | ConcentrationId ConcentrationId |
ONE_TO_MANY | _FnaHumMod | Fauna | HumModId HumModId |
ONE_TO_MANY | _SpecArtClass | SpecArtfcts | ClassId ClassId |
ONE_TO_MANY | Test_Romos_Motif_lookup | Test_Romos_Band_Motif | motifid motifid |
ONE_TO_MANY | _Sites | ExcvtdUnits_del | SiteId SiteId |
ONE_TO_MANY | Dates | CarbonSamples | DateId DateId |
ONE_TO_MANY | _SpecArtMat | SpecArtfcts | SpecArtMatId SpecArtMatId |
ONE_TO_MANY | ArtifactCatalog | Photo_Artifacts | CatId CatId |
ONE_TO_MANY | _RimLipForm | RimStudy | lip_id LipFormId |
ONE_TO_MANY | RomosStudy_new | Romos_Sherd_Band_Assoc | ID Sherd_id_fk |
ONE_TO_MANY | ULLs | Fauna | ULLId ULLId |
ONE_TO_MANY | _Sites | WoodChrcl | SiteId ULLId |
ONE_TO_MANY | _CarbonSamplePriority | CarbonSamples | PriorityId PriorityId |
ONE_TO_MANY | _AUReportArea | AUs | ReportAreaId ReportAreaId |
ONE_TO_MANY | Test_Romos_Linkage_lookup | Test_Romos_Type | LinkageId ST_3_Linkage_id |
ONE_TO_MANY | Test_Romos_CoreOxidation_lookup | Test_RomosSherds | CoreOxidationId CoreOxidationId |
ONE_TO_MANY | _Sites | Debitage | SiteId SiteId |
ONE_TO_MANY | _MbotPrtn | Macrobot | MbotPortId PortionId |
ONE_TO_MANY | Test_Romos_Portion_lookup | Test_RomosSherds | PortionId PortionId |
ONE_TO_MANY | _ChapterGroups | AUs | ChapterGroupId ChapterId |
ONE_TO_MANY | Test_Romos_Banding_lookup | Test_RomosSherds | BandingId BandingTypeId |
ONE_TO_MANY | _MbotFrctnId | Macrobot | FractionId FractionId |
ONE_TO_MANY | _Sites | UnitList_old | SiteId SiteId |
ONE_TO_MANY | Photologs | Photo_Artifacts | PhotoId PhotoId |
ONE_TO_MANY | _DebTypeB | Debitage | TypeBId TypeBId |
ONE_TO_MANY | _CerRprtGrps | _CerType | ReportGroupId ReportGroupId |
ONE_TO_MANY | _CarbonSampleSize | CarbonSamples | SampleSizeId SampleSizeId |
ONE_TO_MANY | _Sites | _FieldNotebooks_old | SiteId SiteId |
ONE_TO_MANY | _ArtCatManufacturingClasses | ArtifactCatalog | ManufacturingClassId ManufacturingClassId |
ONE_TO_MANY | ULLs | Ceramics_old_del | ULLId ULLId |
ONE_TO_MANY | Test_Romos_Type | Test_Romos_SubType | typeid typeid bandid bandid sherdid sherdid motifid motifid |
ONE_TO_MANY | _FnaNatMod | Fauna | NatModID NatModId |
ONE_TO_MANY | _GndstnMat | Grndstn | MatId MatId |
ONE_TO_MANY | _Sites | Ceramics_old_del | SiteId SiteId |
ONE_TO_MANY | _DebStage | Debitage | StageId StageId |
ONE_TO_MANY | _AUCultSpace | AUs | CultSpaceId CultSpaceId |
ONE_TO_MANY | _Sites | Fauna | SiteId SiteId |
ONE_TO_MANY | _Cer_Element_Groups | Romos_Sherd_Band_Assoc | Element_group_id cer_element_group_id_fk |
ONE_TO_MANY | _ShellClass | Shell | ClassId ClassId |
ONE_TO_MANY | UnitList_old | _UnitYear_old | UnitListId UnitId |
ONE_TO_MANY | _GndstnCond | Grndstn | CondId ConId |
ONE_TO_MANY | Test_Romos_LineWidth_lookup | Test_RomosSherds | LineWidthId LineWidthExteriorId |
ONE_TO_MANY | ULLs | RomosStudy_new | ULLId ULL_ID_FK |
ONE_TO_MANY | _TableGroups | AUs | TableGroupId TableGroupId |
ONE_TO_MANY | _DebStageIdx | Debitage | StageIdxId StageIndexId |
ONE_TO_MANY | ULLs | Photo_ULLS | ULLId ULL_Id |
ONE_TO_MANY | Test_Romos_RedRim_lookup | Test_RomosSherds | RedRimId RedRimId |
ONE_TO_MANY | _Sites | Grndstn | SiteId SiteId |
ONE_TO_MANY | Test_Romos_CoreColor_lookup | Test_RomosSherds | CoreColorId CoreColorId |
ONE_TO_MANY | Test_Romos_Ware_lookup | Test_RomosSherds | WareId WareId |
ONE_TO_MANY | TypeCllctn | OtherArtifacts | TypeCllcntID TypeCllcntID |
ONE_TO_MANY | _Sites | ULLs | SiteId SiteId |
ONE_TO_MANY | _STMatGrpId | ShapedTools | MatGroupId MatGroupId |
ONE_TO_MANY | ArtifactCat_Bags | ArtifactCatalog | BagId BagId |
ONE_TO_MANY | Test_Romos_Slip_lookup | Test_RomosSherds | SlipId SlipInteriorId |
ONE_TO_MANY | _Sites | SpecArtfcts | SiteId SiteId |
ONE_TO_MANY | _GndstnWear | Grndstn | WearId WearId |
ONE_TO_MANY | _FigType | Figurines_legacy_del | TypeId TypeId |
ONE_TO_MANY | _AUPhase | AUs | PhaseId PhaseId |
ONE_TO_MANY | _FigFinish | Figurines_legacy_del | FinishId FinishId |
ONE_TO_MANY | _CerType | RimStudy | TypeId TypeId |
ONE_TO_MANY | _GndstnMTM | Grndstn | MTMId MTMId |
ONE_TO_ONE | Test_Romos_Band_Motif | Test_Romos_Line_Infratype | typeid typeid bandid bandid sherdid sherdid motifid motifid |
ONE_TO_MANY | _SubGroups | _CulturalSpace | SubGroupId SubGroupId |
ONE_TO_MANY | Test_Romos_Firing_lookup | Test_RomosSherds | FiringId FiringExteriorId |
ONE_TO_MANY | _RimVsslShp | ArtifactCatalog | shape_id VesselShapeId |
ONE_TO_MANY | _FnaProxDist | Fauna | ProxDistId ProxDistId |
ONE_TO_MANY | Test_RomosSherds | Test_Romos_Band_Motif | sherdid sherdid |
ONE_TO_MANY | _Sites | Figurines_legacy_del | SiteId SiteId |
ONE_TO_MANY | _FigSex | Figurines_legacy_del | SexId SexId |
ONE_TO_MANY | ULLs | ArtifactCatalog | ULLId ULLId |
ONE_TO_MANY | _ArtifactCatTypes | ArtifactCatalog | ArtCatTypeId ArtifactCatType |
ONE_TO_MANY | _SpecArtDec | SpecArtfcts | DecTechId DecTechId |
ONE_TO_MANY | ArtifactCatalog | IllstArtfcts | CatId CatId |
ONE_TO_MANY | Test_Romos_Smearing_lookup | Test_RomosSherds | SmearingId SmearingExteriorId |
ONE_TO_MANY | _Sites | Macrobot | SiteId SiteId |
ONE_TO_MANY | _DebMaterial | Debitage | MaterialId MatId |
ONE_TO_MANY | ArtifactCatalog | RimStudy | CatId CatId |
ONE_TO_MANY | _MbotTaxa | Macrobot | TaxaId MbotTaxaId |
ONE_TO_MANY | _HmOsLvl1Grp | LPHumBone | Lvl1GrpId Lvl1GrpId |
ONE_TO_MANY | ArtifactCatalog | ArtCatVesselAnalysis | CatId CatId |
ONE_TO_MANY | TypeCllctn | IllstArtfcts | TypeCllcntID TypeCllctnId |
ONE_TO_MANY | _CerPortion | Ceramics_old_del | PortionId PortionId |
ONE_TO_MANY | Test_Romos_Surface_lookup | Test_RomosSherds | SurfaceId SurfaceInteriorId |
ONE_TO_MANY | ULLs | Figurines_legacy_del | ULLId ULLId |
ONE_TO_MANY | _FigPortion | Figurines_legacy_del | PortionId PortionId |
ONE_TO_MANY | _ShellGenera | Shell | GeneraId GeneraId |
ONE_TO_MANY | _FieldNotebooks_old | _UnitYear_old | NotebookId NotebookId |
ONE_TO_MANY | _Cer_Elements | Romos_Sherd_Band_Assoc | Cer_element_id cer_element_id_fk |
ONE_TO_MANY | _ChapterGroups | _SubGroups | ChapterGroupId ChapterGroupId |
ONE_TO_MANY | _Sites | ULLs_old | SiteId SiteId |
ONE_TO_MANY | Test_Romos_SubType_lookup | Test_Romos_Type | subtypeid SubInfraType_id |
ONE_TO_MANY | _CarbonSampleComposition | CarbonSamples | CompositionId CompositionId |
ONE_TO_MANY | _FnaTaxa | Fauna | TaxaId TaxaId |
ONE_TO_MANY | Test_Romos_FireClouding_lookup | Test_RomosSherds | FireCloudingId FireCloudingInteriorId |
ONE_TO_MANY | ULLs | Grndstn | ULLId ULLId |
ONE_TO_MANY | _DebType | Debitage | TypeId TypeId |
ONE_TO_MANY | _IE_Element_Fill | IE_SherdElemJunct | ElementFillId IE_ElementFillId |
ONE_TO_MANY | _FieldNotebooks | _UnitYear | NotebookId NotebookId |
ONE_TO_MANY | ULLs | Debitage | ULLId ULLId |
ONE_TO_MANY | Test_Romos_FireClouding_lookup | Test_RomosSherds | FireCloudingId FireCloudingExteriorId |
ONE_TO_MANY | _RimContourType | RimStudy | contour_id ContourTypeId |
ONE_TO_MANY | _AUGroupLvl1 | AUs | GroupLvl1Id GroupLvl1Id |
ONE_TO_MANY | _Sites | LPHumBone | SiteId SiteId |
ONE_TO_MANY | ULLs | Macrobot | ULLId ULL_ID |
ONE_TO_MANY | _CerType | Ceramics_old_del | TypeId TypeId |
ONE_TO_MANY | _RimVsslShp | RimStudy | shape_id VesselShapeId |
ONE_TO_MANY | ULLs | CarbonSamples | ULLId ULLId |
ONE_TO_MANY | Test_Romos_Smearing_lookup | Test_RomosSherds | SmearingId SmearingInteriorId |
ONE_TO_MANY | _FnaBurn | Fauna | BurnId BurnId |
Keywords
Material
Building Materials
•
Ceramic
•
Chipped Stone
•
Dating Sample
•
Fauna
•
Ground Stone
•
Human Remains
•
Macrobotanical
•
Mineral
•
Shell
•
Wood
Site Name
La Quemada
•
Malpaso Valley
Site Type
Ancient Communal / Public Structure
•
Archaeological Feature
•
Artifact Scatter
•
Ball Court
•
Building Substructure
•
Causeway
•
Domestic Structure or Architectural Complex
•
Encampment
•
Hamlet / Village
•
Hearth
•
House
•
Non-Domestic Structures
•
Palace
•
Platform Mound
•
Plaza
•
Pyramid
•
Resource Extraction / Production / Transportation Structure or Features
•
Settlements
•
Sheet Midden
•
Stairway
•
Temple
•
Terrace
•
Town / City
•
Trash Midden
General
AMS Radiocarbon Dating
•
Archaeobotanical Analysis
•
Archaeomagnetic Dating
•
Bioarchaeology/Skeletal Analysis
•
Ceramic Figurine
•
Ceramic Production and Exchange
•
Charcoal Analysis
•
Chronological Seriation
•
Figurines, West Mexico
•
Groundstone & Lithic Analysis
•
Human-Environmental Interactions
•
Long-Distance Exchange Networks
•
Northern expansion of Mesoamerica
•
Obsidian Source Analysis
•
ritual practice
•
Social Complexity
Temporal Coverage
Calendar Date: -1000 to 1050
Radiocarbon Date: 1250 to ?
Spatial Coverage
min long: -102.853; min lat: 22.437 ; max long: -102.788; max lat: 22.479 ;
Individual & Institutional Roles
Contact(s): Vincent Schiavitti
File Information
Name | Size | Creation Date | Date Uploaded | Access | |
---|---|---|---|---|---|
d_11_1266_malpaso_ver3_sync.mdb | 682.64mb | Oct 16, 2010 10:43:14 AM | Public |