Skip to content

Provide forward joins to Identification, Protocol, Provenance and UsagePolicy #152

@tucotuco

Description

@tucotuco

Use cases have been presented for multiple UsagePolicies per entity from Local Contexts. Based on this and the commentary to keep join tables in DwC-DP, we should add foreign keys from resources that connect to the UsagePolicy, Protocol, and Provenance tables wherever they are missing. Specifically,

Material.usagePolicyID
Media.usagePolicyID
Event.provenanceID
Material.provenanceID
Media.provenanceID
Event.protocolID
Identification.protocolID (this suggestion from tdwg/dwc#774)
Material.protocolID
Occurrence.protocolID
Survey.samplingProtocolID

Metadata

Metadata

Assignees

No one assigned

    Labels

    Table - eventPertaining to the event table schema.Table - identificationPertaining to the identification table schema.Table - materialPertaining to the material table schema.Table - mediaPertaining to the media table schema.Table - occurrencePertaining to the occurrence table schema.Table - surveyPertaining to the survey table schema.Term - newRequest a new term.

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions