Table: dbo.Recorded_Event
Columns
NameTypeConstraintsDescription
create_datedatetime (8, 3)NOT NULLThe date and time this row was created. The time value is UTC.
computernvarchar (30)NOT NULLName of computer that was running Practice when the event was detected.
event_type_KEYint (4)NOT NULLKey of event type that occurred.
event_class_type_KEYint (4)NOT NULLKey of object type affected by the event.
detailsnvarchar (-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_KEYint (4)Alert level for event.
is_system_eventbit (1)NOT NULLIndicates whether this is a system level event and therefore not to be displayed to users.
update__staff_KEYint (4)NOT NULLKey of staff member who was logged into Practice when the event was detected.
textnvarcharSummary of what happened in a format suitable for reporting, viewing in a portlet, and so on.
recorded_event_KEYint (4)NOT NULL
Primary key
NameColumnsDescription
PK_Recorded_Eventrecorded_event_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Recorded_Event__Alert_Level__alert_level_KEYalert_level_KEYAlert_Level (alert_level_KEY)
FK_Recorded_Event__Event_Class_Type__event_class_type_KEYevent_class_type_KEYEvent_Class_Type (event_class_type_KEY)
FK_Recorded_Event__Event_Type__event_type_KEYevent_type_KEYEvent_Type (event_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Recorded_Event_Searchable_Attribute__Recorded_Event__recorded_event_KEYrecorded_event_KEYRecorded_Event_Searchable_Attribute
FK_Recorded_Event_N_Secondary_Recorded_Event_Object__Recorded_Event__recorded_event_KEYrecorded_event_KEYRecorded_Event_N_Secondary_Recorded_Event_Object
FK_Recorded_Event_N_Recorded_Event_Object__Recorded_Event__recorded_event_KEYrecorded_event_KEYRecorded_Event_N_Recorded_Event_Object
FK_Recorded_Event_Client_Recorded_Event_Object__Recorded_Event__recorded_event_KEYrecorded_event_KEYRecorded_Event_Client_Recorded_Event_Object
FK_Recorded_Event_Staff_Recorded_Event_Object__Recorded_Event__recorded_event_KEYrecorded_event_KEYRecorded_Event_Staff_Recorded_Event_Object
FK_Connect_Alert__Recorded_Event__recorded_event_KEYrecorded_event_KEYConnect_Alert
FK_Recorded_Event_Notification__Recorded_Event__recorded_event_KEYrecorded_event_KEYRecorded_Event_Notification

Schema diagram