165 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| SystemUserBase_status_fkey |
|
|
Restrict delete | ||
| new_receiptBase_currency_id_fkey |
|
|
Restrict delete | ||
| new_receiptBase_paymentmethod_id_fkey |
|
|
Restrict delete | ||
| new_receiptBase_owner_id_fkey |
|
|
Restrict delete | ||
| new_receiptBase_createdby_id_fkey |
|
|
Restrict delete | ||
| new_receiptBase_company_id_fkey |
|
|
Restrict delete | ||
| new_receiptBase_CancelledBy_fkey |
|
|
Restrict delete | ||
| process_rate_id_fkey |
|
|
Restrict delete | ||
| ContactBase_createdby_id_fkey |
|
|
Restrict delete | ||
| ContactBase_owner_id_fkey |
|
|
Restrict delete | ||
| ContactBase_paymentmethod_id_fkey |
|
|
Restrict delete | ||
| ContactBase_language_id_fkey |
|
|
Restrict delete | ||
| ContactBase_currency_id_fkey |
|
|
Restrict delete | ||
| ContactBase_language1_id_fkey |
|
|
Restrict delete | ||
| ContactBase_new_Contacttype_fkey |
|
|
Restrict delete | ||
| new_POBase_writer_id_fkey |
|
|
Restrict delete | ||
| new_POBase_statuscode_fkey |
|
|
Restrict delete | ||
| new_POBase_paymentmethod_id_fkey |
|
|
Restrict delete | ||
| new_POBase_company_id_fkey |
|
|
Restrict delete | ||
| new_POBase_paidby_id_fkey |
|
|
Restrict delete | ||
| new_POBase_CancelledBy_fkey |
|
|
Restrict delete | ||
| new_POBase_createdby_id_fkey |
|
|
Restrict delete | ||
| new_POBase_approvedby_id_fkey |
|
|
Restrict delete | ||
| new_POBase_supplier_id_fkey |
|
|
Restrict delete | ||
| new_POBase_currency_id_fkey |
|
|
Restrict delete | ||
| new_POBase_owner_id_fkey |
|
|
Restrict delete | ||
| new_paymentmethodBase_new_Company_fkey |
|
|
Restrict delete | ||
| Contacts_Roles_role_id_fkey |
|
|
Restrict delete | ||
| Contacts_Roles_contact_id_fkey |
|
|
Restrict delete | ||
| View_created_by_fkey |
|
|
Restrict delete | ||
| Users_Roles_role_id_fkey |
|
|
Restrict delete | ||
| Users_Roles_user_id_fkey |
|
|
Restrict delete | ||
| project_topic_topic_id_fkey |
|
|
Restrict delete | ||
| Posts_new_PostLinksStatus_fkey |
|
|
Restrict delete | ||
| Posts_uploadedby_id_fkey |
|
|
Restrict delete | ||
| Posts_contenttype_id_fkey |
|
|
Restrict delete | ||
| Posts_approvedby_id_fkey |
|
|
Restrict delete | ||
| Posts_new_anchortext5type_fkey |
|
|
Restrict delete | ||
| Posts_onlinechecksubmittedby_id_fkey |
|
|
Restrict delete | ||
| Posts_orderedby_id_fkey |
|
|
Restrict delete | ||
| Posts_new_CopyScapeDuplicate_fkey |
|
|
Restrict delete | ||
| Posts_new_anchortext3type_fkey |
|
|
Restrict delete | ||
| Posts_new_anchortext6type_fkey |
|
|
Restrict delete | ||
| Posts_supplier_currency_id_fkey |
|
|
Restrict delete | ||
| Posts_currency_id_fkey |
|
|
Restrict delete | ||
| Posts_supplier_id_fkey |
|
|
Restrict delete | ||
| Posts_writer_id_fkey |
|
|
Restrict delete | ||
| Posts_language_id_fkey |
|
|
Restrict delete | ||
| Posts_new_ContentOrderStatus_fkey |
|
|
Restrict delete | ||
| Posts_createdby_id_fkey |
|
|
Restrict delete | ||
| Posts_AdvertiserStatus_fkey |
|
|
Null on delete | ||
| Posts_campaign_id_fkey |
|
|
Restrict delete | ||
| Posts_requestedfrom_id_fkey |
|
|
Restrict delete | ||
| Posts_statuscode_fkey |
|
|
Restrict delete | ||
| Posts_new_PostOnlineStatus_fkey |
|
|
Restrict delete | ||
| Posts_approver_id_fkey |
|
|
Restrict delete | ||
| Posts_new_anchortext4type_fkey |
|
|
Restrict delete | ||
| Posts_new_SEODeclineReasonOptions_fkey |
|
|
Restrict delete | ||
| Posts_website_id_fkey |
|
|
Restrict delete | ||
| Posts_new_anchortext1type_fkey |
|
|
Restrict delete | ||
| Posts_uploader_id_fkey |
|
|
Restrict delete | ||
| Posts_requestedby_id_fkey |
|
|
Restrict delete | ||
| Posts_new_OutreachStatus_fkey |
|
|
Restrict delete | ||
| Posts_brand_id_fkey |
|
|
Restrict delete | ||
| Posts_new_anchortext2type_fkey |
|
|
Restrict delete | ||
| Posts_new_SEOApproval_fkey |
|
|
Restrict delete | ||
| Posts_new_PostStatus_fkey |
|
|
Restrict delete | ||
| Posts_PublisherStatus_fkey |
|
|
Null on delete | ||
| Posts_po_id_fkey |
|
|
Restrict delete | ||
| new_brandBase_company_id_fkey |
|
|
Restrict delete | ||
| new_brandBase_createdby_id_fkey |
|
|
Restrict delete | ||
| WebsitesToTopics_website_id_fkey |
|
|
Null on delete | ||
| WebsitesToTopics_topic_id_fkey |
|
|
Null on delete | ||
| Offer_currency_id_fkey |
|
|
Restrict delete | ||
| Offer_website_topic_id_fkey |
|
|
Restrict delete | ||
| Offer_supplier_id_fkey |
|
|
Restrict delete | ||
| Offer_website_id_fkey |
|
|
Restrict delete | ||
| new_affordertypeBase_priority_id_fkey |
|
|
Restrict delete | ||
| Campaign_statuscode_fkey |
|
|
Restrict delete | ||
| Campaign_approver_id_fkey |
|
|
Restrict delete | ||
| Campaign_strategy_id_fkey |
|
|
Restrict delete | ||
| Campaign_contenttype_id_fkey |
|
|
Restrict delete | ||
| Campaign_project_id_fkey |
|
|
|||
| Campaign_language_id_fkey |
|
|
Restrict delete | ||
| Campaign_new_Priority_fkey |
|
|
Restrict delete | ||
| Campaign_uploader_id_fkey |
|
|
Restrict delete | ||
| Campaign_writer_id_fkey |
|
|
Restrict delete | ||
| Campaign_createdby_id_fkey |
|
|
Restrict delete | ||
| Campaign_owner_id_fkey |
|
|
Restrict delete | ||
| new_trackerBase_order_id_fkey |
|
|
Restrict delete | ||
| new_trackerBase_currency_id_fkey |
|
|
Restrict delete | ||
| new_trackerBase_project_id_fkey |
|
|
Null on delete | ||
| new_trackerBase_brand_id_fkey |
|
|
Restrict delete | ||
| new_trackerBase_createdby_id_fkey |
|
|
Restrict delete | ||
| new_trackerBase_new_Deal_fkey |
|
|
Restrict delete | ||
| LandinPages_priority_fkey |
|
|
Restrict delete | ||
| LandinPages_project_id_fkey |
|
|
Restrict delete | ||
| LandinPages_page_id_fkey |
|
|
Restrict delete | ||
| ContentTypes_website_id_fkey |
|
|
Restrict delete | ||
| new_new_brand_new_countryBase_brand_id_fkey |
|
|
Restrict delete | ||
| new_new_brand_new_countryBase_country_id_fkey |
|
|
Restrict delete | ||
| Project_new_Importance_fkey |
|
|
Restrict delete | ||
| Project_createdby_id_fkey |
|
|
Restrict delete | ||
| Project_website_id_fkey |
|
|
Restrict delete | ||
| Project_category_id_fkey |
|
|
Restrict delete | ||
| Project_statuscode_fkey |
|
|
Restrict delete | ||
| Project_language_id_fkey |
|
|
Restrict delete | ||
| Project_owner_id_fkey |
|
|
Restrict delete | ||
| AccountBase_createdby_id_fkey |
|
|
Restrict delete | ||
| AccountBase_new_Accounttype_fkey |
|
|
Restrict delete | ||
| AccountBase_owner_id_fkey |
|
|
Restrict delete | ||
| AccountBase_country_id_fkey |
|
|
Restrict delete | ||
| InvoiceBase_StatusCode_fkey |
|
|
Restrict delete | ||
| InvoiceBase_paymentmethod_id_fkey |
|
|
Restrict delete | ||
| InvoiceBase_company_id_fkey |
|
|
Restrict delete | ||
| InvoiceBase_receipt_id_fkey |
|
|
Restrict delete | ||
| InvoiceBase_currency_id_fkey |
|
|
Restrict delete | ||
| InvoiceBase_new_PayTo_fkey |
|
|
Restrict delete | ||
| InvoiceBase_CancelledBy_fkey |
|
|
Restrict delete | ||
| InvoiceBase_createdby_id_fkey |
|
|
Restrict delete | ||
| InvoiceBase_owner_id_fkey |
|
|
Restrict delete | ||
| InvoiceBase_order_id_fkey |
|
|
Restrict delete | ||
| InvoiceBase_StateCode_fkey |
|
|
Restrict delete | ||
| Page_brand_id_fkey |
|
|
Restrict delete | ||
| Page_website_id_fkey |
|
|
Restrict delete | ||
| TrackerToTags_tracker_id_fkey |
|
|
Restrict delete | ||
| TrackerToTags_tag_id_fkey |
|
|
Restrict delete | ||
| SalesOrderBase_new_For_fkey |
|
|
Restrict delete | ||
| SalesOrderBase_PriorityCode_fkey |
|
|
Restrict delete | ||
| SalesOrderBase_owner_id_fkey |
|
|
Restrict delete | ||
| SalesOrderBase_affiliate_project_fkey |
|
|
Null on delete | ||
| SalesOrderBase_new_AffiliateDealType_fkey |
|
|
Restrict delete | ||
| SalesOrderBase_registrationemail_id_fkey |
|
|
Restrict delete | ||
| SalesOrderBase_project_id_fkey |
|
|
Null on delete | ||
| SalesOrderBase_createdby_id_fkey |
|
|
Restrict delete | ||
| SalesOrderBase_new_PayTo_fkey |
|
|
Restrict delete | ||
| SalesOrderBase_new_OrderType_fkey |
|
|
Restrict delete | ||
| SalesOrderBase_company_id_fkey |
|
|
Restrict delete | ||
| SalesOrderBase_currency_id_fkey |
|
|
Restrict delete | ||
| SalesOrderBase_paymentmethod_id_fkey |
|
|
Restrict delete | ||
| Project_Countries_project_id_fkey |
|
|
Restrict delete | ||
| Project_Countries_country_id_fkey |
|
|
Restrict delete | ||
| Website_createdby_id_fkey |
|
|
Restrict delete | ||
| Website_new_UptimeStatus_fkey |
|
|
Restrict delete | ||
| Website_language_id_fkey |
|
|
Restrict delete | ||
| Website_platform_id_fkey |
|
|
Restrict delete | ||
| Website_website_topic_id_fkey |
|
|
Restrict delete | ||
| Website_new_ContentIndicator_fkey |
|
|
Restrict delete | ||
| Website_new_dtoxrisk_fkey |
|
|
Restrict delete | ||
| Website_website_owner_id_fkey |
|
|
Restrict delete | ||
| Website_new_BlogProbability_fkey |
|
|
Restrict delete | ||
| Website_statuscode_fkey |
|
|
Restrict delete | ||
| CampaignStrategy_new_Fieldsset_fkey |
|
|
Restrict delete | ||
| CampaignStrategy_created_by_fkey |
|
|
Restrict delete | ||
| CampaignStrategy_modified_by_fkey |
|
|
Restrict delete | ||
| CampaignStrategy_new_ProjectType_fkey |
|
|
Restrict delete | ||
| InvoiceDetailBase_invoice_id_fkey |
|
|
Cascade on delete | ||
| InvoiceDetailBase_currency_id_fkey |
|
|
Restrict delete | ||
| InvoiceDetailBase_createdby_id_fkey |
|
|
Restrict delete | ||
| Report_Roles_roles_id_fkey |
|
|
Restrict delete | ||
| Report_Roles_report_id_fkey |
|
|
Restrict delete | ||
| Supplier_Tag_rel_supplierid_fkey |
|
|
Restrict delete | ||
| Supplier_Tag_rel_tag_id_fkey |
|
|
Restrict delete | ||
| PoToPosts_post_id_fkey |
|
|
Restrict delete | ||
| PoToPosts_po_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|