Values for defect a columns of a record where the column has more than one value.
Column Name | Description | Datatype | Length | Allow Nulls | Default | |
---|---|---|---|---|---|---|
COMV_COMPONENT_ID | The COMPONENT.CO_ID | int | 4 | |||
COMV_COLUMN_NAME | The multi-value column. | varchar | 40 | |||
COMV_VALUE | A single value.
Note: The values are denormalized for performance reasons. Any program that alters the values in this value field must also handle the semicolon-separated value in the main entity table. | varchar | 255 | ![]() |