SchemaSpy Analysis of shrdb.LAWRS Generated by
SchemaSpy
Generated by SchemaSpy on Thu Dec 13 15:47 CST 2012
Database Type: Oracle - Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SourceForge.net

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

Table Children Parents Columns Rows Comments
EBS_BSCHANNEL 5 0
EBS_BSFOLDER 7 0
EBS_BSGROUP 4 0
EBS_BSIDCHAN 5 0
EBS_BSIDCHFLD 6 0
EBS_BSIDCHFLDI 13 0
EBS_BSIDPUB 5 0
EBS_BSINFODTL 9 0
EBS_BSINFOHDR 9 0
EBS_BSLISTGRP 11 0
EBS_BSPUBLISH 6 0
EBS_BSRULEDTL 7 0
EBS_BSRULEHDR 3 0
EBS_BSRULELIST 4 0
EBS_BSSUBSCR 5 0
EBS_SIBSLISTHD 6 0
EBS_SIBSLISTID 4 0
EBS_SIRDIDHDR 9 0
EBS_WEBUSER 28 0
EBS_WFFOLDER 10 0
EBS_WFSERVICE 9 0
EBS_WFSERVPROC 9 0
EBS_WFVARIABLE 6 0
EBS_WFWORKUNIT 28 0
EJS_BLOB_TRIGGERS 2 3 0
EJS_CALENDARS 2 0
EJS_CRON_TRIGGERS 2 4 3
EJS_FIRED_TRIGGERS 11 0
EJS_JOB_DETAILS 4 9 160
EJS_JOB_LISTENERS 2 3 0
EJS_JOBS 9 21
EJS_LOCKS 1 5
EJS_PAUSED_TRIGGER_GRPS 1 0
EJS_SCHEDULER_STATE 4 0
EJS_SIMPLE_TRIGGERS 2 5 1
EJS_TRIGGER_LISTENERS 2 3 0
EJS_TRIGGERS 8 2 15 4
ERS_ATTRIBUTELIST 3 45
ERS_ATTRIBUTES 9 34
ERS_CACHEDTABLES 2 10
ERS_CUSTOMGROUPMEMBERS 2 0
ERS_CUSTOMGROUPS 3 0
ERS_DISTRIBUTIONOPTIONS 14 2
ERS_ELEMENTREFERENCES 15 15
ERS_ELEMENTS 11 15
ERS_LISTDEFAULT 2 518
ERS_LISTDETAIL 9 718
ERS_LISTEXCEPTIONS 5 0
ERS_LISTS 5 146
ERS_LISTUSERS 4 212
ERS_PARAMETERS 2 25 98
ERS_PARAMETERS_IDS 1 1
ERS_PARAMETERVALUES 6 0
ERS_PARM_AVAILVALUES 1 3 361
ERS_PARM_AVAILVALUES_IDS 1 2 13
ERS_PUBLICATIONS 8 3
ERS_PUBLICATIONS2 9 0
ERS_QUEUE_DTL 15 0
ERS_QUEUE_HDR 8 0
ERS_REPORTACCESS 5 5,459
ERS_REPORTATTRIBUTES 6 5,536
ERS_REPORTDATASOURCES 9 80
ERS_REPORTEVENTS 6 0
ERS_REPORTFORMULAS 6 80
ERS_REPORTINSTANCEPARAMVALUE 6 0
ERS_REPORTITEMMAPPINGS 5 6
ERS_REPORTNOTIFICATION 6 0
ERS_REPORTPARMVALUES 6 361
ERS_REPORTPERMISSIONS 7 6,392
ERS_REPORTS 22 608
ERS_REPORTSTATUS 9 89
ERS_RULEACCESS 4 0
ERS_RULEDETAIL 8 3,239
ERS_RULEMAPPINGS 3 570
ERS_RULEMASTER 10 569
ERS_RULEVALUES 6 8,374
ERS_SECURITYGROUPS 3 0
ERS_SERVERACCESS 5 162
ERS_SERVERATTRIBUTES 6 244
ERS_SERVERCONFIGURATIONS 5 23
ERS_SOLPACKOBJECTS 8 379
ERS_SOLPACKPROPERTIES 4 0
ERS_SOLPACKS 6 3
ERS_STRUCTURE 4 22
ERS_STRUCTUREMAPPING 3 819
ERS_STRUCTURETEMPLATE 4 27
ERS_STRUCTURETOFIELDMAP 4 6
ERS_SYSTEMPERMISSIONS 4 21
ERS_SYSTEMTASKS 5 38
ERS_VARIABLES 5 39
RS_AUDIT 12 0
           
91 Tables     641 35,531  
0 Views     0