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
NameTypeConstraintsDescription
recorded_event_n_secondary_recorded_event_object_KEYint (4)NOT NULLPrimary key.
recorded_event_KEYint (4)NOT NULLEvent that occurred.
recorded_event_object_KEYint (4)NOT NULLThe related event object.
Primary key
NameColumnsDescription
PK_Recorded_Event_N_Secondary_Recorded_Event_Objectrecorded_event_n_secondary_recorded_event_object_KEY
Unique constraints
NameColumnsDescription
UK_Recorded_Event_N_Secondary_Recorded_Event_Object$recorded_event_KEY$recorded_event_object_KEYrecorded_event_KEY, recorded_event_object_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Recorded_Event_N_Secondary_Recorded_Event_Object__Recorded_Event__recorded_event_KEYrecorded_event_KEYRecorded_Event (recorded_event_KEY)
FK_Recorded_Event_N_Secondary_Recorded_Event_Object__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object (recorded_event_object_KEY)

Schema diagram