Table mob_odm2.odm2.citations Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
citationid serial 10  √  nextval('odm2.citations_citationid_seq'::regclass)
annotations.citationid fk_annotations_citations C
authorlists.citationid fk_authorlists_citations C
citationextensionpropertyvalues.citationid fk_citationextensionpropertyvalues_citations C
citationexternalidentifiers.citationid fk_citationexternalidentifiers_citations C
datasetcitations.citationid fk_datasetcitations_citations C
methodcitations.citationid fk_methodcitations_citations C
referencematerialvalues.citationid fk_referencematerialvalues_citations C
relatedcitations.citationid fk_relatedcitations_citations C
relatedcitations.relatedcitationid fk_relatedcitations_citations_arerelated C
specimentaxonomicclassifiers.citationid fk_specimentaxonomicclassifiers_citations C
title varchar 255
publisher varchar 255
publicationyear int4 10
citationlink varchar 255  √  null

Table contained 0 rows at Fri Mar 08 15:58 PST 2019

Indexes:
Column(s) Type Sort Constraint Name
citationid Primary key Asc citations_pkey

Close relationships  within of separation: