Represents a historical record of a particular business unit
Data model
Fields
| Field |
Type |
Description |
| action_id* |
INT |
History type identifier, (1 = creation, 2 = edit, 5 = file added, 6 = file deleted, 9 = note, 14 = reopened, 15 = closed, 20 = baseline, 21 = related article addition, 21 = article deletion, 23 = restored baseline, 24 = converted) |
| author_id* |
INT |
Identifier of the user who created the record, reference the table AFW_USERS.user_id |
| created* |
DATETIME |
Record creation date |
| description |
NVARCHAR (MAX) |
Description of the historical change in html or Json format that represents the values before and after modification of the properties of an item |
| description_nohtml |
NVARCHAR (MAX) |
Description of the historical record without html elements |
| id* |
INT |
Unique identifier of the record |
| item_id* |
INT |
Related Business Unit Item Identifier |
| item_rev |
INT |
Item revision number |
| item_type_id* |
INT |
Related item type, reference table ASMS_TYPES.id |
| visible* |
BIT |
Indicates whether the record is visible, (0 = not visible, 1 = visible) |
Primary Key
References
| Column |
Referenced Table |
Referenced column |
Name |
| item_type_id* |
dbo.ASMS_TYPES |
id |
FK01_ASMS_HISTORY |
