Relationships

Text13: SSURGO 2.3.2

Lett Table 

Physical Name Left Table Join Column Physical Name(s)

Relationship 

Orientation

Right Table 

Physical Name Right Table Join Column Physical Name(s) Relationship ID

chaashto chkey Child:Parent chorizon chkey 52

chconsistence chkey Child:Parent chorizon chkey 4074

chdesgnsuffix chkey Child:Parent chorizon chkey 57

chfrags chkey Child:Parent chorizon chkey 66

chorizon chkey Parent:Child chaashto chkey 52

chorizon chkey Parent:Child chconsistence chkey 4074

chorizon chkey Parent:Child chdesgnsuffix chkey 57

chorizon chkey Parent:Child chfrags chkey 66

chorizon chkey Parent:Child chpores chkey 64

chorizon chkey Parent:Child chstructgrp chkey 4075

chorizon chkey Parent:Child chtext chkey 116

chorizon chkey Parent:Child chtexturegrp chkey 70

chorizon chkey Parent:Child chunified chkey 71

chorizon cokey Child:Parent component cokey 6

chpores chkey Child:Parent chorizon chkey 64

chstruct chstructgrpkey Child:Parent chstructgrp chstructgrpkey 4076

chstructgrp chstructgrpkey Parent:Child chstruct chstructgrpkey 4076

chstructgrp chkey Child:Parent chorizon chkey 4075

chtext chkey Child:Parent chorizon chkey 116

chtexture chtkey Parent:Child chtexturemod chtkey 74

chtexture chtgkey Child:Parent chtexturegrp chtgkey 73

chtexturegrp chtgkey Parent:Child chtexture chtgkey 73

chtexturegrp chkey Child:Parent chorizon chkey 70

chtexturemod chtkey Child:Parent chtexture chtkey 74

chunified chkey Child:Parent chorizon chkey 71

cocanopycover cokey Child:Parent component cokey 27

cocropyld cokey Child:Parent component cokey 17

codiagfeatures cokey Child:Parent component cokey 18

2/4/2014 Page 1
Relationships

Text13: SSURGO 2.3.2

Lett Table 

Physical Name Left Table Join Column Physical Name(s)

Relationship 

Orientation

Right Table 

Physical Name Right Table Join Column Physical Name(s) Relationship ID

coecoclass cokey Child:Parent component cokey 4418

coeplants cokey Child:Parent component cokey 23

coerosionacc cokey Child:Parent component cokey 1093

coforprod cofprodkey Parent:Child coforprodo cofprodkey 1254

coforprod cokey Child:Parent component cokey 1247

coforprodo cofprodkey Child:Parent coforprod cofprodkey 1254

cogeomordesc cogeomdkey Parent:Child cosurfmorphgc cogeomdkey 1406

cogeomordesc cogeomdkey Parent:Child cosurfmorphhpp cogeomdkey 1407

cogeomordesc cogeomdkey Parent:Child cosurfmorphmr cogeomdkey 1408

cogeomordesc cogeomdkey Parent:Child cosurfmorphss cogeomdkey 1409

cogeomordesc cokey Child:Parent component cokey 1092

cohydriccriteria cokey Child:Parent component cokey 4468

cointerp cokey Child:Parent component cokey 2112

comonth comonthkey Parent:Child cosoilmoist comonthkey 182

comonth comonthkey Parent:Child cosoiltemp comonthkey 183

comonth cokey Child:Parent component cokey 184

component cokey Parent:Child chorizon cokey 6

component cokey Parent:Child cocanopycover cokey 27

component cokey Parent:Child cocropyld cokey 17

component cokey Parent:Child codiagfeatures cokey 18

component cokey Parent:Child coecoclass cokey 4418

component cokey Parent:Child coeplants cokey 23

component cokey Parent:Child coerosionacc cokey 1093

component cokey Parent:Child coforprod cokey 1247

component cokey Parent:Child cogeomordesc cokey 1092

component cokey Parent:Child cohydriccriteria cokey 4468

component cokey Parent:Child cointerp cokey 2112

component cokey Parent:Child comonth cokey 184

2/4/2014 Page 2
Relationships

Text13: SSURGO 2.3.2

Lett Table 

Physical Name Left Table Join Column Physical Name(s)

Relationship 

Orientation

Right Table 

Physical Name Right Table Join Column Physical Name(s) Relationship ID

component cokey Parent:Child copmgrp cokey 1095

component cokey Parent:Child copwindbreak cokey 41

component cokey Parent:Child corestrictions cokey 42

component cokey Parent:Child cosurffrags cokey 47

component cokey Parent:Child cotaxfmmin cokey 1094

component cokey Parent:Child cotaxmoistcl cokey 124

component cokey Parent:Child cotext cokey 115

component cokey Parent:Child cotreestomng cokey 51

component cokey Parent:Child cotxfmother cokey 50

component mukey Child:Parent mapunit mukey 4417

copm copmgrpkey Child:Parent copmgrp copmgrpkey 1096

copmgrp copmgrpkey Parent:Child copm copmgrpkey 1096

copmgrp cokey Child:Parent component cokey 1095

copwindbreak cokey Child:Parent component cokey 41

corestrictions cokey Child:Parent component cokey 42

cosoilmoist comonthkey Child:Parent comonth comonthkey 182

cosoiltemp comonthkey Child:Parent comonth comonthkey 183

cosurffrags cokey Child:Parent component cokey 47

cosurfmorphgc cogeomdkey Child:Parent cogeomordesc cogeomdkey 1406

cosurfmorphhpp cogeomdkey Child:Parent cogeomordesc cogeomdkey 1407

cosurfmorphmr cogeomdkey Child:Parent cogeomordesc cogeomdkey 1408

cosurfmorphss cogeomdkey Child:Parent cogeomordesc cogeomdkey 1409

cotaxfmmin cokey Child:Parent component cokey 1094

cotaxmoistcl cokey Child:Parent component cokey 124

cotext cokey Child:Parent component cokey 115

cotreestomng cokey Child:Parent component cokey 51

cotxfmother cokey Child:Parent component cokey 50

distinterpmd distmdkey Child:Parent distmd distmdkey 4425

2/4/2014 Page 3
Relationships

Text13: SSURGO 2.3.2

Lett Table 

Physical Name Left Table Join Column Physical Name(s)

Relationship 

Orientation

Right Table 

Physical Name Right Table Join Column Physical Name(s) Relationship ID

distlegendmd distmdkey Child:Parent distmd distmdkey 4424

distmd distmdkey Parent:Child distinterpmd distmdkey 4425

distmd distmdkey Parent:Child distlegendmd distmdkey 4424

laoverlap lareaovkey Parent:Child muaoverlap lareaovkey 4449

laoverlap lkey Child:Parent legend lkey 145

legend lkey Parent:Child laoverlap lkey 145

legend lkey Parent:Child legendtext lkey 147

legend lkey Parent:Child mapunit lkey 146

legendtext lkey Child:Parent legend lkey 147

mapunit mukey Parent:Child component mukey 4417

mapunit mukey Parent:Child muaggatt mukey 4426

mapunit mukey Parent:Child muaoverlap mukey 4450

mapunit mukey Parent:Child mucropyld mukey 4416

mapunit mukey Parent:Child mutext mukey 113

mapunit lkey Child:Parent legend lkey 146

mdstatdomdet domainname Child:Parent mdstatdommas domainname 4482

mdstatdommas domainname Parent:Child mdstatdomdet domainname 4482

mdstatdommas domainname Parent:Child mdstattabcols domainname 4483

mdstatidxdet idxphyname, tabphyname Child:Parent mdstatidxmas idxphyname, tabphyname 4485

mdstatidxmas idxphyname, tabphyname Parent:Child mdstatidxdet idxphyname, tabphyname 4485

mdstatidxmas tabphyname Child:Parent mdstattabs tabphyname 4420

mdstatrshipdet ltabphyname, relationshipname, rtabphyname Child:Parent mdstatrshipmas ltabphyname, relationshipname, rtabphyname 4484

mdstatrshipmas ltabphyname, relationshipname, rtabphyname Parent:Child mdstatrshipdet ltabphyname, relationshipname, rtabphyname 4484

mdstatrshipmas ltabphyname Child:Parent mdstattabs tabphyname 4422

mdstatrshipmas rtabphyname Child:Parent mdstattabs tabphyname 4423

mdstattabcols domainname Child:Parent mdstatdommas domainname 4483

mdstattabcols tabphyname Child:Parent mdstattabs tabphyname 4419

mdstattabs tabphyname Parent:Child mdstatidxmas tabphyname 4420

2/4/2014 Page 4
Relationships

Text13: SSURGO 2.3.2

Lett Table 

Physical Name Left Table Join Column Physical Name(s)

Relationship 

Orientation

Right Table 

Physical Name Right Table Join Column Physical Name(s) Relationship ID

mdstattabs tabphyname Parent:Child mdstatrshipmas ltabphyname 4422

mdstattabs tabphyname Parent:Child mdstatrshipmas rtabphyname 4423

mdstattabs tabphyname Parent:Child mdstattabcols tabphyname 4419

muaggatt mukey Child:Parent mapunit mukey 4426

muaoverlap lareaovkey Child:Parent laoverlap lareaovkey 4449

muaoverlap mukey Child:Parent mapunit mukey 4450

mucropyld mukey Child:Parent mapunit mukey 4416

mutext mukey Child:Parent mapunit mukey 113

sacatalog sacatalogkey Parent:Child sainterp sacatalogkey 6820

sainterp sacatalogkey Child:Parent sacatalog sacatalogkey 6820

sdvattribute attributekey Parent:Child sdvfolderattribute attributekey 6961

sdvfolder folderkey Parent:Child sdvfolderattribute folderkey 6960

sdvfolderattribute attributekey Child:Parent sdvattribute attributekey 6961

sdvfolderattribute folderkey Child:Parent sdvfolder folderkey 6960

2/4/2014 Page 5