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