SchemaSpy Analysis of rhnschema.public Generated by
SchemaSpy
Generated by SchemaSpy on Fri Nov 25 12:03 CET 2016
Database Type: PostgreSQL - 8.4.20 SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Rows Comments
all_primary_keys 3 view
all_tab_columns 7 view
dual 1 1
log 3 1 3 1
pxtsessions 1 1 4 0
qrtz_blob_triggers 2 3 0
qrtz_calendars 2 0
qrtz_cron_triggers 2 4 16
qrtz_fired_triggers 12 0
qrtz_job_details 4 9 16
qrtz_job_listeners 2 3 0
qrtz_locks 1 5
qrtz_paused_trigger_grps 1 0
qrtz_scheduler_state 3 0
qrtz_simple_triggers 2 5 0
qrtz_trigger_listeners 2 3 0
qrtz_triggers 8 2 16 16
rhn_config_group 1 2 28 confg configuration group definition:general,mail,cf_db
rhn_config_parameter 2 6 179 confp configuration parameter definition
rhn_config_security_type 1 2 3 conct security levels internal,external,all
rhnaction 30 4 11 0
rhnactionchain 1 1 5 0
rhnactionchainentry 3 6 0
rhnactionconfigchannel 5 5 0
rhnactionconfigdate 1 6 0
rhnactionconfigdatefile 1 5 0
rhnactionconfigfilename 5 7 0
rhnactionconfigrevision 1 4 7 0
rhnactionconfigrevisionresult 1 4 0
rhnactiondaemonconfig 1 5 0
rhnactionerrataupdate 2 2 0
rhnactionimagedeploy 1 9 0
rhnactionkickstart 1 1 8 0
rhnactionkickstartfilelist 2 4 0
rhnactionkickstartguest 2 15 0
rhnactionoverview 13 view
rhnactionpackage 2 4 6 0
rhnactionpackageanswerfile 1 4 0
rhnactionpackagedelta 2 2 0
rhnactionpackageremovalfailure 6 8 0
rhnactionscap 1 1 4 0
rhnactionscript 1 1 8 0
rhnactionstatus 1 4 4
rhnactiontype 2 5 52
rhnactionvirtdestroy 1 4 0
rhnactionvirtreboot 1 4 0
rhnactionvirtrefresh 1 3 0
rhnactionvirtresume 1 4 0
rhnactionvirtschedulepoller 1 8 0
rhnactionvirtsetmemory 1 5 0
rhnactionvirtshutdown 1 4 0
rhnactionvirtstart 4 0
rhnactionvirtsuspend 1 4 0
rhnactionvirtvcpu 1 5 0
rhnactivationkey 2 5 0
rhnarchtype 4 5 6
rhnarchtypeactions 2 5 11
rhnavailablechannels 10 view
rhncddevice 13 view
rhnchannel 26 6 26 7
rhnchannelarch 7 1 6 23
rhnchannelcloned 2 4 0
rhnchannelcomps 1 6 1
rhnchannelcontentsource 2 4 7
rhnchannelerrata 2 4 0
rhnchannelfamily 3 1 7 1
rhnchannelfamilymembers 2 4 7
rhnchannelfamilypermissions 4 view
rhnchannelnewestpackage 5 5 6,696
rhnchannelnewestpackageaudit 1 3 8
rhnchannelnewestpackageview 5 view
rhnchannelpackage 2 4 6,696
rhnchannelpackagearchcompat 2 4 107
rhnchannelpermission 3 5 0
rhnchannelpermissionrole 1 5 2
rhnchannelpermissions 2 view
rhnchannelproduct 1 6 0
rhnchanneltreeview 10 view
rhnchanneltrust 2 4 0
rhnchecksum 9 1 3 679,048
rhnchecksumtype 2 5 5
rhnchecksumview 3 view
rhnchildchannelarchcompat 2 4 28
rhnclientcapability 2 5 0
rhnclientcapabilityname 1 2 0
rhnconfigchannel 5 2 8 0
rhnconfigchanneltype 1 6 3
rhnconfigcontent 1 1 9 0
rhnconfigfile 1 4 7 0
rhnconfigfilefailure 2 5 4
rhnconfigfilename 4 4 0
rhnconfigfilestate 1 5 2
rhnconfigfiletype 1 5 3
rhnconfiginfo 1 1 8 0
rhnconfigrevision 4 5 9 0
rhnconfiguration 6 3
rhncontentsource 2 5 10 7
rhncontentsourcefilter 1 7 0
rhncontentsourcetype 1 4 3
rhncpu 2 20 0
rhncpuarch 1 5 30
rhncryptokey 4 2 5 2
rhncryptokeykickstart 2 2 0
rhncryptokeytype 1 5 2
rhncustomdatakey 1 3 8 0
rhncve 1 2 0
rhndailysummaryqueue 1 3 0
rhndevice 1 15 0
rhndistchannelmap 3 6 0
rhnentitledservers 10 view
rhnerrata 13 2 21 0
rhnerratabuglist 1 6 0
rhnerratabuglisttmp 1 6 0
rhnerratacloned 2 4 0
rhnerrataclonedtmp 2 4 0
rhnerratacve 2 4 0
rhnerratafile 3 3 7 0
rhnerratafilechannel 2 4 0
rhnerratafilechanneltmp 2 4 0
rhnerratafilepackage 2 4 0
rhnerratafilepackagesource 2 4 0
rhnerratafilepackagetmp 2 4 0
rhnerratafiletmp 2 3 7 0
rhnerratafiletype 2 2 4
rhnerratakeyword 1 4 0
rhnerratakeywordtmp 1 4 0
rhnerratanotificationqueue 3 6 0
rhnerratapackage 2 4 0
rhnerratapackagetmp 2 4 0
rhnerrataqueue 2 5 0
rhnerrataseverity 1 3 4
rhnerratatmp 5 1 20 0
rhnexception 3 64
rhnfeature 1 5 24
rhnfile 2 2 7 0
rhnfiledownload 2 6 0
rhnfilelist 4 1 5 0
rhnfilelistmembers 2 4 0
rhnfilelocation 1 2 0
rhnhwdevice 13 view
rhnindexerwork 3 1
rhninfopane 1 3 7
rhnissmaster 1 5 0
rhnissmasterorgs 2 6 0
rhnissslave 1 6 0
rhnissslaveorgs 2 3 0
rhnkickstartabletree 3 4 13 0
rhnkickstartchildchannel 2 4 0
rhnkickstartcommand 2 6 0
rhnkickstartcommandname 1 5 49
rhnkickstartdefaultregtoken 2 4 0
rhnkickstartdefaults 4 8 0
rhnkickstartiprange 2 6 0
rhnkickstartpackage 2 5 0
rhnkickstartpreservefilelist 2 4 0
rhnkickstartscript 1 12 0
rhnkickstartsession 4 11 22 0
rhnkickstartsessionhistory 3 8 0
rhnkickstartsessionstate 2 6 13
rhnkickstarttimezone 1 4 2,290
rhnkickstartvirtualizationtype 2 5 5
rhnksdata 10 1 24 0
rhnksinstalltype 2 5 9
rhnkstreefile 2 7 0
rhnkstreetype 1 5 2
rhnorgadminmanagement 1 4 1
rhnorgchannelfamilypermissions 4 view
rhnorgchannelsettings 3 5 0
rhnorgchannelsettingstype 1 4 1
rhnorgchanneltreeview 11 view
rhnorgconfiguration 1 12 1
rhnorgdistchannelmap 7 view
rhnorgerrata 3 view
rhnorgerratacachequeue 1 3 0
rhnorgextgroupmapping 2 5 0
rhnpackage 21 7 28 6,696
rhnpackagearch 15 1 6 46
rhnpackagebreaks 2 5 0
rhnpackagecapability 14 5 927,472
rhnpackagechangelog 8 view
rhnpackagechangelogdata 1 5 101,688
rhnpackagechangelogrec 2 5 514,510
rhnpackageconflicts 2 5 430
rhnpackagedelta 2 4 0
rhnpackagedeltaelement 2 2 0
rhnpackageenhances 2 5 0
rhnpackageevr 14 5 2,093
rhnpackagefile 3 17 978,001
rhnpackagefiledeletequeue 2 0
rhnpackagegroup 2 4 63
rhnpackagekey 1 2 6 51
rhnpackagekeyassociation 2 4 6,696
rhnpackagekeytype 1 4 4
rhnpackagename 16 2 5,146
rhnpackagenevra 1 3 4 6,696
rhnpackageobsoletes 2 5 1,752
rhnpackagepredepends 2 5 0
rhnpackageprovider 1 4 9
rhnpackageprovides 2 5 70,722
rhnpackagerecommends 2 5 0
rhnpackagerepodata 1 6 6,696
rhnpackagerequires 2 5 125,461
rhnpackagesource 1 5 17 0
rhnpackagesuggests 2 5 0
rhnpackagesupplements 2 5 0
rhnpackagesyncblacklist 2 4 3
rhnpackageupgradearchcompat 2 4 124
rhnprivatechannelfamily 2 4 1
rhnproductname 1 5 0
rhnprovisionstate 1 5 0
rhnproxyinfo 2 2 0
rhnpublicchannelfamily 1 3 0
rhnpushclient 1 11 0
rhnpushclientstate 1 5 2
rhnpushdispatcher 8 1
rhnram 1 6 0
rhnregtoken 9 3 8 0
rhnregtokenchannels 2 2 0
rhnregtokenconfigchannels 2 3 0
rhnregtokenentitlement 2 2 0
rhnregtokengroups 2 2 0
rhnregtokenorgdefault 2 2 0
rhnregtokenpackages 3 4 0
rhnreleasechannelmap 2 5 0
rhnreporegenqueue 9 0
rhnresetpassword 1 6 0
rhnsatelliteinfo 2 9 0
rhnserver 50 4 19 0
rhnserver_log 1 19 0
rhnserveraction 4 3 10 0
rhnserveractionpackageresult 2 7 0
rhnserveractionscriptresult 2 8 0
rhnserveractionverifymissing 6 8 0
rhnserveractionverifyresult 6 17 0
rhnserverarch 4 1 6 39
rhnserverchannel 2 4 0
rhnserverchannelarchcompat 2 4 39
rhnserverconfigchannel 2 5 0
rhnservercrash 2 4 20 0
rhnservercrashcount 4 view
rhnservercrashfile 1 8 0
rhnservercrashnote 2 7 0
rhnservercustomdatavalue 4 7 0
rhnserverdmi 1 12 0
rhnserverentitlementphysical 7 view
rhnserverentitlementview 5 view
rhnserverentitlementvirtual 6 view
rhnservererratatypeview 3 view
rhnserverevent 1 5 0
rhnserverfeaturesview 2 view
rhnservergroup 6 2 8 2
rhnservergroup_log 1 8 2
rhnservergroupmembers 2 4 0
rhnservergroupmembership 6 view
rhnservergroupoverview 9 view
rhnservergroupovlitehelper 2 view
rhnservergrouptype 6 7 2
rhnservergrouptypefeature 2 4 22
rhnserverhistory 1 6 0
rhnserverinfo 1 3 0
rhnserverinstallinfo 1 7 0
rhnserverlocation 1 13 0
rhnserverlock 2 4 0
rhnserverneededcache 4 4 0
rhnserverneedederratacache 2 view
rhnserverneededpackagecache 3 view
rhnservernetaddress4 1 6 0
rhnservernetaddress6 1 6 0
rhnservernetinterface 2 1 8 0
rhnservernetwork 1 7 0
rhnservernotes 2 7 0
rhnserveroutdatedpackages 7 view
rhnserveroverview 23 view
rhnserverpackage 4 6 0
rhnserverpackagearchcompat 2 5 132
rhnserverpath 2 6 0
rhnserverpreservefilelist 2 4 0
rhnserverprofile 3 3 9 0
rhnserverprofilepackage 4 4 0
rhnserverprofiletype 1 5 2
rhnserverservergrouparchcompat 2 4 63
rhnservertokenregs 2 2 0
rhnserveruuid 1 2 0
rhnset 1 5 0
rhnsgtypebaseaddoncompat 2 2 1
rhnsharedchanneltreeview 11 view
rhnsharedchannelview 21 view
rhnsnapshot 6 3 7 0
rhnsnapshotchannel 2 2 0
rhnsnapshotconfigchannel 2 4 0
rhnsnapshotconfigrevision 2 4 0
rhnsnapshotinvalidreason 1 5 6
rhnsnapshotpackage 2 2 0
rhnsnapshotservergroup 2 2 0
rhnsnapshottag 3 5 0
rhnsourcerpm 2 2 2,169
rhnssmoperation 1 1 6 0
rhnssmoperationserver 2 3 0
rhnstoragedevice 11 view
rhnsystemmigrations 3 4 0
rhntag 1 2 5 0
rhntagname 1 4 0
rhntaskobunch 2 6 18
rhntaskorun 2 11 30,177
rhntaskoschedule 1 1 10 16
rhntaskotask 1 5 20
rhntaskotemplate 1 2 7 20
rhntaskqueue 1 5 0
rhntemplatecategory 1 5 2
rhntemplatestring 1 7 3
rhntimezone 1 3 45
rhntinyurl 5 0
rhntransactionoperation 1 4 3
rhntransactionpackage 1 4 5 0
rhntrustedorgs 2 4 0
rhnuseractionoverview 11 view
rhnuserchannel 4 view
rhnuserchannelfamilyperms 5 view
rhnuserchanneltreeview 12 view
rhnuserdefaultsystemgroups 2 2 0
rhnuserextgroup 2 1 5 0
rhnuserextgroupmapping 2 5 0
rhnusergroup 1 2 9 6
rhnusergroupmembers 2 5 2
rhnusergrouptype 2 5 6
rhnuserinfo 2 19 1
rhnuserinfopane 2 2 0
rhnusermanagedservergroups 2 view
rhnuserreceivenotifications 3 view
rhnuserreserved 5 0
rhnuserservergroupperms 2 4 0
rhnuserserverperms 2 2 0
rhnuserserverpermsdupes 2 view
rhnuserserverprefs 2 6 0
rhnusersinorgoverview 9 view
rhnusertypebase 4 view
rhnversioninfo 2 5 1
rhnvirtualinstance 2 2 7 0
rhnvirtualinstanceeventlog 4 17 0
rhnvirtualinstanceeventtype 1 5 8
rhnvirtualinstanceinfo 3 8 0
rhnvirtualinstanceinstalllog 1 5 0
rhnvirtualinstancestate 3 5 5
rhnvirtualinstancetype 1 5 6
rhnvisibleobjects 1 3 0
rhnvisibleservergroup 8 view
rhnvisibleservergroupmembers 4 view
rhnvisservergroupmembership 6 view
rhnwebcontactchangelog 3 5 0
rhnwebcontactchangestate 1 2 2
rhnwebcontactdisabled 9 view
rhnwebcontactenabled 10 view
rhnxccdfbenchmark 1 3 0
rhnxccdfident 1 1 3 0
rhnxccdfidentsystem 1 2 0
rhnxccdfprofile 1 3 0
rhnxccdfruleidentmap 2 2 0
rhnxccdfruleresult 1 2 3 0
rhnxccdfruleresulttype 1 4 9
rhnxccdftestresult 1 4 9 0
state_change 3 0
susecredentials 2 8 0
susecredentialstype 1 5 1
valid_countries 3 240
web_contact 32 1 10 1
web_contact_all 1 3 3
web_contact_log 1 10 1
web_customer 44 4 1
web_user_contact_permission 1 7 1
web_user_personal_info 2 21 1
web_user_prefix 1 1 9
web_user_site_info 2 31 1
web_user_site_type 1 2 4
           
326 Tables     1,951 3,482,963  
47 Views     337