Footprints Data Model

Table
Name scheduled_task
Comment A scheduled task that may include recurrence. This is all of the information needed to provide the scheduler with data to execute a task. It is used for Reports, but is intended to be generic for other scheduled tasks. This is the root object. Report specific information will go in an association table.

Column
Name Datatype Comment Is PK Is FK
schdd_task_id bigint The automatically generated primary key of the Scheduled Task table. Yes No
schdd_task_name varchar(255) The name of the Scheduled Task. No No
schdd_task_descr varchar(512) A descriptive name of the Scheduled Task. This descriptive name may be localized. No No
recur_schd_type_id integer The unique identifier for an instance of Recur Schedule Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. No Yes
begin_date datetime Begin Date. No No
recur_period_type_id integer The unique identifier for an instance of Recur Period Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. No Yes
recur_hour integer The Hours portion of a time of day No No
recur_minute integer The minutes portion of a time of day No No
recur_days_of_week varchar(255) Recur Days of Week. No No
recur_days_of_month varchar(255) Recur Days of Month. No No
create_date datetime The date that the Scheduled Task was created. No No
create_app_user_id bigint A Foreign Key to the Application User table. No Yes
schdd_task_type_id integer The unique identifier for an instance of Scheduled Task Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. No Yes