reference_group_traders

199283 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ref_id int4 10 √ null
flows_references.id reference_group_traders_ref_id_fkey R
group_id int4 10 √ null
nodes.id reference_group_traders_group_id_fkey R
trader_id int4 10 √ null
nodes.id reference_group_traders_trader_id_fkey R

Check Constraints

Constraint Name Constraint
check_reference_group_trader_level ((get_node_level((trader_id)::bigint) = 1))
check_reference_group_group_type ((get_node_type((group_id)::bigint) = 'TRADER'::text))
check_reference_group_trader_type ((get_node_type((trader_id)::bigint) = 'TRADER'::text))
check_reference_group_group_level ((get_node_level((group_id)::bigint) = 0))

Relationships

Close relationships within degrees of separation