Constraints

150 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_purorderline
purorderline.poid
purchaseorder.poid
Restrict delete
fk_finassetcomponent
finassetcomponent.assetid
finasset.assetid
Restrict delete
fk_colpromise
colpromise.colid
collection.colid
Restrict delete
fk_mgusersfavorite
mgusersfavorite.mgid
mgcompany.mgid
Restrict delete
fk_mgusersfavoriteusers
mgusersfavorite.id
users.id
Restrict delete
fk_scoringattribute
scoringattribute.scoid
scoring.scoid
Restrict delete
fk_conguaranty
conguaranty.guarid
guaranty.guarid
Restrict delete
fk_paynetting
paynetting.payid
payment.payid
Restrict delete
fk_accbalance
accbalance.ctrid
contract.ctrid
Restrict delete
fk_mgbroker
mgbroker.mgid
mgcompany.mgid
Restrict delete
fk_parpricingcommission
parpricingcommission.priid
parpricing.priid
Restrict delete
fk_parofferpricing
parofferpricing.offerid
paroffer.offerid
Restrict delete
fk_mgofferpricingfiltering
mgofferpricingfiltering.offerid
paroffer.offerid
Restrict delete
fk_parassetcatalogcomponent
parassetcatalogcomponent.catalogid
parassetcatalog.catalogid
Restrict delete
fk_finassetdeprschedule
finassetdeprschedule.assetid
finasset.assetid
Restrict delete
fk_parcurrlabel
parcurrlabel.currcode
parcurrency.currcode
Restrict delete
fk_parratevalue
parratevalue.ratecode
parrate.ratecode
Restrict delete
fk_mgparlistparcode
mgparlist.parcode
parameters.parcode
Restrict delete
fk_mgparlist
mgparlist.mgid
mgcompany.mgid
Restrict delete
fk_mgofferparameters
mgofferparameters.mgid
mgcompany.mgid
Restrict delete
fk_parratelabel
parratelabel.ratecode
parrate.ratecode
Restrict delete
fk_payfiledetail
payfiledetail.pfid
payfile.pfid
Restrict delete
fk_mguserlandingusers
mguserlanding.userid
users.id
Restrict delete
fk_mguserlanding
mguserlanding.mgid
mgcompany.mgid
Restrict delete
fk_parpagcomponent
parpagcomponent.pagcode
parpage.pagcode
Restrict delete
fk_finconelemservicestep
finconelemservicestep.cteid
finconelement.cteid
Restrict delete
fk_procedure
procedure.procid
procedure.procid
Restrict delete
fk_conthirdparty
conthirdparty.ctrid
contract.ctrid
Restrict delete
fk_conelemservicestep
conelemservicestep.cteid
conelement.cteid
Restrict delete
fk_finconsyndication
finconsyndication.ctrid
fincontract.ctrid
Restrict delete
fk_mgbranch
mgbranch.mgid
mgcompany.mgid
Restrict delete
fk_colstatus
colstatus.colid
collection.colid
Restrict delete
fk_ciprefininterest
ciprefininterest.ciid
clientinvoice.ciid
Restrict delete
fk_finconelemspreading
finconelemspreading.cteid
finconelement.cteid
Restrict delete
fk_assetcomponentpaymentschedule
assetcomponentpaymentschedule.compid
assetcomponent.compid
Restrict delete
fk_colunpaid
colunpaid.colid
collection.colid
Restrict delete
fk_parrateformulalabel
parrateformulalabel.formulacode
parrateformula.formulacode
Restrict delete
fk_condecision
condecision.ctrid
contract.ctrid
Restrict delete
fk_accentries
accentries.ctrid
contract.ctrid
Restrict delete
fk_finassetmarketvalue
finassetmarketvalue.assetid
finasset.assetid
Restrict delete
fk_cilatechargedetail
cilatechargedetail.calid
cilatecharge.calid
Restrict delete
fk_guarbeneficiary
guarbeneficiary.guarid
guaranty.guarid
Restrict delete
fk_acccuttoff
acccuttoff.ctrid
fincontract.ctrid
Restrict delete
fk_tprelationship
tprelationship.tpid
thirdparty.tpid
Restrict delete
fk_parassetcatalogcriteria
parassetcatalogcriteria.catalogid
parassetcatalog.catalogid
Restrict delete
fk_accevents
accevents.ctrid
contract.ctrid
Restrict delete
fk_consyndication
consyndication.ctrid
contract.ctrid
Restrict delete
fk_clientinvoiceline
clientinvoiceline.ciid
clientinvoice.ciid
Restrict delete
cil_ciid_fkey
clientinvoiceline.ciid
clientinvoice.ciid
Restrict delete
fk_parassetcatalogservice
parassetcatalogservice.catalogid
parassetcatalog.catalogid
Restrict delete
fk_finassetservice
finassetservice.assetid
finasset.assetid
Restrict delete
fk_mgwithholdingtax
mgwithholdingtax.mgid
mgcompany.mgid
Restrict delete
fk_parrateformula
parrateformula.ratecode
parrate.ratecode
Restrict delete
fk_parcriterialabel
parcriterialabel.critid
parcriteria.critid
Restrict delete
fk_suppinvoiceschedule
suppinvoiceschedule.siid
supplierinvoice.siid
Restrict delete
sis_siid_fkey
suppinvoiceschedule.siid
supplierinvoice.siid
Restrict delete
fk_mgusersparfilteringusers
mgusersparfiltering.userid
users.id
Restrict delete
fk_mgusersparfiltering
mgusersparfiltering.mgid
mgcompany.mgid
Restrict delete
fk_suppinvoicefile
suppinvoicefile.siid
supplierinvoice.siid
Restrict delete
fk_parpagelabel
parpagelabel.pagcode
parpage.pagcode
Restrict delete
fk_parassetcatalogamount
parassetcatalogamount.entityid
parassetcatalog.catalogid
Restrict delete
fk_tpbankaccount
tpbankaccount.tpid
thirdparty.tpid
Restrict delete
fk_finconelemstep
finconelemstep.cteid
finconelement.cteid
Restrict delete
fk_assetfvcontextuse
assetfvcontextuse.contextid
assetfvcontext.contextid
Restrict delete
fk_guarvalue
guarvalue.guarid
guaranty.guarid
Restrict delete
fk_parpricingstep
parpricingstep.priid
parpricing.priid
Restrict delete
fk_tpaddress
tpaddress.tpid
thirdparty.tpid
Restrict delete
fk_mgbuserprofileusers
mgbuserprofile.userid
users.id
Restrict delete
fk_mgbuserprofile
mgbuserprofile.mgid
mgcompany.mgid
Restrict delete
fk_tpcorrespondent
tpcorrespondent.tpid
thirdparty.tpid
Restrict delete
fk_mgprovision
mgprovision.mgid
mgcompany.mgid
Restrict delete
cis_ciid_fkey
clientinvoiceschedule.ciid
clientinvoice.ciid
Restrict delete
fk_clientinvoiceschedule
clientinvoiceschedule.ciid
clientinvoice.ciid
Restrict delete
fk_parassetcatalogoption
parassetcatalogoption.catalogid
parassetcatalog.catalogid
Restrict delete
fk_finconelemschedule
finconelemschedule.cteid
finconelement.cteid
Restrict delete
fk_parservicecommission
parservicecommission.servcode
parservice.servcode
Restrict delete
fk_mgbrokervendor
mgbrokervendor.mgid
mgcompany.mgid
Restrict delete
fk_mgbusers
mgbusers.mgid
mgcompany.mgid
Restrict delete
fk_mgbusersusers
mgbusers.userid
users.id
Restrict delete
fk_parcontrollabel
parcontrolconfig.ccode
parcontrol.ccode
Restrict delete
fk_scoringattributelist
scoringattributelist.scoid
scoring.scoid
Restrict delete
fk_tprole
tprole.tpid
thirdparty.tpid
Restrict delete
fk_proctask
proctask.procid
procedure.procid
Restrict delete
fk_mgparameters
mgparameters.mgid
mgcompany.mgid
Restrict delete
fk_parlist
parlist.parcode
parameters.parcode
Restrict delete
fk_parpricingcriteria
parpricingcriteria.priid
parpricing.priid
Restrict delete
fk_tpauthorization
tpauthorization.tpid
thirdparty.tpid
Restrict delete
fk_parservicestep
parservicestep.servcode
parservice.servcode
Restrict delete
fk_accinventory
accinventory.ctrid
fincontract.ctrid
Restrict delete
fk_paroffercriteria
paroffercriteria.offerid
paroffer.offerid
Restrict delete
fk_parcurrlabel
parfunctionlabel.funcode
parfunctionlabel.funmodule
parfunction.funcode
parfunction.funmodule
Restrict delete
fk_finassetdeprcontext
finassetdeprcontext.assetid
finasset.assetid
Restrict delete
fk_menusitemlabel
menusitemlabel.itemid
menusitem.itemid
Restrict delete
fk_parpagcomponentlabel
parpagcomponentlabel.pagcode
parpage.pagcode
Restrict delete
fk_accprovisiondetail
accprovisiondetail.provid
accprovision.provid
Restrict delete
fk_parcontrollabel
parcontrollabel.ccode
parcontrol.ccode
Restrict delete
sas_sil_siid_fkeys
sas_suppinvoiceline.siid
sas_supplierinvoice.siid
Restrict delete
fk_mgpricingfiltering
mgpricingfiltering.priid
parpricing.priid
Restrict delete
fk_tpstatus
tpstatus.tpid
thirdparty.tpid
Restrict delete
fk_parassetcatalogresidualvalue
parassetcatalogresidualvalue.catalogid
parassetcatalog.catalogid
Restrict delete
sil_siid_fkey
suppinvoiceline.siid
supplierinvoice.siid
Restrict delete
fk_suppinvoiceline
suppinvoiceline.siid
supplierinvoice.siid
Restrict delete
fk_parameterslabel
parameterslabel.parcode
parameters.parcode
Restrict delete
fk_parservice
parservice.servcode
parservice.servcode
Restrict delete
fk_purchaseorder
purchaseorder.poid
purchaseorder.poid
Restrict delete
fk_parlistlabel
parlistlabel.parcode
parameters.parcode
Restrict delete
fk_ciprefininterestdetail
ciprefininterestdetail.calid
ciprefininterest.calid
Restrict delete
fk_parassetcatalogoptionconflict
parassetcatalogoptionconflict.catalogid
parassetcatalog.catalogid
Restrict delete
fk_accaudit
accaudit.aceid
accentries.aceid
Restrict delete
fk_finconelemattribute
finconelemattribute.cteid
finconelement.cteid
Restrict delete
fk_finassetirvschedule
finassetirvschedule.assetid
finasset.assetid
Restrict delete
fk_mgproduct
mgproduct.mgid
mgcompany.mgid
Restrict delete
fk_menususers
menususers.menuid
menus.menuid
Restrict delete
fk_menususersusers
menususers.userid
users.id
Restrict delete
fk_conelement
conelement.ctrid
contract.ctrid
Restrict delete
fk_parpricingpackcriteria
parpricingpackcriteria.packid
parpricingpack.packid
Restrict delete
fk_parassetcataloglabel
parassetcataloglabel.catalogid
parassetcatalog.catalogid
Restrict delete
fk_parassetcatalogpicture
parassetcatalogpicture.objectid
parassetcatalog.catalogid
Restrict delete
fk_mgofferparfiltering
mgofferparfiltering.mgid
mgcompany.mgid
Restrict delete
fk_menusroles
menusroles.menuid
menus.menuid
Restrict delete
fk_mgcurrency
mgcurrency.mgid
mgcompany.mgid
Restrict delete
fk_mgguaranty
mgguaranty.mgid
mgcompany.mgid
Restrict delete
fk_parservicecriteria
parservicecriteria.servcode
parservice.servcode
Restrict delete
fk_mgusers
mgusers.mgid
mgcompany.mgid
Restrict delete
fk_mgusersusers
mgusers.userid
users.id
Restrict delete
fk_conelemattribute
conelemattribute.cteid
conelement.cteid
Restrict delete
fk_conelemstep
conelemstep.cteid
conelement.cteid
Restrict delete
fk_parpricingcommcriteria
parpricingcommcriteria.pricommid
parpricingcommission.prcommid
Restrict delete
fk_mgproductparfiltering
mgproductparfiltering.mgid
mgcompany.mgid
Restrict delete
fk_parpagfiltering
parpagfiltering.pagcode
parpage.pagcode
Restrict delete
fk_menusitem
menusitem.menuid
menus.menuid
Restrict delete
fk_mgbankaccount
mgbankaccount.mgid
mgcompany.mgid
Restrict delete
fk_finassetconelement
finassetconelement.cteid
finconelement.cteid
Restrict delete
fk_suppinvoicefiledetail
suppinvoicefiledetail.sfid
suppinvoicefile.sfid
Restrict delete
fk_userkeywords
userkeywords.userid
users.id
Restrict delete
fk_mguserprofileusers
mguserprofile.userid
users.id
Restrict delete
fk_mguserprofile
mguserprofile.mgid
mgcompany.mgid
Restrict delete
fk_accprovision
accprovision.tpid
thirdparty.tpid
Restrict delete
fk_colmanager
colmanager.colid
collection.colid
Restrict delete
fk_parassetcatalogupgrade
parassetcatalogupgrade.catalogid
parassetcatalog.catalogid
Restrict delete
fk_mgtax
mgtax.mgid
mgcompany.mgid
Restrict delete
fk_parservcommcriteria
parservcommcriteria.servcommid
parservicecommission.servcommid
Restrict delete
fk_mgproductparameters
mgproductparameters.mgid
mgcompany.mgid
Restrict delete
fk_parbankbranch
parbankbranch.bkcode
parbank.bkcode
Restrict delete
fk_mgbrokerparfiltering
mgbrokerparfiltering.mgid
mgcompany.mgid
Restrict delete
fk_parpricingpackdetail
parpricingpackdetail.priid
parpricing.priid
Restrict delete
fk_parpricingpackdetailpack
parpricingpackdetail.packid
parpricingpack.packid
Restrict delete
fk_tpauthorizationdetail
tpauthorizationdetail.authid
tpauthorization.authid
Restrict delete
sas_sis_siid_fkeys
sas_suppinvoiceschedule.siid
sas_supplierinvoice.siid
Restrict delete
fk_mgciladditionaltax
mgciladditionaltax.mgid
mgcompany.mgid
Restrict delete

Check Constraints

Table Constraint Name Constraint