Native PostgreSQL Schema Script: postgres.sql - Extension items
This page documents schema objects parsed from config/sql/native/postgres.sql.
Region: Extension items
Extension item catalog and indexed extension value storage support.
Tables
m_ext_item
Catalog of extension and attribute items indexed in JSON extension storage.
Columns
| Column | Type | Required / constraints | Description |
|---|---|---|---|
|
|
primary key, required |
Numeric extension item identifier used as key in JSON extension storage. |
|
|
required |
Extension or attribute item QName. |
|
|
required |
Value type QName. |
|
|
required |
Holder category for the indexed item. |
|
|
required |
Cardinality of indexed item values. |
Indexes
| Name | Columns | Purpose / notes |
|---|---|---|
|
|
Enforces unique extension item definitions and speeds up lookup during raw extension processing. Used for: extension item catalog lookup and uniqueness checks. unique |