Table candlepin.public.cp_consumer 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_consumer_facts.cp_consumer_id fk278ce810390317d
cp_consumer_guests.consumer_id fk_consumer_guests
cp_consumer_installed_products.consumer_id fk_consumer_installed_product
cp_entitlement.consumer_id fk_entitlement_consumer
created timestamptz 35,6  √  null
updated timestamptz 35,6  √  null
autoheal bool 1  √  null
entitlementstatus varchar 32  √  null
lastcheckin timestamptz 35,6  √  null
name varchar 255
servicelevel varchar 32
username varchar 255  √  null
uuid varchar 255
environment_id varchar 32  √  null
cp_environment.id fk_consumer_env
consumer_idcert_id varchar 32  √  null
cp_id_cert.id fk58205388a0b39916
keypair_id varchar 32  √  null
cp_key_pair.id fk5820538861936445
owner_id varchar 32
cp_owner.id fk_consumer_owner
type_id varchar 32
cp_consumer_type.id fk_consumer_consumer_type
releasever varchar 255  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc cp_consumer_pkey
consumer_idcert_id Performance Asc cp_consumer_consumer_idcert_id_idx
environment_id Performance Asc cp_consumer_environment_id_idx
keypair_id Performance Asc cp_consumer_keypair_id_idx
owner_id Performance Asc cp_consumer_owner_id_idx
type_id Performance Asc cp_consumer_type_id_idx
uuid Must be unique Asc cp_consumer_uuid_key

Close relationships  within of separation: