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