| Table slot9.WORLD.TSTA.VEHICLE_MODELS This table defines the valid model codes that can be added to a vehicle in the application
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| NCIC_FLAG IN ( 'Y','N') | CK_VMO_NCIC_FLAG_YN |
| "VEHICLE_MODEL_CODE" IS NOT NULL | VMO_VEHICLE_MODEL_CODE_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| VEHICLE_MODEL_CODE + VMA_VEHICLE_MAKE_CODE | Primary key | Asc/Asc | VMO_PK |
| Performance | VMO_DESC_FNCBAS_I | ||
| VMA_VEHICLE_MAKE_CODE | Performance | Asc | VMO_VMA_FK_I |
| VTC_TYPE_CODE | Performance | Asc | VMO_VTC_FK_I |
|