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 |