Citations - Table
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

CitationsInformation about Citations

PKNameData TypeNULLsA/NDefaultCommentFK

CitationIDInteger

Primary key identifier
TitleVarChar(255) Text title of the Citation
PublisherVarChar(255) Text publisher of the Citation
PublicationYearInteger Integer publication year (4 digits) of the Citation
CitationLinkVarChar(255)

Text link to the Citation (i.e. URL or path).



NameParent TableChild TableParent ColumnsChild Columns
fk_Annotations_CitationsODM2Provenance.CitationsODM2Annotations.AnnotationsCitationIDCitationID
fk_ReferenceMaterialValues_CitationsODM2Provenance.CitationsODM2DataQuality.ReferenceMaterialValuesCitationIDCitationID
fk_CitationExtensionPropertyValues_CitationsODM2Provenance.CitationsODM2ExtensionProperties.CitationExtensionPropertyValuesCitationIDCitationID
fk_CitationExternalIdentifiers_CitationsODM2Provenance.CitationsODM2ExternalIdentifiers.CitationExternalIdentifiersCitationIDCitationID
fk_AuthorLists_CitationsODM2Provenance.CitationsODM2Provenance.AuthorListsCitationIDCitationID
fk_DataSetCitations_CitationsODM2Provenance.CitationsODM2Provenance.DatasetCitationsCitationIDCitationID
fk_MethodCitations_CitationsODM2Provenance.CitationsODM2Provenance.MethodCitationsCitationIDCitationID
fk_RelatedCitations_CitationsODM2Provenance.CitationsODM2Provenance.RelatedCitationsCitationIDCitationID
fk_RelatedCitations_Citations_AreRelatedODM2Provenance.CitationsODM2Provenance.RelatedCitationsCitationIDRelatedCitationID
fk_SpecimenTaxonomicClassifiers_CitationsODM2Provenance.CitationsODM2SamplingFeatures.SpecimenTaxonomicClassifiersCitationIDCitationID

Diagram Name
ODM2ExtensionProperties
ODM2ExternalIdentifers
ODM2OverviewSimplified
ODM2Provenance