flows

57028160 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('flows_id_seq'::regclass)
flow_inds.flow_id flow_inds_flow_id_fkey C
flow_paths.flow_id flow_paths_flow_id_fkey C
flow_quals.flow_id flow_quals_flow_id_fkey C
flow_quants.flow_id flow_quants_flow_id_fkey C
steps.flow_id steps_flow_id_fkey C
raw_id int4 10 √ null
commodities.id flows_raw_id_fkey R
raw_vol float8 17,17 √ null
ref_id int4 10 √ null
flows_references.id flows_ref_id_fkey R
time_start timestamp 29,6 √ null
time_end timestamp 29,6 √ null
com_eq_group_id int4 10 √ null
commodity_equivalence_groups.id flows_com_eq_group_ref_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
flows_pkey Primary key Asc id
flows_com_eq_group_id_idx Performance Asc com_eq_group_id
flows_ref_id_idx Performance Asc ref_id
flows_ref_id_time_start_idx Performance Asc/Asc ref_id + time_start

Check Constraints

Constraint Name Constraint
flow_commodity_equivalence_group_id_same_as_reference ((com_eq_group_id = get_reference_commodity_equivalence_group_id(ref_id)))

Relationships

Close relationships within degrees of separation