partition_id

BIGINT

Primary key, foreign key

The ID of the partition that contains the column, from the pga_partition_info metadata table.

column_id

BIGINT

Foreign key

The ID of the column from the pga_column metadata table.

table_id

BIGINT

Foreign key, NOT NULL

The ID of the analytical table that contains the column, from the pga_table metadata table.

partition_key_index

BIGINT

NOT NULL

The sequence number of the column in the partition beginning with 0.

For example, if a partition contains columns A, B, and C, the partition_key_index value for the column B is 1.