Table candlepin.public.cp_entitlement Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
id varchar 32
cp_ent_certificate
cp_pool
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
owner_id varchar 32
cp_owner
pool_id varchar 32  √  null
cp_pool
dirty bool 1  √  false

Table contained 10 rows at Tue Sep 04 13:10 ADT 2012

Indexes:
Column(s) Type Sort
id Primary key Asc
consumer_id Performance Asc
owner_id Performance Asc
pool_id Performance Asc

Close relationships  within of separation: