Malpaso Database
Part of the Malpaso Valley - La Quemada project
Year: 2008
Summary
no description provided
Cite this Record
Malpaso Database. 2008 ( tDAR id: 1266) ; doi:10.6067/XCV87P8X92
Data Set Structure
Measurement Column
Count Column
Coded Column
Filename Column
Integration Column (has Ontology)
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 |
---|---|---|---|---|---|---|
Cast | TEXT | Uncoded Value | uncategorized | none | none | true |
CM # | TEXT | Uncoded Value | uncategorized | none | none | true |
Loc | 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 |