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;