trader_labels

1082795 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
trader_id int8 19 √ null
nodes.id trader_labels_trader_id_fkey C
label_id int8 19 √ null
nodes.id trader_labels_label_id_fkey C

Indexes

Constraint Name Type Sort Column(s)
trader_labels_label_id_idx Performance Asc label_id
trader_labels_trader_id_idx Performance Asc trader_id
trader_labels_trader_id_label_id_idx Must be unique Asc/Asc trader_id + label_id

Check Constraints

Constraint Name Constraint
trader_labels_trader_id_check ((get_node_level(trader_id) = 1))
trader_labels_label_id_check ((get_node_level(label_id) = 2))

Relationships

Close relationships within degrees of separation