Navigation Tree

Native PostgreSQL Schema Script: postgres.sql - System objects

Last modified 07 Jul 2026 08:05 UTC

Table of Contents

Tables
Triggers

Back to native PostgreSQL schema overview

Back to postgres.sql documentation

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

Region: System objects

Node, system configuration, security policy, and other system-level repository objects.

Tables

`m_node`

Stores midPoint cluster node objects.

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

Inherits from: m_assignment_holder

Columns

Column Type Required / constraints Description

Column	Type	Required / constraints	Description
`oid`	`UUID`	primary key, required	Node object identifier.
`objectType`	`ObjectType`
`nodeIdentifier`	`TEXT`		Node identifier used by the cluster.
`operationalState`	`NodeOperationalStateType`		Operational state of the node.

oid

UUID

primary key, required

Node object identifier.

objectType

ObjectType

nodeIdentifier

TEXT

Node identifier used by the cluster.

operationalState

NodeOperationalStateType

Operational state of the node.

Indexes

Name Columns Purpose / notes

Name	Columns	Purpose / notes
`m_node_nameOrig_idx`	`nameOrig`	Speeds up lookup by original object name. Used for: original name searches
`m_node_nameNorm_key`	`nameNorm`	Enforces unique normalized object names and speeds up exact name lookup. Used for: normalized name lookup and uniqueness checks. unique

m_node_nameOrig_idx

nameOrig

Speeds up lookup by original object name. Used for: original name searches

m_node_nameNorm_key

nameNorm

Enforces unique normalized object names and speeds up exact name lookup. Used for: normalized name lookup and uniqueness checks. unique

Foreign keys

Column References

Column	References
`oid`	`m_object_oid.oid`

oid

m_object_oid.oid

`m_security_policy`

Stores security policy objects.

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

Inherits from: m_assignment_holder

Columns

Column Type Required / constraints Description

Column	Type	Required / constraints	Description
`oid`	`UUID`	primary key, required	Security policy object identifier.
`objectType`	`ObjectType`

oid

UUID

primary key, required

Security policy object identifier.

objectType

ObjectType

Indexes

Name Columns Purpose / notes

Name	Columns	Purpose / notes
`m_security_policy_nameOrig_idx`	`nameOrig`	Speeds up lookup by original object name. Used for: original name searches
`m_security_policy_nameNorm_key`	`nameNorm`	Enforces unique normalized object names and speeds up exact name lookup. Used for: normalized name lookup and uniqueness checks. unique
`m_security_policy_subtypes_idx`	`USING gin (subtypes)`	Speeds up filtering by object subtype. Used for: subtype filters
`m_security_policy_policySituation_idx`	`USING gin (policysituations)`	Speeds up filtering by policy situation. Used for: policy situation filters
`m_security_policy_fullTextInfo_idx`	`USING gin (fullTextInfo)`	Speeds up full-text-like object searches. Used for: full-text-like object searches
`m_security_policy_createTimestamp_idx`	`createTimestamp`	Speeds up filtering or ordering by creation time. Used for: creation time filters and ordering
`m_security_policy_modifyTimestamp_idx`	`modifyTimestamp`	Speeds up filtering or ordering by modification time. Used for: modification time filters and ordering

m_security_policy_nameOrig_idx

nameOrig

Speeds up lookup by original object name. Used for: original name searches

m_security_policy_nameNorm_key

nameNorm

Enforces unique normalized object names and speeds up exact name lookup. Used for: normalized name lookup and uniqueness checks. unique

m_security_policy_subtypes_idx

USING gin (subtypes)

Speeds up filtering by object subtype. Used for: subtype filters

m_security_policy_policySituation_idx

USING gin (policysituations)

Speeds up filtering by policy situation. Used for: policy situation filters

m_security_policy_fullTextInfo_idx

USING gin (fullTextInfo)

Speeds up full-text-like object searches. Used for: full-text-like object searches

m_security_policy_createTimestamp_idx

createTimestamp

Speeds up filtering or ordering by creation time. Used for: creation time filters and ordering

m_security_policy_modifyTimestamp_idx

modifyTimestamp

Speeds up filtering or ordering by modification time. Used for: modification time filters and ordering

Foreign keys

Column References

Column	References
`oid`	`m_object_oid.oid`

oid

m_object_oid.oid

`m_system_configuration`

Stores the system configuration object.

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

Inherits from: m_assignment_holder

Columns

Column Type Required / constraints Description

Column	Type	Required / constraints	Description
`oid`	`UUID`	primary key, required	System configuration object identifier.
`objectType`	`ObjectType`

oid

UUID

primary key, required

System configuration object identifier.

objectType

ObjectType

Indexes

Name Columns Purpose / notes

Name	Columns	Purpose / notes
`m_system_configuration_nameNorm_key`	`nameNorm`	Enforces unique normalized object names and speeds up exact name lookup. Used for: normalized name lookup and uniqueness checks. unique

m_system_configuration_nameNorm_key

nameNorm

Enforces unique normalized object names and speeds up exact name lookup. Used for: normalized name lookup and uniqueness checks. unique

Foreign keys

Column References

Column	References
`oid`	`m_object_oid.oid`

oid

m_object_oid.oid

Triggers

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

Trigger Description Table Executes

Trigger	Description	Table	Executes
`m_node_oid_delete_tr`	Removes the object OID registry entry when rows are deleted from `m_node`.	`m_node`	`delete_object_oid`
`m_node_oid_insert_tr`	Maintains the object OID registry when rows are inserted into `m_node`.	`m_node`	`insert_object_oid`
`m_node_update_tr`	Maintains object update metadata before rows are updated in `m_node`.	`m_node`	`before_update_object`
`m_security_policy_oid_delete_tr`	Removes the object OID registry entry when rows are deleted from `m_security_policy`.	`m_security_policy`	`delete_object_oid`
`m_security_policy_oid_insert_tr`	Maintains the object OID registry when rows are inserted into `m_security_policy`.	`m_security_policy`	`insert_object_oid`
`m_security_policy_update_tr`	Maintains object update metadata before rows are updated in `m_security_policy`.	`m_security_policy`	`before_update_object`
`m_system_configuration_oid_delete_tr`	Removes the object OID registry entry when rows are deleted from `m_system_configuration`.	`m_system_configuration`	`delete_object_oid`
`m_system_configuration_oid_insert_tr`	Maintains the object OID registry when rows are inserted into `m_system_configuration`.	`m_system_configuration`	`insert_object_oid`
`m_system_configuration_update_tr`	Maintains object update metadata before rows are updated in `m_system_configuration`.	`m_system_configuration`	`before_update_object`