Table: dbo.Ste_County | |||
Columns | |||
Name | Type | Constraints | Description |
ste_county_KEY | int (4) | NOT NULL | Primary key. |
ste_state_code_KEY | nvarchar (4) | NOT NULL | Foreign key link to Ste_State_Code record having state name and postal code. |
county | nvarchar (50) | NOT NULL | County name. The Symmetry calculation engine is the source of the county names. |
ste_county_code | nvarchar (6) | NOT NULL | STE County code. The Symmetry calculation engine is the source of the county code. |
ste_location_code | nvarchar (70) | NOT NULL | Contains the complete ste location code associated with given county code. |
Primary key | |||
Name | Columns | Description | |
PK_Ste_County | ste_county_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Ste_County$ste_location_code | ste_location_code | ||
UK_Ste_County$ste_state_code_KEY$county | ste_state_code_KEY, county | ||
UK_Ste_County$ste_state_code_KEY$ste_county_code | ste_state_code_KEY, ste_county_code |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Ste_County__Ste_Location_Code__ste_location_code | ste_location_code | Ste_Location_Code (ste_location_code) | |
FK_Ste_County__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |