SchemaSpy Analysis of HLPDTEST.SCH Generated by
SchemaSpy
Generated by SchemaSpy on Tue Jun 02 01:39 IST 2020
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 5,322
T_JOB_PARAMS_BKP 3 2,821
T_JOB_PARAMS_V 11 view
T_JOBS 3 1 7 703
T_JOBS_DEF 2 3 58
T_JOBS_DEF_PARAMS 1 8 285
T_JOBS_RUN 2 15 3,106,757
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 3,212,427
T_SCHEDULE_PARAMS 1 3 2,734
T_SCHEDULE_PARAMS_V 13 view
T_SCHEDULED_JOBS 2 8 570
T_SCHEDULER_STATUS_V 21 view
T_SCHEDULES 4 1 13 553
T_SCHEDULES_DEF 2 3 2
T_SCHEDULES_DEF_PARAMS 1 6 8
T_SCHEDULES_JOB_JOBTYPES 3 view
T_SCHEDULES_JOBS 3 view
           
16 Tables     86 6,495,912  
8 Views     104