Navigation Tree

Native PostgreSQL Schema Script: postgres.sql - Schema objects

Last modified 07 Jul 2026 08:05 UTC

Table of Contents

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

Region: Schema objects

Schema repository objects.

Tables

Stores schema objects.

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

Column Type Required / constraints Description

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

oid

UUID

primary key, required

Schema object identifier.

objectType

ObjectType

Column References

Column	References
`oid`	`m_object_oid.oid`

oid

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

Trigger Description Table Executes

Trigger	Description	Table	Executes
`m_schema_oid_delete_tr`	Removes the object OID registry entry when rows are deleted from `m_schema`.	`m_schema`	`delete_object_oid`
`m_schema_oid_insert_tr`	Maintains the object OID registry when rows are inserted into `m_schema`.	`m_schema`	`insert_object_oid`
`m_schema_update_tr`	Maintains object update metadata before rows are updated in `m_schema`.	`m_schema`	`before_update_object`