Description
Values for defect a columns of a record where the column has more than one value.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| 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 |  |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| COMPONENT_MULTIVALUE_IX2 | |||
| COMPONENT_MULTIVALUE_UIX1 | |
See Also