This table stores information about the task status.
|
Field Name |
Data type |
Field Length |
FK Relationship |
Allow Null? |
Short description (Default value if applicable) |
|
|
Field |
Table |
|||||
|
ID |
INTEGER |
4 |
|
|
N |
Unique identifier |
|
TASKSTATUSTYPEID |
INTEGER |
4 |
|
|
Y |
Id that maps SWTaskStatusType |
|
TASKSTATUS |
NVARCHAR |
100 |
|
|
Y |
Name of the status for a particular task status type |
|
TASKCOMPLETIONMAKER |
NVARCHAR |
10 |
|
|
Y |
Determines whether the task is completed or not |