reference_work

757 rows


Description

Reference work

Columns

Column Type Size Nulls Auto Default Children Parents Comments
reference_id serial 10 √ nextval('reference_work_reference_id_seq'::regclass)
alternate_num.reference_id reference_work_alternate_num_fk R
analyte_determination.reference_id reference_work_analyte_determination_fk R
author.reference_id reference_work_author_fk R
dic_ana_method.reference_id reference_work_dic_analysis_method_fk R
dic_exp_method.reference_id reference_work_dic_exp_method_fk R
dic_proxy.reference_id reference_work_dic_proxy_fk R
interpreted_age.reference_id reference_work_interpreted_age_fk R
project_citation.reference_id reference_work_project_citation_fk R
proxy_published.reference_id reference_work_proxy_published_fk R

PK. Unique identifier for reference work. Generated by database.
is_published bool 1 null

Notes if reference work has been published.
pub_year varchar 25 √ null

Year of publication.
title varchar 1000 √ null

Title of reference work.
pages varchar 50 √ null

Page numbers of reference work.
volume varchar 10 √ null

Volume number of reference work.
reference_type varchar 100 null

Type of reference work in Zotero reference software format e.g. journalArticle, dataset, thesis, report, book, bookSection.
url varchar 1000 √ null

URL for the reference work.
doi varchar 4000 √ null

Digital object identifier e.g. 10.1000/182
reference_notes varchar 4000 √ null

Notes about the reference
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 √ now()
book_title varchar 1000 √ null

Title of book or report
journal_id int4 10 √ null
dic_publication.publication_id dic_journal_reference_work_fk R

FK. ID for the journal. Links to the dic_journal table.
article_num varchar 100 √ null

Article number
issue varchar 25 √ null

Issue
series varchar 250 √ null

Series
series_number varchar 25 √ null

Series number
conference_name varchar 500 √ null

Conference name
isbn varchar 250 √ null

International Standard Book Number
book_publisher varchar 500 √ null

Book publisher
book_pub_place varchar 250 √ null

Publishing location
thesis_university varchar 500 √ null

University where thesis was completed
thesis_type varchar 10 √ null

Thesis type (PhD, MSc, BA, BSc)

Indexes

Constraint Name Type Sort Column(s)
reference_id Primary key Asc reference_id

Relationships

Close relationships within degrees of separation