catalogs_custom_fields

78 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
catalogs_custom_fields_enums.custom_field_id catalogs_custom_fields_enums_custom_field_id_fkey R
catalogs_custom_fields_values_checkbox.custom_field_id catalogs_custom_fields_values_checkbox_custom_field_id_fkey R
catalogs_custom_fields_values_date.custom_field_id catalogs_custom_fields_values_date_custom_field_id_fkey R
catalogs_custom_fields_values_file.custom_field_id catalogs_custom_fields_values_file_custom_field_id_fkey R
catalogs_custom_fields_values_items.custom_field_id catalogs_custom_fields_values_items_custom_field_id_fkey R
catalogs_custom_fields_values_legal_entity.custom_field_id catalogs_custom_fields_values_legal_entity_custom_field_id_fkey R
catalogs_custom_fields_values_linked_entity.custom_field_id catalogs_custom_fields_values_linked_entit_custom_field_id_fkey R
catalogs_custom_fields_values_numeric.custom_field_id catalogs_custom_fields_values_numeric_custom_field_id_fkey R
catalogs_custom_fields_values_select.custom_field_id catalogs_custom_fields_values_select_custom_field_id_fkey R
catalogs_custom_fields_values_text.custom_field_id catalogs_custom_fields_values_text_custom_field_id_fkey R
catalog_id int4 10 null
catalogs.id catalogs_custom_fields_catalog_id R
name text 2147483647 null
code text 2147483647 √ null
type_id int2 5 null
custom_fields_types.id catalogs_custom_fields_type_id_fkey R
is_deleted bool 1 false

Indexes

Constraint Name Type Sort Column(s)
catalogs_custom_fields_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
catalogs_custom_fields_id_check ((id > 0))

Relationships

Close relationships within degrees of separation