Table: dbo.Recorded_Event_Object_N_Client_Pay_Schedule
Table used to store references of the event object with the client pay schedule key on which the action is performed.
Columns
NameTypeConstraintsDescription
recorded_event_object_KEYint (4)NOT NULLPrimary key for the table.
client_pay_schedule_KEYint (4)NOT NULLclient pay schedule key on which the actions is performed.
Primary key
NameColumnsDescription
PK_Recorded_Event_Object_N_Client_Pay_Schedule$recorded_event_object_KEYrecorded_event_object_KEY
Unique constraints
NameColumnsDescription
UK_Recorded_Event_Object_N_Client_Pay_Schedule$client_pay_schedule_KEYclient_pay_schedule_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Recorded_Event_Object_N_Client_Pay_Schedule__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYClient_Pay_Schedule (client_pay_schedule_KEY)
FK_Recorded_Event_Object_N_Client_Pay_Schedule__Recorded_Event_Object__recorded_event_object_KEYrecorded_event_object_KEYRecorded_Event_Object (recorded_event_object_KEY)

Schema diagram