Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int | 4 | null |
|
|
|||
| TransportAMPM | varchar | 5 | null |
|
|
|||
| TransportSeq | smallint | 2 | null |
|
|
|||
| TransportCode | varchar | 15 | null |
|
|
|||
| TransportDescription | varchar | 255 | null |
|
|
|||
| TravelFactor | decimal | 11,8 | null |
|
|
|||
| TravelMondayFlag | bit | 1 | null |
|
|
|||
| TravelTuesdayFlag | bit | 1 | null |
|
|
|||
| TravelWednesdayFlag | bit | 1 | null |
|
|
|||
| TravelThursdayFlag | bit | 1 | null |
|
|
|||
| TravelFridayFlag | bit | 1 | null |
|
|
|||
| TravelSaturdayFlag | bit | 1 | null |
|
|
|||
| TravelSundayFlag | bit | 1 | null |
|
|
|||
| TravelDistance | decimal | 8,2 | null |
|
|
|||
| StopCode | varchar | 30 | null |
|
|
|||
| OverrideTravelDistanceFlag | bit | 1 | null |
|
|
|||
| AccompaniedByAdult | varchar | 1 | null |
|
|
|||
| CreatedDate | datetime | 16,3 | √ | null |
|
|
||
| CreatedByID | int | 4 | √ | null |
|
|
||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| ModifiedByID | int | 4 | √ | null |
|
|
||
| StartDate | datetime | 16,3 | √ | null |
|
|
||
| StopDate | datetime | 16,3 | √ | null |
|
|
Table contained 0 rows