ST_WORKRECORDHISTORY

This table lists the work record history - work records for every task revision.

Column

Field

Type

Length

Primary

Description

1

ServerID

int

4

Y

Server ID

2

ID

int

4

Y

Workrecord ID

3

StWorkTaskID

int

4

N

ObjectID of Task

4

RevisionNumber

int

4

Y

Revision number of task

5

StWorkDate

datetime

8

N

Date

6

StWorkHours

float

8

N

Hours

7

StWorkRemainingHours

float

8

N

Remaining Hours

8

StWorkUserID

varchar

254

N

User Name

9

StWorkComment

Text

16

N

Comment

Table Joins

Column Primary Table Primary Field Foreign Table Foreign Field

1

ST_TASKHISTORY

ServerID

ST_WORKRECORDHISTORY

ServerID

2

ST_TASKHISTORY

ID

ST_WORKRECORDHISTORY

StWorkTaskID

3

ST_TASKHISTORY

RevisionNumber

STWORKRECORDHISTORY

RevisionNumber