SchemaSpy Analysis of shrdb.LAWSN 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 / View Children Parents Columns Rows Comments
EMAILHISTORY 9 228,242
ENPATTRLIST 2 1 3 153
ENPBATREE 8 3 11 11,221
ENPCATATTRS 4 view
ENPCATEGORIES 2 2 25
ENPCATLISTHELPER 1 view
ENPDELIVERYLOG 1 9 28,298
ENPDELIVERYLOGVIEW 10 view
ENPENTRYACCESS 3 3 0
ENPENTRYACCESSLIST 4 view
ENPENTRYACCESSTYPES 1 2 1
ENPENTRYATTR 3 8 43,467
ENPGROUPMAP 2 2 12,541
ENPLOGSOURCES 1 2 0
ENPLOGTABLE 1 7 0
ENPPERSONALALERTHIST 1 2 0
ENPPERSONALOBJECT 2 20 0
ENPPERSONALTRIPPED 1 3 0
ENPREFCATS 4 view
ENPREFERENCECV 3 view
ENPREFERENCES 2 2 539
ENPREFLISTVIEW 1 view
ENPROCESSAUDIT 13 738
ENPSEQNUM 2 9
ENPSTATSLOG 2 3 0
ENPSTATSLOGTYPES 1 2 7
ENPSTATSREPORT 6 view
ENPSYSTEMPERMISSIONS 4 11
ENPSYSTEMTASKS 6 18
ENPTRANSACTSUB 17 0
ENPTREEATTRS 18 view
ENPUSERGROUPLIST 4 view
ENPUSERLISTVIEW 2 view
ENPUSERMAP 6 4 10,260
INFOSETRIGHTS 1 7 0
QRTZ_BLOB_TRIGGERS 2 3 0
QRTZ_CALENDARS 2 0
QRTZ_CRON_TRIGGERS 2 4 10
QRTZ_FIRED_TRIGGERS 12 0
QRTZ_JOB_DETAILS 4 9 9
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 10
SLAVESERVER 5 0
SNAUDIT 2 10 0
TMP_EMAILHISTORY 7 0
           
116 Tables     1,308 604,984  
11 Views     57