Tables


SchemaSpy Analysis of SSOQ

Generated on Wed Jun 12 11:11 WEST 2019

idmStaging.preprod.schemaspy.properties

XML Representation
Insertion Order Deletion Order
TABLES 29
VIEWS 19
COLUMNS 299
Constraints 13
Anomalies 14
Routines 38

Database Properties

Database Type: Oracle - Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options

Tables

Table / View Children Parents Columns Rows Type Comments
TMP_EOS_ROLES 0 0 6 68 Table
TMP_ORG_OPER 0 0 7 275 Table
TMP_ROL_PRV 0 0 5 1 Table
OPERATION_ORGANIZATION 0 2 5 42 Table
RELATIONSHIP_TRANSACTION 0 0 8 0 Table
PROFILE_ORGANIZATION 0 2 5 1228 Table
PROVISIONING_ENDPOINT 1 0 7 10 Table
ORGANIZATION 4 1 6 593 Table
ROLE 3 0 7 664 Table
AUXILIARY_ACTION 0 0 4 2201 Table
TMP_EOS_PRF_ROL 0 0 3 576 Table
PROFILE 2 0 8 614 Table
COUNTRY 1 0 8 274 Table
TMP_EOS_PROFILES 0 0 4 67 Table
TMP_PRF_ROL 0 0 4 1 Table
ENTITY_TRANSACTION 0 0 18 0 Table
SERVICE 1 0 6 19 Table
ROLE_PROVISIONING 0 2 6 896 Table
TMP_USR_PRFS 0 0 3 118 Table
TMP_USR_OPER 0 0 2 5 Table
TMP_OPERATION 0 0 2 21 Table
TMP_PROFILES 0 0 5 1 Table
TMP_USR 0 0 12 67 Table
ORGANIZATION_PARENT 0 2 5 0 Table
SECURITY_LEVEL 1 0 2 5 Table
TMP_ROLES 0 0 7 1 Table
OPERATION 1 0 6 34 Table
SERVICE_ROLE 0 2 5 664 Table
PROFILE_ROLE 0 2 5 1647 Table
OPR_ORGANIZATION 0 0 4 0 View
SRV_ENDPOINT 0 0 3 0 View
ROLE_V 0 0 8 0 View
OPERATION_ORGANIZATION_V 0 0 6 0 View
ORGANIZATION_V 0 0 7 0 View
SERVICE_V 0 0 7 0 View
PROFILE_V 0 0 8 0 View
PROFILE_ROLE_V 0 0 6 0 View
SERVICE_ROLE_V 0 0 6 0 View
OPERATION_V 0 0 7 0 View
PRF_ROL 0 0 4 0 View
SRV_PRF_ROL 0 0 6 0 View
PROFILE_ORGANIZATION_V 0 0 6 0 View
PROVISIONING_ROLES_BY_PROFILES 0 0 19 0 View
COUNTRY_V 0 0 9 0 View
PROVISIONING_ENDPOINT_V 0 0 8 0 View
ROLE_PROVISIONING_V 0 0 7 0 View
SECURITY_LEVEL_V 0 1 3 0 View
SRV_ROL 0 0 4 0 View