ST_CHANGEPACKAGES

This table provides the list of change packages.

Column

Field

Type

Length

Primary

Description

1

ServerID

int

4

Y

Server ID

2

ID

int

4

Y

Object ID

3

CreatedTime

datetime

8

N

Created Time

4

CreatedUserID

varchar

254

N

Created User

5

ModifiedTime

datetime

8

N

Modified Time

6

ModifiedUserID

varchar

254

N

Modified User

7

RevisionNumber

int

4

N

Revision Number

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_CHANGEPACKAGECHANGES

ServerID

2

ST_CHANGEPACKAGES

ID

ST_CHANGEPACKAGECHANGES

1

ST_CHANGEPACKAGES

ServerID

ST_CHANGEPACKAGEHISTORY

ServerID

2

ST_CHANGEPACKAGES

ID

ST_CHANGEPACKAGEHISTORY

ID

1

ST_CHANGEPACKAGES

ServerID

ST_OBJECTACLS

ServerID

2

STCHANGEPACKAGES

ID

STOBJECTACLS

ObjectID