Table: Monitored_Event_Action | |||
Columns | |||
Name | Type | Constraints | Description |
monitored_event_action_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table |
update__staff_KEY | int | NOT NULL | |
update_date_utc | datetime | NOT NULL | |
create_date_utc | datetime | NOT NULL | |
monitored_event_KEY | int | NOT NULL | Key to parent record. |
email_staff | bit | NOT NULL | Indicates whether all staff specified by this record should be emailed when the event occurs. |
contact_email_KEY | int | Specifes non-staff email address to notify when event occurs. | |
lookup_table_name | nvarchar (128) | NOT NULL | Table that specifies entity to notify. |
field_name | nvarchar (128) | NOT NULL | Field in table_name that specifies entity to notify. |
row_KEY | int | Optional key value that specifies entity to notify. |
Primary key | |||
Name | Columns | Description | |
PK_Monitored_Event_Action$monitored_event_action_KEY | monitored_event_action_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Monitored_Event_Action$contact_email_KEY | contact_email_KEY | Index supports foreign key FK_Monitored_Event_Action__Contact_Email__contact_email_KEY | |
IX_Monitored_Event_Action$monitored_event_KEY | monitored_event_KEY | Index supports foreign key FK_Monitored_Event_Action__Monitored_Event__monitored_event_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Monitored_Event_Action__Contact_Email__contact_email_KEY | contact_email_KEY | Contact_Email | |
FK_Monitored_Event_Action__Monitored_Event__monitored_event_KEY | monitored_event_KEY | Monitored_Event |