Contains the value information for the item for each additional field configured
Data model
Fields
| Field | Type | Description |
|---|---|---|
| bool_value | BIT | Value of the additional field stored as boolean |
| date_value | DATETIME | Value of the additional field stored as a date |
| field_id* | INT | Identifier of the associated additional field, reference the ASMS_FIELDS.id table |
| float_value | FLOAT | Value of the additional field stored as a floating number |
| int_value | INT | Value of the additional field stored as an integer |
| item_id* | INT | Identifier of the associated item |
| item_type_id* | INT | Identifier of the type of item (Incident, Change, Problem, Requirement, Request among others), reference the table ASMS_TYPES.id |
| string_value | NVARCHAR (8000) | Value of the additional field stored as a text string |
Primary Key
| PK_ASMS_FIELDS_DATA |
|---|
| item_id, field_id, item_type_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| field_id* | dbo.ASMS_FIELDS | id | FK01_ASMS_FIELDS_DATA |
| item_type_id* | dbo.ASMS_TYPES | id | FK02_ASMS_FIELDS_DATA |