SchemaSpy Analysis of candlepin.public - Constraints | Generated by SchemaSpy |
46 Foreign Key Constraints: |
|
Constraint Name | Child Column | Parent Column |
---|---|---|
fk16370c54b9410fc | cp_certificate.serial_id | cp_cert_serial.id |
fk278ce810390317d | cp_consumer_facts.cp_consumer_id | cp_consumer.id |
fk27d80fafd8564fd9 | cp_subscription.certificate_id | cp_certificate.id |
fk456324f64b9410fc | cp_id_cert.serial_id | cp_cert_serial.id |
fk5820538861936445 | cp_consumer.keypair_id | cp_key_pair.id |
fk58205388a0b39916 | cp_consumer.consumer_idcert_id | cp_id_cert.id |
fk9349dd972cc5ca5 | cp_import_record.owner_id | cp_owner.id |
fk9ef75306401fcf77 | cp_product_dependent_products.cp_product_id | cp_product.id |
fk_activation_key_owner | cp_activation_key.owner_id | cp_owner.id |
fk_activation_key_pool_k | cp_activationkey_pool.key_id | cp_activation_key.id |
fk_activation_key_pool_p | cp_activationkey_pool.pool_id | cp_pool.id |
fk_cert_entitlement | cp_ent_certificate.entitlement_id | cp_entitlement.id |
fk_cert_product | cp_product_certificate.product_id | cp_product.id |
fk_consumer_consumer_type | cp_consumer.type_id | cp_consumer_type.id |
fk_consumer_env | cp_consumer.environment_id | cp_environment.id |
fk_consumer_guests | cp_consumer_guests.consumer_id | cp_consumer.id |
fk_consumer_installed_product | cp_consumer_installed_products.consumer_id | cp_consumer.id |
fk_consumer_owner | cp_consumer.owner_id | cp_owner.id |
fk_entitlement_consumer | cp_entitlement.consumer_id | cp_consumer.id |
fk_entitlement_owner | cp_entitlement.owner_id | cp_owner.id |
fk_entitlement_pool | cp_entitlement.pool_id | cp_pool.id |
fk_env_content_env | cp_env_content.environment_id | cp_environment.id |
fk_env_owner | cp_environment.owner_id | cp_owner.id |
fk_permission_owner | cp_owner_permission.owner_id | cp_owner.id |
fk_permission_role | cp_owner_permission.role_id | cp_role.id |
fk_pool_id | cp_product_pool_attribute.pool_id | cp_pool.id |
fk_pool_owner | cp_pool.owner_id | cp_owner.id |
fk_pool_provided_product | cp_pool_products.pool_id | cp_pool.id |
fk_pool_source_entitlement | cp_pool.sourceentitlement_id | cp_entitlement.id |
fk_product_id | cp_subscription_products.subscription_id | cp_subscription.id |
fk_role_id | cp_role_users.user_id | cp_user.id |
fk_subscription_id | cp_subscription_products.product_id | cp_product.id |
fk_subscription_owner | cp_subscription.owner_id | cp_owner.id |
fk_subscription_product | cp_subscription.product_id | cp_product.id |
fk_user_id | cp_role_users.role_id | cp_role.id |
fkc93d6a8232912b37 | cp_content_modified_products.cp_content_id | cp_content.id |
fkce093157574ef825 | cp_product_content.content_id | cp_content.id |
fkce09315764dd9c65 | cp_product_content.product_id | cp_product.id |
fke76508714b9410fc | cp_ent_certificate.serial_id | cp_cert_serial.id |
fkf06f6b8872cc5ca5 | cp_export_metadata.owner_id | cp_owner.id |
fkf93e9c616343755c | cp_owner.parent_owner | cp_owner.id |
qrtz_blob_triggers_trigger_name_fkey | qrtz_blob_triggers.sched_name qrtz_blob_triggers.trigger_name qrtz_blob_triggers.trigger_group |
qrtz_triggers.sched_name qrtz_triggers.trigger_name qrtz_triggers.trigger_group |
qrtz_cron_triggers_trigger_name_fkey | qrtz_cron_triggers.sched_name qrtz_cron_triggers.trigger_name qrtz_cron_triggers.trigger_group |
qrtz_triggers.sched_name qrtz_triggers.trigger_name qrtz_triggers.trigger_group |
qrtz_simple_triggers_trigger_name_fkey | qrtz_simple_triggers.sched_name qrtz_simple_triggers.trigger_name qrtz_simple_triggers.trigger_group |
qrtz_triggers.sched_name qrtz_triggers.trigger_name qrtz_triggers.trigger_group |
qrtz_simprop_triggers_trigger_name_fkey | qrtz_simprop_triggers.sched_name qrtz_simprop_triggers.trigger_name qrtz_simprop_triggers.trigger_group |
qrtz_triggers.sched_name qrtz_triggers.trigger_name qrtz_triggers.trigger_group |
qrtz_triggers_job_name_fkey | qrtz_triggers.sched_name qrtz_triggers.job_name qrtz_triggers.job_group |
qrtz_job_details.sched_name qrtz_job_details.job_name qrtz_job_details.job_group |
Check Constraints:
Table | Constraint Name | Constraint |
---|---|---|
None detected |