Table: dbo.Recorded_Event
Columns
Name | Type | Constraints | Description
create_date | datetime (8, 3) | NOT NULL | The date and time this row was created. The time value is UTC.
computer | nvarchar (30) | NOT NULL | Name of computer that was running Practice when the event was detected.
event_type_KEY | int (4) | NOT NULL | Key of event type that occurred.
event_class_type_KEY | int (4) | NOT NULL | Key of object type affected by the event.
details | nvarchar (-1) |  | 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 (4) |  | Alert level for event.
is_system_event | bit (1) | NOT NULL | Indicates whether this is a system level event and therefore not to be displayed to users.
update__staff_KEY | int (4) | NOT NULL | Key of staff member who was logged into Practice when the event was detected.
text | nvarchar |  | Summary of what happened in a format suitable for reporting, viewing in a portlet, and so on.
recorded_event_KEY | int (4) | NOT NULL |

Primary key
Name | Columns | Description
PK_Recorded_Event | recorded_event_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Recorded_Event__Alert_Level__alert_level_KEY | alert_level_KEY | Alert_Level (alert_level_KEY) |
FK_Recorded_Event__Event_Class_Type__event_class_type_KEY | event_class_type_KEY | Event_Class_Type (event_class_type_KEY) |
FK_Recorded_Event__Event_Type__event_type_KEY | event_type_KEY | Event_Type (event_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Recorded_Event_Searchable_Attribute__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Recorded_Event_Searchable_Attribute |
FK_Recorded_Event_N_Secondary_Recorded_Event_Object__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Recorded_Event_N_Secondary_Recorded_Event_Object |
FK_Recorded_Event_N_Recorded_Event_Object__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Recorded_Event_N_Recorded_Event_Object |
FK_Recorded_Event_Client_Recorded_Event_Object__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Recorded_Event_Client_Recorded_Event_Object |
FK_Recorded_Event_Staff_Recorded_Event_Object__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Recorded_Event_Staff_Recorded_Event_Object |
FK_Connect_Alert__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Connect_Alert |
FK_Recorded_Event_Notification__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Recorded_Event_Notification |