folder_id

BIGINT

Primary key

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

begin_snapshot

BIGINT

Foreign key, NOT NULL

The snapshot associated with creating the shared directory, from the pga_snapshot metadata table.

end_snapshot

BIGINT

Foreign key

The snapshot associated with deleting the shared directory, from the pga_snapshot metadata table.

If the value is NULL, the shared directory is not deleted.

path

VARCHAR

NOT NULL

The path to the shared directory relative to the root storage directory.

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

folder_name

VARCHAR

NOT NULL

The shared directory name, for example, my_directory.

folder_name values are not UNIQUE because pgpro_metastore does not delete the metadata of shared directories. Deleted directories are associated with end_snapshot values to indicate that these directories can no longer be used.

This allows you to create a new shared directory with the same name as a previously deleted directory.

storage_id

BIGINT

Foreign key, NOT NULL

The ID of the storage that contains the shared directory, from the pga_storage metadata table.

proxy_table_id

BIGINT

NOT NULL, UNIQUE

The ID of the proxy table associated with the shared directory, from the pga_proxy_table metadata table.