Native PostgreSQL Schema Script: postgres.sql - Role analysis

Last modified 07 Jul 2026 08:05 UTC
Table of Contents

Back to native PostgreSQL schema overview

Back to postgres.sql documentation

This page documents schema objects parsed from config/sql/native/postgres.sql.

Region: Role analysis

Role analysis sessions, clusters, outliers, detected patterns, and related containers.

Tables

m_role_analysis_cluster

Stores role analysis cluster objects and their parent cluster references.

XSD type: http://midpoint.evolveum.com/xml/ns/public/common/common-3#RoleAnalysisClusterType

Inherits from: m_assignment_holder

Columns

Column Type Required / constraints Description

oid

UUID

primary key, required

Role analysis cluster object identifier.

objectType

ObjectType

parentRefTargetOid

UUID

OID of the parent cluster reference target.

parentRefTargetType

ObjectType

Object type of the parent cluster reference target.

parentRefRelationId

INTEGER

Relation URI identifier of the parent cluster reference.

Indexes

Name Columns Purpose / notes

m_role_analysis_cluster_parentRefTargetOid_idx

parentRefTargetOid

Speeds up lookup of role analysis clusters by parent reference target OID. Used for: role analysis cluster parent searches

m_role_analysis_cluster_parentRefTargetType_idx

parentRefTargetType

Speeds up filtering role analysis clusters by parent reference target type. Used for: role analysis cluster parent searches

m_role_analysis_cluster_parentRefRelationId_idx

parentRefRelationId

Speeds up filtering role analysis clusters by parent reference relation. Used for: role analysis cluster parent searches

Foreign keys

Column References

oid

m_object_oid.oid

parentRefRelationId

m_uri.id

m_role_analysis_cluster_detected_pattern

Stores detected role analysis patterns inside a role analysis cluster.

XSD type: http://midpoint.evolveum.com/xml/ns/public/common/common-3#DetectedPatternType

Inherits from: m_container

Columns

Column Type Required / constraints Description

ownerOid

UUID

primary key, required

OID of the role analysis cluster that owns the detected pattern.

containerType

ContainerType

reductionCount

double precision

Reduction count calculated for the detected pattern.

Indexes

Name Columns Purpose / notes

m_role_analysis_cluster_detected_pattern_reductionCount_idx

reductionCount

Speeds up filtering detected patterns by reduction count. Used for: role analysis detected pattern ranking and filters

Foreign keys

Column References Notes

ownerOid

m_object_oid.oid

ON DELETE CASCADE

m_role_analysis_outlier

Stores role analysis outlier objects and references to analyzed target objects.

XSD type: http://midpoint.evolveum.com/xml/ns/public/common/common-3#RoleAnalysisOutlierType

Inherits from: m_assignment_holder

Columns

Column Type Required / constraints Description

oid

UUID

primary key, required

Role analysis outlier object identifier.

objectType

ObjectType

targetObjectRefTargetOid

UUID

OID of the object identified as an outlier target.

targetObjectRefTargetType

ObjectType

Object type of the outlier target object.

targetObjectRefRelationId

INTEGER

Relation URI identifier of the outlier target reference.

overallConfidence

double precision

Overall confidence score calculated for the outlier.

Indexes

Name Columns Purpose / notes

m_role_analysis_outlier_targetObjectRefTargetOid_idx

targetObjectRefTargetOid

Speeds up lookup of role analysis outliers by target object OID. Used for: role analysis outlier target searches

m_role_analysis_outlier_targetObjectRefTargetType_idx

targetObjectRefTargetType

Speeds up filtering role analysis outliers by target object type. Used for: role analysis outlier target searches

m_role_analysis_outlier_targetObjectRefRelationId_idx

targetObjectRefRelationId

Speeds up filtering role analysis outliers by target reference relation. Used for: role analysis outlier target searches

m_role_analysis_outlier_overallConfidence_idx

overallConfidence

Speeds up filtering or ordering role analysis outliers by confidence score. Used for: role analysis outlier confidence filters and ordering

Foreign keys

Column References

oid

m_object_oid.oid

targetObjectRefRelationId

m_uri.id

m_role_analysis_outlier_partition

Stores partition data for role analysis outliers.

XSD type: http://midpoint.evolveum.com/xml/ns/public/common/common-3#RoleAnalysisOutlierPartitionType

Inherits from: m_container

Columns

Column Type Required / constraints Description

ownerOid

UUID

primary key, required

OID of the role analysis outlier that owns this partition row.

containerType

ContainerType

clusterRefOid

UUID

OID of the related role analysis cluster.

clusterRefTargetType

ObjectType

Object type of the related role analysis cluster.

clusterRefRelationId

INTEGER

Relation URI identifier of the cluster reference.

overallConfidence

double precision

Confidence score calculated for this outlier partition.

Indexes

Name Columns Purpose / notes

m_role_analysis_outlier_partition_clusterRefOid_idx

clusterRefOid

Speeds up lookup of outlier partitions by cluster OID. Used for: role analysis outlier partition cluster searches

m_role_analysis_outlier_partition_overallConfidence_idx

overallConfidence

Speeds up filtering or ordering outlier partitions by confidence score. Used for: role analysis outlier confidence filters and ordering

Foreign keys

Column References Notes

ownerOid

m_object_oid.oid

ON DELETE CASCADE

clusterRefRelationId

m_uri.id

-

m_role_analysis_session

Stores role analysis session objects.

XSD type: http://midpoint.evolveum.com/xml/ns/public/common/common-3#RoleAnalysisSessionType

Inherits from: m_assignment_holder

Columns

Column Type Required / constraints Description

oid

UUID

primary key, required

Role analysis session object identifier.

objectType

ObjectType

Foreign keys

Column References

oid

m_object_oid.oid

Triggers

Triggers run routines automatically when table rows are inserted, updated, or deleted.

Trigger Description Table Executes

m_role_analysis_cluster_oid_delete_tr

Removes the object OID registry entry when rows are deleted from m_role_analysis_cluster.

m_role_analysis_cluster

delete_object_oid

m_role_analysis_cluster_oid_insert_tr

Maintains the object OID registry when rows are inserted into m_role_analysis_cluster.

m_role_analysis_cluster

insert_object_oid

m_role_analysis_cluster_update_tr

Maintains object update metadata before rows are updated in m_role_analysis_cluster.

m_role_analysis_cluster

before_update_object

m_role_analysis_outlier_oid_delete_tr

Removes the object OID registry entry when rows are deleted from m_role_analysis_outlier.

m_role_analysis_outlier

delete_object_oid

m_role_analysis_outlier_oid_insert_tr

Maintains the object OID registry when rows are inserted into m_role_analysis_outlier.

m_role_analysis_outlier

insert_object_oid

m_role_analysis_outlier_update_tr

Maintains object update metadata before rows are updated in m_role_analysis_outlier.

m_role_analysis_outlier

before_update_object

m_role_analysis_session_oid_delete_tr

Removes the object OID registry entry when rows are deleted from m_role_analysis_session.

m_role_analysis_session

delete_object_oid

m_role_analysis_session_oid_insert_tr

Maintains the object OID registry when rows are inserted into m_role_analysis_session.

m_role_analysis_session

insert_object_oid

m_role_analysis_session_update_tr

Maintains object update metadata before rows are updated in m_role_analysis_session.

m_role_analysis_session

before_update_object
Was this page helpful?
YES NO
Thanks for your feedback