RelatedCitations - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: RelatedCitations

Information about relationships among citations

Columns

PKNameData TypeNULLAutoDefaultCommentFK

RelationIDInteger

nextval('"ODMXProvenance"."RelatedCitations_RelationID_seq"'::regclass)Primary key for a relationship table (i.e. named "Related...").
CitationIDInteger Foreign key identifier for a Citation

RelationshipTypeCVVarChar() CV term describing the relationship between Citations (e.g., "IsSupplementTo" or "IsPartOf"), largely conforming to CV used by DataCite.org.

RelatedCitationIDInteger Foreign key identifier for a Citation that is related to the Citation identified by CitationID


Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_RelatedCitations_CitationsODMXProvenance.CitationsODMXProvenance.RelatedCitationsCitationIDCitationID
fk_RelatedCitations_Citations_AreRelatedODMXProvenance.CitationsODMXProvenance.RelatedCitationsCitationIDRelatedCitationID
fk_RelatedCitations_CV_RelationshipTypeODMXCV.CV_RelationshipTypeODMXProvenance.RelatedCitationsTermRelationshipTypeCV

Triggers

(none)


Used in Diagrams

Diagram Name
ODMXProvenance