Table: dbo.Recorded_Event_N_Secondary_Recorded_Event_Object
Links objects to an event that are not the primary event object (meaning the one the event happened to), but were otherwise involved - like employees in a batch of payroll checks.
Columns
Name | Type | Constraints | Description
recorded_event_n_secondary_recorded_event_object_KEY | int (4) | NOT NULL | Primary key.
recorded_event_KEY | int (4) | NOT NULL | Event that occurred.
recorded_event_object_KEY | int (4) | NOT NULL | The related event object.

Primary key
Name | Columns | Description
PK_Recorded_Event_N_Secondary_Recorded_Event_Object | recorded_event_n_secondary_recorded_event_object_KEY |
Unique constraints
Name | Columns | Description
UK_Recorded_Event_N_Secondary_Recorded_Event_Object$recorded_event_KEY$recorded_event_object_KEY | recorded_event_KEY, recorded_event_object_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Recorded_Event_N_Secondary_Recorded_Event_Object__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Recorded_Event (recorded_event_KEY) |
FK_Recorded_Event_N_Secondary_Recorded_Event_Object__Recorded_Event_Object__recorded_event_object_KEY | recorded_event_object_KEY | Recorded_Event_Object (recorded_event_object_KEY) |