MDSTATTABS

(Table)

tabphyname (PK)

MDSTATTABCOLS

(Column)

tabphyname (PK)(AK1)(FK1)

colsequence (PK)

colphyname (AK1)

domainname (FK2)

MDSTATDOMMAS

(Domain Master)

domainname (PK)

MDSTATDOMDET

(Domain Detail)

domainname (PK)(AK1)(FK1)

choicesequence (PK)

choice (AK1)

MDSTATIDXMAS

(Index Master)

tabphyname (PK)(FK1)

Idxphyname (PK)

MDSTATIDXDET

(Index Detail)

tabphyname (PK)(AK1)(FK1)

Idxphyname (PK)(AK1)(FK1)

Idxcolsequence (PK)

colphyname (AK1)

MDSTATRSHIPMAS

(Relationship Master)

ltabphyname (PK)(FK1)

rtabphyname (PK)(FK2)

relationshipname (PK)

MDSTATRSHIPDET

(Relationship Detail)

ltabphyname (PK)(FK1)

rtabphyname (PK)(FK1)

relationshipname (PK)(FK1)

ltabcolphyname (PK)

rtabcolphyname (PK)

tabphyname tabphyname tabphyname : ltabphyname tabphyname : rtabphyname

domainname

tabphyname, idxphyname domainname ltabphyname, rtabphyname, relationshipname

SDVALGORITHM

(SDV Algorithm)

algorithmsequence (AK1)

algorithmname (PK)

algorithminitials (AK2)

SDVATTRIBUTE

(SDV Attribute)

attributekey (PK)

attributename (AK1)

resultcolumnname (AK2)

algorithmname (FK1)

SDVFOLDER

(SDV Folder)

folderkey (PK)

SDVFOLDERATTRIBUTE

(SDV Folder Attribute)

folderkey (PK)(FK1)

attributekey (PK)(FK2)

algorithmname folderkey

attributekey

Legend

TABLEPHYSICALNAME

(Table Logical Name)

columnphysicalname (PK)

columnphysicalname (AKn)

columnphysicalname (FKn)

Table contains static metadata 

(metadata that documents the 

SSURGO 2.2 data model itself).

TABLE A

A record in table A is related to one or 

more records in table B.

TABLE B

A record in table B is related to one 

and only one record in table A.

join column physical name

TABLE A

A record in table A is related to zero 

or more records in table B.

TABLE B

A record in table B is related to one 

and only one record in table A.

join column physical name

TABLE A

A record in table A is related to zero 

or one record in table B.

TABLE B

A record in table B is related to one 

and only one record in table A.

join column physical name

TABLEPHYSICALNAME (copy n) - this is the nth copy of 

this table in this diagram, but all copies represent the 

same table in the database

columnphysicalname (PK) - column participates in primary 

key

columnphysicalname (AKn) – column participates in 

alternate unique key n

columnphysicalname (FKn) - column participates in 

foreign key n

Only those columns that participate in primary keys, major 

alternate unique keys and foreign keys are shown.

All columns that participate in a particular primary key, 

major alternate unique key or foreign key are included in 

this diagram.

For this data model, any column name that occurs in more 

than one table represents exactly the same concept in 

each table in which it occurs.

Table contains data that drives the 

Soil Data Viewer application.

SSURGO 2.2 Data Model – Diagram 2 of 2

The primary purpose of this data model is to show how tables are related. A table in this 

model shows only a handful of the columns that exist in that table. No diagram exists that 

shows all of the columns in a table. For the complete set of columns in a table, please see 

the tabular report titled “SSURGO Metadata – Table Columns”.

Static Metadata and Soil Data Viewer Related Tables