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 |