Constraints

195 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_contacts_creator
contacts.creator
users.ID
Null on delete
fk_contacts_assigneduser
contacts.assigneduser
users.ID
Null on delete
fk_contacts_ownergroup
contacts.ownergroup
groups.ID
Cascade on delete
fk_contacts_owneruser
contacts.owneruser
users.ID
Cascade on delete
fk_appointments_owneruser
appointments.owneruser
users.ID
Cascade on delete
fk_appointments_assigneduser
appointments.assigneduser
users.ID
Null on delete
fk_appointments_creator
appointments.creator
users.ID
Null on delete
fk_appointments_ownergroup
appointments.ownergroup
groups.ID
Cascade on delete
fk_mailservers_creator
mailservers.creator
users.ID
Null on delete
fk_mailservers_ownergroup
mailservers.ownergroup
groups.ID
Cascade on delete
fk_mailservers_owneruser
mailservers.owneruser
users.ID
Cascade on delete
fk_mailservers_recipientuser
mailservers.recipientuser
users.ID
Null on delete
fk_mailservers_recipientgroup
mailservers.recipientgroup
groups.ID
Null on delete
fk_permissions_group
permissions.group
groups.ID
Cascade on delete
fk_permissions_creator
permissions.creator
users.ID
Null on delete
fk_events_creator
events.creator
users.ID
Null on delete
fk_events_ownergroup
events.ownergroup
groups.ID
Cascade on delete
fk_events_owneruser
events.owneruser
users.ID
Cascade on delete
fk_contracts_creator
contracts.creator
users.ID
Null on delete
fk_contracts_ownergroup
contracts.ownergroup
groups.ID
Cascade on delete
fk_contracts_account
contracts.account
accounts.ID
Null on delete
fk_contracts_assigneduser
contracts.assigneduser
users.ID
Null on delete
fk_groups_leader
groups.leader
users.ID
Null on delete
fk_groups_creator
groups.creator
users.ID
Null on delete
fk_services_application
services.application
applications.ID
Cascade on delete
fk_services_creator
services.creator
users.ID
Null on delete
fk_pricelists_ownergroup
pricelists.ownergroup
groups.ID
Cascade on delete
fk_pricelists_creator
pricelists.creator
users.ID
Null on delete
fk_items_model
items.model
items.ID
Null on delete
fk_items_creator
items.creator
users.ID
Null on delete
fk_items_ownergroup
items.ownergroup
groups.ID
Cascade on delete
fk_opportunities_creator
opportunities.creator
users.ID
Null on delete
fk_opportunities_contact
opportunities.contact
contacts.ID
Null on delete
fk_opportunities_assigneduser
opportunities.assigneduser
users.ID
Null on delete
fk_opportunities_account
opportunities.account
accounts.ID
Null on delete
fk_opportunities_campaign
opportunities.campaign
campaigns.ID
Null on delete
fk_opportunities_ownergroup
opportunities.ownergroup
groups.ID
Cascade on delete
fk_messagereads_message
messagereads.message
messages.ID
Cascade on delete
fk_messagereads_creator
messagereads.creator
users.ID
Cascade on delete
fk_coupons_creator
coupons.creator
users.ID
Null on delete
fk_coupons_ownergroup
coupons.ownergroup
groups.ID
Cascade on delete
fk_imapids_message
imapids.message
messages.ID
Null on delete
fk_imapids_mailserver
imapids.mailserver
mailservers.ID
Cascade on delete
fk_payments_ownergroup
payments.ownergroup
groups.ID
Cascade on delete
fk_payments_account
payments.account
accounts.ID
Null on delete
fk_payments_transaction
payments.transaction
transactions.ID
Null on delete
fk_payments_assigneduser
payments.assigneduser
users.ID
Null on delete
fk_payments_creator
payments.creator
users.ID
Null on delete
fk_payments_ledger
payments.ledger
ledgers.ID
Null on delete
fk_feedids_feedserver
feedids.feedserver
feedservers.ID
Cascade on delete
fk_feedids_record
feedids.record
records.ID
Null on delete
fk_accounts_contact
accounts.contact
contacts.ID
Null on delete
fk_accounts_ownergroup
accounts.ownergroup
groups.ID
Cascade on delete
fk_accounts_creator
accounts.creator
users.ID
Null on delete
fk_accounts_assigneduser
accounts.assigneduser
users.ID
Null on delete
fk_storages_creator
storages.creator
users.ID
Null on delete
fk_storages_ownergroup
storages.ownergroup
groups.ID
Cascade on delete
fk_components_component
components.component
items.ID
Cascade on delete
fk_components_creator
components.creator
users.ID
Null on delete
fk_components_item
components.item
items.ID
Cascade on delete
fk_files_creator
files.creator
users.ID
Null on delete
fk_files_comment
files.comment
comments.ID
Cascade on delete
fk_files_record
files.record
records.ID
Cascade on delete
fk_objects_owneruser
objects.owneruser
users.ID
Cascade on delete
fk_objects_ownergroup
objects.ownergroup
groups.ID
Cascade on delete
fk_objects_assigneduser
objects.assigneduser
users.ID
Null on delete
fk_objects_creator
objects.creator
users.ID
Null on delete
fk_categories_owneruser
categories.owneruser
users.ID
Cascade on delete
fk_categories_ownergroup
categories.ownergroup
groups.ID
Cascade on delete
fk_categories_creator
categories.creator
users.ID
Null on delete
fk_pricelists2accounts_pricelist
pricelists2accounts.pricelist
pricelists.ID
Cascade on delete
fk_pricelists2accounts_creator
pricelists2accounts.creator
users.ID
Null on delete
fk_pricelists2accounts_account
pricelists2accounts.account
accounts.ID
Cascade on delete
fk_weblets_creator
weblets.creator
users.ID
Null on delete
fk_weblets_application
weblets.application
applications.ID
Cascade on delete
fk_dunning_account
dunning.account
accounts.ID
Null on delete
fk_dunning_creator
dunning.creator
users.ID
Null on delete
fk_dunning_assigneduser
dunning.assigneduser
users.ID
Null on delete
fk_dunning_ownergroup
dunning.ownergroup
groups.ID
Cascade on delete
fk_couponcodes_creator
couponcodes.creator
users.ID
Null on delete
fk_couponcodes_coupon
couponcodes.coupon
coupons.ID
Cascade on delete
fk_couponcodes_transaction
couponcodes.transaction
transactions.ID
Null on delete
fk_feedservers_creator
feedservers.creator
users.ID
Null on delete
fk_feedservers_owneruser
feedservers.owneruser
users.ID
Cascade on delete
fk_feedservers_recipientuser
feedservers.recipientuser
users.ID
Null on delete
fk_feedservers_recipientgroup
feedservers.recipientgroup
groups.ID
Null on delete
fk_feedservers_ownergroup
feedservers.ownergroup
groups.ID
Cascade on delete
fk_tickets_project
tickets.project
projects.ID
Null on delete
fk_tickets_account
tickets.account
accounts.ID
Null on delete
fk_tickets_ownergroup
tickets.ownergroup
groups.ID
Cascade on delete
fk_tickets_assigneduser
tickets.assigneduser
users.ID
Null on delete
fk_tickets_creator
tickets.creator
users.ID
Null on delete
fk_addresses_creator
addresses.creator
users.ID
Null on delete
fk_addresses_contact
addresses.contact
contacts.ID
Cascade on delete
fk_addresses_account
addresses.account
accounts.ID
Cascade on delete
fk_davids_task
davids.task
tasks.ID
Null on delete
fk_davids_contact
davids.contact
contacts.ID
Null on delete
fk_davids_davserver
davids.davserver
davservers.ID
Cascade on delete
fk_davids_appointment
davids.appointment
appointments.ID
Null on delete
fk_suppliers_item
suppliers.item
items.ID
Cascade on delete
fk_suppliers_creator
suppliers.creator
users.ID
Null on delete
fk_suppliers_account
suppliers.account
accounts.ID
Cascade on delete
fk_users_contact
users.contact
contacts.ID
Null on delete
fk_users_creator
users.creator
users.ID
Null on delete
fk_mailinglists_campaign
mailinglists.campaign
campaigns.ID
Null on delete
fk_mailinglists_assigneduser
mailinglists.assigneduser
users.ID
Null on delete
fk_mailinglists_ownergroup
mailinglists.ownergroup
groups.ID
Cascade on delete
fk_mailinglists_creator
mailinglists.creator
users.ID
Null on delete
fk_mailinglists_owneruser
mailinglists.owneruser
users.ID
Cascade on delete
fk_participants_mailinglist
participants.mailinglist
mailinglists.ID
Cascade on delete
fk_participants_contact
participants.contact
contacts.ID
Null on delete
fk_participants_creator
participants.creator
users.ID
Null on delete
fk_participants_campaign
participants.campaign
campaigns.ID
Cascade on delete
fk_davservers_owneruser
davservers.owneruser
users.ID
Cascade on delete
fk_davservers_creator
davservers.creator
users.ID
Null on delete
fk_davservers_recipientgroup
davservers.recipientgroup
groups.ID
Null on delete
fk_davservers_recipientuser
davservers.recipientuser
users.ID
Null on delete
fk_davservers_ownergroup
davservers.ownergroup
groups.ID
Cascade on delete
fk_actionsteps_creator
actionsteps.creator
users.ID
Null on delete
fk_actionsteps_assigneduser
actionsteps.assigneduser
users.ID
Null on delete
fk_actionsteps_ownergroup
actionsteps.ownergroup
groups.ID
Cascade on delete
fk_actionsteps_ticket
actionsteps.ticket
tickets.ID
Null on delete
fk_actionsteps_owneruser
actionsteps.owneruser
users.ID
Cascade on delete
fk_actionsteps_transaction
actionsteps.transaction
transactions.ID
Null on delete
fk_actionsteps_account
actionsteps.account
accounts.ID
Null on delete
fk_actionsteps_task
actionsteps.task
tasks.ID
Null on delete
fk_links_assigneduser
links.assigneduser
users.ID
Null on delete
fk_links_owneruser
links.owneruser
users.ID
Cascade on delete
fk_links_ownergroup
links.ownergroup
groups.ID
Cascade on delete
fk_links_creator
links.creator
users.ID
Null on delete
fk_comments_record
comments.record
records.ID
Cascade on delete
fk_comments_creator
comments.creator
users.ID
Null on delete
fk_campaigns_ownergroup
campaigns.ownergroup
groups.ID
Cascade on delete
fk_campaigns_assigneduser
campaigns.assigneduser
users.ID
Null on delete
fk_campaigns_creator
campaigns.creator
users.ID
Null on delete
fk_likes_record
likes.record
records.ID
Cascade on delete
fk_likes_creator
likes.creator
users.ID
Cascade on delete
fk_transactions_account
transactions.account
accounts.ID
Null on delete
fk_transactions_assigneduser
transactions.assigneduser
users.ID
Null on delete
fk_transactions_ownergroup
transactions.ownergroup
groups.ID
Cascade on delete
fk_transactions_creator
transactions.creator
users.ID
Null on delete
fk_transactions_contract
transactions.contract
contracts.ID
Null on delete
fk_transactions_item
transactions.item
items.ID
Cascade on delete
fk_tasks_ownergroup
tasks.ownergroup
groups.ID
Cascade on delete
fk_tasks_creator
tasks.creator
users.ID
Null on delete
fk_tasks_assigneduser
tasks.assigneduser
users.ID
Null on delete
fk_tasks_project
tasks.project
projects.ID
Null on delete
fk_tasks_owneruser
tasks.owneruser
users.ID
Cascade on delete
fk_tasks_ticket
tasks.ticket
tickets.ID
Null on delete
fk_notes_ownergroup
notes.ownergroup
groups.ID
Cascade on delete
fk_notes_assigneduser
notes.assigneduser
users.ID
Null on delete
fk_notes_creator
notes.creator
users.ID
Null on delete
fk_notes_owneruser
notes.owneruser
users.ID
Cascade on delete
fk_messages_reference
messages.reference
messages.ID
Null on delete
fk_messages_opportunity
messages.opportunity
opportunities.ID
Null on delete
fk_messages_creator
messages.creator
users.ID
Null on delete
fk_messages_ownergroup
messages.ownergroup
groups.ID
Cascade on delete
fk_messages_ticket
messages.ticket
tickets.ID
Null on delete
fk_messages_mailinglist
messages.mailinglist
mailinglists.ID
Null on delete
fk_messages_owneruser
messages.owneruser
users.ID
Cascade on delete
fk_messages_mailserver
messages.mailserver
mailservers.ID
Null on delete
fk_follows_creator
follows.creator
users.ID
Cascade on delete
fk_applications_creator
applications.creator
users.ID
Null on delete
fk_invitations_appointment
invitations.appointment
appointments.ID
Cascade on delete
fk_invitations_contact
invitations.contact
contacts.ID
Null on delete
fk_invitations_creator
invitations.creator
users.ID
Null on delete
fk_groups2users_group
groups2users.group
groups.ID
Cascade on delete
fk_groups2users_creator
groups2users.creator
users.ID
Null on delete
fk_groups2users_user
groups2users.user
users.ID
Cascade on delete
fk_resources_application
resources.application
applications.ID
Cascade on delete
fk_resources_creator
resources.creator
users.ID
Null on delete
fk_prices_pricelist
prices.pricelist
pricelists.ID
Cascade on delete
fk_prices_creator
prices.creator
users.ID
Null on delete
fk_prices_item
prices.item
items.ID
Cascade on delete
fk_projects_assigneduser
projects.assigneduser
users.ID
Null on delete
fk_projects_ownergroup
projects.ownergroup
groups.ID
Cascade on delete
fk_projects_creator
projects.creator
users.ID
Null on delete
fk_projects_owneruser
projects.owneruser
users.ID
Cascade on delete
fk_stocktransactions_item
stocktransactions.item
items.ID
Cascade on delete
fk_stocktransactions_transfer
stocktransactions.transfer
stocktransactions.ID
Null on delete
fk_stocktransactions_transaction
stocktransactions.transaction
transactions.ID
Null on delete
fk_stocktransactions_storage
stocktransactions.storage
storages.ID
Null on delete
fk_stocktransactions_creator
stocktransactions.creator
users.ID
Null on delete
fk_records_creator
records.creator
users.ID
Null on delete
fk_records_assigneduser
records.assigneduser
users.ID
Cascade on delete
fk_records_ownergroup
records.ownergroup
groups.ID
Cascade on delete
fk_records_owneruser
records.owneruser
users.ID
Cascade on delete
fk_contacts2contacts_contact1
contacts2contacts.contact1
contacts.ID
Cascade on delete
fk_contacts2contacts_contact2
contacts2contacts.contact2
contacts.ID
Cascade on delete
fk_contacts2contacts_creator
contacts2contacts.creator
users.ID
Null on delete
fk_ledgers_creator
ledgers.creator
users.ID
Null on delete
fk_ledgers_ownergroup
ledgers.ownergroup
groups.ID
Cascade on delete
fk_dunning2transactions_transaction
dunning2transactions.transaction
transactions.ID
Cascade on delete
fk_dunning2transactions_dunning
dunning2transactions.dunning
dunning.ID
Cascade on delete
fk_dunning2transactions_creator
dunning2transactions.creator
users.ID
Null on delete

Check Constraints

Table Constraint Name Constraint
None detected