Footprints Data Model

Table
Table Name Calendar Workspace
Table Definition The association of a workspace to a calendar. The workspace definition is associated with the Calendar Item that is the root entry for a recurring schedule item in the calender service tables. The workspace can have one default work schedule, and it may have a second shift.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Calendar Workspace Id The automatically generated primary key of the cal_wksp table. LONG Yes
Is Default Flag Indicates if Is Default Flag. BOOLEAN No
Workspace Definition Id A Foreign Key to the Definition table. Identifies the Workspace that owns the Calendar. LONG Yes
Calendar Item Id A Foreign Key to the Calendar Item table. This is a Workspace Calendar type of Calendar Item that owns appointments. LONG No