The PDBX_FRAGHUB_INVESTIGATION_CAMPAIGN category is another top level category. This category 'campaign' can cluster information in child catergories per year / processing pipeline software used. Key aspect: there can be more than one campaign per investigation. Also, an investigation might take more than one year and pipeline software may change.
_pdbx_fraghub_investigation_campaign.campaign_id 1 _pdbx_fraghub_investigation_campaign.investigation_id FH123 _pdbx_fraghub_investigation_campaign.proc_pipeline CRIMS _pdbx_fraghub_investigation_campaign.verison v4 _pdbx_fraghub_investigation_campaign.year 2022 _pdbx_fraghub_investigation_campaign.facility ESRF _pdbx_fraghub_investigation_campaign.internal_id 123456789
loop_ _pdbx_fraghub_investigation_campaign.campaign_id _pdbx_fraghub_investigation_campaign.investigation_id _pdbx_fraghub_investigation_campaign.proc_pipeline _pdbx_fraghub_investigation_campaign.pipeline-verison _pdbx_fraghub_investigation_campaign.year _pdbx_fraghub_investigation_campaign.facility _pdbx_fraghub_investigation_campaign.internal_id 1 FH123 CRIMS v3 2020 2 FH123 CRIMS v4 2022