| 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 (70) | 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) | |