node_inds

3598799 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
node_id int8 19 null
nodes.id node_inds_node_id_fkey R
ind_id int4 10 null
inds.id node_inds_ind_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_inds_ref_id_fkey R
inherited bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
node_inds_ind_id_ref_id_idx Performance Asc/Asc ind_id + ref_id
node_inds_node_id_ind_id_idx Performance Asc/Asc node_id + ind_id
unique_node_ind Must be unique Asc/Asc/Asc/Asc/Asc node_id + ind_id + time_start + time_end + ref_id

Check Constraints

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

Relationships

Close relationships within degrees of separation