Footprints Data Model

Table
Name cal_wksp
Comment The usage of a Calendar in a Workspace. The calendar can be used as the Workspace default calendar, or it can be used in SLA calculations.

Column
Name Datatype Comment Is PK Is FK
cal_wksp_id bigint The automatically generated primary key of the cal_wksp table. Yes No
is_dflt_flag bit Indicates if Is Default Flag. No No
wksp_defn_id bigint A Foreign Key to the Definition table. Identifies the Workspace that owns the Calendar. No Yes
cal_item_id bigint A Foreign Key to the Calendar Item table. This is a Workspace Calendar type of Calendar Item that owns appointments. No Yes