Developer Guide
entity_changes
| Column Name | Data Type | Nullity | Default value | Description |
|---|---|---|---|---|
id |
Integer | Non-null | A sequential numeric index of the entity change. | |
entityName |
Text | Non-null | The type of entity being changed (attributes, branches, note_reordering, etc.) |
|
entityId |
Text | Non-null | The ID of the entity being changed. | |
hash |
Text | Nullable (*) | TODO: Describe how the hash is calculated | |
isErased |
Integer (1 or 0) | Nullable (*) | TODO: What does this do? | |
changeId |
Text | Nullable (*) | TODO: What does this do? | |
componentId |
Text | Nullable (*) | The ID of the UI component that caused this change. Examples: date-note, F-PoZMI0vc, NA (catch all) |
|
instanceId |
Text | Nullable (*) | The ID of the instance that created this change. | |
isSynced |
Integer (1 or 0) | Non-null | TODO: What does this do? | |
utcDateChanged |
Text | Non-null | Date of the entity change in UTC format (e.g. 2023-11-08 16:43:44.204Z) |
Nullable (*) means all new values are non-null, old rows may contain null values.