In my project there is a BR written when operational status on cmdb_ci (in particular I am looking for server table record) record changes to retired , the cmdb_rel_ci records for that CI (be parent or child) are deleted. This in turn is deleting the svc_ci_assoc and svc_model_assoc_ci table data for the server which basically stores service mapping relations.
1)Can anyone help me understand HOW and which are the tables triggered for cascade delete on cmdb_rel_ci record deletion .
2) which record gets deleted first svc_ci_assoc or svc_model_assoc_ci?
