node_quants

8856068 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
node_id int8 19 null
nodes.id node_quants_node_id_fkey R
quant_id int4 10 null
quants.id node_quants_quant_id_fkey R
value float8 17,17 null
time_start timestamp 29,6 √ null
time_end timestamp 29,6 √ null
ref_id int4 10 √ null
node_attributes_references.id node_quants_ref_id_fkey R
inherited bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
node_quants_node_id_quant_id_idx Performance Asc/Asc node_id + quant_id
node_quants_quant_id_ref_id_idx Performance Asc/Asc quant_id + ref_id
unique_node_quant Must be unique Asc/Asc/Asc/Asc/Asc node_id + quant_id + time_start + time_end + ref_id

Check Constraints

Constraint Name Constraint
only_trader_can_inherit_node_quants ( CASE WHEN (get_node_type(node_id) <> 'TRADER'::text) THEN (NOT inherited) ELSE true END)

Relationships

Close relationships within degrees of separation