StaticNew_change

Metadata

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

Fields

NameTypeSize (bytes)Description
IdInteger (signed)8The unique identifier of this StaticNew.
StatusSet of Status4
TimestampInteger (unsigned)8The time at which this change record was generated. This is not the same as the business-level timestamp of this StaticNew_change.
TableOne of Table1
PosForeign key to All8
UpdateNumberInteger (unsigned)8A 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.
BCSequenceInteger (unsigned)8The sequence number of this StaticNew_change message in the overall broadcast sequence.
ReloadedInteger (unsigned)1Set to true for change records that are generated during a normal startup from engine cache files.
InstanceIdInteger (unsigned)4
RunIdInteger (unsigned)4
ChangedFieldOne of KVPKey4
CreateUserForeign key to User8The Id of the User that created this StaticNew.
CreateTimestampInteger (unsigned)8The time at which this StaticNew was created.
UpdateUserForeign key to User8The Id of the User that last updated this StaticNew.
UpdateTimestampInteger (unsigned)8The time at which this StaticNew was last updated.