ST_CHANGEPACKAGEHISTORY

This table lists the change package history - one record for every revision.

Column

Field

Type

Length

Primary

Description

1

ServerID

int

4

Y

Server ID

2

ID

int

4

Y

Object ID

3

RevisionNumber

int

4

Y

Revision Number

4

CreatedTime

datetime

8

N

Created Time

5

CreatedUserID

varchar

254

N

Created User

6

ModifiedTime

datetime

8

N

Modified Time

7

ModifiedUserID

varchar

254

N

Modified User

8

RevisionFlags

int

4

N

Revision Flags

9

StComment

text

16

N

Comment

10

Name

varchar

762

N

Name

11

Description

text

16

N

Description

12

SessionType

varchar

254

N

Type of Session

13

Responsibility

varchar

254

N

Responsible User

14

SourceViewID

int

4

N

View of Source

15

TargetViewID

int

4

N

View of Target

16

State

varchar

254

N

State of Change Package

17

CommitTime

datetime

8

N

Commit Time for Change Package

18

CommitUserID

varchar

254

N

Commit user

19

TransactionID

int

4

N

Transaction ID

20

CommittedInBuild

varchar

254

N

Committed Build

21

PreCommitViewLabel

varchar

254

N

Pre commit view label

22

PreCommitRevisionLabel

varchar

254

N

Pre commit revision label

23

PostCommitViewLabel

varchar

254

N

Post commit view label

24

PostCommitRevisionLabel

varchar

254

N

Post commit revision label

25

AttachmentCount

int

4

N

Attachment Count

26

AttachmentNames

text

16

N

Attachment Names

Table Joins

Column Primary Table Primary Field Foreign Table Foreign Field

1

ST_CHANGEPACKAGES

ServerID

ST_CHANGEPACKAGEHISTORY

ServerID

2

ST_CHANGEPACKAGES

ID

ST_CHANGEPACKAGEHISTORY

ID

1

ST_CHANGEPACKAGEHIST

ServerID

ST_VIEWMEMBER

ServerID

2

ST_CHANGEPACKAGEHISTORY ID ST_VIEWMEMBER ID
3 ST_CHANGEPACKAGEHIST

RevisionNumber

ST_VIEWMEMBER RevisionNumber