SchemaSpy Analysis of candlepin.public - Constraints Generated by
SchemaSpy
46 Foreign Key Constraints:
SourceForge.net

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