Malpaso Database
Part of the La Quemada-Malpaso Valley Archaeological Project (LQ-MVAP) project
Year: 2008
Summary
no description provided
Cite this Record
Malpaso Database. 2008 ( tDAR id: 1266) ; doi:10.6067/XCV87P8X92
Data Set Structure
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 |
|---|---|---|---|---|---|---|
| CM # | TEXT | Uncoded Value | uncategorized | none | none | true |
| Loc | TEXT | Uncoded Value | uncategorized | none | none | true |
| Cast | TEXT | Uncoded Value | uncategorized | none | none | true |
| Pos | TEXT | Uncoded Value | uncategorized | none | none | true |
| Sort # | TEXT | Uncoded Value | uncategorized | none | none | true |
| Cast # | TEXT | Uncoded Value | uncategorized | none | none | true |
| Length | TEXT | Uncoded Value | uncategorized | none | none | true |
| Width | TEXT | Uncoded Value | uncategorized | none | none | true |
| Depth | TEXT | Uncoded Value | uncategorized | none | none | true |
| Shape | TEXT | Uncoded Value | uncategorized | none | none | true |
| Dir | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| Site_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| other info | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Provience | TEXT | Uncoded Value | uncategorized | none | none | true |
| Bone | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field # | TEXT | Uncoded Value | uncategorized | none | none | true |
| Side | TEXT | Uncoded Value | uncategorized | none | none | true |
| CM Total | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: LQ_Processed_Human_Bone
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ps | TEXT | Uncoded Value | uncategorized | none | none | true |
| id | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Site_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| unit | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| level | TEXT | Uncoded Value | uncategorized | none | none | true |
| locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| Ull_rect_comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| otherinfo | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| side | TEXT | Uncoded Value | uncategorized | none | none | true |
| frag | TEXT | Uncoded Value | uncategorized | none | none | true |
| bone | TEXT | Uncoded Value | uncategorized | none | none | true |
| age | TEXT | Uncoded Value | uncategorized | none | none | true |
| % | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| peri fract | TEXT | Uncoded Value | uncategorized | none | none | true |
| ivr | TEXT | Uncoded Value | uncategorized | none | none | true |
| sc1 | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| cr | TEXT | Uncoded Value | uncategorized | none | none | true |
| pt | TEXT | Uncoded Value | uncategorized | none | none | true |
| fl | TEXT | Uncoded Value | uncategorized | none | none | true |
| pe | TEXT | Uncoded Value | uncategorized | none | none | true |
| ct | TEXT | Uncoded Value | uncategorized | none | none | true |
| ch | TEXT | Uncoded Value | uncategorized | none | none | true |
| pp | TEXT | Uncoded Value | uncategorized | none | none | true |
| sc2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| gn | TEXT | Uncoded Value | uncategorized | none | none | true |
| cd | TEXT | Uncoded Value | uncategorized | none | none | true |
| b | TEXT | Uncoded Value | uncategorized | none | none | true |
| box | TEXT | Uncoded Value | uncategorized | none | none | true |
| measurement | TEXT | Uncoded Value | uncategorized | none | none | true |
| comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: LQ_ULL_VOL_EST
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| VOL_EST_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | all valid Ulls from La Qemada | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| unit | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| level | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| locus | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| TOP_BOT_IRREG | is the top shape different from the bottom shape (YES or NO)? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| U_SHAPE | combo box of acceptable shapes - not based on a table | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| L_SHAPE | TEXT | Uncoded Value | uncategorized | none | none | true |
| U_LENGTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_WIDTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_HEIGHT | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_BASE | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| SIDE_A | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| SIDE_B | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| L_LENGTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_WIDTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_HEIGHT | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_BASE | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| RADIUS | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| AREA | shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc]) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| DEPTH | average depth measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| VOL | measurement in cubic meters (AREA * DEPTH) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| NOTES | note any unusual steps needed in orde rto make your calculation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: LQVolEstsOld
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| U_SHAPE | combo box of acceptable shapes - not based on a table | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| L_SHAPE | TEXT | Uncoded Value | uncategorized | none | none | true |
| U_LENGTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_WIDTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| VOL_EST_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | all valid Ulls from La Qemada | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| unit | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| level | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| locus | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| TOP_BOT_IRREG | is the top shape different from the bottom shape (YES or NO)? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| U_HEIGHT | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_BASE | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| SIDE_A | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| SIDE_B | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| L_LENGTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_WIDTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_HEIGHT | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_BASE | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| RADIUS | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| AREA | shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc]) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| DEPTH | average depth measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| VOL | measurement in cubic meters (AREA * DEPTH) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| NOTES | note any unusual steps needed in orde rto make your calculation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: Macrobot
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SampleId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Area | to be deleted? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Locus | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Fraction | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| FractionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ID | to be deleted? | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Taxa | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| MbotTaxaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Portion | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Weight | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Charred | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Comment | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Mbot_Type_Analysis
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Mbot_type_anal_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| speci_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
| botanical_type_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: MD_Fields
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Field_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Field_name | TEXT | Uncoded Value | uncategorized | none | none | true |
| Table_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Doc_Object | BLOB | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
| MetaData_Desc | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: MD_Tables
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Table_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Table_Name | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
| MetaData | TEXT | Uncoded Value | uncategorized | none | none | true |
| Doc_object | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: NewFlots
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Unid 6 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 7 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 3 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 4 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ID | NewFlots unique identifier - data set created by Paula Turkon summer of 2006 | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Site | Site name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | Site ID and FK to sites table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Area | delete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULL | Unit-Level-Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULLId | Unit-Leve-LLocus ID | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Unit | Unit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Level | Level | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Locus | Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Slash | Slash number or letter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Phase | delete - these phases inlcude those from middens based on their specific stratigraphy and are not necessarliy the same phases as those in architectural areas | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| AU(old) | delete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| AU Description(old) | delete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Wood Charcoal (in grams) | TEXT | Uncoded Value | uncategorized | none | none | true |
| Maize cupule-count | TEXT | Uncoded Value | uncategorized | none | none | true |
| Cupule Weight (in grams) | TEXT | Uncoded Value | uncategorized | none | none | true |
| Maize kernel-count | TEXT | Uncoded Value | uncategorized | none | none | true |
| Kernel Weight (in grams) | TEXT | Uncoded Value | uncategorized | none | none | true |
| Phaseolus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Curcurbita | TEXT | Uncoded Value | uncategorized | none | none | true |
| Opuntia | TEXT | Uncoded Value | uncategorized | none | none | true |
| Opuntia sp 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Agave Tissue (in grams) | TEXT | Uncoded Value | uncategorized | none | none | true |
| Wild Legume | TEXT | Uncoded Value | uncategorized | none | none | true |
| Chenopodium | TEXT | Uncoded Value | uncategorized | none | none | true |
| Chenopodium sp 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Chenopodium sp 3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Chenopodium album | TEXT | Uncoded Value | uncategorized | none | none | true |
| Chenopodium-tiny | TEXT | Uncoded Value | uncategorized | none | none | true |
| Amaranthus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Mammalaria | TEXT | Uncoded Value | uncategorized | none | none | true |
| Cactaceae | TEXT | Uncoded Value | uncategorized | none | none | true |
| Physalis | TEXT | Uncoded Value | uncategorized | none | none | true |
| Solanaceae | TEXT | Uncoded Value | uncategorized | none | none | true |
| Euphorbiaceae | TEXT | Uncoded Value | uncategorized | none | none | true |
| Brassica | TEXT | Uncoded Value | uncategorized | none | none | true |
| Portulaca | TEXT | Uncoded Value | uncategorized | none | none | true |
| Compositae | TEXT | Uncoded Value | uncategorized | none | none | true |
| Compositae sp 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Helianthus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Pinus nut frag | TEXT | Uncoded Value | uncategorized | none | none | true |
| Prosopis | TEXT | Uncoded Value | uncategorized | none | none | true |
| Stellaria | TEXT | Uncoded Value | uncategorized | none | none | true |
| Setaria | TEXT | Uncoded Value | uncategorized | none | none | true |
| Leguminoseae sp 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Gramineae | TEXT | Uncoded Value | uncategorized | none | none | true |
| Polygonum | TEXT | Uncoded Value | uncategorized | none | none | true |
| Lychnis | TEXT | Uncoded Value | uncategorized | none | none | true |
| Labiateae | TEXT | Uncoded Value | uncategorized | none | none | true |
| Unid 1 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 2 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 8 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 9 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 10 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 11 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 12 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid13 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 14 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 16 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 17 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 18 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 20 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 21 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 22 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 23 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 24 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 25 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 26 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid Fruit 1 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid Fruit 2 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid Fruit 3 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid Fruit 4 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid Fruit 5 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid Spines | Unidentified spines | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Reeds | TEXT | Uncoded Value | uncategorized | none | none | true |
| Misc Stems | TEXT | Uncoded Value | uncategorized | none | none | true |
| Misc tissue (grams) | TEXT | Uncoded Value | uncategorized | none | none | true |
| Unid Fragments | Unidentified Fragments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Land Snails (100=more not pulled) | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Obsidian 97
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| obs_id | Primary key | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| bag_id | Bag number (Zacatecas only) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| analytical_unit | Analytical unit | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| site | La Quemada or Los Pilarillos | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Site_ID_FK | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Area_name | Portion of Site | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| midden_phase | Midden phase (early, middle, late, mixed) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| unit | Excavation Unit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| level | Level | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| locus | Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL_ID_FK | BIGINT | Uncoded Value | uncategorized | none | none | true |
| / | Slash - Number=Point Proveniece, Letter=Special Find | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| mg | Weight in mg +-10mg | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| count | Number of flakes | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| flake | Flake type: Primary Flake, Secondary Flake, Tertiary Flake, Primary RETouch flake, Secondary RETouch flake, Tertiary RETouch flake, CORE, COBBLE, Fragmentary Flake, FRAGment | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| edge | U=used, PL= likely usable/used, PD=doubtful usable/used, N=not usable | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| cortex | + or - (TF's with cortex on platform and cores) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| cortex_surface | Cortex surface - 1=smooth and flat, 2 = smooth and ridged, 3 = rough and flat, 4 = rough and ridged, 5 = very rough | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| color | Flake Color, Loni's categories/classification: Lustrous Black; Dull Black; Translucent Black; Translucent Green; Dull Green; Dull Grey; Lustrous Dark Grey; Lustrous Red | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| luster | Luster: GReasy; GLassy; Lustrous (not types as GR or GL); UNknown | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| surface | Surface Quality: Rough or Calcified, no entry = smooth and clean | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| clarity | Clarity 1=Clear; 2= Clear with cloudiness; 3= cloudy but translucent; 4= Part opaque, part cloudy/translucent; 5= Fully opaque, possible translucent at thin edges; 6= Special; 7= Unknown | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| inclusions | STRiations, SHMutz, BUBbles, SPLotches, RIBbons, CLOuds, FLEcks, MOTtling, SPEckles | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| primary_clr | Primary Color: Black; Black-Dark Grey; Dark Grey; Grey; Light Grey; White; Green; Light Green; Dark Green; Grey-Green; Red; Red-Brown; Brown; Brown-Green; Red-Orange; Dark Red-Brown; Ochre; UNknown | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| secondary_clr | Secondary Color: Grey; Black; Dark Grey; Black-Dark Grey; Light Grey; Light Green; White; Red; Brown-Green; Dark Red; Red-Orange; Brown | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| tertiary_clr | Tertiary Color: Black; Grey; Brown | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| opalescent | + is yes, = is maybe, - is no | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| special | Special qualities | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| color_group | Color group | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| mvp_id | MURR sample number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| analysis | Type of Analysis | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| naa_source | Sub source based on color association | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| chemical_source | Greatest detail, only recorded if only one source associates with the group | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| source_area | Less detail, only similar source areas are recoded | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| means_of_procurement | Least detail, only similarly acquisition - Unk E and Noch for example | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| drawn | Drawn? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| photo | Photogrpahed? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| location | Where curated? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: OtherArtifacts
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| OtherId | Unique identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| TypeCllcntID | Type Collection ID and FK to the Type Collection table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Material | Material | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Material subclass | Material subclass | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Class | Class | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Functional subclass | Functional subclass | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Details | Details | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| count | count | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
Table Information: Photo_Artifacts
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| PhotoArtifactsId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| PhotoId | Link back to traditional prints in Photolog table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Exposure | TEXT | Uncoded Value | uncategorized | none | none | true |
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| PrimId | TEXT | Uncoded Value | uncategorized | none | none | true |
| RimNumber | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULLInfo | TEXT | Uncoded Value | uncategorized | none | none | true |
| SelectedForArtCat | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| SelectedForReport | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Image | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: Photo_ULLS
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| IdPhotoNum_ULL | BIGINT | Uncoded Value | uncategorized | none | none | true |
| PohotoId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SIte_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| AUId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Photologs
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| PhotoId | Unique identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Page | Page | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| BinderNum | Note book binder number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Roll | Roll identifier | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Film | Film Type | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Speed | Film speed | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Exp | Exposure number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Sort | Sort number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Site | Site | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Subject | Subject | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Date | Date photo was taken | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Description | Description | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Direction | Direction facing when photo taken | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Photographer | Photographer | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Hyperlink | Hyperlink to digital copy of photograph | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Item1 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Item2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Item3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Item4 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Item5 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Item6 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Item7 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Item8 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Item9 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Item10 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Item11 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Item12 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: RimStudy
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | TEXT | Uncoded Value | uncategorized | none | none | true |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Site | TEXT | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| R number | TEXT | Uncoded Value | uncategorized | none | none | true |
| AndrewComment | TEXT | Uncoded Value | uncategorized | none | none | true |
| Sort number | BIGINT | Uncoded Value | uncategorized | none | none | true |
| V number | BIGINT | Uncoded Value | uncategorized | none | none | true |
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| PrimId | TEXT | Uncoded Value | uncategorized | none | none | true |
| BoxId_new | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Box number | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Bag number | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Year | TEXT | Uncoded Value | uncategorized | none | none | true |
| Coder | TEXT | Uncoded Value | uncategorized | none | none | true |
| Date coded | DATETIME | Uncoded Value | uncategorized | none | none | true |
| Ware | Incised-engraved, Painted, Plain, Negative, Pseudo-cloisonné, Indeterminate, Historic, Slipped | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| WareId | FK to _CerTypeWare | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Type | Look to "Ceramics: type lookup" for more information | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TypeId | FK to _CerType | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Vessel shape | Look to "Rim study: vessel shape lookup" for possible values, definitions, and examples | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| VesselShapeId | FK to _RimVsslShape | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Contour type | Look to "Rim study: contour type lookup" for possible values, definitions, and examples | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ContourTypeId | FK to _RimContourType | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Rim form | Look to "Rim study: rim form lookup" for possible values, definitions, and examples | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| RimFormId | FK to _RimRimForm | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Rim thickening | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Neck-shoulder thickness | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Lip form | Tapered, Rounded, Squared | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| LipFormId | FK to _RimLipForm | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Lip thickening | Yes or No | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Lip treatment | Ticking, Notching, Continuous lines, Discontinuous line, Zig-Zag, Wavy, Diagonal lines, Combination | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| LipTreatmentId | FK to _RimLipTreatment | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Decoration | Decorated, Undecorated | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DecorationId | FK to _CerTrtmnt | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Surface finish ext | Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Surface finish int | Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Slip consistency | Washy, Complete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Orifice radius ext | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Arc ext | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Orifice radius int | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Arc int | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Rim | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Lip | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Neck | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Shoulder | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Body | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Base | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Rim tab | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Tripod facet | Scar where tripod broke off, but effectively no tripod remaining. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Tripod frag | Only a portion of the tripod remains - either shape, length, and/or width measurement would be missing. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Tripod whole | Presence of the entire tripod - shape, length, and width measurements should be possible. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Handle | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Handle orientation | Vertical, Horizontal | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Handle position | Rim, Neck, Shoulder, Body | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Lip to brushing | The measurement on brushed wares from the top of the lip to the point at which brushing begins - measures the amount of obliterated brushing at rim. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Brushed ware neck treat | Simple, Smoothed, Burnished, Highly burnished/Self-slipped, Polished | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Support xsection | Circular, Elliptical | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Support shaft type | Simple, Kneed, Bulbuous | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Support attachment | Simple, Complex | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Foot type | Flared, Direct, Clawed, Pointed | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Carbon streak width | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Carbon sym | Centered, Exteriorly biased, Interiorly biased | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Firing ext | Reduced, Oxidized, Both | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Firing int | Reduced, Oxidized, Both | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| Gen_Comments | BIGINT | Uncoded Value | uncategorized | none | none | true |
| s_ColLineage | BLOB | Uncoded Value | uncategorized | none | none | true |
| s_Generation | BIGINT | Uncoded Value | uncategorized | none | none | true |
| s_GUID | TEXT | Uncoded Value | uncategorized | none | none | true |
| s_Lineage | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: RimStudy_old
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SortNumber | BIGINT | Uncoded Value | uncategorized | none | none | true |
| VNumber | BIGINT | Uncoded Value | uncategorized | none | none | true |
| BoxNumber | BIGINT | Uncoded Value | uncategorized | none | none | true |
| RimId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| RNumber | TEXT | Uncoded Value | uncategorized | none | none | true |
| Body | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| BagNumber | TEXT | Uncoded Value | uncategorized | none | none | true |
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | TEXT | Uncoded Value | uncategorized | none | none | true |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL | to be deleted? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Year | TEXT | Uncoded Value | uncategorized | none | none | true |
| Coder | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateCoded | DATETIME | Uncoded Value | uncategorized | none | none | true |
| Ware | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| WareId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Type | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| VesselShape | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| VesselShapeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ContourType | to be delted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ContourTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| RimForm | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| RimFormId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| RimThickening | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| NeckSsoulderThickness | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| LipForm | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| LipFormId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| LipThickening | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| LipTreatment | to be delted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| LipTreatmentId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Decoration | to be delted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DecorationId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SurfaceFinishExt | TEXT | Uncoded Value | uncategorized | none | none | true |
| SurfaceFinishInt | TEXT | Uncoded Value | uncategorized | none | none | true |
| SlipConsistency | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SlipConsistencyId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| OrificeRadiusExt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| ArcExt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| OrificeRadiusInt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| ArcInt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Rim | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Lip | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Neck | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Shoulder | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Base | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| RimTab | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| TripodFacet | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| TripodFrag | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| TripodWhole | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Handle | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| HandleOrientation | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| HandelPositionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| HandlePosition | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| HandlePositionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| LipToBrushing | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| BrushedWareNeckTreat | TEXT | Uncoded Value | uncategorized | none | none | true |
| SupportXSection | TEXT | Uncoded Value | uncategorized | none | none | true |
| SupportShaftType | TEXT | Uncoded Value | uncategorized | none | none | true |
| SupportAttachment | TEXT | Uncoded Value | uncategorized | none | none | true |
| FootType | TEXT | Uncoded Value | uncategorized | none | none | true |
| CarbonStreakWidth | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| CarbonSym | TEXT | Uncoded Value | uncategorized | none | none | true |
| FiringExt | TEXT | Uncoded Value | uncategorized | none | none | true |
| FiringInt | TEXT | Uncoded Value | uncategorized | none | none | true |
| Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| GenComments | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: RimStudyold_2
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Handle position | Rim, Neck, Shoulder, Body | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Handle orientation | Vertical, Horizontal | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| R number | TEXT | Uncoded Value | uncategorized | none | none | true |
| Sort number | BIGINT | Uncoded Value | uncategorized | none | none | true |
| V number | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Box number | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Bag number | TEXT | Uncoded Value | uncategorized | none | none | true |
| Site | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | TEXT | Uncoded Value | uncategorized | none | none | true |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Year | TEXT | Uncoded Value | uncategorized | none | none | true |
| Coder | TEXT | Uncoded Value | uncategorized | none | none | true |
| Date coded | DATETIME | Uncoded Value | uncategorized | none | none | true |
| Ware | Incised-engraved, Painted, Plain, Negative, Pseudo-cloisonné, Indeterminate, Historic, Slipped | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Type | Look to "Ceramics: type lookup" for more information | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Vessel shape | Look to "Rim study: vessel shape lookup" for possible values, definitions, and examples | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Contour type | Look to "Rim study: contour type lookup" for possible values, definitions, and examples | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Rim form | Look to "Rim study: rim form lookup" for possible values, definitions, and examples | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Rim thickening | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Neck-shoulder thickness | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Lip form | Tapered, Rounded, Squared | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Lip thickening | Yes or No | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Lip treatment | Ticking, Notching, Continuous lines, Discontinuous line, Zig-Zag, Wavy, Diagonal lines, Combination | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Decoration | Decorated, Undecorated | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Surface finish ext | Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Surface finish int | Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Slip consistency | Washy, Complete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Orifice radius ext | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Arc ext | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Orifice radius int | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Arc int | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Rim | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Lip | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Neck | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Shoulder | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Body | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Base | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Rim tab | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Tripod facet | Scar where tripod broke off, but effectively no tripod remaining. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Tripod frag | Only a portion of the tripod remains - either shape, length, and/or width measurement would be missing. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Tripod whole | Presence of the entire tripod - shape, length, and width measurements should be possible. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Handle | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Lip to brushing | The measurement on brushed wares from the top of the lip to the point at which brushing begins - measures the amount of obliterated brushing at rim. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Brushed ware neck treat | Simple, Smoothed, Burnished, Highly burnished/Self-slipped, Polished | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Support xsection | Circular, Elliptical | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Support shaft type | Simple, Kneed, Bulbuous | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Support attachment | Simple, Complex | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Foot type | Flared, Direct, Clawed, Pointed | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Carbon streak width | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Carbon sym | Centered, Exteriorly biased, Interiorly biased | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Firing ext | Reduced, Oxidized, Both | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Firing int | Reduced, Oxidized, Both | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| Gen_Comments | BIGINT | Uncoded Value | uncategorized | none | none | true |
| s_ColLineage | BLOB | Uncoded Value | uncategorized | none | none | true |
| s_Generation | BIGINT | Uncoded Value | uncategorized | none | none | true |
| s_GUID | TEXT | Uncoded Value | uncategorized | none | none | true |
| s_Lineage | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: Romos2001Blk
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Page | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| AnDate | DATETIME | Uncoded Value | uncategorized | none | none | true |
| Box | TEXT | Uncoded Value | uncategorized | none | none | true |
| Coder | TEXT | Uncoded Value | uncategorized | none | none | true |
| Bag | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Portion | TEXT | Uncoded Value | uncategorized | none | none | true |
| Site | TEXT | Uncoded Value | uncategorized | none | none | true |
| Unit | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Level | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Locus | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Form | TEXT | Uncoded Value | uncategorized | none | none | true |
| PaintLoc | TEXT | Uncoded Value | uncategorized | none | none | true |
| Indet | TEXT | Uncoded Value | uncategorized | none | none | true |
| FnStr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| FnOtr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| ThnStr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| ThnOtr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| ThkStr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| ThkOtr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| BrdStr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| BrdOtr | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| RimInt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| RimExt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| RimIntExt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| AllInt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| AllExt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| AllBoth | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| RimInt_AllExt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| RimExt_AllInt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Romos_Sherd_Band_Assoc
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Sherd_band_assoc_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Sherd_id_fk | links to ID in the Romos Study table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Band_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
| type_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
| cer_element_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
| cer_element_group_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: RomosStudy_new
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 1-subinfratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype4_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subinfratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-additional_type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-motif_morphology_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL_ID_FK | BIGINT | Uncoded Value | uncategorized | none | none | true |
| TestID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| armillas collection | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| site | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| level | TEXT | Uncoded Value | uncategorized | none | none | true |
| locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| area | TEXT | Uncoded Value | uncategorized | none | none | true |
| count | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ware | TEXT | Uncoded Value | uncategorized | none | none | true |
| form | TEXT | Uncoded Value | uncategorized | none | none | true |
| portion | TEXT | Uncoded Value | uncategorized | none | none | true |
| firing_ interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| firing_ exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| fire_ clouding_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| fire_ clouding_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| slip_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| slip_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| surface_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| surface_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| core oxidation | TEXT | Uncoded Value | uncategorized | none | none | true |
| core color | TEXT | Uncoded Value | uncategorized | none | none | true |
| smearing_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| smearing_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| red rim | TEXT | Uncoded Value | uncategorized | none | none | true |
| Coyo-like | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Coyo-like comment | TEXT | Uncoded Value | uncategorized | none | none | true |
| comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| Residue? | TEXT | Uncoded Value | uncategorized | none | none | true |
| Illustrated | TEXT | Uncoded Value | uncategorized | none | none | true |
| Digital Photo | TEXT | Uncoded Value | uncategorized | none | none | true |
| Photo | TEXT | Uncoded Value | uncategorized | none | none | true |
| vessel motif complexity | TEXT | Uncoded Value | uncategorized | none | none | true |
| line_width_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-motif_morphology_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band1_Band_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 1-geometric type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| band1_type_int_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Band_1_Element_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 1-line_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-fret_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-fret_scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-element_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-indeterminate type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-Life Form Type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-life_form_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype1_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype2_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype3_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype4_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-additional_type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-motif_morphology_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band2_band_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Band_2_Element_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 2-geometric type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| band2_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 2-line_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-fret_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-fret_scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-element_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-indeterminate type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-Life Form Type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-life_form_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype1_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype2_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype3_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype4_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subinfratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-additional_type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| line_width_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-motif_morphology_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band3 | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 1-geometric type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| band3_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Band_3_element_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 1-line_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-fret_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-fret_scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-element_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-indeterminate type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-Life Form Type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-life_form_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype1_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype2_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype3_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype4_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subinfratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-additional_type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-motif_morphology_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band4 | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 2-geometric type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band4_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Band_4_Element_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 2-line_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-fret_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-fret_scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-element_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-indeterminate type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-Life Form Type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-life_form_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype1_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype2_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype3_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band5 | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 3-geometric type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band5_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Band_5_Element_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 3-line_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-fret_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-fret_scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-element_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-indeterminate type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-Life Form Type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-life_form_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-subtype1_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-subtype2_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-subtype3_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-subtype4_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-subinfratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-additional_type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: RomosStudy_old
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 1-additional_type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band5 | BIGINT | Uncoded Value | uncategorized | none | none | true |
| TestID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| armillas collection | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| site | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| level | TEXT | Uncoded Value | uncategorized | none | none | true |
| locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| area | TEXT | Uncoded Value | uncategorized | none | none | true |
| count | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ware | TEXT | Uncoded Value | uncategorized | none | none | true |
| form | TEXT | Uncoded Value | uncategorized | none | none | true |
| portion | TEXT | Uncoded Value | uncategorized | none | none | true |
| firing_ interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| firing_ exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| fire_ clouding_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| fire_ clouding_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| slip_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| slip_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| surface_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| surface_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| core oxidation | TEXT | Uncoded Value | uncategorized | none | none | true |
| core color | TEXT | Uncoded Value | uncategorized | none | none | true |
| smearing_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| smearing_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| red rim | TEXT | Uncoded Value | uncategorized | none | none | true |
| Coyo-like | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Coyo-like comment | TEXT | Uncoded Value | uncategorized | none | none | true |
| comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| Residue? | TEXT | Uncoded Value | uncategorized | none | none | true |
| Illustrated | TEXT | Uncoded Value | uncategorized | none | none | true |
| Digital Photo | TEXT | Uncoded Value | uncategorized | none | none | true |
| Photo | TEXT | Uncoded Value | uncategorized | none | none | true |
| vessel motif complexity | TEXT | Uncoded Value | uncategorized | none | none | true |
| line_width_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-fret_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-motif_morphology_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band1_Band_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 1-geometric type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| band1_type_int_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 1-line_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-fret_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-fret_scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-element_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-indeterminate type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-Life Form Type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-life_form_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype1_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype2_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype3_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype4_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subinfratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-additional_type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-motif_morphology_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band2_band_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 2-geometric type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| band2_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 2-line_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-fret_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-fret_scroll_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-element_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-indeterminate type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-Life Form Type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-life_form_infratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype1_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype2_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype3_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype4_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subinfratype_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-additional_type_interior | TEXT | Uncoded Value | uncategorized | none | none | true |
| line_width_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-motif_morphology_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band3 | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 1-geometric type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| band3_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 1-line_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-fret_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-fret_scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-element_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-indeterminate type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-Life Form Type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-life_form_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype1_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype2_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype3_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subtype4_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 1-subinfratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-motif_morphology_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band4 | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 2-geometric type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band4_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 2-line_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-fret_scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-element_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-indeterminate type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-Life Form Type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-life_form_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype1_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype2_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype3_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subtype4_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-subinfratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2-additional_type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-motif_morphology_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-geometric type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band5_type_int | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 3-line_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-fret_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-fret_scroll_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-element_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-indeterminate type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-Life Form Type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-life_form_infratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-subtype1_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-subtype2_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-subtype3_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-subtype4_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-subinfratype_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| 3-additional_type_exterior | TEXT | Uncoded Value | uncategorized | none | none | true |
| Vws ULL Update | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: ShapedTools
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Date Recorded | DATETIME | Uncoded Value | uncategorized | none | none | true |
| UllId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| StoneToolId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Page | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Box Number | TEXT | Uncoded Value | uncategorized | none | none | true |
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Tool Number | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Recorder | TEXT | Uncoded Value | uncategorized | none | none | true |
| Date Collected | DATETIME | Uncoded Value | uncategorized | none | none | true |
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | TEXT | Uncoded Value | uncategorized | none | none | true |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| MaterialGroup | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| MatGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Material | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| MaterialId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Form | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| FormId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Tool type | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Handled | TEXT | Uncoded Value | uncategorized | none | none | true |
| Retouch Loc | TEXT | Uncoded Value | uncategorized | none | none | true |
| Point form | TEXT | Uncoded Value | uncategorized | none | none | true |
| Pnt base shape | TEXT | Uncoded Value | uncategorized | none | none | true |
| Pnt base type | TEXT | Uncoded Value | uncategorized | none | none | true |
| Point notch | TEXT | Uncoded Value | uncategorized | none | none | true |
| Length | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Pct len | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Width | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Pct wid | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Thickness | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Weight | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Comments 1 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Tracing | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Table Information: Shell
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| L | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| ShellId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Vic's ID | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Unit | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Level | TEXT | Uncoded Value | uncategorized | none | none | true |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Spec Art Inv? | TEXT | Uncoded Value | uncategorized | none | none | true |
| MNI | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Abs# | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Wt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| W | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Thick | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Dia | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Province | TEXT | Uncoded Value | uncategorized | none | none | true |
| Class | TEXT | Uncoded Value | uncategorized | none | none | true |
| ClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Genera | TEXT | Uncoded Value | uncategorized | none | none | true |
| GeneraId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Species | TEXT | Uncoded Value | uncategorized | none | none | true |
| SpeciesId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Type | TEXT | Uncoded Value | uncategorized | none | none | true |
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Sub-type | TEXT | Uncoded Value | uncategorized | none | none | true |
| SubTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Infra-type | TEXT | Uncoded Value | uncategorized | none | none | true |
| InfraTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Shape | TEXT | Uncoded Value | uncategorized | none | none | true |
| ShapeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Perf | TEXT | Uncoded Value | uncategorized | none | none | true |
| PerfId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Stage | TEXT | Uncoded Value | uncategorized | none | none | true |
| StageId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Infra-stage | TEXT | Uncoded Value | uncategorized | none | none | true |
| InfraStageId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Condition | TEXT | Uncoded Value | uncategorized | none | none | true |
| ConditionId | TEXT | Uncoded Value | uncategorized | none | none | true |
| Incising? | TEXT | Uncoded Value | uncategorized | none | none | true |
| Burned? | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: SoilsByULLFromPaulaByAU
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| AUId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| AUNum | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| SOIL | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: SpecArtfcts
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SpecArt_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Year | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Locale | to be deleted? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| AU | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Unit | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Level | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Locus | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULLSNum | TEXT | Uncoded Value | uncategorized | none | none | true |
| SpecArtMatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| MatCnfdnc | TEXT | Uncoded Value | uncategorized | none | none | true |
| Worked | TEXT | Uncoded Value | uncategorized | none | none | true |
| ClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ObjRepsntd | TEXT | Uncoded Value | uncategorized | none | none | true |
| DecTech | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DecTechId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ApprxPerct | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: SurveySites
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| MV_sites_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| order_id | TEXT | Uncoded Value | uncategorized | none | none | true |
| site | TEXT | Uncoded Value | uncategorized | none | none | true |
| site_name | TEXT | Uncoded Value | uncategorized | none | none | true |
| settlement_affiliation | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: tempDetail
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| AUId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| AUNum | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| FullDesc | TEXT | Uncoded Value | uncategorized | none | none | true |
| DetailName | TEXT | Uncoded Value | uncategorized | none | none | true |
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: test_macroBot
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| id | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Articulation_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ArticulationId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ArticulationType | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Band_Motif
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| typeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Banding_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| BandingId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| BandingName | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Band_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| band | TEXT | Uncoded Value | uncategorized | none | none | true |
| Band_type | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_CoreOxidation_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CoreOxidationId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| CoreOxidation | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_CoreColor_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CoreColorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| CoreColor | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Firing_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| FiringId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Firing | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_FireClouding_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| FireCloudingId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FireClouding | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Form_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| FormId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Form | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_GeometricElement_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| geometricElementsid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| geometricElement | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_GeoElementTypes_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| GeoElementTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| GeoElementType | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_LineWidth_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| LineWidthId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| LineWidth | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Linkage_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| LinkageId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| LinkageType | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Line_Infratype
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| typeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| line_infratypeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_MotifElement
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| elementId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| geoElementTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| geoElementSubTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Motif_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| motif | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Portion_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Portion | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_RedRim_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| RedRimId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| RedRim | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Repeating_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| RepeatingId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| RepeatingType | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_SubType_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| subtypeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| subtype name | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Slip_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SlipId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Slip | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Smearing_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SmearingId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Smearing | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_SubType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| typeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| subtypeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Surface_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SurfaceId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Surface | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Type_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Type_name | TEXT | Uncoded Value | uncategorized | none | none | true |
| SuperTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SuperType | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Type
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| typeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ST_2_Articulation_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ST_3_Linkage_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ST_4_Repeating_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SubInfraType_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| AdditionalType | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_VesselMotifComplexity_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| MotifComplexityId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| MotifComplexity | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_Romos_Ware_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| WareId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Ware | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Test_RomosSherds
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| RedRimId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SmearingInteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| DestId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ArmillasCollection | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | TEXT | Uncoded Value | uncategorized | none | none | true |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| SlashNo | TEXT | Uncoded Value | uncategorized | none | none | true |
| PrimId | TEXT | Uncoded Value | uncategorized | none | none | true |
| Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
| WareId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FormId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FiringInteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FiringExteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FireCloudingInteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FireCloudingExteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SlipInteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SlipExteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SurfaceInteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SurfaceExteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| CoreOxidationId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| CoreColorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SmearingExteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Coyo-Like | TEXT | Uncoded Value | uncategorized | none | none | true |
| Coyo-LikeComments | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| Residue | TEXT | Uncoded Value | uncategorized | none | none | true |
| Illustrated | TEXT | Uncoded Value | uncategorized | none | none | true |
| DigitalPhoto | TEXT | Uncoded Value | uncategorized | none | none | true |
| Photo | TEXT | Uncoded Value | uncategorized | none | none | true |
| VesselMotifComplexityId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| LineWidthInteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| LineWidthExteriorId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| BandingTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: testExposures2
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| PhotoId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Exposure | TEXT | Uncoded Value | uncategorized | none | none | true |
| Exp | TEXT | Uncoded Value | uncategorized | none | none | true |
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| placeOfDash | BIGINT | Uncoded Value | uncategorized | none | none | true |
| characRightOfDash | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: testSherdBand
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: TypeCllctn
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Level | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| TypeCllcntID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| PrimID | TEXT | Uncoded Value | uncategorized | none | none | true |
| Material Code | TEXT | Uncoded Value | uncategorized | none | none | true |
| MaterialId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Item | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Number | TEXT | Uncoded Value | uncategorized | none | none | true |
| Photo | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| PhotoId | Should be linked to the PhotoLog table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Roll | Once link has been made to photo table - this field should be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Exp | Once link has been made to photo table - this field should be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Photographer | Once link has been made to photo table - this field should be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| to be photo | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Manuscript | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Fig Number | TEXT | Uncoded Value | uncategorized | none | none | true |
| Gen desc | TEXT | Uncoded Value | uncategorized | none | none | true |
| Status | TEXT | Uncoded Value | uncategorized | none | none | true |
| IllustrationId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Illustration | Should be linked to Illustration table | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Priority | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Site | TEXT | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULLSNum | TEXT | Uncoded Value | uncategorized | none | none | true |
| AU | TEXT | Uncoded Value | uncategorized | none | none | true |
| Unit | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Locus | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Photograph | Once link has been made to photo table - this field should be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Link | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash # | TEXT | Uncoded Value | uncategorized | none | none | true |
| PHOTO EXT | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
| Other Type | TEXT | Uncoded Value | uncategorized | none | none | true |
| count | BIGINT | Uncoded Value | uncategorized | none | none | true |
| To be photo'd temp | TEXT | Uncoded Value | uncategorized | none | none | true |
| To be illustr -temp | TEXT | Uncoded Value | uncategorized | none | none | true |
| Preliminary | TEXT | Uncoded Value | uncategorized | none | none | true |
| Ill date | Once link has been made to illustration table - this field should be deleted | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Artist | TEXT | Uncoded Value | uncategorized | none | none | true |
| Final | TEXT | Uncoded Value | uncategorized | none | none | true |
| Date1 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field18 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Needs Revision | TEXT | Uncoded Value | uncategorized | none | none | true |
| Revised Preliminary | TEXT | Uncoded Value | uncategorized | none | none | true |
| Date2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field22 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Revised Final | TEXT | Uncoded Value | uncategorized | none | none | true |
| Date3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field25 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field26 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Box Number | TEXT | Uncoded Value | uncategorized | none | none | true |
| Other Prov | TEXT | Uncoded Value | uncategorized | none | none | true |
| Publication | TEXT | Uncoded Value | uncategorized | none | none | true |
| Date | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Gen_Illustration | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Gen_PHOTO EXT | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Gen_Photograph | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| pathtophoto | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: ULL_Utility_for_Unit60s
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| UtilULL | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: ULLs
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Level | Level designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULLId | Identification number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | FK to SiteId in _Sites lookup table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| AUId | FK to AUId in the AU table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ULL | Unit-Level-Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateExc | What is the beginning date that the ULL was excavated | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| SecondDate | This is here because there is a ULL that was excavated in 2 separate years | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| Datum | What datums were used for measurements of this ULL - info taken from field notes | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULLValidity | valid means that the ull can be found in the field notes - reassigned means the ULL was derived from "errors" during artifact coding or bag mislabelling | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unit | Unit designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| UnitId | FK to UnitList lookup table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Locus | Locus designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| VolumeExpected | Volumes are not expected for surface ULLs, reassigned ULLs, or mixed ULLs | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Volume | Estimated volume for the ULL (see Nawa S. for details) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| FieldNotes | link to a pdf of the field notes - the pdf file resides on the server - may need to be restablished if the link gets broken | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Comments | General comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ULLs_old
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ULLId | Identification number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | FK to SiteId in _Sites lookup table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| AUId | FK to AUId in the AU table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULLValidity | valid means that the ull can be found in the field notes - reassigned means the ULL was derived from "errors" during artifact coding | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unit | Unit designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Level | Level designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Locus | Locus designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| VolumeExpected | TEXT | Uncoded Value | uncategorized | none | none | true |
| Volume | Estimated volume for the ULL (see Nawa for details) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Comments | General comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: UnitList
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| UnitListId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Validity | TEXT | Uncoded Value | uncategorized | none | none | true |
| SortOrder | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| BeginingSize | TEXT | Uncoded Value | uncategorized | none | none | true |
| EndingSize | TEXT | Uncoded Value | uncategorized | none | none | true |
| UnitDetails | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: UnitList_old
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| UnitListId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SortOrder | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| BeginingSize | TEXT | Uncoded Value | uncategorized | none | none | true |
| EndingSize | TEXT | Uncoded Value | uncategorized | none | none | true |
| UnitDetails | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: volsbychapt
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| GroupLvl2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| SumOfSumOfVolume | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Table Information: WoodChrcl
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| WoodId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Phase | To be deleted? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Area | to be deleted? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Unit | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Level | TEXT | Uncoded Value | uncategorized | none | none | true |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Fraction | TEXT | Uncoded Value | uncategorized | none | none | true |
| Taxa | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TaxaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Weight | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Comment | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: zBandMotifType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| sherdid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| bandid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| motifid | BIGINT | Uncoded Value | uncategorized | none | none | true |
| typeid | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: zzSheet1
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| BoxId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| BagNo | TEXT | Uncoded Value | uncategorized | none | none | true |
| Rim | TEXT | Uncoded Value | uncategorized | none | none | true |
| Vessel | TEXT | Uncoded Value | uncategorized | none | none | true |
| Prim-ID | TEXT | Uncoded Value | uncategorized | none | none | true |
| tempNo | BIGINT | Uncoded Value | uncategorized | none | none | true |
| temp_bulk | TEXT | Uncoded Value | uncategorized | none | none | true |
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Year | TEXT | Uncoded Value | uncategorized | none | none | true |
| Site | TEXT | Uncoded Value | uncategorized | none | none | true |
| Unit-level-locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Material | TEXT | Uncoded Value | uncategorized | none | none | true |
| Category | TEXT | Uncoded Value | uncategorized | none | none | true |
| Bulk | TEXT | Uncoded Value | uncategorized | none | none | true |
| Count | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: zzSheet3
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| V# | TEXT | Uncoded Value | uncategorized | none | none | true |
| R# | TEXT | Uncoded Value | uncategorized | none | none | true |
| RB# | TEXT | Uncoded Value | uncategorized | none | none | true |
| BagId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Box# | TEXT | Uncoded Value | uncategorized | none | none | true |
| BoxId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Year | TEXT | Uncoded Value | uncategorized | none | none | true |
| Site | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | TEXT | Uncoded Value | uncategorized | none | none | true |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Ware | TEXT | Uncoded Value | uncategorized | none | none | true |
| Type | TEXT | Uncoded Value | uncategorized | none | none | true |
| Form | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| Count | TEXT | Uncoded Value | uncategorized | none | none | true |
| Roll | TEXT | Uncoded Value | uncategorized | none | none | true |
| Frame 1 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Frame 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Frame 3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Frame 4 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Frame 5 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Frame 6 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Frame 7 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Frame 8 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Frame 9 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Frame 10 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Frame 11 | TEXT | Uncoded Value | uncategorized | none | none | true |
Data Table Relationships:
| Type | Local Table | Foreign Table | Column Relationships |
|---|---|---|---|
| ONE_TO_MANY | Test_Romos_Form_lookup | Test_RomosSherds | FormId FormId |
| ONE_TO_MANY | _FnaElement | Fauna | ElementId ElementId |
| ONE_TO_MANY | ULLs | Dates | ULLId ULLId |
| ONE_TO_MANY | Test_Romos_VesselMotifComplexity_lookup | Test_RomosSherds | MotifComplexityId VesselMotifComplexityId |
| ONE_TO_MANY | ULLs | LPHumBone | ULLId ULLId |
| ONE_TO_MANY | _ArtCatFunctionalClasses | ArtifactCatalog | FunctClassId FunctionalClassId |
| ONE_TO_MANY | Test_Romos_Band_lookup | Test_Romos_Band_Motif | bandid bandid |
| ONE_TO_MANY | Test_Romos_Surface_lookup | Test_RomosSherds | SurfaceId SurfaceExteriorId |
| ONE_TO_MANY | _CerTypeWare | RimStudy | WareId WareId |
| ONE_TO_MANY | IE_Sherds | IE_SherdElemJunct | IESherdsIdD IESherdId |
| MANY_TO_ONE | _STType | ShapedTools | TypeId TypeId |
| ONE_TO_MANY | ULLs | Figurines_new | ULLId ULL_Id |
| ONE_TO_MANY | _CerTrtmnt | _CerType | TrtmntId TrtmntId |
| ONE_TO_MANY | _WoodTaxa | WoodChrcl | WoodtaxaId TaxaId |
| ONE_TO_MANY | _AUGroupLvl2 | AUs | GroupLvl2Id GroupLvl2Id |
| ONE_TO_MANY | _HmOstLvl2Grp | LPHumBone | Lvl2GrpId Lvl2GrpId |
| ONE_TO_MANY | _Sites | RimStudy_old | SiteId SiteId |
| ONE_TO_MANY | Test_Romos_Articulation_lookup | Test_Romos_Type | ArticulationId ST_2_Articulation_id |
| ONE_TO_MANY | _FnaFusion | Fauna | FusionId FusionId |
| ONE_TO_MANY | Photologs | Photo_ULLS | PhotoId PohotoId |
| ONE_TO_MANY | _DebCortex | Debitage | CotexId CortexId |
| ONE_TO_MANY | _IE_Elements | IE_SherdElemJunct | IE_ElementId IE_ElementId |
| ONE_TO_MANY | _AUPhase2 | AUs | Phase2Id Phase2Id |
| ONE_TO_MANY | Test_Romos_LineWidth_lookup | Test_RomosSherds | LineWidthId LineWidthInteriorId |
| ONE_TO_MANY | _CerType | ArtifactCatalog | TypeId TypeId |
| ONE_TO_MANY | _RimLipTreatment | RimStudy | lip_treat_id LipTreatmentId |
| ONE_TO_MANY | ULLs | NewFlots | ULLId ULLId |
| ONE_TO_MANY | ULLs | RimStudy_old | ULLId ULLId |
| ONE_TO_MANY | _IE_ElementType_revised | _IE_Elements_revised | ElementTypeId ElementTypeId |
| ONE_TO_MANY | ULLs | LQ_Processed_Human_Bone | ULLId ULL_ID |
| ONE_TO_MANY | _CerTypeWare | ArtifactCatalog | WareId WareId |
| ONE_TO_MANY | Test_Romos_Slip_lookup | Test_RomosSherds | SlipId SlipExteriorId |
| ONE_TO_MANY | _Sites | NewFlots | SiteId SiteId |
| ONE_TO_MANY | _ArtCatAnalyticalClasses | ArtifactCatalog | AnalyticalClassId AnalyticalClassId |
| ONE_TO_MANY | UnitList | _UnitYear | UnitListId UnitId |
| ONE_TO_MANY | _Sites | Shell | SiteId SiteId |
| ONE_TO_MANY | _AU_Phase3 | AUs | Phase3_ID Phase3Id |
| ONE_TO_MANY | Test_Romos_SubType_lookup | Test_Romos_SubType | subtypeid subtypeid |
| ONE_TO_MANY | Test_Romos_Type_lookup | Test_Romos_Band_Motif | TypeId typeid |
| ONE_TO_MANY | Test_Romos_Firing_lookup | Test_RomosSherds | FiringId FiringInteriorId |
| ONE_TO_MANY | _HmOstEleNorm | LPHumBone | ElementId ElementId |
| ONE_TO_MANY | _GrndstnCat | Grndstn | CatId TypeCatId |
| ONE_TO_MANY | _CerForm | Ceramics_old_del | FormId FormId |
| ONE_TO_MANY | ArtifactCat_BoxInventory | ArtifactCat_Bags | BoxId BoxId |
| ONE_TO_MANY | _CerTrtmnt | RimStudy | TrtmntId DecorationId |
| ONE_TO_MANY | AUs | ULLs | AUId AUId |
| ONE_TO_MANY | _CarbonSampleConcentration | CarbonSamples | ConcentrationId ConcentrationId |
| ONE_TO_MANY | _FnaHumMod | Fauna | HumModId HumModId |
| ONE_TO_MANY | _SpecArtClass | SpecArtfcts | ClassId ClassId |
| ONE_TO_MANY | Test_Romos_Motif_lookup | Test_Romos_Band_Motif | motifid motifid |
| ONE_TO_MANY | _Sites | ExcvtdUnits_del | SiteId SiteId |
| ONE_TO_MANY | Dates | CarbonSamples | DateId DateId |
| ONE_TO_MANY | _SpecArtMat | SpecArtfcts | SpecArtMatId SpecArtMatId |
| ONE_TO_MANY | ArtifactCatalog | Photo_Artifacts | CatId CatId |
| ONE_TO_MANY | _RimLipForm | RimStudy | lip_id LipFormId |
| ONE_TO_MANY | RomosStudy_new | Romos_Sherd_Band_Assoc | ID Sherd_id_fk |
| ONE_TO_MANY | ULLs | Fauna | ULLId ULLId |
| ONE_TO_MANY | _Sites | WoodChrcl | SiteId ULLId |
| ONE_TO_MANY | _CarbonSamplePriority | CarbonSamples | PriorityId PriorityId |
| ONE_TO_MANY | _AUReportArea | AUs | ReportAreaId ReportAreaId |
| ONE_TO_MANY | Test_Romos_Linkage_lookup | Test_Romos_Type | LinkageId ST_3_Linkage_id |
| ONE_TO_MANY | Test_Romos_CoreOxidation_lookup | Test_RomosSherds | CoreOxidationId CoreOxidationId |
| ONE_TO_MANY | _Sites | Debitage | SiteId SiteId |
| ONE_TO_MANY | _MbotPrtn | Macrobot | MbotPortId PortionId |
| ONE_TO_MANY | Test_Romos_Portion_lookup | Test_RomosSherds | PortionId PortionId |
| ONE_TO_MANY | _ChapterGroups | AUs | ChapterGroupId ChapterId |
| ONE_TO_MANY | Test_Romos_Banding_lookup | Test_RomosSherds | BandingId BandingTypeId |
| ONE_TO_MANY | _MbotFrctnId | Macrobot | FractionId FractionId |
| ONE_TO_MANY | _Sites | UnitList_old | SiteId SiteId |
| ONE_TO_MANY | Photologs | Photo_Artifacts | PhotoId PhotoId |
| ONE_TO_MANY | _DebTypeB | Debitage | TypeBId TypeBId |
| ONE_TO_MANY | _CerRprtGrps | _CerType | ReportGroupId ReportGroupId |
| ONE_TO_MANY | _CarbonSampleSize | CarbonSamples | SampleSizeId SampleSizeId |
| ONE_TO_MANY | _Sites | _FieldNotebooks_old | SiteId SiteId |
| ONE_TO_MANY | _ArtCatManufacturingClasses | ArtifactCatalog | ManufacturingClassId ManufacturingClassId |
| ONE_TO_MANY | ULLs | Ceramics_old_del | ULLId ULLId |
| ONE_TO_MANY | Test_Romos_Type | Test_Romos_SubType | typeid typeid bandid bandid sherdid sherdid motifid motifid |
| ONE_TO_MANY | _FnaNatMod | Fauna | NatModID NatModId |
| ONE_TO_MANY | _GndstnMat | Grndstn | MatId MatId |
| ONE_TO_MANY | _Sites | Ceramics_old_del | SiteId SiteId |
| ONE_TO_MANY | _DebStage | Debitage | StageId StageId |
| ONE_TO_MANY | _AUCultSpace | AUs | CultSpaceId CultSpaceId |
| ONE_TO_MANY | _Sites | Fauna | SiteId SiteId |
| ONE_TO_MANY | _Cer_Element_Groups | Romos_Sherd_Band_Assoc | Element_group_id cer_element_group_id_fk |
| ONE_TO_MANY | _ShellClass | Shell | ClassId ClassId |
| ONE_TO_MANY | UnitList_old | _UnitYear_old | UnitListId UnitId |
| ONE_TO_MANY | _GndstnCond | Grndstn | CondId ConId |
| ONE_TO_MANY | Test_Romos_LineWidth_lookup | Test_RomosSherds | LineWidthId LineWidthExteriorId |
| ONE_TO_MANY | ULLs | RomosStudy_new | ULLId ULL_ID_FK |
| ONE_TO_MANY | _TableGroups | AUs | TableGroupId TableGroupId |
| ONE_TO_MANY | _DebStageIdx | Debitage | StageIdxId StageIndexId |
| ONE_TO_MANY | ULLs | Photo_ULLS | ULLId ULL_Id |
| ONE_TO_MANY | Test_Romos_RedRim_lookup | Test_RomosSherds | RedRimId RedRimId |
| ONE_TO_MANY | _Sites | Grndstn | SiteId SiteId |
| ONE_TO_MANY | Test_Romos_CoreColor_lookup | Test_RomosSherds | CoreColorId CoreColorId |
| ONE_TO_MANY | Test_Romos_Ware_lookup | Test_RomosSherds | WareId WareId |
| ONE_TO_MANY | TypeCllctn | OtherArtifacts | TypeCllcntID TypeCllcntID |
| ONE_TO_MANY | _Sites | ULLs | SiteId SiteId |
| ONE_TO_MANY | _STMatGrpId | ShapedTools | MatGroupId MatGroupId |
| ONE_TO_MANY | ArtifactCat_Bags | ArtifactCatalog | BagId BagId |
| ONE_TO_MANY | Test_Romos_Slip_lookup | Test_RomosSherds | SlipId SlipInteriorId |
| ONE_TO_MANY | _Sites | SpecArtfcts | SiteId SiteId |
| ONE_TO_MANY | _GndstnWear | Grndstn | WearId WearId |
| ONE_TO_MANY | _FigType | Figurines_legacy_del | TypeId TypeId |
| ONE_TO_MANY | _AUPhase | AUs | PhaseId PhaseId |
| ONE_TO_MANY | _FigFinish | Figurines_legacy_del | FinishId FinishId |
| ONE_TO_MANY | _CerType | RimStudy | TypeId TypeId |
| ONE_TO_MANY | _GndstnMTM | Grndstn | MTMId MTMId |
| ONE_TO_ONE | Test_Romos_Band_Motif | Test_Romos_Line_Infratype | typeid typeid bandid bandid sherdid sherdid motifid motifid |
| ONE_TO_MANY | _SubGroups | _CulturalSpace | SubGroupId SubGroupId |
| ONE_TO_MANY | Test_Romos_Firing_lookup | Test_RomosSherds | FiringId FiringExteriorId |
| ONE_TO_MANY | _RimVsslShp | ArtifactCatalog | shape_id VesselShapeId |
| ONE_TO_MANY | _FnaProxDist | Fauna | ProxDistId ProxDistId |
| ONE_TO_MANY | Test_RomosSherds | Test_Romos_Band_Motif | sherdid sherdid |
| ONE_TO_MANY | _Sites | Figurines_legacy_del | SiteId SiteId |
| ONE_TO_MANY | _FigSex | Figurines_legacy_del | SexId SexId |
| ONE_TO_MANY | ULLs | ArtifactCatalog | ULLId ULLId |
| ONE_TO_MANY | _ArtifactCatTypes | ArtifactCatalog | ArtCatTypeId ArtifactCatType |
| ONE_TO_MANY | _SpecArtDec | SpecArtfcts | DecTechId DecTechId |
| ONE_TO_MANY | ArtifactCatalog | IllstArtfcts | CatId CatId |
| ONE_TO_MANY | Test_Romos_Smearing_lookup | Test_RomosSherds | SmearingId SmearingExteriorId |
| ONE_TO_MANY | _Sites | Macrobot | SiteId SiteId |
| ONE_TO_MANY | _DebMaterial | Debitage | MaterialId MatId |
| ONE_TO_MANY | ArtifactCatalog | RimStudy | CatId CatId |
| ONE_TO_MANY | _MbotTaxa | Macrobot | TaxaId MbotTaxaId |
| ONE_TO_MANY | _HmOsLvl1Grp | LPHumBone | Lvl1GrpId Lvl1GrpId |
| ONE_TO_MANY | ArtifactCatalog | ArtCatVesselAnalysis | CatId CatId |
| ONE_TO_MANY | TypeCllctn | IllstArtfcts | TypeCllcntID TypeCllctnId |
| ONE_TO_MANY | _CerPortion | Ceramics_old_del | PortionId PortionId |
| ONE_TO_MANY | Test_Romos_Surface_lookup | Test_RomosSherds | SurfaceId SurfaceInteriorId |
| ONE_TO_MANY | ULLs | Figurines_legacy_del | ULLId ULLId |
| ONE_TO_MANY | _FigPortion | Figurines_legacy_del | PortionId PortionId |
| ONE_TO_MANY | _ShellGenera | Shell | GeneraId GeneraId |
| ONE_TO_MANY | _FieldNotebooks_old | _UnitYear_old | NotebookId NotebookId |
| ONE_TO_MANY | _Cer_Elements | Romos_Sherd_Band_Assoc | Cer_element_id cer_element_id_fk |
| ONE_TO_MANY | _ChapterGroups | _SubGroups | ChapterGroupId ChapterGroupId |
| ONE_TO_MANY | _Sites | ULLs_old | SiteId SiteId |
| ONE_TO_MANY | Test_Romos_SubType_lookup | Test_Romos_Type | subtypeid SubInfraType_id |
| ONE_TO_MANY | _CarbonSampleComposition | CarbonSamples | CompositionId CompositionId |
| ONE_TO_MANY | _FnaTaxa | Fauna | TaxaId TaxaId |
| ONE_TO_MANY | Test_Romos_FireClouding_lookup | Test_RomosSherds | FireCloudingId FireCloudingInteriorId |
| ONE_TO_MANY | ULLs | Grndstn | ULLId ULLId |
| ONE_TO_MANY | _DebType | Debitage | TypeId TypeId |
| ONE_TO_MANY | _IE_Element_Fill | IE_SherdElemJunct | ElementFillId IE_ElementFillId |
| ONE_TO_MANY | _FieldNotebooks | _UnitYear | NotebookId NotebookId |
| ONE_TO_MANY | ULLs | Debitage | ULLId ULLId |
| ONE_TO_MANY | Test_Romos_FireClouding_lookup | Test_RomosSherds | FireCloudingId FireCloudingExteriorId |
| ONE_TO_MANY | _RimContourType | RimStudy | contour_id ContourTypeId |
| ONE_TO_MANY | _AUGroupLvl1 | AUs | GroupLvl1Id GroupLvl1Id |
| ONE_TO_MANY | _Sites | LPHumBone | SiteId SiteId |
| ONE_TO_MANY | ULLs | Macrobot | ULLId ULL_ID |
| ONE_TO_MANY | _CerType | Ceramics_old_del | TypeId TypeId |
| ONE_TO_MANY | _RimVsslShp | RimStudy | shape_id VesselShapeId |
| ONE_TO_MANY | ULLs | CarbonSamples | ULLId ULLId |
| ONE_TO_MANY | Test_Romos_Smearing_lookup | Test_RomosSherds | SmearingId SmearingInteriorId |
| ONE_TO_MANY | _FnaBurn | Fauna | BurnId BurnId |
Keywords
Material
Bone
•
Building Materials
•
Ceramic
•
Chipped Stone
•
Dating Sample
•
Fauna
•
Ground Stone
•
Human Remains
•
Macrobotanical
•
Mineral
•
Pollen
•
Shell
•
Wood
Site Name
El Potrerito
•
La Quemada
•
Malpaso Valley
Site Type
Ancient Church / Religious Structure
•
Ancient Communal / Public Structure
•
Archaeological Feature
•
Artifact Scatter
•
Ball Court
•
Building Substructure
•
Burial Pit
•
Causeway
•
Church / Religious Structure
•
Domestic Structure or Architectural Complex
•
Domestic Structures
•
Encampment
•
Funerary and Burial Structures or Features
•
Hamlet / Village
•
Hearth
•
House
•
House Mound
•
Midden
•
Mound / Earthwork
•
Non-Domestic Structures
•
Ossuary
•
Palace
•
Platform Mound
•
Plaza
•
Pyramid
•
Resource Extraction / Production / Transportation Structure or Features
•
Room Block / Compound / Pueblo
•
Settlements
•
Sheet Midden
•
Stairway
•
Temple
•
Terrace
•
Tomb
•
Town / City
•
Trash Midden
Show More
General
AMS Radiocarbon Dating
•
Archaeobotanical Analysis
•
Archaeomagnetic Dating
•
Bioarchaeology/Skeletal Analysis
•
Built Environment
•
Built Landscapes
•
Ceramic Figurine
•
Ceramic Petrography
•
Ceramic Production and Exchange
•
Charcoal Analysis
•
Chronological Seriation
•
Climate Change
•
Collective Action
•
Craft Production
•
Craft Specialization
•
Economic Specialization
•
Electron Microprobe Analysis
•
Ethnographic Analogy
•
Faunal Analysis
•
Figurines, West Mexico
•
Food Processing
•
Food Production
•
Groundstone & Lithic Analysis
•
Human-Environmental Interactions
•
Instrumental Neutron Activation Analysis
•
Isotope Analysis
•
Long-Distance Exchange Networks
•
Macrobotanical Analysis
•
Monumentality
•
Northern expansion of Mesoamerica
•
Obsidian Source Analysis
•
Resilience and Sustainability
•
ritual practice
•
Social Complexity
•
Social Identification
•
Social Status
Show More
Temporal Coverage
Calendar Date: -1000 to 1050
Radiocarbon Date: 1250 to ?
Spatial Coverage
min long: -102.853; min lat: 22.437 ; max long: -102.788; max lat: 22.479 ;
Individual & Institutional Roles
Contact(s): Vincent Schiavitti
File Information
| Name | Size | Creation Date | Date Uploaded | Access | |
|---|---|---|---|---|---|
| d_11_1266_malpaso_ver3_sync.mdb | 682.64mb | Oct 16, 2010 10:43:14 AM | Public |