| 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 | |
| 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 | users.id |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| id | Primary key | Asc | citations_pkey |
| user_id | Performance | Asc | index_citations_on_user_id |
|
