flows_references

445 rows


Description

Dataset references

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('refs_id_seq'::regclass)
flows.ref_id flows_ref_id_fkey R
flows_references.other_parent_ref_id refs_other_parent_ref_id_fkey R
flows_references.parent_ref_id refs_parent_ref_id_fkey R
reference_group_traders.ref_id reference_group_traders_ref_id_fkey R
reference_node_roles.ref_id reference_node_roles_ref_id_fkey C
reference_trader_labels.ref_id reference_trader_labels_ref_id_fkey R
release_flows_references.ref_id release_refs_ref_id_fkey R
description text 2147483647 √ null
country_id int8 19 √ null
nodes.id refs_country_id_fkey R
com_id int4 10 √ null
commodities.id refs_com_id_fkey R
version text 2147483647 √ null
latest bool 1 √ null
parent_ref_id int4 10 √ null
flows_references.id refs_parent_ref_id_fkey R
version_type version_type 2147483647 √ null
commodity_equivalence_group_id int4 10 √ null
commodity_equivalence_groups.id refs_commodity_equivalence_group_id_fkey R
other_parent_ref_id int4 10 √ null
flows_references.id refs_other_parent_ref_id_fkey R
updated timestamptz 35,6 √ null
suffix text 2147483647 √ ''::text
title text 2147483647 √ get_generated_title(country_id, com_id, version, version_type, suffix)

Indexes

Constraint Name Type Sort Column(s)
refs_pkey Primary key Asc id
unique_flows_reference_when_version_type_not_null Must be unique Asc/Asc/Asc/Asc/Asc country_id + com_id + version + version_type + suffix
unique_flows_reference_when_version_type_null Must be unique Asc/Asc/Asc/Asc country_id + com_id + version + suffix
unique_suffix_when_all_null Must be unique Asc suffix

Check Constraints

Constraint Name Constraint
parent_is_not_self ((id <> parent_ref_id))
only_full_latest ( CASE WHEN (version_type <> 'FULL'::version_type) THEN (NOT latest) ELSE true END)
suffix_must_be_uppercase ((upper(suffix) = suffix))
flow_version_not_null_if_latest ( CASE WHEN latest THEN (version IS NOT NULL) ELSE true END)
unique_version_type ( CASE WHEN ((version IS NOT NULL) AND (version_type IS NOT NULL)) THEN (NOT context_already_has_version_type(id, country_id, com_id, version, version_type)) ELSE true END)
commodity_is_primary (commodity_is_primary(com_id))

Relationships

Close relationships within degrees of separation