PackageVersionInState Table

This table contains a history of changes made to the state of a package. Note that the username is recorded as a nvarchar rather than a foreign key to the user table so that if a user is deleted, there is still a record of the changes that were made.

Table 1. Database columns for PackageVersionInState table

Database Column



Type: integer. Key

The package that has been changed


Type: integer. Key

The state that was set


Type: text (max 64 characters). Key

The user that made the state change


Type: datetime. Key

The date/time that the change was made


Type: text (max 256 characters)

A user defined set of comments relating to the state change