Lookup table for county and state.
| Field Name | Field Description | Data Type | Field Size* | CountyID | The primary key for table County | smallint | 2 | FipsCode | The US Fips code for the county | char | 5 | CountyName | The County name | varchar | 20 | StateID | The identifier code for the state. Cross reference to State table. | tinyint | 1 | Note | Comment | varchar | 50 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.