ST_WORKRECORDS

This table lists work records for every task.

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

StWorkDate

datetime

8

N

Date

5

StWorkHours

float

8

N

Hours

6

StWorkRemainingHours

float

8

N

Remaining Hours

7

StWorkUserID

varchar

254

N

User Name

8

StWorkComment

Text

16

N

Comment

Table Joins

Column Primary Table Primary Field Foreign Table Foreign Field

1

ST_TASKS

ServerID

ST_WORKRECORDS

ServerID

2

ST_TASKS

ID

ST_WORKRECORDS

StWorkTaskID