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 |