schema_id

BIGINT

Primary key

The analytical schema ID assigned by increasing the next_catalog_id value of the pga_snapshot metadata table.

schema_uuid

UUID

NOT NULL, UNIQUE

The persistent analytical schema ID stored for compatibility with Postgres Pro schemas.

begin_snapshot

BIGINT

Foreign key, NOT NULL

The snapshot associated with creating the analytical schema, from the pga_snapshot metadata table.

end_snapshot

BIGINT

Foreign key

The snapshot associated with deleting the analytical schema, from the pga_snapshot metadata table.

If the value is NULL, the analytical schema is not deleted.

schema_name

VARCHAR

NOT NULL, UNIQUE

The unique analytical schema name, for example, my_schema.

proxy_table_id

BIGINT

NOT NULL, UNIQUE

The ID of the proxy table associated with the analytical schema, from the pga_proxy_table metadata table.