reference_work

189 rows


Description

Reference work, may be published or unpublished.

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_fkR
analyte_determination.reference_id reference_work_analyte_determination_fkR
author.reference_id reference_work_author_fkR
dic_ana_method.reference_id reference_work_dic_analysis_method_fkR
dic_exp_method.reference_id reference_work_dic_exp_method_fkR
dic_proxy.reference_id reference_work_dic_proxy_fkR
interpreted_age.reference_id reference_work_interpreted_age_fkR
project_citation.reference_id reference_work_project_citation_fkR
proxy_published.reference_id reference_work_proxy_published_fkR

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 e.g. Journal article, PhD dissertation.
url varchar 1000 √ null

Link to reference work.
doi varchar 4000 √ null

Digital object identifier.
reference_notes varchar 4000 √ null
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 √ now()
book_title varchar 1000 √ null

Title of book.
journal_id int4 10 √ null
dic_publication.publication_id dic_journal_reference_work_fkR

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

Indexes

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

Relationships

Close relationships within degrees of separation