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