Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| table_schema | varchar | 32 | null |
|
|
|||
| table_name | varchar | 64 | null |
|
|
|||
| pk_column | varchar | 32 | null |
|
|
|||
| pk_column_idx | int4 | 10 | √ | null |
|
|
||
| pk_policy | varchar | 32 | √ | null |
|
|
||
| pk_sequence | varchar | 64 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| gt_pk_metadata_table_schema_table_name_pk_column_key | Must be unique | Asc/Asc/Asc | table_schema + table_name + pk_column |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| gt_pk_metadata_pk_policy_check | (((pk_policy)::text = ANY ((ARRAY['sequence'::character varying, 'assigned'::character varying, 'autogenerated'::character varying])::text[]))) |