Native PostgreSQL Schema Script: postgres.sql - References
This page documents schema objects parsed from config/sql/native/postgres.sql.
Region: References
Tables storing object and container references such as archetype, projection, role membership, and approver references.
Tables
m_ref_archetype
Stores archetype references assigned to assignment-holder objects.
Inherits from: m_reference
Columns
| Column | Type | Required / constraints | Description |
|---|---|---|---|
|
|
primary key, required |
OID of the object that owns the archetype reference. |
|
|
Indexes
| Name | Columns | Purpose / notes |
|---|---|---|
|
|
Speeds up reverse lookup of archetype references by target object and relation. Used for: archetype reference target searches |
Foreign keys
| Column | References | Notes |
|---|---|---|
|
ON DELETE CASCADE |
m_ref_delegated
Stores delegated references for assignment-holder objects.
Inherits from: m_reference
Columns
| Column | Type | Required / constraints | Description |
|---|---|---|---|
|
|
primary key, required |
OID of the object that owns the delegated reference. |
|
|
Indexes
| Name | Columns | Purpose / notes |
|---|---|---|
|
|
Speeds up reverse lookup of delegated references by target object and relation. Used for: delegated reference target searches |
Foreign keys
| Column | References | Notes |
|---|---|---|
|
ON DELETE CASCADE |
m_ref_object_create_approver
Stores create-approver references from object metadata.
Inherits from: m_reference
Columns
| Column | Type | Required / constraints | Description |
|---|---|---|---|
|
|
primary key, required |
OID of the object that owns the create-approver reference. |
|
|
Indexes
| Name | Columns | Purpose / notes |
|---|---|---|
|
|
Speeds up reverse lookup of object create-approver references by target object and relation. Used for: object create-approver reference target searches |
Foreign keys
| Column | References | Notes |
|---|---|---|
|
ON DELETE CASCADE |
m_ref_object_effective_mark
Stores effective mark references attached to objects.
Inherits from: m_reference
Columns
| Column | Type | Required / constraints | Description |
|---|---|---|---|
|
|
primary key, required |
OID of the object that owns the effective mark reference. |
|
|
Indexes
| Name | Columns | Purpose / notes |
|---|---|---|
|
|
Speeds up reverse lookup of object effective mark references by target object and relation. Used for: effective mark reference target searches |
Foreign keys
| Column | References | Notes |
|---|---|---|
|
ON DELETE CASCADE |
m_ref_object_modify_approver
Stores modify-approver references from object metadata.
Inherits from: m_reference
Columns
| Column | Type | Required / constraints | Description |
|---|---|---|---|
|
|
primary key, required |
OID of the object that owns the modify-approver reference. |
|
|
Indexes
| Name | Columns | Purpose / notes |
|---|---|---|
|
|
Speeds up reverse lookup of object modify-approver references by target object and relation. Used for: object modify-approver reference target searches |
Foreign keys
| Column | References | Notes |
|---|---|---|
|
ON DELETE CASCADE |
m_ref_role_membership
Stores computed role membership references for assignment-holder objects.
Inherits from: m_reference
Columns
| Column | Type | Required / constraints | Description |
|---|---|---|---|
|
|
primary key, required |
OID of the object that owns the role membership reference. |
|
|
||
|
|
Serialized reference value when full reference data is needed. |
Indexes
| Name | Columns | Purpose / notes |
|---|---|---|
|
|
Speeds up reverse lookup of role membership references by target object and relation. Used for: role membership target searches |
Foreign keys
| Column | References | Notes |
|---|---|---|
|
ON DELETE CASCADE |