Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Fips | INT | 10 | √ | null |
|
|
||
| County | VARCHAR | 50 | null |
|
|
|||
| State | VARCHAR | 50 | null |
|
|
|||
| Region | VARCHAR | 50 | √ | null |
|
|
||
| Market | VARCHAR | 59 | √ | null |
|
|
||
| MSA_ID | INT | 10 | √ | null |
|
|
||
| MSA_NAME | VARCHAR | 74 | √ | null |
|
|
||
| CBSA_ID | INT | 10 | √ | null |
|
|
||
| CBSA_NAME | VARCHAR | 75 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ix_engineer_region_county_state | Performance | Asc/Asc | County + State |
