Field Name

Data type

Field Length

FK Relationship

Allow Null?

Short description

(Default value if applicable)

Field

Table

ID

INTEGER

4

TASKSTATUSTYPEID

SWTASKASSIGNMENTSTATUSTYPE, SWTASKSTATUS

N

Unique identifier

TASKSTATUSTYPE

NVARCHAR

200

Y

Name of the task

RESOURCEHANDLER

NVARCHAR

100

Y

Name of the resource handler which is used for querying and extracting the resource’s properties

LASTUPDATEDDATETIME

DATETIME

8

Y

Last updated date and time