config_data__t


Columns

Column Type Size Nulls Auto Default Children Parents Comments
__id int8 19 √ null
__cf bool 1 true
__start timestamptz 35,6 null
__source varchar 63 null
__origin varchar 63 ''::character varying
id uuid 2147483647 null
audit_config_data.id Implied ConstraintR
audit_config_data__t.id Implied ConstraintR
config_data.id Implied ConstraintR
invoices__t.bill_to invoices__t_bill_to_fkeyR
order_templates__t.bill_to order_templates__t_bill_to_fkeyR
order_templates__t.ship_to order_templates__t_ship_to_fkeyR
purchase_order__t.bill_to purchase_order__t_bill_to_fkeyR
purchase_order__t.ship_to purchase_order__t_ship_to_fkeyR
config_name varchar 55 √ null
value varchar 2796 √ null
module varchar 22 √ null
enabled bool 1 √ null
default bool 1 √ null
description varchar 37 √ null
code varchar 31 √ null

Indexes

Constraint Name Type Sort Column(s)
config_data__t_pkey Primary key Asc id
config_data__t___origin_idx Performance Asc __origin
config_data__t___source_idx Performance Asc __source
config_data__t___start_idx Performance Asc __start
config_data__t_code_idx Performance Asc code
config_data__t_config_name_idx Performance Asc config_name
config_data__t_default_idx Performance Asc default
config_data__t_description_idx Performance Asc description
config_data__t_enabled_idx Performance Asc enabled
config_data__t_id_idx Performance Asc id
config_data__t_module_idx Performance Asc module

Relationships

Close relationships within degrees of separation