part_config_sub


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sub_parent text 2147483647 null
part_config.parent_table part_config_sub_sub_parent_fkey C
sub_partition_type text 2147483647 null
sub_control text 2147483647 null
sub_partition_interval text 2147483647 null
sub_constraint_cols _text 2147483647 √ null
sub_premake int4 10 4
sub_optimize_trigger int4 10 4
sub_optimize_constraint int4 10 30
sub_epoch text 2147483647 'none'::text
sub_inherit_fk bool 1 true
sub_retention text 2147483647 √ null
sub_retention_schema text 2147483647 √ null
sub_retention_keep_table bool 1 true
sub_retention_keep_index bool 1 true
sub_infinite_time_partitions bool 1 false
sub_automatic_maintenance text 2147483647 'on'::text
sub_jobmon bool 1 true
sub_trigger_exception_handling bool 1 √ false
sub_upsert text 2147483647 ''::text
sub_trigger_return_null bool 1 true
sub_template_table text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
part_config_sub_pkey Primary key Asc sub_parent

Check Constraints

Constraint Name Constraint
part_config_sub_epoch_check (check_epoch_type(sub_epoch))
part_config_sub_type_check (check_partition_type(sub_partition_type))
retention_schema_not_empty_chk ((sub_retention_schema <> ''::text))
control_constraint_col_chk (((sub_constraint_cols @> ARRAY[sub_control]) <> true))
part_config_sub_automatic_maintenance_check (check_automatic_maintenance_value(sub_automatic_maintenance))
positive_premake_check ((premake > 0))

Relationships

Close relationships within degrees of separation