Table: Recorded_Event | |||
Columns | |||
Name | Type | Constraints | Description |
recorded_event_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table |
create_date_utc | datetime | NOT NULL | |
computer | nvarchar (15) | NOT NULL | Name of computer that was running Practice when the event was detected. |
client_KEY | int | Client that was affected by the event. Null if not associated with a clint. | |
event_type_KEY | int | NOT NULL | Key of event type that occurred. |
event_class_type_KEY | int | NOT NULL | Key of object type affected by the event. |
text | nvarchar (-1) | NOT NULL | Summary of what happened in a format suitable for reporting, viewing in a portlet, and so on. |
details | nvarchar (-1) | NOT NULL | XML blob that contains raw data upon which the event was based, probably the essence of the Montored_Event record as well as details about the specific occurrence. |
alert_level_KEY | int | Alert level for event. | |
is_system_event | bit | NOT NULL | Indicates whether this is a system level event and therefore not to be displayed to users. |
update__staff_KEY | int | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Recorded_Event$recorded_event_KEY | recorded_event_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Recorded_Event$alert_level_KEY | alert_level_KEY | Index supports foreign key FK_Recorded_Event__Alert_Level__alert_level_KEY | |
IX_Recorded_Event$client_KEY | client_KEY | Index supports foreign key FK_Recorded_Event__Client__client_KEY | |
IX_Recorded_Event$event_class_type_KEY | event_class_type_KEY | Index supports foreign key FK_Recorded_Event__Event_Class_Type__event_class_type_KEY | |
IX_Recorded_Event$event_type_KEY | event_type_KEY | Index supports foreign key FK_Recorded_Event__Event_Type__event_type_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Recorded_Event__Client__client_KEY | client_KEY | Client | on delete cascade; |
FK_Recorded_Event__Event_Class_Type__event_class_type_KEY | event_class_type_KEY | Event_Class_Type |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Recorded_Event_Notification__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Recorded_Event_Notification | on delete cascade; |
FK_Schedule_Item_Reminder_Recorded_Event__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Schedule_Item_Reminder_Recorded_Event | on delete cascade; |