March 2020
Intermediate to advanced
534 pages
14h 15m
English
In this section, we will create a main table, similar to the customer table. The steps are similar to the vehicle group, and we will abbreviate some of the steps we have already done. The pattern described in this recipe can be applied to any main table using your own data types.
The table in this example will be to store vehicle details. The table design will be as follows:
| Field | Type | Size | EDT (: indicates extends) |
| VehicleId | String | 20 | *ConVMSVehicleId : Num |
| VehicleGroupId | String | 10 | ConVMSVehicleGroupId |
| RegNum | String | 10 | * ConVMSRegNum |
| AcquiredDate | Date | *ConVMSAcquiredDate : TransDate |
Note that (*) means we will create the marked EDTs later in this section.
Read now
Unlock full access