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.
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 |