Table cxgn.public.pub

A documented provenance artefact - publications,
documents, personal communication

 Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
pub_id serial 10  √  nextval('pub_pub_id_seq'::regclass)
cvterm_pub_ranking.pub_id cvterm_pub_ranking_pub_id_fkey
feature_cvterm.pub_id feature_cvterm_pub_id_fkey
feature_cvterm_pub.pub_id feature_cvterm_pub_pub_id_fkey
feature_pub.pub_id feature_pub_pub_id_fkey
feature_relationship_pub.pub_id feature_relationship_pub_pub_id_fkey
feature_relationshipprop_pub.pub_id feature_relationshipprop_pub_pub_id_fkey
feature_synonym.pub_id feature_synonym_pub_id_fkey
featureloc_pub.pub_id featureloc_pub_pub_id_fkey
featureprop_pub.pub_id featureprop_pub_pub_id_fkey
locus_pub_ranking.pub_id locus_pub_ranking_pub_id_fkey
locus_pub_ranking_validate.pub_id locus_pub_ranking_validate_pub_id_fkey
pub_curator.pub_id pub_curator_pub_id_fkey
pub_dbxref.pub_id pub_dbxref_pub_id_fkey
pub_relationship.object_id pub_relationship_object_id_fkey
pub_relationship.subject_id pub_relationship_subject_id_fkey
pubabstract.pub_id pubabstract_pub_id_fkey
pubauthor.pub_id pubauthor_pub_id_fkey
pubprop.pub_id pubprop_pub_id_fkey
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 range[s], eg, 457--459, viii + 664pp, lv--lvii
miniref varchar 255  √  null
uniquename text 2147483647
type_id int4 10
cvterm.cvterm_id pub_type_id_fkey
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

Table contained 12,944 rows at Wed May 20 01:40 EDT 2009

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

Close relationships  within one two degrees of separation :