| Column Name | Type | Length | Nullable | Description | Relationships | |
| Identity | ID | int identity | No | |||
| Tripcode | varchar | 3 | Yes | |||
| Description | varchar | 25 | Yes | |||
| DisplayTC | bit | Yes | ||||
| MileageTC | bit | Yes | ||||
| Rate0 | money | Yes | ||||
| Miles | numeric | Yes | ||||
| Longhaul | varchar | 1 | Yes | |||
| Fare | money | Yes | ||||
| Zone | varchar | 6 | Yes | |||
| Timestamp | datetime | Yes |
| Index Name | Index Description | Index Keys |
| PK_Tripcodes | clustered, unique, primary key located on PRIMARY | ID |
| U_Tripcode | nonclustered, unique located on PRIMARY | Tripcode |