SchemaSpy Analysis of HLPDTEST.SCH Generated by
SchemaSpy
Generated by SchemaSpy on Sun Oct 20 01:32 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 4,257
T_JOB_PARAMS_BKP 3 2,824
T_JOB_PARAMS_V 11 view
T_JOBS 3 1 7 574
T_JOBS_DEF 2 3 42
T_JOBS_DEF_PARAMS 1 8 186
T_JOBS_RUN 2 15 2,285,348
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,501,645
T_SCHEDULE_PARAMS 1 3 2,406
T_SCHEDULE_PARAMS_V 11 view
T_SCHEDULED_JOBS 2 8 498
T_SCHEDULER_STATUS_V 21 view
T_SCHEDULES 4 1 13 500
T_SCHEDULES_DEF 2 3 2
T_SCHEDULES_DEF_PARAMS 1 4 7
T_SCHEDULES_JOB_JOBTYPES 3 view
T_SCHEDULES_JOBS 3 view
TEST_PARAMS 2 7
           
17 Tables     86 4,961,968  
8 Views     102