Footprints Data Model

Table
Name scheduled_task_notification
Comment The collection of notification recipients for the Scheduled Task. Having true references here will make it easier to maintain changes to user's information such as LDAP lookup, name changes, and user deletion or replacement use cases.

Column
Name Datatype Comment Is PK Is FK
schdd_task_notifn_id bigint The automatically generated primary key of the Scheduled Task Notification table. Yes No
schdd_task_id bigint A Foreign Key to the Scheduled Task table. No Yes
app_user_id bigint A Foreign Key to the Application User table. No Yes
team_id bigint A Foreign Key to the Team table. No Yes
cntc_defn_id bigint A Foreign Key to the Definition table. No Yes
cntc_item_id bigint A Foreign Key to the Item table. No Yes
email_addr varchar(255) An email address for the Scheduled Task Notification. No No
all_cntcs_flag numeric(1) A boolean flag for xxx No No
cntc_email varchar(255) An email address for the Scheduled Task Notification. No No