Table: Recorded_Event
Columns
NameTypeConstraintsDescription
recorded_event_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
create_date_utcdatetimeNOT NULL
computernvarchar (15)NOT NULLName of computer that was running Practice when the event was detected.
client_KEYintClient that was affected by the event. Null if not associated with a clint.
event_type_KEYintNOT NULLKey of event type that occurred.
event_class_type_KEYintNOT NULLKey of object type affected by the event.
textnvarchar (-1)NOT NULLSummary of what happened in a format suitable for reporting, viewing in a portlet, and so on.
detailsnvarchar (-1)NOT NULLXML 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_KEYintAlert level for event.
is_system_eventbitNOT NULLIndicates whether this is a system level event and therefore not to be displayed to users.
update__staff_KEYintNOT NULL
Primary key
NameColumnsDescription
PK_Recorded_Event$recorded_event_KEYrecorded_event_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Recorded_Event$alert_level_KEYalert_level_KEYIndex supports foreign key FK_Recorded_Event__Alert_Level__alert_level_KEY
IX_Recorded_Event$client_KEYclient_KEYIndex supports foreign key FK_Recorded_Event__Client__client_KEY
IX_Recorded_Event$event_class_type_KEYevent_class_type_KEYIndex supports foreign key FK_Recorded_Event__Event_Class_Type__event_class_type_KEY
IX_Recorded_Event$event_type_KEYevent_type_KEYIndex supports foreign key FK_Recorded_Event__Event_Type__event_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Recorded_Event__Client__client_KEYclient_KEYClienton delete cascade;
FK_Recorded_Event__Event_Class_Type__event_class_type_KEYevent_class_type_KEYEvent_Class_Type
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Recorded_Event_Notification__Recorded_Event__recorded_event_KEYrecorded_event_KEYRecorded_Event_Notificationon delete cascade;
FK_Schedule_Item_Reminder_Recorded_Event__Recorded_Event__recorded_event_KEYrecorded_event_KEYSchedule_Item_Reminder_Recorded_Eventon delete cascade;

Schema diagram