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. |
changeset_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned auto-incrementing value. |
begin_date_utc | datetime | NOT NULL | When this changeset was created. |
end_date_utc | datetime | | When this changeset was ended. This is as close to the commit time of the transaction as possible. |
user_session_pattern_guid | uniqueidentifier | | Reference to other information known about a user session. |
user_name | nvarchar (128) | | The application user name if known. |
host_name | nvarchar (128) | | The host (computer) if known. Should be as close to the user as possible. |
program_name | nvarchar (128) | | The friendly name of the application making the changes. |
windows_user_name | nvarchar (128) | | The operating system user name if known. |
resolved_end_date_utc | datetime | NOT NULL | The value to use for the ending time of this Changeset. |
row_version | timestamp | NOT NULL | |