Table: dbo.Recorded_Event_Object
Table that represents an object tracked by the recorded event system.
Columns
NameTypeConstraintsDescription
recorded_event_object_KEYint (4)NOT NULLPrimary key
event_class_type_KEYint (4)NOT NULLA foreign key to the Event_Class that this object represents.
idnvarchar (150)NOT NULLThe id of the thing that the object represents
descriptionnvarchar (360)NOT NULLThe description of the thing that the object represents
recorded_event_object_guiduniqueidentifier (16)NOT NULLA unique identifer for each record event object row.
Primary key
NameColumnsDescription
PK_Recorded_Event_Objectrecorded_event_object_KEY
Unique constraints
NameColumnsDescription
UK_Recorded_Event_Object$recorded_event_object_guidrecorded_event_object_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Recorded_Event_Object__Event_Class_Type__event_class_type_KEYevent_class_type_KEYEvent_Class_Type (event_class_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Recorded_Event_N_Secondary_Recorded_Event_Object__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_N_Secondary_Recorded_Event_Object
FK_Recorded_Event_N_Recorded_Event_Object__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_N_Recorded_Event_Object
FK_Recorded_Event_Client_Recorded_Event_Object__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Client_Recorded_Event_Object
FK_Recorded_Event_Staff_Recorded_Event_Object__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Staff_Recorded_Event_Object
FK_Recorded_Event_Object_N_Impound_Profile__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object_N_Impound_Profile
FK_Recorded_Event_Object_N_Client__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object_N_Client
FK_Recorded_Event_Object_N_Bank__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object_N_Bank
FK_Recorded_Event_Object_N_Payroll_Department__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object_N_Payroll_Department
FK_Recorded_Event_Object_N_Balance_Definition__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object_N_Balance_Definition
FK_Recorded_Event_Object_N_Staff__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object_N_Staff
FK_Recorded_Event_Object_N_Client_Access_Notification__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object_N_Client_Access_Notification
FK_Recorded_Event_Object_N_Engagement_Binder__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object_N_Engagement_Binder
FK_Recorded_Event_Object_N_Workpaper__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object_N_Workpaper
FK_Recorded_Event_Object_N_GL_Account__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object_N_GL_Account
FK_Recorded_Event_Object_N_Checkbook__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object_N_Checkbook
FK_Recorded_Event_Object_N_Client_Pay_Schedule__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object_N_Client_Pay_Schedule
FK_Recorded_Event_Object_N_Employee__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object_N_Employee

Schema diagram