Navigation Tree

Native PostgreSQL Schema Script: postgres.sql - Marks

Last modified 07 Jul 2026 08:05 UTC

Table of Contents

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

Region: Marks

Mark objects used to classify and annotate repository objects and events.

Tables

Stores mark objects used to classify and annotate repository objects and events.

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

Column Type Required / constraints Description

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

oid

UUID

primary key, required

Mark 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_mark_oid_delete_tr`	Removes the object OID registry entry when rows are deleted from `m_mark`.	`m_mark`	`delete_object_oid`
`m_mark_oid_insert_tr`	Maintains the object OID registry when rows are inserted into `m_mark`.	`m_mark`	`insert_object_oid`
`m_mark_update_tr`	Maintains object update metadata before rows are updated in `m_mark`.	`m_mark`	`before_update_object`