Table: citations
Legend: Primary key columns Indexed columns
Column Type Size Nulls Auto Default References Comments
id bigserial 19  χ   √  nextval('citations_id_seq'::regclass)
author varchar 255  χ   χ  last name of first author
year int4 10  χ   χ  year of publication
title varchar 255  χ   χ  article title
journal varchar 255  χ   χ  ''::character varying Journal name
vol int4 10  √   χ  null
pg varchar 255  χ   χ  ''::character varying page range of article
url varchar 512  χ   χ  ''::character varying link to article url
pdf varchar 255  χ   χ  ''::character varying link to pdf version of article
created_at timestamp 29,6  √   χ  utc_now()
updated_at timestamp 29,6  √   χ  utc_now()
doi varchar 255  χ   χ  ''::character varying Digital Object Identifier
user_id int8 19  √   χ  null
Column(s) Type Sort Constraint Name
id Primary key Asc citations_pkey
user_id Performance Asc index_citations_on_user_id