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 from the pga_snapshot metadata table associated with the analytical schema creation date and time.

end_snapshot

BIGINT

Foreign key

The snapshot from the pga_snapshot metadata table associated with the analytical schema deletion date and time.

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.