Table candlepin.public.cp_subscription Generated by
SchemaSpy
Legend: SourceForge.net
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_subscription_products.subscription_id fk_product_id
created timestamptz 35,6  √  null
updated timestamptz 35,6  √  null
accountnumber varchar 255  √  null
contractnumber varchar 255  √  null
enddate timestamptz 35,6
modified timestamptz 35,6  √  null
quantity int8 19
startdate timestamptz 35,6
upstream_pool_id varchar 255  √  null
certificate_id varchar 32  √  null
cp_certificate.id fk27d80fafd8564fd9
owner_id varchar 32
cp_owner.id fk_subscription_owner
product_id varchar 32
cp_product.id fk_subscription_product

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc cp_subscription_pkey
certificate_id Performance Asc cp_subscription_certificate_id_idx
owner_id Performance Asc cp_subscription_owner_id_idx
product_id Performance Asc cp_subscription_product_id_idx
upstream_pool_id Performance Asc cp_subscription_upstream_pool_id_idx

Close relationships  within of separation: