Table candlepin.public.cp_pool 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_activationkey_pool.pool_id fk_activation_key_pool_p
cp_entitlement.pool_id fk_entitlement_pool
cp_pool_attribute.pool_id fk_pool_id
cp_pool_products.pool_id fk_pool_provided_product
cp_product_pool_attribute.pool_id fk_pool_id
created timestamptz 35,6  √  null
updated timestamptz 35,6  √  null
accountnumber varchar 255  √  null
activesubscription bool 1  √  null
contractnumber varchar 255  √  null
enddate timestamptz 35,6
productid varchar 255
productname varchar 255  √  null
quantity int8 19
restrictedtousername varchar 255  √  null
startdate timestamptz 35,6
subscriptionid varchar 255  √  null
subscriptionsubkey varchar 255  √  null
version int4 10
owner_id varchar 32 fk_pool_owner
sourceentitlement_id varchar 32  √  null fk_pool_source_entitlement

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

Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc cp_pool_pkey  
owner_id Performance Asc cp_pool_owner_id_idx  
productid Performance Asc cp_pool_productid_idx  
sourceentitlement_id Performance Asc cp_pool_sourceentitlement_id_idx  
subscriptionid Performance Asc cp_pool_subscriptionid_idx  
subscriptionid + subscriptionsubkey Must be unique Asc/Asc cp_pool_subscriptionid_subscriptionsubkey_key These unique columns are also nullable

Close relationships  within of separation: