reference_trader_labels

469877 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ref_id int4 10 √ null
flows_references.id reference_trader_labels_ref_id_fkey R
trader_id int4 10 √ null
nodes.id reference_trader_labels_trader_id_fkey R
label_id int4 10 √ null
nodes.id reference_trader_labels_label_id_fkey R

Check Constraints

Constraint Name Constraint
check_reference_label_label_type ((get_node_type((label_id)::bigint) = 'TRADER'::text))
check_reference_label_trader_level ((get_node_level((trader_id)::bigint) = 1))
check_reference_label_label_level ((get_node_level((label_id)::bigint) = 2))
check_reference_label_trader_type ((get_node_type((trader_id)::bigint) = 'TRADER'::text))

Relationships

Close relationships within degrees of separation