Contains the value information for an additional field of type list or tree
Data model
Fields
| Field | Type | Description |
|---|---|---|
| field_id | INT | Identifier of the associated additional field |
| id* | INT | Unique value identifier for the additional field |
| parent_id | INT | Identifier of the parent additional field, if it is of tree type |
| value | NVARCHAR (100) | Value associated with the additional field |
Primary Key
| PK_ASMS_FIELDS_VALUES |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| field_id | dbo.ASMS_FIELDS | id | FK01_ASMS_FIELDS_VALUES |
| parent_id | dbo.ASMS_FIELDS_VALUES | id | FK02_ASMS_FIELDS_VALUES |