Footprints Data Model

Table
Name schd
Comment
A personal or workspace calendar in Footprints.  It is used to define work
hours and settings for appointment scheduling and metric reporting. This table
is duplicate re-persisted data whose master copy exists in the Calendar Service
tables, Only the attributes that are required by reporting and other services
that access the database and cannot make a call to Java should be replicated
here.

Column
Name Datatype Comment Is PK Is FK
schd_id bigint The automatically generated primary key of the schd table. Yes No
schd_name varchar(255) The name of the Schedule. No No
use_local_time bit
Indicates that the workschedule is base on local time for the time zone region.
 If you want UTC time, use that as the region.
No No
max_date_val datetime
The time spans are forecast out into the future as CalendarActualPeriod.  This
is the maximum date for which those periods are generated.
No No
time_zone_region_name varchar(255)
The name of the Time Zone Region for the calendar, which derives from or
overrides the value used for the system or workspace.
No Yes
cal_type_id int A Foreign Key to the Calendar Type table. No Yes
app_user_id bigint A Foreign Key to the Application User table. No Yes