Table candlepin.public.cp_owner Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 32
cp_activation_key.owner_id fk_activation_key_owner
cp_consumer.owner_id fk_consumer_owner
cp_entitlement.owner_id fk_entitlement_owner
cp_environment.owner_id fk_env_owner
cp_export_metadata.owner_id fkf06f6b8872cc5ca5
cp_import_record.owner_id fk9349dd972cc5ca5
cp_owner.parent_owner fkf93e9c616343755c
cp_owner_permission.owner_id fk_permission_owner
cp_pool.owner_id fk_pool_owner
cp_subscription.owner_id fk_subscription_owner
created timestamptz 35,6  √  null
updated timestamptz 35,6  √  null
contentprefix varchar 255  √  null
defaultservicelevel varchar 255  √  null
displayname varchar 255
account varchar 255
upstream_uuid varchar 255  √  null
parent_owner varchar 32  √  null fkf93e9c616343755c

Table contained 17 rows at Mon Jan 14 11:12 EST 2013

Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc cp_owner_pkey  
account Must be unique Asc cp_owner_account_key  
parent_owner Performance Asc cp_owner_parent_owner_idx  
upstream_uuid Must be unique Asc cp_owner_upstream_uuid_key This unique column is also nullable

Close relationships  within of separation: