Cinchy contains system columns used to perform various functionality. These columns cannot be modified directly by a user. You cannot create a column with the same name.
Cinchy Id is a unique identifier assigned automatically to all records within a normal table. The Cinchy Id is associated with the record permanently and is never reassigned even if the record is deleted.
Version and Draft Version are used to track changes and versions.
Any changes made to a record increments the Version. Draft Version is always 0.
Any data approval increments Version and resets Draft Version to 0. Any proposed changes increments the Draft Version.
Legacy column - always blank.
Created By is a linked column to the [Cinchy].[Users] table, of the user who created the record.
Created is the time when the record was created.
Created By and Created will be the same for all records with the same Cinchy Id.
Created By and Created is based on the first user to make changes on an approved record. So the user where Draft Version = 1.
Modified By is a linked column to the [Cinchy].[Users] table, of the user who last modified the record.
The last user to modify the record, and when it happened.
The last user to either modify the record (Draft Version != 0) or approve the record (Draft Version = 0). The timestamp for when that version was generated.
If a record is deleted, it will show up in the Recycle Bin.
A deleted record will have Deleted By and Deleted filled in.
Deleted By and Deleted are based on the user/time when the Delete Request was created, not when it was approved.
There is always only one latest/up to date record at a time. Anytime changes are made to a record, a new version (normal or draft) is created, and the previous version is updated with a Replaced timestamp.
Any record where Replaced is empty is the current version of that record.