| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPTravel Planning |
| 1 | TA20ROUTE | Routes for Airfares and Discounts | 2 | ROUTING_NUMBER | Route | nvarchar | 4 | 0 | | |
| 2 | TA20ROUTING | Routes for Airfares and Discounts | 2 | ROUTING_NUMBER | Route | nvarchar | 4 | 0 | | |
| 3 | TA20RTG | Route Segments for Routings for Airfares and Discounts | 2 | ROUTING_NUMBER | Route | nvarchar | 4 | 0 | | |
| 4 | TA20RTG_G | Geographical Description of a Route Segment | 2 | ROUTING_NUMBER | Route | nvarchar | 4 | 0 | | |
| 5 | TA20RTG_P | Route Segment Provider | 2 | ROUTING_NUMBER | Route | nvarchar | 4 | 0 | | |
| 6 | TA20RTG_R | Booking Classes for Route Segment | 2 | ROUTING_NUMBER | Route | nvarchar | 4 | 0 | | |
| 7 | TA23PAF_CONN | Assignment of Airline Programs Corporate Cust. - Route/Class | 10 | ROUTING_NUMBER | Route | nvarchar | 4 | 0 | | |
| 8 | TA23ROUTE1 | Routes for Airfares and Discounts | 3 | ROUTING_NUMBER | Route | nvarchar | 4 | 0 | | |
| 9 | TA23ROUTING1 | Routes for Airfares and Discounts | 3 | ROUTING_NUMBER | Route | nvarchar | 4 | 0 | | |
| 10 | TA23RTG1 | Route Segments for Routings for Airfares and Discounts | 3 | ROUTING_NUMBER | Route | nvarchar | 4 | 0 | | |
