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