Table: dbo.Recorded_Event_Object
Table that represents an object tracked by the recorded event system.
Columns
Name | Type | Constraints | Description
recorded_event_object_KEY | int (4) | NOT NULL | Primary key
event_class_type_KEY | int (4) | NOT NULL | A foreign key to the Event_Class that this object represents.
id | nvarchar (150) | NOT NULL | The id of the thing that the object represents
description | nvarchar (360) | NOT NULL | The description of the thing that the object represents
recorded_event_object_guid | uniqueidentifier (16) | NOT NULL | A unique identifer for each record event object row.

Primary key
Name | Columns | Description
PK_Recorded_Event_Object | recorded_event_object_KEY |
Unique constraints
Name | Columns | Description
UK_Recorded_Event_Object$recorded_event_object_guid | recorded_event_object_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Recorded_Event_Object__Event_Class_Type__event_class_type_KEY | event_class_type_KEY | Event_Class_Type (event_class_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Recorded_Event_N_Secondary_Recorded_Event_Object__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_N_Secondary_Recorded_Event_Object |
FK_Recorded_Event_N_Recorded_Event_Object__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_N_Recorded_Event_Object |
FK_Recorded_Event_Client_Recorded_Event_Object__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Client_Recorded_Event_Object |
FK_Recorded_Event_Staff_Recorded_Event_Object__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Staff_Recorded_Event_Object |
FK_Recorded_Event_Object_N_Impound_Profile__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object_N_Impound_Profile |
FK_Recorded_Event_Object_N_Client__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object_N_Client |
FK_Recorded_Event_Object_N_Bank__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object_N_Bank |
FK_Recorded_Event_Object_N_Payroll_Department__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object_N_Payroll_Department |
FK_Recorded_Event_Object_N_Balance_Definition__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object_N_Balance_Definition |
FK_Recorded_Event_Object_N_Staff__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object_N_Staff |
FK_Recorded_Event_Object_N_Client_Access_Notification__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object_N_Client_Access_Notification |
FK_Recorded_Event_Object_N_Engagement_Binder__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object_N_Engagement_Binder |
FK_Recorded_Event_Object_N_Workpaper__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object_N_Workpaper |
FK_Recorded_Event_Object_N_GL_Account__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object_N_GL_Account |
FK_Recorded_Event_Object_N_Checkbook__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object_N_Checkbook |
FK_Recorded_Event_Object_N_Client_Pay_Schedule__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object_N_Client_Pay_Schedule |
FK_Recorded_Event_Object_N_Employee__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object_N_Employee |