Table: Changeset
A changeset is a way to associate a set of record changes with each other and with who, when and where the changes were made. Changeset records should only be inserted or updated by calling the procedures up_Changeset_begin and up_Changeset_end. After insert, records can only be updated while they are active, and only to specify a value for end_date_utc as they are being ended/becoming inactive.
Columns
NameTypeConstraintsDescription
changeset_KEYintNOT NULLAUTO-INCREMENT: Database assigned auto-incrementing value.
begin_date_utcdatetimeNOT NULLWhen this changeset was created.
end_date_utcdatetimeWhen this changeset was ended. This is as close to the commit time of the transaction as possible.
user_session_pattern_guiduniqueidentifierReference to other information known about a user session.
user_namenvarchar (128)The application user name if known.
host_namenvarchar (128)The host (computer) if known. Should be as close to the user as possible.
program_namenvarchar (128)The friendly name of the application making the changes.
windows_user_namenvarchar (128)The operating system user name if known.
resolved_end_date_utcdatetimeNOT NULLThe value to use for the ending time of this Changeset.
row_versiontimestampNOT NULL
Primary key
NameColumnsDescription
PK_Changeset$changeset_KEYchangeset_KEYCLUSTERED
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Changeset_Active__Changeset__changeset_KEYchangeset_KEYChangeset_Active
FK_Changeset_Modified_Table__Changeset__changeset_KEYchangeset_KEYChangeset_Modified_Table

Schema diagram