Store the value information of an additional field
Data model
Fields
| Field | Type | Description |
|---|---|---|
| bool_value | BIT | Boolean-type value |
| date_value | DATETIME | Date and Time Type Value |
| field_id* | INT | Field ID |
| float_value | FLOAT | Double type value |
| id* | INT | Field value identifier |
| integer_value | BIGINT | Integer Value |
| item_id* | INT | Object Identifier |
| modification_date | DATETIME | Date of last modification |
| modified_by | INT | Identifier of the last user who modified the record |
| text_value | NVARCHAR (4000) | Chain-type value |
Primary Key
| PK_AFW_ADDITIONAL_FIELD_VAL |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| field_id* | dbo.AFW_ADDITIONAL_FIELD | id | FK01_AFW_ADDITIONAL_FIELD_VAL |