table_id

BIGINT

Primary key

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

table_uuid

UUID

NOT NULL, UNIQUE

The persistent analytical table ID stored for compatibility with Postgres Pro tables.

begin_snapshot

BIGINT

Foreign key, NOT NULL

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

end_snapshot

BIGINT

Foreign key

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

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

schema_id

BIGINT

NOT NULL, UNIQUE

The ID of the analytical schema from the pga_schema metadata table where the analytical table is created.

table_name

VARCHAR

NOT NULL

The analytical table name, for example, my_table.

table_name values are not UNIQUE because pgpro_metastore does not delete metadata of analytical tables. Deleted analytical tables are rather associated with end_snapshot values to indicate that these tables can no longer be used.

If table_name values were UNIQUE, you would not be able to create a new analytical table with the same name as a previously deleted table.

path

VARCHAR

NOT NULL, UNIQUE

The path to the shared directory relative to the uri value of the pga_storage metadata table.

The absolute path is generated by concatenating the uri value of the pga_storage metadata table and the path value of the pga_table metadata table.

storage_id

BIGINT

Foreign key, NOT NULL

The ID of the storage from the pga_storage metadata table where the analytical table is created.