Footprints Data Model

Table
Table Name Scheduled Task Notification
Table Definition 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.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Scheduled Task Notification Id The automatically generated primary key of the Scheduled Task Notification table. LONG Yes
Scheduled Task Id A Foreign Key to the Scheduled Task table. LONG Yes
Application User Id A Foreign Key to the Application User table. LONG No
Team Id A Foreign Key to the Team table. LONG No
Contact Definition Id A Foreign Key to the Definition table. LONG No
Contact Item Id A Foreign Key to the Item table. LONG No
All_Contacts_Flag A boolean flag for xxx INTEGER No
Email Address An email address for the Scheduled Task Notification. VARCHAR(255) No
Contact Email An email address for the Scheduled Task Notification. VARCHAR(255) No