SchemaSpy Analysis of HLPDTEST.SCH Generated by
SchemaSpy
Generated by SchemaSpy on Sun Aug 18 01:29 IST 2019
Database Type: Oracle - Oracle Database 11g Enterprise Edition Release 11.2.0.3.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
SCH_TIME_ZONES 3 17
SEQUENCE_NUMBERS 1 101
T_JOB_PARAMS 1 3 3,820
T_JOB_PARAMS_BKP 3 2,821
T_JOB_PARAMS_V 11 view
T_JOBS 3 1 7 519
T_JOBS_DEF 2 3 41
T_JOBS_DEF_PARAMS 1 8 174
T_JOBS_RUN 2 15 2,146,335
T_JOBS_RUN_MV 4 163,552
T_JOBS_RUN_V 25 view
T_JOBS_V 10 view
T_SCH_JOB_DEFAULT_VALUES 3 2
T_SCHDULES_V 18 view
T_SCHEDULE_FIRE 1 3 2,337,952
T_SCHEDULE_PARAMS 1 3 2,219
T_SCHEDULE_PARAMS_V 11 view
T_SCHEDULED_JOBS 2 8 456
T_SCHEDULER_STATUS_V 21 view
T_SCHEDULES 4 1 13 459
T_SCHEDULES_DEF 2 3 2
T_SCHEDULES_DEF_PARAMS 1 4 7
T_SCHEDULES_JOB_JOBTYPES 3 view
T_SCHEDULES_JOBS 3 view
           
16 Tables     84 4,658,477  
8 Views     102