SchemaSpy Analysis of HLPDTEST.TAS Generated by
SchemaSpy
Generated by SchemaSpy on Mon Aug 19 01:28 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
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,149
T_USER_INVALID_ATTEMPTS 1 3 2
T_USER_INVALID_ATTEMPTS_AUDIT 1 4 53
T_USER_LOGIN_INFO 1 12 408,035
T_USER_PASSWORD_HISTORY 1 4 712
T_USER_PASSWORD_INFO 1 5 571
T_USER_PROPERTIES 1 4 622
T_USER_RELATIONS 2 2 0
T_USER_ROLES 2 4 7,189
T_USER_ROLES_V 7 view
T_USERNAME_CONFIGURATION 1 1
T_USERS 12 37 1,331
T_USERS_EMAILS 3 0
T_USERS_PROP_DETAILS 1 4 1,326
T_USERS_ROLES 2 view
T_WEEK_PASSWORDS 2 15
           
23 Tables     147 423,166  
4 Views     13