| Column Name | Type | Length | Nullable | Description | Relationships | |
| Identity | ID | int identity | No | |||
| StateFIPS | numeric | Yes | ||||
| ZipCode | varchar | 255 | Yes | |||
| State | varchar | 255 | Yes | |||
| City | varchar | 255 | Yes | |||
| County | varchar | 50 | Yes | |||
| Population | numeric | Yes | ||||
| Allocation | numeric | Yes |
| Index Name | Index Description | Index Keys |
| PK__ZipCodes__300424B4 | clustered, unique, primary key located on PRIMARY | ID |