Navigation Tree

Native PostgreSQL Schema Script: postgres.sql - Templates and messages

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: Templates and messages

Object templates, include references, sequences, forms, function libraries, and message templates.

Tables

`m_form`

Stores custom form definitions.

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

Inherits from: m_assignment_holder

Columns

Column Type Required / constraints Description

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

oid

UUID

primary key, required

Form object identifier.

objectType

ObjectType

Indexes

Name Columns Purpose / notes

Name	Columns	Purpose / notes
`m_form_nameOrig_idx`	`nameOrig`	Speeds up lookup by original object name. Used for: original name searches
`m_form_nameNorm_key`	`nameNorm`	Enforces unique normalized object names and speeds up exact name lookup. Used for: normalized name lookup and uniqueness checks. unique
`m_form_subtypes_idx`	`USING gin (subtypes)`	Speeds up filtering by object subtype. Used for: subtype filters
`m_form_policySituation_idx`	`USING gin (policysituations)`	Speeds up filtering by policy situation. Used for: policy situation filters
`m_form_createTimestamp_idx`	`createTimestamp`	Speeds up filtering or ordering by creation time. Used for: creation time filters and ordering
`m_form_modifyTimestamp_idx`	`modifyTimestamp`	Speeds up filtering or ordering by modification time. Used for: modification time filters and ordering

m_form_nameOrig_idx

nameOrig

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

m_form_nameNorm_key

nameNorm

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

m_form_subtypes_idx

USING gin (subtypes)

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

m_form_policySituation_idx

USING gin (policysituations)

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

m_form_createTimestamp_idx

createTimestamp

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

m_form_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_function_library`

Stores function library objects used by expressions.

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

Inherits from: m_assignment_holder

Columns

Column Type Required / constraints Description

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

oid

UUID

primary key, required

Function library object identifier.

objectType

ObjectType

Indexes

Name Columns Purpose / notes

Name	Columns	Purpose / notes
`m_function_library_nameOrig_idx`	`nameOrig`	Speeds up lookup by original object name. Used for: original name searches
`m_function_library_nameNorm_key`	`nameNorm`	Enforces unique normalized object names and speeds up exact name lookup. Used for: normalized name lookup and uniqueness checks. unique
`m_function_library_subtypes_idx`	`USING gin (subtypes)`	Speeds up filtering by object subtype. Used for: subtype filters
`m_function_library_policySituation_idx`	`USING gin (policysituations)`	Speeds up filtering by policy situation. Used for: policy situation filters

m_function_library_nameOrig_idx

nameOrig

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

m_function_library_nameNorm_key

nameNorm

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

m_function_library_subtypes_idx

USING gin (subtypes)

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

m_function_library_policySituation_idx

USING gin (policysituations)

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

Foreign keys

Column References

Column	References
`oid`	`m_object_oid.oid`

oid

m_object_oid.oid

`m_message_template`

Stores reusable message templates for notifications and message transport.

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

Inherits from: m_assignment_holder

Columns

Column Type Required / constraints Description

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

oid

UUID

primary key, required

Message template object identifier.

objectType

ObjectType

Indexes

Name Columns Purpose / notes

Name	Columns	Purpose / notes
`m_message_template_nameOrig_idx`	`nameOrig`	Speeds up lookup by original object name. Used for: original name searches
`m_message_template_nameNorm_key`	`nameNorm`	Enforces unique normalized object names and speeds up exact name lookup. Used for: normalized name lookup and uniqueness checks. unique
`m_message_template_policySituation_idx`	`USING gin (policysituations)`	Speeds up filtering by policy situation. Used for: policy situation filters
`m_message_template_createTimestamp_idx`	`createTimestamp`	Speeds up filtering or ordering by creation time. Used for: creation time filters and ordering
`m_message_template_modifyTimestamp_idx`	`modifyTimestamp`	Speeds up filtering or ordering by modification time. Used for: modification time filters and ordering

m_message_template_nameOrig_idx

nameOrig

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

m_message_template_nameNorm_key

nameNorm

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

m_message_template_policySituation_idx

USING gin (policysituations)

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

m_message_template_createTimestamp_idx

createTimestamp

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

m_message_template_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_object_template`

Stores object template definitions.

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

Inherits from: m_assignment_holder

Columns

Column Type Required / constraints Description

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

oid

UUID

primary key, required

Object template identifier.

objectType

ObjectType

Indexes

Name Columns Purpose / notes

Name	Columns	Purpose / notes
`m_object_template_nameOrig_idx`	`nameOrig`	Speeds up lookup by original object name. Used for: original name searches
`m_object_template_nameNorm_key`	`nameNorm`	Enforces unique normalized object names and speeds up exact name lookup. Used for: normalized name lookup and uniqueness checks. unique
`m_object_template_subtypes_idx`	`USING gin (subtypes)`	Speeds up filtering by object subtype. Used for: subtype filters
`m_object_template_policySituation_idx`	`USING gin (policysituations)`	Speeds up filtering by policy situation. Used for: policy situation filters
`m_object_template_createTimestamp_idx`	`createTimestamp`	Speeds up filtering or ordering by creation time. Used for: creation time filters and ordering
`m_object_template_modifyTimestamp_idx`	`modifyTimestamp`	Speeds up filtering or ordering by modification time. Used for: modification time filters and ordering

m_object_template_nameOrig_idx

nameOrig

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

m_object_template_nameNorm_key

nameNorm

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

m_object_template_subtypes_idx

USING gin (subtypes)

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

m_object_template_policySituation_idx

USING gin (policysituations)

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

m_object_template_createTimestamp_idx

createTimestamp

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

m_object_template_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_ref_include`

Stores include references between object templates.

Inherits from: m_reference

Columns

Column Type Required / constraints Description

Column	Type	Required / constraints	Description
`ownerOid`	`UUID`	primary key, required	OID of the object template that owns the include reference.
`referenceType`	`ReferenceType`

ownerOid

UUID

primary key, required

OID of the object template that owns the include reference.

referenceType

ReferenceType

Indexes

Name Columns Purpose / notes

Name	Columns	Purpose / notes
`m_ref_include_targetOidRelationId_idx`	`targetOid, relationId`	Speeds up reverse lookup of include references by target object and relation. Used for: object template include reference searches

m_ref_include_targetOidRelationId_idx

targetOid, relationId

Speeds up reverse lookup of include references by target object and relation. Used for: object template include reference searches

Foreign keys

Column References Notes

Column	References	Notes
`ownerOid`	`m_object_oid.oid`	ON DELETE CASCADE

ownerOid

m_object_oid.oid

ON DELETE CASCADE

`m_sequence`

Stores sequence objects used for generated values.

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

Inherits from: m_assignment_holder

Columns

Column Type Required / constraints Description

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

oid

UUID

primary key, required

Sequence object identifier.

objectType

ObjectType

Indexes

Name Columns Purpose / notes

Name	Columns	Purpose / notes
`m_sequence_nameOrig_idx`	`nameOrig`	Speeds up lookup by original object name. Used for: original name searches
`m_sequence_nameNorm_key`	`nameNorm`	Enforces unique normalized object names and speeds up exact name lookup. Used for: normalized name lookup and uniqueness checks. unique
`m_sequence_subtypes_idx`	`USING gin (subtypes)`	Speeds up filtering by object subtype. Used for: subtype filters
`m_sequence_policySituation_idx`	`USING gin (policysituations)`	Speeds up filtering by policy situation. Used for: policy situation filters
`m_sequence_createTimestamp_idx`	`createTimestamp`	Speeds up filtering or ordering by creation time. Used for: creation time filters and ordering
`m_sequence_modifyTimestamp_idx`	`modifyTimestamp`	Speeds up filtering or ordering by modification time. Used for: modification time filters and ordering

m_sequence_nameOrig_idx

nameOrig

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

m_sequence_nameNorm_key

nameNorm

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

m_sequence_subtypes_idx

USING gin (subtypes)

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

m_sequence_policySituation_idx

USING gin (policysituations)

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

m_sequence_createTimestamp_idx

createTimestamp

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

m_sequence_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

Triggers

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

Trigger Description Table Executes

Trigger	Description	Table	Executes
`m_form_oid_delete_tr`	Removes the object OID registry entry when rows are deleted from `m_form`.	`m_form`	`delete_object_oid`
`m_form_oid_insert_tr`	Maintains the object OID registry when rows are inserted into `m_form`.	`m_form`	`insert_object_oid`
`m_form_update_tr`	Maintains object update metadata before rows are updated in `m_form`.	`m_form`	`before_update_object`
`m_function_library_oid_delete_tr`	Removes the object OID registry entry when rows are deleted from `m_function_library`.	`m_function_library`	`delete_object_oid`
`m_function_library_oid_insert_tr`	Maintains the object OID registry when rows are inserted into `m_function_library`.	`m_function_library`	`insert_object_oid`
`m_function_library_update_tr`	Maintains object update metadata before rows are updated in `m_function_library`.	`m_function_library`	`before_update_object`
`m_message_template_oid_delete_tr`	Removes the object OID registry entry when rows are deleted from `m_message_template`.	`m_message_template`	`delete_object_oid`
`m_message_template_oid_insert_tr`	Maintains the object OID registry when rows are inserted into `m_message_template`.	`m_message_template`	`insert_object_oid`
`m_message_template_update_tr`	Maintains object update metadata before rows are updated in `m_message_template`.	`m_message_template`	`before_update_object`
`m_object_template_oid_delete_tr`	Removes the object OID registry entry when rows are deleted from `m_object_template`.	`m_object_template`	`delete_object_oid`
`m_object_template_oid_insert_tr`	Maintains the object OID registry when rows are inserted into `m_object_template`.	`m_object_template`	`insert_object_oid`
`m_object_template_update_tr`	Maintains object update metadata before rows are updated in `m_object_template`.	`m_object_template`	`before_update_object`
`m_sequence_oid_delete_tr`	Removes the object OID registry entry when rows are deleted from `m_sequence`.	`m_sequence`	`delete_object_oid`
`m_sequence_oid_insert_tr`	Maintains the object OID registry when rows are inserted into `m_sequence`.	`m_sequence`	`insert_object_oid`
`m_sequence_update_tr`	Maintains object update metadata before rows are updated in `m_sequence`.	`m_sequence`	`before_update_object`