SchemaSpy - candlepin.public

Generated by
SchemaSpy

Generated by SchemaSpy on Tue Sep 04 13:10 ADT 2012
Database Type: PostgreSQL - 9.1.5
XML Representation Insertion Order Deletion Order (for database loading/purging scripts)

53 Tables:

Table	Children	Parents	Columns	Rows
cp_activation_key	1	1	5	3
cp_activationkey_pool		2	6	0
cp_cert_serial	3		6	485
cp_certificate	1	1	6	10
cp_consumer	4	5	16	5
cp_consumer_facts		1	3	0
cp_consumer_guests		1	5	0
cp_consumer_installed_products		1	6	0
cp_consumer_type	1		5	6
cp_content	2		12	54
cp_content_modified_products		1	2	22
cp_deleted_consumers			5	290
cp_ent_certificate		2	7	10
cp_entitlement	2	3	12	10
cp_env_content		1	6	0
cp_environment	2	1	6	0
cp_event			11	1,990
cp_export_metadata		1	6	3
cp_id_cert	1	1	6	284
cp_import_record		1	12	5
cp_job			11	6
cp_key_pair	1		5	5
cp_owner	10	1	9	18
cp_owner_permission		2	6	16
cp_pool	5	2	17	218
cp_pool_attribute		1	6	3
cp_pool_products		1	6	279
cp_product	6		5	66
cp_product_attribute		1	6	319
cp_product_certificate		1	6	23
cp_product_content		2	5	74
cp_product_dependent_products		1	2	0
cp_product_pool_attribute		1	7	1,430
cp_role	2		4	16
cp_role_users		2	2	22
cp_rules			4	1
cp_stat_history			8	5,071
cp_subscription	1	3	13	214
cp_subscription_products		2	2	279
cp_user	1		6	27
databasechangelog			11	210
databasechangeloglock			4	1
qrtz_blob_triggers		3	4	0
qrtz_calendars			3	0
qrtz_cron_triggers		3	5	0
qrtz_fired_triggers			13	0
qrtz_job_details	3		10	0
qrtz_locks			2	5
qrtz_paused_trigger_grps			2	0
qrtz_scheduler_state			4	0
qrtz_simple_triggers		3	6	0
qrtz_simprop_triggers		3	14	0
qrtz_triggers	12	3	16	0

Columns: 367 Rows: 11,480