Table: dbo.Ste_Feature_Code_By_County | |||
Table that holds a list of feature codes contained in a county. | |||
Columns | |||
Name | Type | Constraints | Description |
ste_feature_code_by_county_KEY | int (4) | NOT NULL | Primary key. |
ste_state_code_KEY | nvarchar (4) | NOT NULL | The Symmerty state code key assoicated with this feature code. |
ste_county_code | nvarchar (6) | NOT NULL | The Symmetry county code assoicated with this feature code. |
ste_feature_code | nvarchar (60) | NOT NULL | The Symmetry feature code for this specific location. |
description | nvarchar (110) | NOT NULL | The Symmetry description of this specific feature code. |
Primary key | |||
Name | Columns | Description | |
PK_Ste_Feature_Code_By_County | ste_feature_code_by_county_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Ste_Feature_Code_By_County__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |