Native PostgreSQL Schema Script: postgres.sql - Focus and users
This page documents schema objects parsed from config/sql/native/postgres.sql.
Region: Focus and users
Focus base data, users, generic objects, focus identities, and focus-related references.
Tables
m_focus
Abstract base table for focus objects such as users, roles, services, and organizations.
XSD type: http://midpoint.evolveum.com/xml/ns/public/common/common-3#FocusType
Inherits from: m_assignment_holder
No primary key is defined directly on this table. The table inherits from m_assignment_holder.
Columns
| Column | Type | Required / constraints | Description |
|---|---|---|---|
|
|
required |
|
|
|
Cost center value used by focus objects. |
|
|
|
Primary email address of the focus object. |
|
|
|
Binary photo data for the focus object. |
|
|
|
Locale preference of the focus object. |
|
|
|
Original locality value. |
|
|
|
Normalized locality value used for searches. |
|
|
|
Preferred language of the focus object. |
|
|
|
Telephone number of the focus object. |
|
|
|
Timezone preference of the focus object. |
|
|
|
Time when password credentials were created. |
|
|
|
Time when password credentials were last modified. |
|
|
|
Administrative activation status. |
|
|
|
Effective activation status. |
|
|
|
Time when the focus becomes enabled. |
|
|
|
Time when the focus becomes disabled. |
|
|
|
Reason for disabling the focus. |
|
|
|
Validity interval status. |
|
|
|
Start of the focus validity interval. |
|
|
|
End of the focus validity interval. |
|
|
|
Time when validity state last changed. |
|
|
|
Time when the focus was archived. |
|
|
|
Lockout status for focus credentials. |
|
|
|
Normalized focus data used by repository search and correlation features. |
m_focus_identity
Stores focus identity values used by correlation and identity matching.
XSD type: http://midpoint.evolveum.com/xml/ns/public/common/common-3#FocusIdentityType
Inherits from: m_container
Columns
| Column | Type | Required / constraints | Description |
|---|---|---|---|
|
|
primary key, required |
OID of the focus object that owns the identity value. |
|
|
||
|
|
Serialized focus identity value. |
|
|
|
OID of the source resource reference for this identity value. |
Indexes
| Name | Columns | Purpose / notes |
|---|---|---|
|
|
Speeds up lookup of focus identities by source resource. Used for: focus identity source-resource searches |
Foreign keys
| Column | References | Notes |
|---|---|---|
|
ON DELETE CASCADE |
m_generic_object
Stores generic objects that do not have a dedicated concrete repository table.
XSD type: http://midpoint.evolveum.com/xml/ns/public/common/common-3#GenericObjectType
Inherits from: m_focus
Columns
| Column | Type | Required / constraints | Description |
|---|---|---|---|
|
|
primary key, required |
Generic object identifier. |
|
|
Indexes
| Name | Columns | Purpose / notes |
|---|---|---|
|
|
Speeds up lookup by original object name. Used for: original name searches |
|
|
Enforces unique normalized object names and speeds up exact name lookup. Used for: normalized name lookup and uniqueness checks. unique |
|
|
Speeds up filtering by object subtype. Used for: subtype filters |
|
|
Speeds up filtering by activation validity start time. Used for: validity interval filters |
|
|
Speeds up filtering by activation validity end time. Used for: validity interval filters |
|
|
Speeds up full-text-like object searches. Used for: full-text-like object searches |
|
|
Speeds up filtering or ordering by creation time. Used for: creation time filters and ordering |
|
|
Speeds up filtering or ordering by modification time. Used for: modification time filters and ordering |
Foreign keys
| Column | References |
|---|---|
|
m_ref_persona
Stores persona references for focus objects.
Inherits from: m_reference
Columns
| Column | Type | Required / constraints | Description |
|---|---|---|---|
|
|
primary key, required |
OID of the focus object that owns the persona reference. |
|
|
Indexes
| Name | Columns | Purpose / notes |
|---|---|---|
|
|
Speeds up reverse lookup of persona references by target object and relation. Used for: persona reference target searches |
Foreign keys
| Column | References | Notes |
|---|---|---|
|
ON DELETE CASCADE |
m_ref_projection
Stores projection references from focus objects to resource object shadows.
Inherits from: m_reference
Columns
| Column | Type | Required / constraints | Description |
|---|---|---|---|
|
|
primary key, required |
OID of the focus object that owns the projection reference. |
|
|
||
|
|
Serialized reference value when full projection reference data is needed. |
Indexes
| Name | Columns | Purpose / notes |
|---|---|---|
|
|
Speeds up reverse lookup of projection references by target object and relation. Used for: projection reference target searches |
Foreign keys
| Column | References | Notes |
|---|---|---|
|
ON DELETE CASCADE |
m_user
Stores user objects and user-specific searchable attributes.
XSD type: http://midpoint.evolveum.com/xml/ns/public/common/common-3#UserType
Inherits from: m_focus
Columns
| Column | Type | Required / constraints | Description |
|---|---|---|---|
|
|
primary key, required |
User object identifier. |
|
|
||
|
|
Additional name in original form. |
|
|
|
Additional name in normalized form used for searches. |
|
|
|
Display name in original form. |
|
|
|
Display name in normalized form used for searches. |
|
|
|
Employee number assigned to the user. |
|
|
|
Family name in original form. |
|
|
|
Family name in normalized form used for searches. |
|
|
|
Full name in original form. |
|
|
|
Full name in normalized form used for searches. |
|
|
|
Given name in original form. |
|
|
|
Given name in normalized form used for searches. |
|
|
|
Honorific prefix in original form. |
|
|
|
Honorific prefix in normalized form used for searches. |
|
|
|
Honorific suffix in original form. |
|
|
|
Honorific suffix in normalized form used for searches. |
|
|
|
Nickname in original form. |
|
|
|
Nickname in normalized form used for searches. |
|
|
|
Personal number assigned to the user. |
|
|
|
Preferred name in original form. |
|
|
|
Preferred name in normalized form used for searches. |
|
|
|
Title in original form. |
|
|
|
Title in normalized form used for searches. |
|
|
|
Organization values stored as searchable poly-string JSON data. |
|
|
|
Organizational unit values stored as searchable poly-string JSON data. |
Indexes
| Name | Columns | Purpose / notes |
|---|---|---|
|
|
Speeds up lookup by original object name. Used for: original name searches |
|
|
Enforces unique normalized object names and speeds up exact name lookup. Used for: normalized name lookup and uniqueness checks. unique |
|
|
Speeds up filtering by policy situation. Used for: policy situation filters |
|
|
Speeds up filtering by indexed extension values. Used for: extension item filters |
|
|
Speeds up lookup by display name. Used for: display name searches |
|
|
Speeds up lookup by original full name. Used for: full name searches |
|
|
Speeds up lookup by original family name. Used for: family name searches |
|
|
Speeds up lookup by original given name. Used for: given name searches |
|
|
Speeds up lookup by employee number. Used for: employee number searches |
|
|
Speeds up lookup by preferred name. Used for: preferred name searches |
|
|
Speeds up filtering by object subtype. Used for: subtype filters |
|
|
Speeds up filtering by organization values. Used for: organization filters |
|
|
Speeds up filtering by organizational unit values. Used for: organizational unit filters |
|
|
Speeds up filtering by activation validity start time. Used for: validity interval filters |
|
|
Speeds up filtering by activation validity end time. Used for: validity interval filters |
|
|
Speeds up full-text-like object searches. Used for: full-text-like object searches |
|
|
Speeds up filtering or ordering by creation time. Used for: creation time filters and ordering |
|
|
Speeds up filtering or ordering by modification time. Used for: modification time filters and ordering |
Foreign keys
| Column | References |
|---|---|
|
Triggers
Triggers run routines automatically when table rows are inserted, updated, or deleted.