Static_change

Section: Change Tables

Metadata

Base Table Class: Change
Not in MDB
Default Size: 100000

Fields

Name	Type	Size (bytes)	Description
Id	Integer (signed)	8	The unique identifier of this Static. Not editable Read-only
Status	Set of Status	4
Timestamp	Integer (unsigned)	8	The time at which this change record was generated. This is not the same as the business-level timestamp of this Static_change.
StaticTable	One of Table	1
StaticId	Foreign key to All	8
StaticIdIndex	Foreign key to All	8	Required
StaticField	One of KVPKey	4
StaticValue	Integer (signed)	8
StaticValueForeignIndex	Foreign key to All	8
StaticTextIndex	Foreign key to StaticText_change	8
TransactionCount	Integer (unsigned)	8
UpdateNumber	Integer (unsigned)	8	A number that records every change that happens to a record. It is primarily used to avoid write after read problems when an intermediate write has changed the originally read record. Not editable
BCSequence	Integer (unsigned)	8	The sequence number of this Static_change message in the overall broadcast sequence.
Reloaded	Integer (unsigned)	1	Set to true for change records that are generated during a normal startup from engine cache files.
InstanceId	Integer (unsigned)	4
RunId	Integer (unsigned)	4
ChangedField	One of KVPKey	4
CreateUser	Foreign key to User	8	The Id of the User that created this Static. Not editable Read-only
CreateTimestamp	Integer (unsigned)	8	The time at which this Static was created. Not editable Read-only
UpdateUser	Foreign key to User	8	The Id of the User that last updated this Static. Not editable Read-only
UpdateTimestamp	Integer (unsigned)	8	The time at which this Static was last updated. Not editable Read-only