SchemaSpy - candlepin.public

Generated by
SchemaSpy

Generated by SchemaSpy on Mon Jan 14 11:12 EST 2013
Database Type: PostgreSQL - 9.1.7
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	560
cp_certificate	1	1	6	12
cp_consumer	4	5	16	7
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	167
cp_content_modified_products		1	2	22
cp_deleted_consumers			5	323
cp_ent_certificate		2	7	16
cp_entitlement	2	3	12	16
cp_env_content		1	6	0
cp_environment	2	1	6	0
cp_event			11	2,272
cp_export_metadata		1	6	4
cp_id_cert	1	1	6	319
cp_import_record		1	13	5
cp_job			11	39
cp_key_pair	1		5	7
cp_owner	10	1	9	17
cp_owner_permission		2	6	15
cp_pool	5	2	17	242
cp_pool_attribute		1	6	5
cp_pool_products		1	6	297
cp_product	6		5	73
cp_product_attribute		1	6	342
cp_product_certificate		1	6	24
cp_product_content		2	5	87
cp_product_dependent_products		1	2	0
cp_product_pool_attribute		1	7	1,539
cp_role	2		4	15
cp_role_users		2	2	22
cp_rules			5	1
cp_stat_history			8	2,030
cp_subscription	1	3	13	240
cp_subscription_products		2	2	297
cp_user	1		6	26
databasechangelog			11	212
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: 369 Rows: 9,268