pub

1 rows


Description

A documented provenance artefact - publications, documents, personal communication

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pub_id serial 10 √ nextval('pub_pub_id_seq'::regclass)
bs_protocol_pub.pub_id bs_protocol_pub_pub_id_fkey R
bs_sample_pub.pub_id bs_sample_pub_pub_id_fkey R
bs_tool_pub.pub_id bs_tool_pub_pub_id_fkey R
ge_experimental_design_pub.pub_id ge_experimental_design_pub_pub_id_fkey R
ge_platform_pub.pub_id ge_platform_pub_pub_id_fkey R
cvterm_pub_ranking.pub_id cvterm_pub_ranking_pub_id_fkey R
locus_pub_ranking.pub_id locus_pub_ranking_pub_id_fkey R
locus_pub_ranking_validate.pub_id locus_pub_ranking_validate_pub_id_fkey R
pub_curator.pub_id pub_curator_pub_id_fkey R
feature_cvterm.pub_id feature_cvterm_pub_id_fkey C
feature_cvterm_pub.pub_id feature_cvterm_pub_pub_id_fkey C
feature_pub.pub_id feature_pub_pub_id_fkey C
feature_relationship_pub.pub_id feature_relationship_pub_pub_id_fkey C
feature_relationshipprop_pub.pub_id feature_relationshipprop_pub_pub_id_fkey C
feature_synonym.pub_id feature_synonym_pub_id_fkey C
featureloc_pub.pub_id featureloc_pub_pub_id_fkey C
featureprop_pub.pub_id featureprop_pub_pub_id_fkey C
nd_experiment_pub.pub_id nd_experiment_pub_pub_id_fkey C
phendesc.pub_id phendesc_pub_id_fkey C
phenotype_comparison.pub_id phenotype_comparison_pub_id_fkey C
phenotype_comparison_cvterm.pub_id phenotype_comparison_cvterm_pub_id_fkey C
phenstatement.pub_id phenstatement_pub_id_fkey C
phylonode_pub.pub_id phylonode_pub_pub_id_fkey C
phylotree_pub.pub_id phylotree_pub_pub_id_fkey C
project_pub.pub_id project_pub_pub_id_fkey C
pub_dbxref.pub_id pub_dbxref_pub_id_fkey C
pub_relationship.object_id pub_relationship_object_id_fkey C
pub_relationship.subject_id pub_relationship_subject_id_fkey C
pubabstract.pub_id pubabstract_pub_id_fkey C
pubauthor.pub_id pubauthor_pub_id_fkey C
pubprop.pub_id pubprop_pub_id_fkey C
stock_cvterm.pub_id stock_cvterm_pub_id_fkey C
stock_pub.pub_id stock_pub_pub_id_fkey C
stock_relationship_cvterm.pub_id stock_relationship_cvterm_pub_id_fkey R
stock_relationship_pub.pub_id stock_relationship_pub_pub_id_fkey C
stockprop_pub.pub_id stockprop_pub_pub_id_fkey C
title text 2147483647 √ null

descriptive general heading
volumetitle text 2147483647 √ null

title of part if one of a series
volume varchar 255 √ null
series_name varchar 255 √ null

full name of (journal) series
issue varchar 255 √ null
pyear varchar 255 √ null
pages varchar 255 √ null

page number ranges, eg, 457–459, viii + 664pp, lv–lvii
miniref varchar 255 √ null
uniquename text 2147483647 null
type_id int4 10 null
cvterm.cvterm_id pub_type_id_fkey C

the type of the publication (book, journal, poem, graffiti, etc). Uses pub cv
is_obsolete bool 1 √ false
publisher varchar 255 √ null
pubplace varchar 255 √ null
title_tsvector tsvector 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
pub_pkey Primary key Asc pub_id
pub_c1 Must be unique Asc uniquename
pub_idx1 Performance Asc type_id

Relationships

Close relationships within degrees of separation