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
Name | Type | Constraints | Description
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 |

Primary key
Name | Columns | Description
PK_Changeset$changeset_KEY | changeset_KEY | CLUSTERED

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Changeset_Active__Changeset__changeset_KEY | changeset_KEY | Changeset_Active |
FK_Changeset_Modified_Table__Changeset__changeset_KEY | changeset_KEY | Changeset_Modified_Table |