Text13: Unique Constraints

Table Physical Name Table Label Constraint Name Columns Participating in the Unique Constraint

Text13: SSURGO 2.3.2

chaashto Horizon AASHTO PK_chaashto chaashtokey

chconsistence Horizon Consistence PK_chconsistence chconsistkey

chdesgnsuffix Horizon Designation Suffix PK_chdesgnsuffix chdesgnsfxkey

chfrags Horizon Fragments PK_chfrags chfragskey

chorizon Horizon PK_chorizon chkey

chpores Horizon Pores PK_chpores chporeskey

chstruct Horizon Structure PK_chstruct chstructkey

chstructgrp Horizon Structure Group PK_chstructgrp chstructgrpkey

chtext Horizon Text PK_chtext chtextkey

chtexture Horizon Texture PK_chtexture chtkey

chtexturegrp Horizon Texture Group PK_chtexturegrp chtgkey

chtexturemod Horizon Texture Modifier PK_chtexturemod chtexmodkey

chunified Horizon Unified PK_chunified chunifiedkey

cocanopycover Component Canopy Cover PK_cocanopycover cocanopycovkey

cocropyld Component Crop Yield PK_cocropyld cocropyldkey

codiagfeatures Component Diagnostic Features PK_codiagfeatures codiagfeatkey

coecoclass Component Ecological Classification PK_coecoclass coecoclasskey

coeplants Component Existing Plants PK_coeplants coeplantskey

coerosionacc Component Erosion Accelerated PK_coerosionacc coeroacckey

coforprod Component Forest Productivity PK_coforprod cofprodkey

coforprodo Component Forest Productivity - Other PK_coforprodo cofprodokey

cogeomordesc Component Geomorphic Description PK_cogeomordesc cogeomdkey

cohydriccriteria Component Hydric Criteria PK_cohydriccriteria cohydcritkey

cointerp Component Interpretation PK_cointerp cointerpkey

comonth Component Month PK_comonth comonthkey

component Component PK_component cokey

copm Component Parent Material PK_copm copmkey

copmgrp Component Parent Material Group PK_copmgrp copmgrpkey

copwindbreak Component Potential Windbreak PK_copwindbreak copwindbreakkey

corestrictions Component Restrictions PK_corestrictions corestrictkey

cosoilmoist Component Soil Moisture PK_cosoilmoist cosoilmoistkey

cosoiltemp Component Soil Temperature PK_cosoiltemp cosoiltempkey

cosurffrags Component Surface Fragments PK_cosurffrags cosurffragskey

cosurfmorphgc Component Three Dimensional Surface Morphometry PK_cosurfmorphgc cosurfmorgckey

cosurfmorphhpp Component Two Dimensional Surface Morphometry PK_cosurfmorphhpp cosurfmorhppkey

cosurfmorphmr Component Microrelief Surface Morphometry PK_cosurfmorphmr cosurfmormrkey

2/4/2014 Page 1
Text13: Unique Constraints

Table Physical Name Table Label Constraint Name Columns Participating in the Unique Constraint

Text13: SSURGO 2.3.2

cosurfmorphss Component Slope Shape Surface Morphometry PK_cosurfmorphss cosurfmorsskey

cotaxfmmin Component Taxonomic Family Mineralogy PK_cotaxfmmin cotaxfmminkey

cotaxmoistcl Component Taxonomic Moisture Class PK_cotaxmoistcl cotaxmckey

cotext Component Text PK_cotext cotextkey

cotreestomng Component Trees To Manage PK_cotreestomng cotreestomngkey

cotxfmother Component Taxonomic Family Other Criteria PK_cotxfmother cotaxfokey

distinterpmd Distribution Interp Metadata PK_distinterpmd distinterpmdkey

distlegendmd Distribution Legend Metadata PK_distlegendmd distlegendmdkey

distmd Distribution Metadata PK_distmd distmdkey

featdesc Feature Description PK_featdesc featkey

laoverlap Legend Area Overlap PK_laoverlap lareaovkey

legend Legend PK_legend lkey

legendtext Legend Text PK_legendtext legtextkey

mapunit Mapunit PK_mapunit mukey

muaggatt Mapunit Aggregated Attribute PK_muaggatt mukey

muaoverlap Mapunit Area Overlap PK_muaoverlap muareaovkey

mucropyld Mapunit Crop Yield PK_mucropyld mucrpyldkey

mutext Mapunit Text PK_mutext mutextkey

sacatalog Survey Area Catalog PK_sacatalog areasymbol

sainterp Survey Area Interpretation PK_sainterp sainterpkey

2/4/2014 Page 2