Constraints

194 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_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
Cascade 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