Constraints

34 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
channelrepository_channel_fkey
channelrepository.mgm_id
channelrepository.channel_id
channel.mgm_id
channel.channel_id
Restrict delete
channelrepository_repository_fkey
channelrepository.mgm_id
channelrepository.repository_id
repository.mgm_id
repository.repository_id
Restrict delete
systemoutdated_system_fkey
systemoutdated.mgm_id
systemoutdated.system_id
system.mgm_id
system.system_id
Restrict delete
systemerrata_errata_fkey
systemerrata.mgm_id
systemerrata.errata_id
errata.mgm_id
errata.errata_id
Restrict delete
systemerrata_system_fkey
systemerrata.mgm_id
systemerrata.system_id
system.mgm_id
system.system_id
Restrict delete
systemhistory_system_fkey
systemhistory.mgm_id
systemhistory.system_id
system.mgm_id
system.system_id
Restrict delete
channelerrata_channel_fkey
channelerrata.mgm_id
channelerrata.channel_id
channel.mgm_id
channel.channel_id
Restrict delete
channelerrata_errata_fkey
channelerrata.mgm_id
channelerrata.errata_id
errata.mgm_id
errata.errata_id
Restrict delete
systemchannel_system_fkey
systemchannel.mgm_id
systemchannel.system_id
system.mgm_id
system.system_id
Restrict delete
systemchannel_channel_fkey
systemchannel.mgm_id
systemchannel.channel_id
channel.mgm_id
channel.channel_id
Restrict delete
systemnetinterface_system_fkey
systemnetinterface.mgm_id
systemnetinterface.system_id
system.mgm_id
system.system_id
Restrict delete
systempackageinstalled_system_fkey
systempackageinstalled.mgm_id
systempackageinstalled.system_id
system.mgm_id
system.system_id
Restrict delete
xccdscanresult_scan_fkey
xccdscanresult.mgm_id
xccdscanresult.scan_id
xccdscan.mgm_id
xccdscan.scan_id
Restrict delete
xccdscanresult_system_fkey
xccdscanresult.mgm_id
xccdscanresult.system_id
system.mgm_id
system.system_id
Restrict delete
cocoattestation_system_action_fkey
cocoattestation.mgm_id
cocoattestation.system_id
cocoattestation.action_id
systemaction.mgm_id
systemaction.system_id
systemaction.action_id
Restrict delete
systemcustominfo
systemcustominfo.mgm_id
systemcustominfo.system_id
system.mgm_id
system.system_id
Restrict delete
cocoattestationresult_report_fkey
cocoattestationresult.mgm_id
cocoattestationresult.report_id
cocoattestation.mgm_id
cocoattestation.report_id
Restrict delete
channelpackage_channel_fkey
channelpackage.mgm_id
channelpackage.channel_id
channel.mgm_id
channel.channel_id
Restrict delete
channelpackage_package_fkey
channelpackage.mgm_id
channelpackage.package_id
package.mgm_id
package.package_id
Restrict delete
systemgrouppermission_group_fkey
systemgrouppermission.mgm_id
systemgrouppermission.system_group_id
systemgroup.mgm_id
systemgroup.system_group_id
Restrict delete
systemgrouppermission_user_fkey
systemgrouppermission.mgm_id
systemgrouppermission.account_id
account.mgm_id
account.account_id
Restrict delete
xccdscan_system_action_fkey
xccdscan.mgm_id
xccdscan.system_id
xccdscan.action_id
systemaction.mgm_id
systemaction.system_id
systemaction.action_id
Restrict delete
systemnetaddressv6_interface_fkey
systemnetaddressv6.mgm_id
systemnetaddressv6.system_id
systemnetaddressv6.interface_id
systemnetinterface.mgm_id
systemnetinterface.system_id
systemnetinterface.interface_id
Restrict delete
accountgroup_account_fkey
accountgroup.mgm_id
accountgroup.account_id
account.mgm_id
account.account_id
Restrict delete
systemnetaddressv4_interface_fkey
systemnetaddressv4.mgm_id
systemnetaddressv4.system_id
systemnetaddressv4.interface_id
systemnetinterface.mgm_id
systemnetinterface.system_id
systemnetinterface.interface_id
Restrict delete
systementitlement_system_fkey
systementitlement.mgm_id
systementitlement.system_id
system.mgm_id
system.system_id
Restrict delete
systemaction_system_fkey
systemaction.mgm_id
systemaction.system_id
system.mgm_id
system.system_id
Restrict delete
systemvirtualdata_virtual_system_fkey
systemvirtualdata.mgm_id
systemvirtualdata.virtual_system_id
system.mgm_id
system.system_id
Restrict delete
systemvirtualdata_host_system_fkey
systemvirtualdata.mgm_id
systemvirtualdata.host_system_id
system.mgm_id
system.system_id
Restrict delete
systemgroupmember_group_fkey
systemgroupmember.mgm_id
systemgroupmember.system_group_id
systemgroup.mgm_id
systemgroup.system_group_id
Restrict delete
systemgroupmember_system_fkey
systemgroupmember.mgm_id
systemgroupmember.system_id
system.mgm_id
system.system_id
Restrict delete
systemconfigchannel_system_fkey
systemconfigchannel.mgm_id
systemconfigchannel.system_id
system.mgm_id
system.system_id
Restrict delete
systempackageupdate_system_fkey
systempackageupdate.mgm_id
systempackageupdate.system_id
system.mgm_id
system.system_id
Restrict delete
systempackageupdate_package_fkey
systempackageupdate.mgm_id
systempackageupdate.package_id
package.mgm_id
package.package_id
Restrict delete

Check Constraints

Table Constraint Name Constraint
system vn_system_address1 (((address1)::text <> ''::text))
system vn_system_address2 (((address2)::text <> ''::text))
system vn_system_architecture (((architecture)::text <> ''::text))
system vn_system_building (((building)::text <> ''::text))
system vn_system_city (((city)::text <> ''::text))
system vn_system_country (((country)::text <> ''::text))
system vn_system_hostname (((hostname)::text <> ''::text))
system vn_system_kernel_version (((kernel_version)::text <> ''::text))
system vn_system_machine (((machine)::text <> ''::text))
system vn_system_machine_id (((machine_id)::text <> ''::text))
system vn_system_minion_id (((minion_id)::text <> ''::text))
system vn_system_minion_kernel_live_version (((minion_kernel_live_version)::text <> ''::text))
system vn_system_minion_os_family (((minion_os_family)::text <> ''::text))
system vn_system_organization (((organization)::text <> ''::text))
system vn_system_profile_name (((profile_name)::text <> ''::text))
system vn_system_rack (((rack)::text <> ''::text))
system vn_system_registered_by (((registered_by)::text <> ''::text))
system vn_system_room (((room)::text <> ''::text))
system vn_system_state (((state)::text <> ''::text))
channelrepository vn_channelrepository_repository_label (((repository_label)::text <> ''::text))
systemerrata vn_systemerrata_advisory_name (((advisory_name)::text <> ''::text))
systemerrata vn_systemerrata_advisory_type (((advisory_type)::text <> ''::text))
systemerrata vn_systemerrata_hostname (((hostname)::text <> ''::text))
systemhistory vn_systemhistory_event (((event)::text <> ''::text))
systemhistory vn_systemhistory_hostname (((hostname)::text <> ''::text))
account vn_account_email (((email)::text <> ''::text))
account vn_account_first_name (((first_name)::text <> ''::text))
account vn_account_last_name (((last_name)::text <> ''::text))
account vn_account_organization (((organization)::text <> ''::text))
account vn_account_position ((("position")::text <> ''::text))
account vn_account_status (((status)::text <> ''::text))
account vn_account_username (((username)::text <> ''::text))
channelerrata vn_channelerrata_advisory_name (((advisory_name)::text <> ''::text))
channelerrata vn_channelerrata_channel_label (((channel_label)::text <> ''::text))
systemgroup vn_systemgroup_description (((description)::text <> ''::text))
systemgroup vn_systemgroup_name (((name)::text <> ''::text))
systemgroup vn_systemgroup_organization (((organization)::text <> ''::text))
systemchannel vn_systemchannel_architecture_name (((architecture_name)::text <> ''::text))
systemchannel vn_systemchannel_description (((description)::text <> ''::text))
systemchannel vn_systemchannel_name (((name)::text <> ''::text))
systemchannel vn_systemchannel_parent_channel_name (((parent_channel_name)::text <> ''::text))
systemnetinterface vn_systemnetinterface_hardware_address (((hardware_address)::text <> ''::text))
systemnetinterface vn_systemnetinterface_module (((module)::text <> ''::text))
systemnetinterface vn_systemnetinterface_name (((name)::text <> ''::text))
package vn_package_arch (((arch)::text <> ''::text))
package vn_package_epoch (((epoch)::text <> ''::text))
package vn_package_name (((name)::text <> ''::text))
package vn_package_organization (((organization)::text <> ''::text))
package vn_package_release (((release)::text <> ''::text))
package vn_package_type (((type)::text <> ''::text))
package vn_package_vendor (((vendor)::text <> ''::text))
package vn_package_version (((version)::text <> ''::text))
systempackageinstalled vn_systempackageinstalled_arch (((arch)::text <> ''::text))
systempackageinstalled vn_systempackageinstalled_epoch (((epoch)::text <> ''::text))
systempackageinstalled vn_systempackageinstalled_name (((name)::text <> ''::text))
systempackageinstalled vn_systempackageinstalled_release (((release)::text <> ''::text))
systempackageinstalled vn_systempackageinstalled_type (((type)::text <> ''::text))
systempackageinstalled vn_systempackageinstalled_version (((version)::text <> ''::text))
xccdscanresult vn_xccdscanresult_ident (((ident)::text <> ''::text))
xccdscanresult vn_xccdscanresult_idref (((idref)::text <> ''::text))
xccdscanresult vn_xccdscanresult_result (((result)::text <> ''::text))
xccdscanresult vn_xccdscanresult_rulesystem (((rulesystem)::text <> ''::text))
cocoattestation vn_cocoattestation_environment_type (((environment_type)::text <> ''::text))
cocoattestation vn_cocoattestation_status (((status)::text <> ''::text))
systemcustominfo vn_systemcustominfo_description (((description)::text <> ''::text))
systemcustominfo vn_systemcustominfo_key (((key)::text <> ''::text))
systemcustominfo vn_systemcustominfo_organization (((organization)::text <> ''::text))
systemcustominfo vn_systemcustominfo_value (((value)::text <> ''::text))
errata vn_errata_advisory_name (((advisory_name)::text <> ''::text))
errata vn_errata_advisory_status (((advisory_status)::text <> ''::text))
errata vn_errata_advisory_type (((advisory_type)::text <> ''::text))
errata vn_errata_organization (((organization)::text <> ''::text))
errata vn_errata_severity (((severity)::text <> ''::text))
errata vn_errata_synopsis (((synopsis)::text <> ''::text))
cocoattestationresult vn_cocoattestationresult_description (((description)::text <> ''::text))
cocoattestationresult vn_cocoattestationresult_result_status (((result_status)::text <> ''::text))
cocoattestationresult vn_cocoattestationresult_result_type (((result_type)::text <> ''::text))
systemgrouppermission vn_systemgrouppermission_group_name (((group_name)::text <> ''::text))
xccdscan vn_xccdscan_benchmark (((benchmark)::text <> ''::text))
xccdscan vn_xccdscan_benchmark_version (((benchmark_version)::text <> ''::text))
xccdscan vn_xccdscan_name (((name)::text <> ''::text))
xccdscan vn_xccdscan_profile (((profile)::text <> ''::text))
xccdscan vn_xccdscan_profile_title (((profile_title)::text <> ''::text))
systemnetaddressv6 vn_systemnetaddressv6_address (((address)::text <> ''::text))
systemnetaddressv6 vn_systemnetaddressv6_netmask (((netmask)::text <> ''::text))
systemnetaddressv6 vn_systemnetaddressv6_scope (((scope)::text <> ''::text))
accountgroup vn_accountgroup_account_group_name (((account_group_name)::text <> ''::text))
accountgroup vn_accountgroup_account_group_type_label (((account_group_type_label)::text <> ''::text))
accountgroup vn_accountgroup_account_group_type_name (((account_group_type_name)::text <> ''::text))
accountgroup vn_accountgroup_username (((username)::text <> ''::text))
systemnetaddressv4 vn_systemnetaddressv4_address (((address)::text <> ''::text))
systemnetaddressv4 vn_systemnetaddressv4_broadcast (((broadcast)::text <> ''::text))
systemnetaddressv4 vn_systemnetaddressv4_netmask (((netmask)::text <> ''::text))
systementitlement vn_systementitlement_description (((description)::text <> ''::text))
systementitlement vn_systementitlement_group_type_name (((group_type_name)::text <> ''::text))
systementitlement vn_systementitlement_name (((name)::text <> ''::text))
systementitlement vn_systementitlement_organization (((organization)::text <> ''::text))
channel vn_channel_arch (((arch)::text <> ''::text))
channel vn_channel_checksum_type (((checksum_type)::text <> ''::text))
channel vn_channel_description (((description)::text <> ''::text))
channel vn_channel_label (((label)::text <> ''::text))
channel vn_channel_name (((name)::text <> ''::text))
channel vn_channel_organization (((organization)::text <> ''::text))
channel vn_channel_parent_channel_label (((parent_channel_label)::text <> ''::text))
channel vn_channel_summary (((summary)::text <> ''::text))
channel vn_channel_type (((type)::text <> ''::text))
systemaction vn_systemaction_action_name (((action_name)::text <> ''::text))
systemaction vn_systemaction_event (((event)::text <> ''::text))
systemaction vn_systemaction_hostname (((hostname)::text <> ''::text))
systemaction vn_systemaction_scheduler_username (((scheduler_username)::text <> ''::text))
systemaction vn_systemaction_status (((status)::text <> ''::text))
systemvirtualdata vn_systemvirtualdata_instance_type_name (((instance_type_name)::text <> ''::text))
systemvirtualdata vn_systemvirtualdata_name (((name)::text <> ''::text))
systemvirtualdata vn_systemvirtualdata_state_name (((state_name)::text <> ''::text))
systemvirtualdata vn_systemvirtualdata_uuid (((uuid)::text <> ''::text))
repository vn_repository_label (((label)::text <> ''::text))
repository vn_repository_organization (((organization)::text <> ''::text))
repository vn_repository_type (((type)::text <> ''::text))
repository vn_repository_url (((url)::text <> ''::text))
systemgroupmember vn_systemgroupmember_group_name (((group_name)::text <> ''::text))
systemgroupmember vn_systemgroupmember_system_name (((system_name)::text <> ''::text))
systemconfigchannel vn_systemconfigchannel_name (((name)::text <> ''::text))
systempackageupdate vn_systempackageupdate_arch (((arch)::text <> ''::text))
systempackageupdate vn_systempackageupdate_epoch (((epoch)::text <> ''::text))
systempackageupdate vn_systempackageupdate_name (((name)::text <> ''::text))
systempackageupdate vn_systempackageupdate_release (((release)::text <> ''::text))
systempackageupdate vn_systempackageupdate_type (((type)::text <> ''::text))
systempackageupdate vn_systempackageupdate_version (((version)::text <> ''::text))