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, reference the ASMS_FIELDS.id table |
| id* | INT | Unique value identifier for the additional field |
| parent_id | INT | Parent additional field identifier, if tree-type, references the ASMS_FIELDS_VALUES.id table |
| 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 |