SchemaSpy Analysis of HLPDTEST.TADMIN Generated by
SchemaSpy
Generated by SchemaSpy on Sun Aug 18 01:30 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
DUMMY_APBILLSPAYMENTS_DETAILS 13 0
DUMMY_APBILLSPAYMENTS_VIEW 13 view
DUMMY_ARRECEIPTS_DETAILS 13 0
DUMMY_ARRECEIPTS_VIEW 13 view
DUMMY_CUSTOMER_DETAILS 9 0
DUMMY_EMPLOYEE_DETAILS 5 0
DUMMY_INVOICE_DETAILS 19 0
DUMMY_INVOICE_VIEW 19 view
DUMMY_JOURNAL_DETAILS 19 0
DUMMY_VENDOR_DETAILS 11 0
DUMMY_VENDOR_DETAILS_V 11 view
T_ACCOUNT_PAYABLES 10 20
T_ACCOUNT_RECEIVABLES 11 41
T_CASH_REPORT 10 31
T_CLOSED_BALANCE_HISTORY 4 3
T_CONSULTING_PROCESS 1 11 1
T_DOCUMENT_DETAILS 1 4 37
T_EMP_ADMIN_REQUEST 11 269
T_EMP_REQUEST 2 7
T_EXPENSES_PAYABLE 6 80
T_INVOICE_CLIENT_DETAILS 1 19 183
T_INVOICE_FILE_TEMPLATES 1 3 192
T_INVOICE_FILE_VERSIONS 7 201
T_INVOICE_HISTORY 1 4 66
T_PAYABLES_AGING 9 83
T_PURCHASE_FILE_TEMPLATES 1 1 9 14
T_PURCHASE_FILE_VERSIONS 1 8 10
T_RECEIVABLES_AGING 10 128
T_RESOURCE_UTILIZATION_V 13 view
T_SONAR_QUBE_CODEREVIEW 4 54
T_SONAR_QUBE_TREND 9 8,189
T_SOW_CLIENT 8 15
T_SOW_FILE_TEMPLATES 1 1 4 539
T_SOW_FILE_VERSIONS 1 8 497
T_SOW_MILESTONE_DETAILS 1 7 71
T_SOW_PROCESS 6 30 640
T_SOW_PROCESS_USERS 1 2 630
T_SOW_RESOURCE_DETAILS 1 2 20 1,639
T_SOW_RESOURCE_TIME_EXPENSES 1 4 7,791
T_SOW_SALES_ORDERS 1 5 4
T_VENDOR_ACCOUNT_DETAILS 3 0
T_VENDOR_DETAILS 1 18 120
T_VENDOR_INVOICE 2 1 17 60
T_VISA_COUNTRIES 4 11
T_VISA_PROCESS_DETAILS 19 87
           
40 Tables     389 21,713  
5 Views     69