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

Details

PackageVersionID

Type: integer. Key

The package that has been changed

PackageStateID

Type: integer. Key

The state that was set

UserName

Type: text (max 64 characters). Key

The user that made the state change

Changed

Type: datetime. Key

The date/time that the change was made

Comments

Type: text (max 256 characters)

A user defined set of comments relating to the state change