Table candlepin.public.cp_entitlement 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_ent_certificate.entitlement_id fk_cert_entitlement
cp_pool.sourceentitlement_id fk_pool_source_entitlement
created timestamptz 35,6  √  null
updated timestamptz 35,6  √  null
accountnumber varchar 255  √  null
contractnumber varchar 255  √  null
enddate timestamptz 35,6  √  null
quantity int4 10  √  null
startdate timestamptz 35,6  √  null
consumer_id varchar 32
cp_consumer.id fk_entitlement_consumer
owner_id varchar 32
cp_owner.id fk_entitlement_owner
pool_id varchar 32  √  null
cp_pool.id fk_entitlement_pool
dirty bool 1  √  false

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc cp_entitlement_pkey
consumer_id Performance Asc cp_entitlement_consumer_id_idx
owner_id Performance Asc cp_entitlement_owner_id_idx
pool_id Performance Asc cp_entitlement_pool_id_idx

Close relationships  within of separation: