Constraints

34 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
module_id
module_stream.module_id
module.id
Restrict delete
basearch_id
repo.basearch_id
arch.id
Restrict delete
content_set_id
repo.content_set_id
content_set.id
Restrict delete
certificate_id
repo.certificate_id
certificate.id
Restrict delete
arch_id
package.arch_id
arch.id
Restrict delete
name_id
package.name_id
package_name.id
Restrict delete
source_package_id
package.source_package_id
package.id
Restrict delete
evr_id
package.evr_id
evr.id
Restrict delete
from_arch_id
arch_compatibility.from_arch_id
arch.id
Restrict delete
to_arch_id
arch_compatibility.to_arch_id
arch.id
Restrict delete
profile_id
module_profile_pkg.profile_id
module_profile.id
Restrict delete
package_name_id
module_profile_pkg.package_name_id
package_name.id
Restrict delete
stream_id
module_profile.stream_id
module_stream.id
Restrict delete
cve_id
errata_cve.cve_id
cve.id
Restrict delete
errata_id
errata_cve.errata_id
errata.id
Restrict delete
severity_id
errata.severity_id
errata_severity.id
Restrict delete
errata_type_id
errata.errata_type_id
errata_type.id
Restrict delete
product_id
content_set.product_id
product.id
Restrict delete
stream_id
module_rpm_artifact.stream_id
module_stream.id
Restrict delete
pkg_id
module_rpm_artifact.pkg_id
package.id
Restrict delete
errata_id
errata_refs.errata_id
errata.id
Restrict delete
repo_id
errata_repo.repo_id
repo.id
Restrict delete
errata_id
errata_repo.errata_id
errata.id
Restrict delete
arch_id
module.arch_id
arch.id
Restrict delete
repo_id
module.repo_id
repo.id
Restrict delete
impact_id
cve.impact_id
cve_impact.id
Restrict delete
cve_source_id
cve.source_id
cve_source.id
Restrict delete
pkg_id
pkg_errata.pkg_id
package.id
Restrict delete
errata_id
pkg_errata.errata_id
errata.id
Restrict delete
module_stream_id
pkg_errata.module_stream_id
module_stream.id
Restrict delete
cwe_id
cve_cwe.cwe_id
cwe.id
Restrict delete
cve_id
cve_cwe.cve_id
cve.id
Restrict delete
repo_id
pkg_repo.repo_id
repo.id
Restrict delete
pkg_id
pkg_repo.pkg_id
package.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
evr evr_epoch_check ((NOT empty(epoch)))
evr evr_release_check ((NOT empty(release)))
evr evr_version_check ((NOT empty(version)))
certificate cert_key (((key IS NULL) OR (cert IS NOT NULL)))
certificate certificate_ca_cert_check ((NOT empty(ca_cert)))
certificate certificate_cert_check ((NOT empty(cert)))
certificate certificate_key_check ((NOT empty(key)))
certificate certificate_name_check ((NOT empty(name)))
arch arch_name_check ((NOT empty(name)))
cwe cwe_link_check ((NOT empty(link)))
cwe cwe_name_check ((NOT empty(name)))
repo repo_releasever_check ((NOT empty(releasever)))
repo repo_url_check ((NOT empty(url)))
package package_description_check ((NOT empty(description)))
package package_summary_check ((NOT empty(summary)))
product product_name_check ((NOT empty(name)))
errata errata_description_check ((NOT empty(description)))
errata errata_name_check ((NOT empty(name)))
errata errata_solution_check ((NOT empty(solution)))
errata errata_summary_check ((NOT empty(summary)))
errata errata_synopsis_check ((NOT empty(synopsis)))
content_set content_set_label_check ((NOT empty(label)))
content_set content_set_name_check ((NOT empty(name)))
errata_severity errata_severity_name_check ((NOT empty(name)))
errata_type errata_type_name_check ((NOT empty(name)))
errata_refs errata_refs_name_check ((NOT empty(name)))
errata_refs errata_refs_type_check ((NOT empty(type)))
cve_source cve_source_name_check ((NOT empty(name)))
cve cve_cvss2_metrics_check ((NOT empty(cvss2_metrics)))
cve cve_cvss3_metrics_check ((NOT empty(cvss3_metrics)))
cve cve_description_check ((NOT empty(description)))
cve cve_iava_check ((NOT empty(iava)))
cve cve_name_check ((NOT empty(name)))
cve cve_redhat_url_check ((NOT empty(redhat_url)))
cve cve_secondary_url_check ((NOT empty(secondary_url)))
cve_impact cve_impact_name_check ((NOT empty(name)))
package_name package_name_name_check ((NOT empty(name)))
metadata metadata_key_check ((NOT empty(key)))
metadata metadata_value_check ((NOT empty(value)))