ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

Citations

Information about Citations

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	CitationID	Integer				Primary key identifier
	Title	VarChar(255)				Text title of the Citation
	Publisher	VarChar(255)				Text publisher of the Citation
	PublicationYear	Integer				Integer publication year (4 digits) of the Citation
	CitationLink	VarChar(255)				Text link to the Citation (i.e. URL or path).

Indexes (none)

Foreign Keys (none)

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Annotations_Citations	ODM2Provenance.Citations	ODM2Annotations.Annotations	CitationID	CitationID
fk_ReferenceMaterialValues_Citations	ODM2Provenance.Citations	ODM2DataQuality.ReferenceMaterialValues	CitationID	CitationID
fk_CitationExtensionPropertyValues_Citations	ODM2Provenance.Citations	ODM2ExtensionProperties.CitationExtensionPropertyValues	CitationID	CitationID
fk_CitationExternalIdentifiers_Citations	ODM2Provenance.Citations	ODM2ExternalIdentifiers.CitationExternalIdentifiers	CitationID	CitationID
fk_AuthorLists_Citations	ODM2Provenance.Citations	ODM2Provenance.AuthorLists	CitationID	CitationID
fk_DataSetCitations_Citations	ODM2Provenance.Citations	ODM2Provenance.DatasetCitations	CitationID	CitationID
fk_MethodCitations_Citations	ODM2Provenance.Citations	ODM2Provenance.MethodCitations	CitationID	CitationID
fk_RelatedCitations_Citations	ODM2Provenance.Citations	ODM2Provenance.RelatedCitations	CitationID	CitationID
fk_RelatedCitations_Citations_AreRelated	ODM2Provenance.Citations	ODM2Provenance.RelatedCitations	CitationID	RelatedCitationID
fk_SpecimenTaxonomicClassifiers_Citations	ODM2Provenance.Citations	ODM2SamplingFeatures.SpecimenTaxonomicClassifiers	CitationID	CitationID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2ExtensionProperties

ODM2ExternalIdentifers

ODM2OverviewSimplified

ODM2Provenance