costs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
orig_id int8 19 √ null
nodes.id costs_orig_id_fkey R
dest_id int8 19 √ null
nodes.id costs_dest_id_fkey R
year int4 10 √ null
cost float8 17,17 √ null
ref_id int4 10 √ null
cost_refs.id costs_ref_id_fkey R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
costs_dest_id_idx Performance Asc dest_id
costs_orig_id_idx Performance Asc orig_id
costs_year_ref_id_idx Performance Asc/Asc year + ref_id
unique_orig_dest_ref_year Must be unique Asc/Asc/Asc/Asc orig_id + dest_id + year + ref_id

Relationships

Close relationships within degrees of separation