SchemaSpy Analysis of HLPDTEST.TAS Generated by
SchemaSpy
Generated by SchemaSpy on Sun Oct 20 01:31 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
ITEM_MASTER_OTM_INBOUND_V 2 view
PS_TXN 5 40
T_CLOUD_REGISTRATIONS 8 3
T_CONCURRENT_POWER_USERS_VIEW 2 view
T_CONTACT_SUPPORT 5 0
T_CUSTOM_NOTIFICATIONS 8 0
T_DESIGNATION_ROLES_MAP 5 9
T_DOWNTIME_DETAILS 10 0
T_DOWNTIME_DETAILS_TIMEZONES 5 0
T_GPS_POWER_USERS_VIEW 2 view
T_PORTAL_COMPATIBILITY_CHECK 7 1,106
T_ROLE_RELATIONS 2 2 2
T_ROLES 5 7 2,183
T_SSO_CLIENT 4 0
T_SSO_REQUEST 7 0
T_USER_INVALID_ATTEMPTS 1 4 140
T_USER_INVALID_ATTEMPTS_AUDIT 1 4 826
T_USER_LOGIN_INFO 1 12 410,536
T_USER_PASSWORD_HISTORY 1 4 806
T_USER_PASSWORD_INFO 1 5 583
T_USER_PROPERTIES 1 4 633
T_USER_RELATIONS 2 2 0
T_USER_ROLES 2 4 7,255
T_USER_ROLES_V 7 view
T_USERNAME_CONFIGURATION 1 1
T_USERS 12 38 1,353
T_USERS_EMAILS 3 0
T_USERS_PROP_DETAILS 1 4 1,333
T_USERS_ROLES 2 view
T_WEEK_PASSWORDS 2 15
TEST123 2 0
XML_TEST 2 0
           
27 Tables     164 426,824  
5 Views     15