catalogs_elements

427 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
catalogs_custom_fields_values_checkbox.element_id catalogs_custom_fields_values_checkbox_element_id_fkey R
catalogs_custom_fields_values_date.element_id catalogs_custom_fields_values_date_element_id_fkey R
catalogs_custom_fields_values_file.element_id catalogs_custom_fields_values_file_element_id_fkey R
catalogs_custom_fields_values_items.element_id catalogs_custom_fields_values_items_element_id_fkey R
catalogs_custom_fields_values_legal_entity.element_id catalogs_custom_fields_values_legal_entity_element_id_fkey R
catalogs_custom_fields_values_linked_entity.element_id catalogs_custom_fields_values_linked_entity_element_id_fkey R
catalogs_custom_fields_values_numeric.element_id catalogs_custom_fields_values_numeric_element_id_fkey R
catalogs_custom_fields_values_select.element_id catalogs_custom_fields_values_select_element_id_fkey R
catalogs_custom_fields_values_text.element_id catalogs_custom_fields_values_text_element_id_fkey R
catalog_id int4 10 null
catalogs.id catalogs_elements_catalog_id_fkey R
name text 2147483647 null
created_by int4 10 null
updated_by int4 10 null
created_at timestamp 29,6 null
updated_at timestamp 29,6 null
is_deleted bool 1 false

Indexes

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

Check Constraints

Constraint Name Constraint
catalogs_elements_updated_by_check ((updated_by >= 0))
catalogs_elements_created_by_check ((created_by >= 0))

Relationships

Close relationships within degrees of separation