Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| vt_id | int | 4 | null |
|
|
|||
| vt_insertdate | datetime | 16,3 | √ | null |
|
|
||
| vt_lastupdate | datetime | 16,3 | √ | null |
|
|
||
| vt_active | char | 1 | null |
|
|
|||
| vt_slid | int | 4 | null |
|
|
|||
| vt_branchcode | char | 3 | null |
|
|
|||
| vt_wkrid | int | 4 | null |
|
|
|||
| vt_paid | int | 4 | √ | null |
|
|
||
| vt_servicedate | datetime | 16,3 | null |
|
|
|||
| vt_vstid | int | 4 | null |
|
|
|||
| vt_starttime | datetime | 16,3 | null |
|
|
|||
| vt_endtime | datetime | 16,3 | null |
|
|
|||
| vt_details | varchar | 255 | √ | null |
|
|
||
| vt_mileagepaymethod | char | 2 | √ | null |
|
|
||
| vt_mileagestart | int | 4 | √ | null |
|
|
||
| vt_mileageend | int | 4 | √ | null |
|
|
||
| vt_tripfees | float | 8 | √ | null |
|
|
||
| vt_bcid | int | 4 | √ | null |
|
|
||
| AVA_insdate | datetime2 | 16,3 | (getdate()) |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_HCHB_VOLUNTEER_TIME | Primary key | Asc | vt_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors