Table: dbo.Ste_Feature_Code_By_County
Table that holds a list of feature codes contained in a county.
Columns
NameTypeConstraintsDescription
ste_feature_code_by_county_KEYint (4)NOT NULLPrimary key.
ste_state_code_KEYnvarchar (4)NOT NULLThe Symmerty state code key assoicated with this feature code.
ste_county_codenvarchar (6)NOT NULLThe Symmetry county code assoicated with this feature code.
ste_feature_codenvarchar (60)NOT NULLThe Symmetry feature code for this specific location.
descriptionnvarchar (110)NOT NULLThe Symmetry description of this specific feature code.
Primary key
NameColumnsDescription
PK_Ste_Feature_Code_By_Countyste_feature_code_by_county_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Ste_Feature_Code_By_County__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)

Schema diagram