Table candlepin.public.cp_activationkey_pool 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
created timestamptz 35,6  √  null
updated timestamptz 35,6  √  null
quantity int8 19
key_id varchar 32
cp_activation_key.id fk_activation_key_pool_k
pool_id varchar 32
cp_pool.id fk_activation_key_pool_p

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc cp_activationkey_pool_pkey
key_id + pool_id Must be unique Asc/Asc cp_activationkey_pool_key_id_pool_id_key

Close relationships  within of separation: