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