Field Name

Data type

Field Length

FK Relationship

Allow Null?

Short description

(Default value if applicable)

Field

Table

ID

INTEGER

4

N

Unique identifier which identifies the organization’s shift details

SHIFTDESC

NVARCHAR

100

Y

Description of the shift

FROMTIME

DATETIME

8

Y

Starting date and time of the shift

TOTIME

DATETIME

8

Y

Ending date and time of the shift

RESOURCEHANDLER

NVARCHAR

30

Y

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

LASTUPDATEDDATETIME

DATETIME

8

Y

Last updated date of the organization shift details