links

63163 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('links_id_seq'::regclass)
link_inds.link_id link_inds_link_id_fkey C
link_paths.link_id link_paths_link_id_fkey C
link_quals.link_id link_quals_link_id_fkey C
link_quants.link_id link_quants_link_id_fkey C
time_start timestamp 29,6 √ null
time_end timestamp 29,6 √ null
ref_id int4 10 √ null
links_references.id links_ref_id_fkey R
raw_id int4 10 √ null
commodities.id links_com_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
links_pkey Primary key Asc id
links_ref_id_idx Performance Asc ref_id
links_ref_id_time_start_idx Performance Asc/Asc ref_id + time_start

Relationships

Close relationships within degrees of separation