| Column Name | Type | Length | Nullable | Description | Relationships | |
| Identity | ID | int identity | No | |||
| Zone | varchar | 6 | Yes | |||
| ZoneName | varchar | 25 | Yes | |||
| Zipcode | varchar | 5 | Yes | |||
| City | varchar | 25 | Yes | |||
| UserReference1 | varchar | 25 | Yes | |||
| UserReference2 | varchar | 25 | Yes | |||
| UserReference3 | varchar | 25 | Yes | |||
| Ycoordinate | numeric | Yes | ||||
| Xcoordinate | numeric | Yes | ||||
| PeakTravelMinutes | numeric | Yes | ||||
| NonPeakTravelMinutes | numeric | Yes | ||||
| Area | varchar | 4 | Yes | |||
| Zones | numeric | Yes | ||||
| Match | numeric | Yes | ||||
| Usewin | numeric | Yes | ||||
| ppminut | numeric | Yes | ||||
| pmminut | numeric | Yes | ||||
| dmminut | numeric | Yes | ||||
| dpminut | numeric | Yes | ||||
| Timestamp | datetime | Yes |
| Index Name | Index Description | Index Keys |
| PK_Zones | clustered, unique, primary key located on PRIMARY | ID |
| U_Zone | nonclustered, unique located on PRIMARY | Zone |