diffrn_radiation_wavelength / diffrn_radiation interaction

[rowlesmr]

I don't know where to go with multi-dictionary interactions, so I'll put it here.

• CIF_POW
  • DIFFRN_RADIATION_WAVELENGTH
    • Linked, non-key data items for calibration purposes
      • _diffrn_radiation_wavelength.diffractogram_id
      • _diffrn_radiation_wavelength.phase_id
• CIF_IMG
  • DIFFRN_RADIATION - Set, child of CIF_IMG_HEAD
    • PKs: _diffrn_radiation.diffrn_id, _diffrn_radiation.variant
    • It also has _diffrn_radiation.wavelength_id, which is described as "a pointer to _diffrn_radiation_wavelength.id in the DIFFRN_RADIATION_WAVELENGTH category", but is not formally linked with _name.linked_item_id.
• CIF_MULTI
  • DIFFRN_RADIATION - Set, child of DIFFRACTION
    • PK: _diffrn_radiation.id
    • Linked, non-key data item: _diffrn_radiation.diffrn_id
  • DIFFRN_RADIATION_WAVELENGTH - Loop, child of DIFFRN_RADIATION
    • PKs: _diffrn_radiation_wavelength.id, _diffrn_radiation_wavelength.radiation_id
    • _drw.radiation_id is a FK pointing to _diffrn_radiation.id
• CIF_CORE
  • DIFFRN_RADIATION - Set, child of DIFFRN
    • no key
  • DIFFRN_RADIATION_WAVELENGTH - Loop, child of DIFFRN_RADIATION
    • PK: _diffrn_radiation_wavelength.id

The import order is POW, IMG, MULTI, CORE, and from my interpretation of the duplication rules, is that the first ones in win.

What should the final definitions of DIFFRN_RADIATION and DIFFRN_RADIATION_WAVELENGTH be?

• DIFFRN_RADIATION - Set, child of CIF_IMG_HEAD
  • PKs: _diffrn_radiation.diffrn_id, _diffrn_radiation.variant
• DIFFRN_RADIATION_WAVELENGTH - Loop, child of DIFFRN_RADIATION
  • PKs: _diffrn_radiation_wavelength.id, _diffrn_radiation_wavelength.radiation_id
  • _drw.radiation_id is a FK pointing to _diffrn_radiation.id

or should _diffrn_radiation.id be in there also as part of the PK?

• DIFFRN_RADIATION - Set, child of CIF_IMG_HEAD
  • PKs: _diffrn_radiation.diffrn_id, _diffrn_radiation.id, _diffrn_radiation.variant
• DIFFRN_RADIATION_WAVELENGTH - Loop, child of DIFFRN_RADIATION
  • PKs: _diffrn_radiation_wavelength.id, _diffrn_radiation_wavelength.radiation_id
  • _drw.radiation_id is a FK pointing to _diffrn_radiation.id

[jamesrhester]

CIF_MULTI expresses how we would like it to work. A radiation source, labelled by _diffrn_radiation.id is described independently of an experiment (labelled by _diffrn.id), and has one or more wavelengths associated with it. The wavelengths are listed in drw and associated with the radiation source using _drw.radiation_id. Both the wavelength identifier and the radiation source are part of the primary key, which is a convenience so that the same wavelength identifiers can be reused for different sources. It is also an inconvenience because anything referring to wavelength needs to also have a data name referring to the radiation source.

So that's the ideal we aimed for when building the multi-block dictionary, and CIF_POW doesn't contradict it.

There seems no conflict regarding drw as both the options you present for this category are the same.

What I think we want is that the final definition for DIFFRN_RADIATION should be unchanged from CIF_MULTI:

• DIFFRN_RADIATION - Set, child of DIFFRACTION
  • PK: _diffrn_radiation.id
  • Linked, non-key data item: _diffrn_radiation.diffrn_id

So we should change the import order if necessary to make this true. And this will be true if the later dictionaries in the import list overrule the earlier dictionaries - is there any basis for thinking that the earlier ones in the list win?

[rowlesmr]

CIF_POW has _import.get [ CIF_IMG CIF_MULTI ]
CIF_IMG has _import.get [ CIF_MULTI ]
CIF_MULTI has _import.get [ CIF_CORE ]

In all of those, dupl: Ignore and mode: Full are given, which means "Ignore imported definitions if block identifiers match". I don't fully know what is meant by "block identifiers match", but took it to mean that if you have the same _definition.id, then you are duplicates.

Given that a list is ordered, and that (at least) in the case for CIF_MULTI, we want to override the definitions in CIF_CORE, I took A imports B to mean: "Define everything in A. Define everything in B, unless it already exists in A."

AFAIK, this results in defining CIF_POW, CIF_IMG, CIF_MULTI*, and then CIF_CORE, with any overlaps with the previous dictionary dropped from that dictionary. So, as DIFFRN_RADIATION is defined in both CIF_IMG and CIF_MULTI, the definition from CIF_IMG is gotten to first, dropping that from CIF_MULTI.

*This is actually loaded from the CIF_IMG dictionary; the CIF_MULTI in CIF_POW doesn't matter because it's already been loaded, and so everything is ignored.

[vaitkus]

In all of those, dupl: Ignore and mode: Full are given, which means "Ignore imported definitions if block identifiers match". I don't fully know what is meant by "block identifiers match", but took it to mean that if you have the same _definition.id, then you are duplicates.

Just to clarify, I think that 'block identifiers' here refer to data frame (data block or save frame) names, i.e. text after the data_ or save_ keyword. Well, at least that how my software currently handles it. It might make sense to further clarify what is meant by 'block identifiers' in the DDLm reference dictionary.

The rest of the import behaviour you describe seems correct to me.

[jamesrhester]

AFAIK, this results in defining CIF_POW, CIF_IMG, CIF_MULTI*, and then CIF_CORE, with any overlaps with the previous dictionary dropped from that dictionary. So, as DIFFRN_RADIATION is defined in both CIF_IMG and CIF_MULTI, the definition from CIF_IMG is gotten to first, dropping that from CIF_MULTI.

Thanks for spelling it out, I agree that this is the (undesirable) result.

I see two options:
1. CIF_IMG imports CIF_MULTI with dupl:Replace. That should fix the diffraction_radiation mismatch and bring the DDLm CIF_IMG into harmony with cif_core (and slightly different regarding category keys with mmCIF, although not with any practical consequences at present).
2. CIF_POW imports CIF_MULTI with dupl:Replace. I think that currently works, but it does mean that CIF_POW can never add category keys to any categories specified in CIF_MULTI as those additions will be overriden, so we're creating a future landmine.
3. CIF_POW changes the order of import to import CIF_MULTI first. Also works, doesn't surprise with an unusual dupl setting, and sort of gives the message that CIF_MULTI is the priority basis that CIF_POW builds on.

So I'd go with (3). @rowlesmr how easy is it to get an updated consistency report with the above changes in place?

(Edit) Actually I think we should do (1) in any case to keep CIF_IMG in harmony with cif_core.

[rowlesmr]

I think that 'block identifiers' here refer to data frame (data block or save frame) names, i.e. text after the data_ or save_ keyword.

That sounds like you're relying on convention in consistent saveframe naming (although this is what's done with the import general_su, and the like), and you could run into the issue where you have clashing _definition.id values.

how easy is it to get an updated consistency report with the above changes in place?
Assuming my code actually does what I think its supposed to, and doesn't have hardcoded AI rubbish in it, should be fairly easy; I just need to convince myself of the import resolution pathway.

I don't know if 3 would work well with the current settings, as if IMG is loaded after MULTI, it is also loaded after CORE (which is loaded after MULTI), so if IMG is supposed to override things in CORE, it can't.

1 wouldn't work, as IMG importing MULTI with replacement would replace IMG definitions with CORE definitions. I think.

I think the only way is to have intermediate dictionaries not import, so MULTI and IMG would not import anything, and POW would import MULTI, IMG, and CORE (in that order) with dupl: Ignore.

But again, I need to figure out how to trace my code paths for import

[jamesrhester]

That sounds like you're relying on convention in consistent saveframe naming (although this is what's done with the import general_su, and the like), and you could run into the issue where you have clashing _definition.id values.

I don't think this has been a problem so far. Because the dictionaries are curated by us/COMCIFS, we can keep things harmonious, unlike data files, which are out of our control. The only dictionary that we have to be careful with is imgCIF, which has to also harmonise with PDBx/mmCIF.

I don't know if 3 would work well with the current settings, as if IMG is loaded after MULTI, it is also loaded after CORE (which is loaded after MULTI), so if IMG is supposed to override things in CORE, it can't.

I think the point is that we actually don't want or need IMG to override anything in MULTI, so (3) is OK. I guess for clarity we should point out that the only overriding we expect to do is adding keys to categories. We should never change data name definitions, for example.

Perhaps it's more robust to say that if imgCIF does need to add a category key to a core category, then we do it in MULTI instead.

[rowlesmr]

updated consistency report with the above changes in place?

The full outputs are below. By switching to import MULTI_BLOCK_CORE before CIF_IMG, we remove the following errors:

  !  FK: '_diffrn.diffrn_radiation_id' -> '_diffrn_radiation.id': target column 'id' is not a PK of 'diffrn_radiation' (PKs=['diffrn_id', 'variant']) -- skipping FK constraint
  !  FK: '_diffrn_detector_axis.detector_id' -> '_diffrn_detector.id': partial FK to 'diffrn_detector' -- covers ['id'] of PKs=['diffrn_id', 'id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.measurement_device' -> '_diffrn_measurement.device': partial FK to 'diffrn_measurement' -- covers ['device_class', 'id'] of PKs=['device_class', 'diffrn_id', 'id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.measurement_id' -> '_diffrn_measurement.id': partial FK to 'diffrn_measurement' -- covers ['device_class', 'id'] of PKs=['device_class', 'diffrn_id', 'id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_radiation.id' is not declared as a category key of 'diffrn_radiation' — recording FK anyway
  !  FK: '_diffrn_radiation.id' is not declared as a category key of 'diffrn_radiation' — recording FK anyway
  !  FK: '_diffrn_radiation.id' is not declared as a category key of 'diffrn_radiation' — recording FK anyway
  !  FK: '_diffrn_radiation.id' is not declared as a category key of 'diffrn_radiation' — recording FK anyway
  !  FK: '_diffrn_radiation_wavelength.radiation_id' -> '_diffrn_radiation.id': target column 'id' is not a PK of 'diffrn_radiation' (PKs=['diffrn_id', 'variant']) -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_monitor.detector_id' -> '_diffrn_detector.id': partial FK to 'diffrn_detector' -- covers ['id'] of PKs=['diffrn_id', 'id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_source.radiation_id' -> '_diffrn_radiation.id': target column 'id' is not a PK of 'diffrn_radiation' (PKs=['diffrn_id', 'variant']) -- skipping FK constraint
  !  FK: '_pd_diffractogram.scan_id' -> '_diffrn_scan.id': partial FK to 'diffrn_scan' -- covers ['id'] of PKs=['id', 'variant'], no transitive bridge found -- skipping FK constraint
  !  FK: '_pd_instr.radiation_id' -> '_diffrn_radiation.id': target column 'id' is not a PK of 'diffrn_radiation' (PKs=['diffrn_id', 'variant']) -- skipping FK constraint
  !  FK: '_pd_instr_detector.diffrn_detector_id' -> '_diffrn_detector.id': partial FK to 'diffrn_detector' -- covers ['id'] of PKs=['diffrn_id', 'id', 'variant'] -- skipping FK constraint

but gain the following errors

  !  category 'diffrn_measurement' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  FK: '_diffrn_measurement.device' is not declared as a category key of 'diffrn_measurement' — recording FK anyway
  !  FK: '_diffrn_measurement.id' is not declared as a category key of 'diffrn_measurement' — recording FK anyway
  !  FK: '_diffrn_measurement_axis.measurement_device' -> '_diffrn_measurement.device': target column 'device_class' is not a PK of 'diffrn_measurement' (PKs=['_pycifparse_id']) -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.measurement_id' -> '_diffrn_measurement.id': target column 'id' is not a PK of 'diffrn_measurement' (PKs=['_pycifparse_id']) -- skipping FK constraint

These errors are:

• diffrn_measurement (Set) doesn't have a key. It's defined in Core as a keyless-Set. CIF_IMG redefines it to have four keys: _diffrn_measurement.device, _diffrn_measurement.diffrn_id, _diffrn_measurement.id, and _diffrn_measurement.variant. but becuase it's imported after CORE, it doesn't take.
• _diffrn_measurement_axis.measurement_device is linked to _diffrn_measurement.device, but _dm.d is not a key
• _diffrn_measurement_axis.measurement_id is linked to _diffrn_measurement.id, but _dm.i is not a key
• _diffrn_measurement_axis.measurement_device is a key to diffrn_measurement_axis
• _diffrn_measurement_axis.measurement_id is a key to diffrn_measurement_axis

Also, _diffrn_measurement.device is actually an alias of _diffrn_measurement.device_class as defined in CORE.

The errors which are constant are:

  !  category 'diffraction' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'diffrn_orient' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'diffrn_orient_matrix' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'diffrn_reflns' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'diffrn_reflns_transf_matrix' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'diffrn_standards' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'reflns' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'exptl' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'exptl_absorpt' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'exptl_crystal_appearance' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'valence' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'publication' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'audit' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'computing' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'database' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'database_code' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'display' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'journal' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'journal_coeditor' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'journal_date' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'journal_techeditor' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'publ' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'publ_manuscript' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'publ_requested' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'publ_section' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'atom' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'atom_sites' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'atom_sites_cartn_transform' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'atom_sites_fract_transform' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'refine' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'refine_diff' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  category 'refine_ls' (Set) has no _category_key.name — using _pycifparse_id as primary key
  !  FK: '_diffrn_standard_refln.code' is not declared as a category key of 'diffrn_standard_refln' — recording FK anyway
  !  FK: '_diffrn_radiation.id' is not declared as a category key of 'diffrn_radiation' — recording FK anyway
  !  FK: '_diffrn_radiation.id' is not declared as a category key of 'diffrn_radiation' — recording FK anyway
  !  FK: '_diffrn_radiation.id' is not declared as a category key of 'diffrn_radiation' — recording FK anyway
  !  FK: '_array_structure_list.axis_set_id' is not declared as a category key of 'array_structure_list' — recording FK anyway
  !  FK: '_diffrn_radiation.id' is not declared as a category key of 'diffrn_radiation' — recording FK anyway
  !  FK: '_array_data.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_element_size.index' -> '_array_structure_list.index': partial FK to 'array_structure_list' -- covers ['index'] of PKs=['array_id', 'index', 'variant'] -- skipping FK constraint
  !  FK: '_array_element_size.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_intensities.binary_id' -> '_array_data.binary_id': partial FK to 'array_data' -- covers ['binary_id'] of PKs=['array_id', 'binary_id', 'variant'] -- skipping FK constraint
  !  FK: '_array_intensities.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_structure.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_structure_list.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_structure_list_axis.axis_set_id' -> '_array_structure_list.axis_set_id': target column 'axis_set_id' is not a PK of 'array_structure_list' (PKs=['array_id', 'index', 'variant']) -- skipping FK constraint
  !  FK: '_array_structure_list_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_structure_list_section.index' -> '_array_structure_list.index': partial FK to 'array_structure_list' -- covers ['index'] of PKs=['array_id', 'index', 'variant'] -- skipping FK constraint
  !  FK: '_axis.depends_on' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn.diffrn_radiation_id' -> '_diffrn_radiation.id': target column 'id' is not a PK of 'diffrn_radiation' (PKs=['diffrn_id', 'variant']) -- skipping FK constraint
  !  FK: '_diffrn_data_frame.binary_id' -> '_array_data.binary_id': partial FK to 'array_data' -- covers ['binary_id'] of PKs=['array_id', 'binary_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_data_frame.detector_element_id' -> '_diffrn_detector_element.id': partial FK to 'diffrn_detector_element' -- covers ['id'] of PKs=['id', 'detector_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_data_frame.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_detector.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_detector_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_detector_element.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_radiation_wavelength.radiation_id' -> '_diffrn_radiation.id': target column 'id' is not a PK of 'diffrn_radiation' (PKs=['diffrn_id', 'variant']) -- skipping FK constraint
  !  FK: '_diffrn_refln.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_refln.standard_code' -> '_diffrn_standard_refln.code': target column 'code' is not a PK of 'diffrn_standard_refln' (PKs=['index_h', 'index_k', 'index_l']) -- skipping FK constraint
  !  FK: '_diffrn_refln.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan.frame_id_end' -> '_diffrn_data_frame.id': ambiguous composite FK -- multiple source columns link to 'diffrn_data_frame'.'id' -- skipping FK constraint
  !  FK: '_diffrn_scan.frame_id_start' -> '_diffrn_data_frame.id': ambiguous composite FK -- multiple source columns link to 'diffrn_data_frame'.'id' -- skipping FK constraint
  !  FK: '_diffrn_scan.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan_collection.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_axis.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_monitor.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_monitor.detector_id' -> '_diffrn_detector.id': partial FK to 'diffrn_detector' -- covers ['id'] of PKs=['diffrn_id', 'id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_source.radiation_id' -> '_diffrn_radiation.id': target column 'id' is not a PK of 'diffrn_radiation' (PKs=['diffrn_id', 'variant']) -- skipping FK constraint
  !  FK: '_map.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_map_segment.array_section_id' -> '_array_structure_list_section.id': partial FK to 'array_structure_list_section' -- covers ['id'] of PKs=['id', 'array_id', 'index', 'variant'] -- skipping FK constraint
  !  FK: '_map_segment.id' -> '_map.id': partial FK to 'map' -- covers ['id'] of PKs=['id', 'diffrn_id', 'entry_id', 'variant'] -- skipping FK constraint
  !  FK: '_map_segment.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_pd_amorphous.peak_id' -> '_pd_peak.id': partial FK to 'pd_peak' -- covers ['id'] of PKs=['diffractogram_id', 'id'], no transitive bridge found -- skipping FK constraint

This is CIF_POW, import [ CIF_IMG MULTI_BLOCK_CORE ]

  !  FK: '_diffrn_standard_refln.code' is not declared as a category key of 'diffrn_standard_refln' — recording FK anyway
  !  FK: '_diffrn_radiation.id' is not declared as a category key of 'diffrn_radiation' — recording FK anyway
  !  FK: '_diffrn_radiation.id' is not declared as a category key of 'diffrn_radiation' — recording FK anyway
  !  FK: '_diffrn_radiation.id' is not declared as a category key of 'diffrn_radiation' — recording FK anyway
  !  FK: '_array_structure_list.axis_set_id' is not declared as a category key of 'array_structure_list' — recording FK anyway
  !  FK: '_diffrn_radiation.id' is not declared as a category key of 'diffrn_radiation' — recording FK anyway
  !  FK: '_array_data.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_element_size.index' -> '_array_structure_list.index': partial FK to 'array_structure_list' -- covers ['index'] of PKs=['array_id', 'index', 'variant'] -- skipping FK constraint
  !  FK: '_array_element_size.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_intensities.binary_id' -> '_array_data.binary_id': partial FK to 'array_data' -- covers ['binary_id'] of PKs=['array_id', 'binary_id', 'variant'] -- skipping FK constraint
  !  FK: '_array_intensities.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_structure.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_structure_list.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_structure_list_axis.axis_set_id' -> '_array_structure_list.axis_set_id': target column 'axis_set_id' is not a PK of 'array_structure_list' (PKs=['array_id', 'index', 'variant']) -- skipping FK constraint
  !  FK: '_array_structure_list_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_array_structure_list_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_structure_list_section.index' -> '_array_structure_list.index': partial FK to 'array_structure_list' -- covers ['index'] of PKs=['array_id', 'index', 'variant'] -- skipping FK constraint
  !  FK: '_axis.depends_on' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn.diffrn_radiation_id' -> '_diffrn_radiation.id': target column 'id' is not a PK of 'diffrn_radiation' (PKs=['diffrn_id', 'variant']) -- skipping FK constraint
  !  FK: '_diffrn_data_frame.binary_id' -> '_array_data.binary_id': partial FK to 'array_data' -- covers ['binary_id'] of PKs=['array_id', 'binary_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_data_frame.array_section_id' -> '_array_structure_list_section.id': partial FK to 'array_structure_list_section' -- covers ['id'] of PKs=['id', 'array_id', 'index', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_data_frame.detector_element_id' -> '_diffrn_detector_element.id': partial FK to 'diffrn_detector_element' -- covers ['id'] of PKs=['id', 'detector_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_data_frame.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_detector.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_detector_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_detector_axis.detector_id' -> '_diffrn_detector.id': partial FK to 'diffrn_detector' -- covers ['id'] of PKs=['diffrn_id', 'id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_detector_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_detector_element.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_measurement.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.measurement_device' -> '_diffrn_measurement.device': partial FK to 'diffrn_measurement' -- covers ['device_class', 'id'] of PKs=['device_class', 'diffrn_id', 'id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.measurement_id' -> '_diffrn_measurement.id': partial FK to 'diffrn_measurement' -- covers ['device_class', 'id'] of PKs=['device_class', 'diffrn_id', 'id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_radiation.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_radiation_wavelength.radiation_id' -> '_diffrn_radiation.id': target column 'id' is not a PK of 'diffrn_radiation' (PKs=['diffrn_id', 'variant']) -- skipping FK constraint
  !  FK: '_diffrn_refln.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_refln.standard_code' -> '_diffrn_standard_refln.code': target column 'code' is not a PK of 'diffrn_standard_refln' (PKs=['index_h', 'index_k', 'index_l']) -- skipping FK constraint
  !  FK: '_diffrn_refln.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan.frame_id_end' -> '_diffrn_data_frame.id': ambiguous composite FK -- multiple source columns link to 'diffrn_data_frame'.'id' -- skipping FK constraint
  !  FK: '_diffrn_scan.frame_id_start' -> '_diffrn_data_frame.id': ambiguous composite FK -- multiple source columns link to 'diffrn_data_frame'.'id' -- skipping FK constraint
  !  FK: '_diffrn_scan.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan_collection.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_axis.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_monitor.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_monitor.detector_id' -> '_diffrn_detector.id': partial FK to 'diffrn_detector' -- covers ['id'] of PKs=['diffrn_id', 'id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_monitor.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_source.radiation_id' -> '_diffrn_radiation.id': target column 'id' is not a PK of 'diffrn_radiation' (PKs=['diffrn_id', 'variant']) -- skipping FK constraint
  !  FK: '_map.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_map_segment.array_section_id' -> '_array_structure_list_section.id': partial FK to 'array_structure_list_section' -- covers ['id'] of PKs=['id', 'array_id', 'index', 'variant'] -- skipping FK constraint
  !  FK: '_map_segment.id' -> '_map.id': partial FK to 'map' -- covers ['id'] of PKs=['id', 'diffrn_id', 'entry_id', 'variant'] -- skipping FK constraint
  !  FK: '_map_segment.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_pd_amorphous.peak_id' -> '_pd_peak.id': partial FK to 'pd_peak' -- covers ['id'] of PKs=['diffractogram_id', 'id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_pd_diffractogram.scan_id' -> '_diffrn_scan.id': partial FK to 'diffrn_scan' -- covers ['id'] of PKs=['id', 'variant'], no transitive bridge found -- skipping FK constraint
  !  FK: '_pd_instr.radiation_id' -> '_diffrn_radiation.id': target column 'id' is not a PK of 'diffrn_radiation' (PKs=['diffrn_id', 'variant']) -- skipping FK constraint
  !  FK: '_pd_instr_detector.diffrn_detector_id' -> '_diffrn_detector.id': partial FK to 'diffrn_detector' -- covers ['id'] of PKs=['diffrn_id', 'id', 'variant'] -- skipping FK constraint

This is CIF_POW, import [ MULTI_BLOCK_CORE CIF_IMG ]

  !  FK: '_diffrn_standard_refln.code' is not declared as a category key of 'diffrn_standard_refln' — recording FK anyway
  !  FK: '_array_structure_list.axis_set_id' is not declared as a category key of 'array_structure_list' — recording FK anyway
  !  FK: '_diffrn_measurement.device' is not declared as a category key of 'diffrn_measurement' — recording FK anyway
  !  FK: '_diffrn_measurement.id' is not declared as a category key of 'diffrn_measurement' — recording FK anyway
  !  FK: '_array_data.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_element_size.index' -> '_array_structure_list.index': partial FK to 'array_structure_list' -- covers ['index'] of PKs=['array_id', 'index', 'variant'] -- skipping FK constraint
  !  FK: '_array_element_size.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_intensities.binary_id' -> '_array_data.binary_id': partial FK to 'array_data' -- covers ['binary_id'] of PKs=['array_id', 'binary_id', 'variant'] -- skipping FK constraint
  !  FK: '_array_intensities.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_structure.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_structure_list.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_structure_list_axis.axis_set_id' -> '_array_structure_list.axis_set_id': target column 'axis_set_id' is not a PK of 'array_structure_list' (PKs=['array_id', 'index', 'variant']) -- skipping FK constraint
  !  FK: '_array_structure_list_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_array_structure_list_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_array_structure_list_section.index' -> '_array_structure_list.index': partial FK to 'array_structure_list' -- covers ['index'] of PKs=['array_id', 'index', 'variant'] -- skipping FK constraint
  !  FK: '_axis.depends_on' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_data_frame.binary_id' -> '_array_data.binary_id': partial FK to 'array_data' -- covers ['binary_id'] of PKs=['array_id', 'binary_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_data_frame.array_section_id' -> '_array_structure_list_section.id': partial FK to 'array_structure_list_section' -- covers ['id'] of PKs=['id', 'array_id', 'index', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_data_frame.detector_element_id' -> '_diffrn_detector_element.id': partial FK to 'diffrn_detector_element' -- covers ['id'] of PKs=['id', 'detector_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_data_frame.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_detector.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_detector_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_detector_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_detector_element.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_measurement.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.measurement_device' -> '_diffrn_measurement.device': target column 'device_class' is not a PK of 'diffrn_measurement' (PKs=['_pycifparse_id']) -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.measurement_id' -> '_diffrn_measurement.id': target column 'id' is not a PK of 'diffrn_measurement' (PKs=['_pycifparse_id']) -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_radiation.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_refln.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_refln.standard_code' -> '_diffrn_standard_refln.code': target column 'code' is not a PK of 'diffrn_standard_refln' (PKs=['index_h', 'index_k', 'index_l']) -- skipping FK constraint
  !  FK: '_diffrn_refln.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan.frame_id_end' -> '_diffrn_data_frame.id': ambiguous composite FK -- multiple source columns link to 'diffrn_data_frame'.'id' -- skipping FK constraint
  !  FK: '_diffrn_scan.frame_id_start' -> '_diffrn_data_frame.id': ambiguous composite FK -- multiple source columns link to 'diffrn_data_frame'.'id' -- skipping FK constraint
  !  FK: '_diffrn_scan.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan_collection.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_axis.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_axis.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_monitor.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id', 'variant'] -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_monitor.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_map.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_map_segment.array_section_id' -> '_array_structure_list_section.id': partial FK to 'array_structure_list_section' -- covers ['id'] of PKs=['id', 'array_id', 'index', 'variant'] -- skipping FK constraint
  !  FK: '_map_segment.id' -> '_map.id': partial FK to 'map' -- covers ['id'] of PKs=['id', 'diffrn_id', 'entry_id', 'variant'] -- skipping FK constraint
  !  FK: '_map_segment.variant' -> '_variant.variant': partial FK to 'variant' -- covers ['variant'] of PKs=['variant', 'diffrn_id', 'entry_id'] -- skipping FK constraint
  !  FK: '_pd_amorphous.peak_id' -> '_pd_peak.id': partial FK to 'pd_peak' -- covers ['id'] of PKs=['diffractogram_id', 'id'], no transitive bridge found -- skipping FK constraint

[rowlesmr]

Perhaps it's more robust to say that if imgCIF does need to add a category key to a core category, then we do it in MULTI instead.

Won't that constrain everyone that uses multiblock?

They'd be stuck with diffrn_measurement having keys: _diffrn_measurement.device, _diffrn_measurement.diffrn_id, _diffrn_measurement.id, and _diffrn_measurement.variant

and then they'd need to import CIF_IMG to get variant

[jamesrhester]

These errors are:

• diffrn_measurement (Set) doesn't have a key. It's defined in Core as a keyless-Set. CIF_IMG redefines it to have four keys: _diffrn_measurement.device, _diffrn_measurement.diffrn_id, _diffrn_measurement.id, and _diffrn_measurement.variant. but becuase it's imported after CORE, it doesn't take.
• _diffrn_measurement_axis.measurement_device is linked to _diffrn_measurement.device, but _dm.d is not a key
• _diffrn_measurement_axis.measurement_id is linked to _diffrn_measurement.id, but _dm.i is not a key
• _diffrn_measurement_axis.measurement_device is a key to diffrn_measurement_axis
• _diffrn_measurement_axis.measurement_id is a key to diffrn_measurement_axis

Also, _diffrn_measurement.device is actually an alias of _diffrn_measurement.device_class as defined in CORE.

Thanks for the speedy re-check. In the following I ignore variant because the only viable way to treat that is to make a variant dictionary an (optional) extension to the imgCIF dictionary.

diffrn_measurement

In Core dm is a Set category, so an as-yet undetermined key. If we make that key a link to diffrn_id, we become compatible with the main PDBx/mmCIF dictionary. Such a choice effectively makes diffrn_measurement no more than some extra columns for the diffrn category.

The problem imgCIF encounters is that it wants to attach axes to devices, but there is no way to refer to an individual device, because the key is diffrn_id. So _dm.device and _dm.id are both added, although you'd think only one of those is needed (see below).

Having _dm.diffrn_id and _dm.id both as keys is inconvenient for powders because we may have many, many unique _diffrn.id values from multi-temperature experiments, and for each one we have to restate all of the _dm.ids. It would be far better to do as we have done for diffrn_radiation and elevate _diffrn_measurement.id to the single unique identifier for a positioning device across the entire dataset. We can make this change in multi-block as the concept of a positioning device is useful not just in imgCIF.

_diffrn_measurement.device
The definition in cif_img.dic for _dm.device appears to state that it is an alternative key:

Either _diffrn_measurement.device or _diffrn_measurement.id may be used to link to other categories.

and

If the experimental setup admits multiple devices, then _diffrn_measurement.id is used to provide a unique link.

from which I deduce that originally device was used, and then it was realised that this was unsuitable as an identifier as it was a general class, not a name, and so id was created but device was left as a key for backwards compatibility.

_diffrn_measurement.device is used in no current PDB entries, so I don't think we need to be too precious about fiddling with whether or not it is a key.

diffrn_measurement_axis

This category must stay in IMG otherwise we have to bring AXIS into multiblock. If we assume measurement_device is an old key which has been replaced by measurement_id, we can simulate that using a default dREL method to copy md to mi when mi is missing, and drop md as a key.

Proposal
Change MULTI as follows:

1. Add DIFFRN_MEASUREMENT with a single key, _diffrn_measurement.id
2. Add _diffrn_measurement.diffrn_id as a non-key pointer to _diffrn.id for limited PDBx/mmCIF compatibility (will work for single-value diffrn.id entries, i.e. all of them so far
3. Add _diffrn_measurement.id
4. Add _diffrn.measurement_id to identify the positioning device used for a measurement

I will make a PR where can continue that part of the discussion.

[jamesrhester]

@rowlesmr , when you get a chance could you see what outstanding key resolution problems are left if COMCIFS/imgCIF#23 (removal of variant category) is merged into cif_img.dic?

[rowlesmr]

These errors remain:

It flags these two as the FK link isn't a PK of the target table. It tries, and then fails. I don't know how much you want to consider them "errors"...

  !  FK: '_diffrn_measurement_axis.measurement_device' -> '_diffrn_measurement.device' : target is not a declared category key of 'diffrn_measurement' (PKs=['id']) -- attempting FK resolution
  !  FK: '_diffrn_refln.standard_code'                 -> '_diffrn_standard_refln.code': target is not a declared category key of 'diffrn_standard_refln' (PKs=['index_h', 'index_k', 'index_l']) -- attempting FK resolution

  !  FK: '_diffrn_measurement_axis.measurement_device' -> '_diffrn_measurement.device' : target column 'device_class' is not a PK of 'diffrn_measurement' (PKs=['id']) -- skipping FK constraint
  !  FK: '_diffrn_refln.standard_code'                 -> '_diffrn_standard_refln.code': target column 'code' is not a PK of 'diffrn_standard_refln' (PKs=['index_h', 'index_k', 'index_l']) -- skipping FK constraint

Here, we've only got a part of the PK, and couldn't find a transitive bridge to somewhere else to find a value to complete it.

  !  FK: '_array_structure_list.axis_set_id'      -> '_array_structure_list_axis.axis_set_id': partial FK to 'array_structure_list_axis' -- covers ['axis_set_id'] of PKs=['axis_set_id', 'axis_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_data_frame.detector_element_id' -> '_diffrn_detector_element.id'           : partial FK to 'diffrn_detector_element' -- covers ['id'] of PKs=['id', 'detector_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_array_structure_list_axis.axis_id'     -> '_axis.id'                              : partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_detector_axis.axis_id'          -> '_axis.id'                              : partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.axis_id'       -> '_axis.id'                              : partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_scan_axis.axis_id'              -> '_axis.id'                              : partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_axis.axis_id'        -> '_axis.id'                              : partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_refln.frame_id'                 -> '_diffrn_data_frame.id'                 : partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_scan.frame_id_end'              -> '_diffrn_data_frame.id'                 : partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_scan.frame_id_start'            -> '_diffrn_data_frame.id'                 : partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_scan_frame.frame_id'            -> '_diffrn_data_frame.id'                 : partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_axis.frame_id'       -> '_diffrn_data_frame.id'                 : partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_monitor.frame_id'    -> '_diffrn_data_frame.id                  : partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id'], no transitive bridge found -- skipping FK constraint

Here, we're missing more than one PK value, so the transitive bridge lookup doesn't doin anything as I haven't gotten around to figuring out how to get Claude to look up more than one missing key

  !  FK: '_diffrn_data_frame.array_section_id' -> '_array_structure_list_section.id': partial FK to 'array_structure_list_section' -- covers ['id'] of PKs=['id', 'array_id', 'index'] (2 missing PKs, bridge search skipped) -- skipping FK constraint
  !  FK: '_map_segment.array_section_id'       -> '_array_structure_list_section.id': partial FK to 'array_structure_list_section' -- covers ['id'] of PKs=['id', 'array_id', 'index'] (2 missing PKs, bridge search skipped) -- skipping FK constraint
  !  FK: '_map_segment.id'                     -> '_map.id'                         : partial FK to 'map' -- covers ['id'] of PKs=['id', 'diffrn_id', 'entry_id'] (2 missing PKs, bridge search skipped) -- skipping FK constraint

And this is a known dictionary deficit.

  !  FK: '_pd_amorphous.peak_id' -> '_pd_peak.id': partial FK to 'pd_peak' -- covers ['id'] of PKs=['diffractogram_id', 'id'], no transitive bridge found -- skipping FK constraint

Just for fun, the complete schema:

-- schema --
163 tables  (65 Set, 98 Loop)  178 FKs  53 warnings

array_data  [Loop]
  PK  array_id, binary_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    array_id           Word     PK  _array_data.array_id
    binary_id          Integer  NOT NULL  PK  _array_data.binary_id
    data               Complex    _array_data.data
    external_data_id   Word       _array_data.external_data_id
    header_contents    Text       _array_data.header_contents
    header_convention  Word       _array_data.header_convention
  foreign keys
    external_data_id -> array_data_external_data.id  DEFERRABLE
    array_id -> array_structure.id  DEFERRABLE

array_data_external_data  [Loop]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _array_data_external_data.id
    archive_format     Word       _array_data_external_data.archive_format
    archive_path       Text       _array_data_external_data.archive_path
    file_compression   Word       _array_data_external_data.file_compression
    format             Word       _array_data_external_data.format
    frame              Word       _array_data_external_data.frame
    path               Text       _array_data_external_data.path
    uri                Word       _array_data_external_data.uri
    version            Word       _array_data_external_data.version

array_element_size  [Loop]
  PK  array_id, index
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    array_id           Word     NOT NULL  PK  _array_element_size.array_id
    index              Integer  PK  _array_element_size.index
    size               Real       _array_element_size.size
  foreign keys
    (array_id, index) -> array_structure_list.(array_id, index)  DEFERRABLE

array_intensities  [Loop]
  PK  array_id, binary_id
  columns
    _cifflow_block_id     TEXT     NOT NULL  synthetic
    _cifflow_row_id       INTEGER  NOT NULL  UNIQUE  synthetic
    array_id              Word     PK  _array_intensities.array_id
    binary_id             Integer  PK  _array_intensities.binary_id
    details               Text       _array_intensities.details
    gain                  Real       _array_intensities.gain
    gain_esd              Real       _array_intensities.gain_esd  ->su _array_intensities.gain
    linearity             Word       _array_intensities.linearity
    offset                Real       _array_intensities.offset
    overload              Real       _array_intensities.overload
    pixel_binning_method  Word       _array_intensities.pixel_binning_method
    pixel_fast_bin_size   Real       _array_intensities.pixel_fast_bin_size
    pixel_slow_bin_size   Real       _array_intensities.pixel_slow_bin_size
    scaling               Real       _array_intensities.scaling
    undefined_value       Real       _array_intensities.undefined_value
    underload             Real       _array_intensities.underload
  foreign keys
    (array_id, binary_id) -> array_data.(array_id, binary_id)  DEFERRABLE
    array_id -> array_structure.id  DEFERRABLE

array_structure  [Loop]
  PK  id
  columns
    _cifflow_block_id      TEXT     NOT NULL  synthetic
    _cifflow_row_id        INTEGER  NOT NULL  UNIQUE  synthetic
    id                     Word     NOT NULL  PK  _array_structure.id
    byte_order             Code       _array_structure.byte_order
    compression_type       Code       _array_structure.compression_type
    compression_type_flag  Code       _array_structure.compression_type_flag
    encoding_type          Text       _array_structure.encoding_type

array_structure_list  [Loop]
  PK  array_id, index
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    array_id           Word     PK  _array_structure_list.array_id
    index              Integer  NOT NULL  PK  _array_structure_list.index
    array_section_id   Word       _array_structure_list.array_section_id
    axis_set_id        Word       _array_structure_list.axis_set_id
    dimension          Integer    _array_structure_list.dimension
    direction          Word       _array_structure_list.direction
    precedence         Integer    _array_structure_list.precedence
  foreign keys
    array_id -> array_structure.id  DEFERRABLE

array_structure_list_axis  [Loop]
  PK  axis_set_id, axis_id
  columns
    _cifflow_block_id             TEXT     NOT NULL  synthetic
    _cifflow_row_id               INTEGER  NOT NULL  UNIQUE  synthetic
    axis_set_id                   Word     NOT NULL  PK  _array_structure_list_axis.axis_set_id
    axis_id                       Word     PK  _array_structure_list_axis.axis_id
    angle                         Real       _array_structure_list_axis.angle
    angle_increment               Real       _array_structure_list_axis.angle_increment
    angular_pitch                 Real       _array_structure_list_axis.angular_pitch
    displacement                  Real       _array_structure_list_axis.displacement
    displacement_increment        Real       _array_structure_list_axis.displacement_increment
    fract_displacement            Real       _array_structure_list_axis.fract_displacement
    fract_displacement_increment  Real       _array_structure_list_axis.fract_displacement_increment
    radial_pitch                  Real       _array_structure_list_axis.radial_pitch
    reference_angle               Real       _array_structure_list_axis.reference_angle
    reference_displacement        Real       _array_structure_list_axis.reference_displacement

array_structure_list_section  [Loop]
  PK  id, array_id, index
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _array_structure_list_section.id
    array_id           Word     PK  _array_structure_list_section.array_id
    index              Integer  PK  _array_structure_list_section.index
    end                Integer    _array_structure_list_section.end
    start              Integer    _array_structure_list_section.start
    stride             Integer    _array_structure_list_section.stride
  foreign keys
    array_id -> array_structure.id  DEFERRABLE
    (array_id, index) -> array_structure_list.(array_id, index)  DEFERRABLE

atom  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic

atom_analytical  [Loop]
  PK  id
  columns
    _cifflow_block_id                 TEXT     NOT NULL  synthetic
    _cifflow_row_id                   INTEGER  NOT NULL  UNIQUE  synthetic
    id                                Word     NOT NULL  PK  _atom_analytical.id
    analyte                           Word       _atom_analytical.analyte
    analyte_mass_percent              Real       _atom_analytical.analyte_mass_percent
    analyte_mass_percent_su           Real       _atom_analytical.analyte_mass_percent_su  ->su _atom_analytical.analyte_mass_percent
    chemical_species                  Text       _atom_analytical.chemical_species
    chemical_species_mass_percent     Real       _atom_analytical.chemical_species_mass_percent
    chemical_species_mass_percent_su  Real       _atom_analytical.chemical_species_mass_percent_su  ->su _atom_analytical.chemical_species_mass_percent
    meas_id                           Word       _atom_analytical.meas_id
  foreign keys
    meas_id -> atom_analytical_source.id  DEFERRABLE

atom_analytical_mass_loss  [Loop]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _atom_analytical_mass_loss.id
    meas_id            Word       _atom_analytical_mass_loss.meas_id
    percent            Real       _atom_analytical_mass_loss.percent
    percent_su         Real       _atom_analytical_mass_loss.percent_su  ->su _atom_analytical_mass_loss.percent
    special_details    Text       _atom_analytical_mass_loss.special_details
    temperature        Real       _atom_analytical_mass_loss.temperature
    temperature_su     Real       _atom_analytical_mass_loss.temperature_su  ->su _atom_analytical_mass_loss.temperature
  foreign keys
    meas_id -> atom_analytical_source.id  DEFERRABLE

atom_analytical_source  [Loop]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _atom_analytical_source.id
    equipment_make     Text       _atom_analytical_source.equipment_make
    special_details    Text       _atom_analytical_source.special_details
    technique          Text       _atom_analytical_source.technique

atom_scat_versus_stol  [Loop]
  PK  atom_type, stol_value
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    atom_type          Word     PK  _atom_scat_versus_stol.atom_type
    stol_value         Real     NOT NULL  PK  _atom_scat_versus_stol.stol_value
    scat_value         Real       _atom_scat_versus_stol.scat_value
    scat_value_su      Real       _atom_scat_versus_stol.scat_value_su  ->su _atom_scat_versus_stol.scat_value
  foreign keys
    atom_type -> atom_type.symbol  DEFERRABLE

atom_site  [Loop]
  PK  label, structure_id
  columns
    _cifflow_block_id           TEXT     NOT NULL  synthetic
    _cifflow_row_id             INTEGER  NOT NULL  UNIQUE  synthetic
    label                       Word     NOT NULL  PK  _atom_site.label
    structure_id                Word     PK  _atom_site.structure_id
    adp_type                    Text       _atom_site.adp_type
    attached_hydrogens          Integer    _atom_site.attached_hydrogens
    b_equiv_geom_mean           Real       _atom_site.b_equiv_geom_mean
    b_equiv_geom_mean_su        Real       _atom_site.b_equiv_geom_mean_su  ->su _atom_site.b_equiv_geom_mean
    b_iso_or_equiv              Real       _atom_site.b_iso_or_equiv
    b_iso_or_equiv_su           Real       _atom_site.b_iso_or_equiv_su  ->su _atom_site.b_iso_or_equiv
    calc_attached_atom          Word       _atom_site.calc_attached_atom
    calc_flag                   Text       _atom_site.calc_flag
    cartn_x                     Real       _atom_site.cartn_x
    cartn_x_su                  Real       _atom_site.cartn_x_su  ->su _atom_site.cartn_x
    cartn_xyz                   Real       _atom_site.cartn_xyz
    cartn_xyz_su                Real       _atom_site.cartn_xyz_su  ->su _atom_site.cartn_xyz
    cartn_y                     Real       _atom_site.cartn_y
    cartn_y_su                  Real       _atom_site.cartn_y_su  ->su _atom_site.cartn_y
    cartn_z                     Real       _atom_site.cartn_z
    cartn_z_su                  Real       _atom_site.cartn_z_su  ->su _atom_site.cartn_z
    chemical_conn_number        Integer    _atom_site.chemical_conn_number
    constraints                 Text       _atom_site.constraints
    description                 Text       _atom_site.description
    disorder_assembly           Word       _atom_site.disorder_assembly
    disorder_group              Word       _atom_site.disorder_group
    fract_symmform              Text       _atom_site.fract_symmform
    fract_x                     Real       _atom_site.fract_x
    fract_x_su                  Real       _atom_site.fract_x_su  ->su _atom_site.fract_x
    fract_xyz                   Real       _atom_site.fract_xyz
    fract_xyz_su                Real       _atom_site.fract_xyz_su  ->su _atom_site.fract_xyz
    fract_y                     Real       _atom_site.fract_y
    fract_y_su                  Real       _atom_site.fract_y_su  ->su _atom_site.fract_y
    fract_z                     Real       _atom_site.fract_z
    fract_z_su                  Real       _atom_site.fract_z_su  ->su _atom_site.fract_z
    label_component_0           Word       _atom_site.label_component_0
    label_component_1           Word       _atom_site.label_component_1
    label_component_2           Word       _atom_site.label_component_2
    label_component_3           Word       _atom_site.label_component_3
    label_component_4           Word       _atom_site.label_component_4
    label_component_5           Word       _atom_site.label_component_5
    label_component_6           Word       _atom_site.label_component_6
    occupancy                   Real       _atom_site.occupancy
    occupancy_su                Real       _atom_site.occupancy_su  ->su _atom_site.occupancy
    refinement_flags            Text       _atom_site.refinement_flags  DEPRECATED -> _atom_site.refinement_flags_posn, _atom_site.refinement_flags_adp, _atom_site.refinement_flags_occupancy
    refinement_flags_adp        Text       _atom_site.refinement_flags_adp
    refinement_flags_occupancy  Text       _atom_site.refinement_flags_occupancy
    refinement_flags_posn       Text       _atom_site.refinement_flags_posn
    restraints                  Text       _atom_site.restraints
    site_symmetry_multiplicity  Integer    _atom_site.site_symmetry_multiplicity
    site_symmetry_order         Integer    _atom_site.site_symmetry_order
    type_symbol                 Word       _atom_site.type_symbol
    u_equiv_geom_mean           Real       _atom_site.u_equiv_geom_mean
    u_equiv_geom_mean_su        Real       _atom_site.u_equiv_geom_mean_su  ->su _atom_site.u_equiv_geom_mean
    u_iso_or_equiv              Real       _atom_site.u_iso_or_equiv
    u_iso_or_equiv_su           Real       _atom_site.u_iso_or_equiv_su  ->su _atom_site.u_iso_or_equiv
    wyckoff_symbol              Text       _atom_site.wyckoff_symbol
    phase_id                    TEXT     synthetic
  foreign keys
    (calc_attached_atom, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    type_symbol -> atom_type.symbol  DEFERRABLE
    (chemical_conn_number, phase_id) -> chemical_conn_atom.(number, phase_id)  DEFERRABLE
    structure_id -> structure.id  DEFERRABLE

atom_site_aniso  [Loop]
  PK  label, structure_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    label              Word     PK  _atom_site_aniso.label
    structure_id       Word     PK  _atom_site_aniso.structure_id
    b_11               Real       _atom_site_aniso.b_11
    b_11_su            Real       _atom_site_aniso.b_11_su  ->su _atom_site_aniso.b_11
    b_12               Real       _atom_site_aniso.b_12
    b_12_su            Real       _atom_site_aniso.b_12_su  ->su _atom_site_aniso.b_12
    b_13               Real       _atom_site_aniso.b_13
    b_13_su            Real       _atom_site_aniso.b_13_su  ->su _atom_site_aniso.b_13
    b_22               Real       _atom_site_aniso.b_22
    b_22_su            Real       _atom_site_aniso.b_22_su  ->su _atom_site_aniso.b_22
    b_23               Real       _atom_site_aniso.b_23
    b_23_su            Real       _atom_site_aniso.b_23_su  ->su _atom_site_aniso.b_23
    b_33               Real       _atom_site_aniso.b_33
    b_33_su            Real       _atom_site_aniso.b_33_su  ->su _atom_site_aniso.b_33
    beta_11            Real       _atom_site_aniso.beta_11
    beta_11_su         Real       _atom_site_aniso.beta_11_su  ->su _atom_site_aniso.beta_11
    beta_12            Real       _atom_site_aniso.beta_12
    beta_12_su         Real       _atom_site_aniso.beta_12_su  ->su _atom_site_aniso.beta_12
    beta_13            Real       _atom_site_aniso.beta_13
    beta_13_su         Real       _atom_site_aniso.beta_13_su  ->su _atom_site_aniso.beta_13
    beta_22            Real       _atom_site_aniso.beta_22
    beta_22_su         Real       _atom_site_aniso.beta_22_su  ->su _atom_site_aniso.beta_22
    beta_23            Real       _atom_site_aniso.beta_23
    beta_23_su         Real       _atom_site_aniso.beta_23_su  ->su _atom_site_aniso.beta_23
    beta_33            Real       _atom_site_aniso.beta_33
    beta_33_su         Real       _atom_site_aniso.beta_33_su  ->su _atom_site_aniso.beta_33
    matrix_b           Real       _atom_site_aniso.matrix_b
    matrix_b_su        Real       _atom_site_aniso.matrix_b_su  ->su _atom_site_aniso.matrix_b
    matrix_beta        Real       _atom_site_aniso.matrix_beta
    matrix_beta_su     Real       _atom_site_aniso.matrix_beta_su  ->su _atom_site_aniso.matrix_beta
    matrix_u           Real       _atom_site_aniso.matrix_u
    matrix_u_su        Real       _atom_site_aniso.matrix_u_su  ->su _atom_site_aniso.matrix_u
    ratio              Real       _atom_site_aniso.ratio
    symmform           Text       _atom_site_aniso.symmform
    type_symbol        Word       _atom_site_aniso.type_symbol
    u_11               Real       _atom_site_aniso.u_11
    u_11_su            Real       _atom_site_aniso.u_11_su  ->su _atom_site_aniso.u_11
    u_12               Real       _atom_site_aniso.u_12
    u_12_su            Real       _atom_site_aniso.u_12_su  ->su _atom_site_aniso.u_12
    u_13               Real       _atom_site_aniso.u_13
    u_13_su            Real       _atom_site_aniso.u_13_su  ->su _atom_site_aniso.u_13
    u_22               Real       _atom_site_aniso.u_22
    u_22_su            Real       _atom_site_aniso.u_22_su  ->su _atom_site_aniso.u_22
    u_23               Real       _atom_site_aniso.u_23
    u_23_su            Real       _atom_site_aniso.u_23_su  ->su _atom_site_aniso.u_23
    u_33               Real       _atom_site_aniso.u_33
    u_33_su            Real       _atom_site_aniso.u_33_su  ->su _atom_site_aniso.u_33
  foreign keys
    (label, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    type_symbol -> atom_type.symbol  DEFERRABLE

atom_sites  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id   TEXT     NOT NULL  synthetic
    _cifflow_id         TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id     INTEGER  NOT NULL  UNIQUE  synthetic
    solution_hydrogens  Text       _atom_sites.solution_hydrogens
    solution_primary    Text       _atom_sites.solution_primary
    solution_secondary  Text       _atom_sites.solution_secondary
    special_details     Text       _atom_sites.special_details

atom_sites_cartn_transform  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    axes               Text       _atom_sites_cartn_transform.axes
    mat_11             Real       _atom_sites_cartn_transform.mat_11
    mat_11_su          Real       _atom_sites_cartn_transform.mat_11_su  ->su _atom_sites_cartn_transform.mat_11
    mat_12             Real       _atom_sites_cartn_transform.mat_12
    mat_12_su          Real       _atom_sites_cartn_transform.mat_12_su  ->su _atom_sites_cartn_transform.mat_12
    mat_13             Real       _atom_sites_cartn_transform.mat_13
    mat_13_su          Real       _atom_sites_cartn_transform.mat_13_su  ->su _atom_sites_cartn_transform.mat_13
    mat_21             Real       _atom_sites_cartn_transform.mat_21
    mat_21_su          Real       _atom_sites_cartn_transform.mat_21_su  ->su _atom_sites_cartn_transform.mat_21
    mat_22             Real       _atom_sites_cartn_transform.mat_22
    mat_22_su          Real       _atom_sites_cartn_transform.mat_22_su  ->su _atom_sites_cartn_transform.mat_22
    mat_23             Real       _atom_sites_cartn_transform.mat_23
    mat_23_su          Real       _atom_sites_cartn_transform.mat_23_su  ->su _atom_sites_cartn_transform.mat_23
    mat_31             Real       _atom_sites_cartn_transform.mat_31
    mat_31_su          Real       _atom_sites_cartn_transform.mat_31_su  ->su _atom_sites_cartn_transform.mat_31
    mat_32             Real       _atom_sites_cartn_transform.mat_32
    mat_32_su          Real       _atom_sites_cartn_transform.mat_32_su  ->su _atom_sites_cartn_transform.mat_32
    mat_33             Real       _atom_sites_cartn_transform.mat_33
    mat_33_su          Real       _atom_sites_cartn_transform.mat_33_su  ->su _atom_sites_cartn_transform.mat_33
    matrix             Real       _atom_sites_cartn_transform.matrix
    matrix_su          Real       _atom_sites_cartn_transform.matrix_su  ->su _atom_sites_cartn_transform.matrix
    vec_1              Real       _atom_sites_cartn_transform.vec_1
    vec_1_su           Real       _atom_sites_cartn_transform.vec_1_su  ->su _atom_sites_cartn_transform.vec_1
    vec_2              Real       _atom_sites_cartn_transform.vec_2
    vec_2_su           Real       _atom_sites_cartn_transform.vec_2_su  ->su _atom_sites_cartn_transform.vec_2
    vec_3              Real       _atom_sites_cartn_transform.vec_3
    vec_3_su           Real       _atom_sites_cartn_transform.vec_3_su  ->su _atom_sites_cartn_transform.vec_3
    vector             Real       _atom_sites_cartn_transform.vector
    vector_su          Real       _atom_sites_cartn_transform.vector_su  ->su _atom_sites_cartn_transform.vector

atom_sites_fract_transform  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    axes               Text       _atom_sites_fract_transform.axes
    mat_11             Real       _atom_sites_fract_transform.mat_11
    mat_11_su          Real       _atom_sites_fract_transform.mat_11_su  ->su _atom_sites_fract_transform.mat_11
    mat_12             Real       _atom_sites_fract_transform.mat_12
    mat_12_su          Real       _atom_sites_fract_transform.mat_12_su  ->su _atom_sites_fract_transform.mat_12
    mat_13             Real       _atom_sites_fract_transform.mat_13
    mat_13_su          Real       _atom_sites_fract_transform.mat_13_su  ->su _atom_sites_fract_transform.mat_13
    mat_21             Real       _atom_sites_fract_transform.mat_21
    mat_21_su          Real       _atom_sites_fract_transform.mat_21_su  ->su _atom_sites_fract_transform.mat_21
    mat_22             Real       _atom_sites_fract_transform.mat_22
    mat_22_su          Real       _atom_sites_fract_transform.mat_22_su  ->su _atom_sites_fract_transform.mat_22
    mat_23             Real       _atom_sites_fract_transform.mat_23
    mat_23_su          Real       _atom_sites_fract_transform.mat_23_su  ->su _atom_sites_fract_transform.mat_23
    mat_31             Real       _atom_sites_fract_transform.mat_31
    mat_31_su          Real       _atom_sites_fract_transform.mat_31_su  ->su _atom_sites_fract_transform.mat_31
    mat_32             Real       _atom_sites_fract_transform.mat_32
    mat_32_su          Real       _atom_sites_fract_transform.mat_32_su  ->su _atom_sites_fract_transform.mat_32
    mat_33             Real       _atom_sites_fract_transform.mat_33
    mat_33_su          Real       _atom_sites_fract_transform.mat_33_su  ->su _atom_sites_fract_transform.mat_33
    matrix             Real       _atom_sites_fract_transform.matrix
    matrix_su          Real       _atom_sites_fract_transform.matrix_su  ->su _atom_sites_fract_transform.matrix
    vec_1              Real       _atom_sites_fract_transform.vec_1
    vec_1_su           Real       _atom_sites_fract_transform.vec_1_su  ->su _atom_sites_fract_transform.vec_1
    vec_2              Real       _atom_sites_fract_transform.vec_2
    vec_2_su           Real       _atom_sites_fract_transform.vec_2_su  ->su _atom_sites_fract_transform.vec_2
    vec_3              Real       _atom_sites_fract_transform.vec_3
    vec_3_su           Real       _atom_sites_fract_transform.vec_3_su  ->su _atom_sites_fract_transform.vec_3
    vector             Real       _atom_sites_fract_transform.vector
    vector_su          Real       _atom_sites_fract_transform.vector_su  ->su _atom_sites_fract_transform.vector

atom_type  [Loop]
  PK  symbol
  columns
    _cifflow_block_id           TEXT     NOT NULL  synthetic
    _cifflow_row_id             INTEGER  NOT NULL  UNIQUE  synthetic
    symbol                      Word     NOT NULL  PK  _atom_type.symbol
    analytical_mass_percent     Real       _atom_type.analytical_mass_percent
    analytical_mass_percent_su  Real       _atom_type.analytical_mass_percent_su  ->su _atom_type.analytical_mass_percent
    atomic_mass                 Real       _atom_type.atomic_mass
    atomic_number               Integer    _atom_type.atomic_number
    description                 Text       _atom_type.description
    display_colour              Word       _atom_type.display_colour
    electron_count              Integer    _atom_type.electron_count
    element_symbol              Word       _atom_type.element_symbol
    mass_number                 Integer    _atom_type.mass_number
    number_in_cell              Real       _atom_type.number_in_cell
    oxidation_number            Integer    _atom_type.oxidation_number
    radius_bond                 Real       _atom_type.radius_bond
    radius_contact              Real       _atom_type.radius_contact

atom_type_scat  [Loop]
  PK  symbol
  columns
    _cifflow_block_id                   TEXT     NOT NULL  synthetic
    _cifflow_row_id                     INTEGER  NOT NULL  UNIQUE  synthetic
    symbol                              Word     PK  _atom_type_scat.symbol
    cromer_mann_a1                      Real       _atom_type_scat.cromer_mann_a1
    cromer_mann_a2                      Real       _atom_type_scat.cromer_mann_a2
    cromer_mann_a3                      Real       _atom_type_scat.cromer_mann_a3
    cromer_mann_a4                      Real       _atom_type_scat.cromer_mann_a4
    cromer_mann_b1                      Real       _atom_type_scat.cromer_mann_b1
    cromer_mann_b2                      Real       _atom_type_scat.cromer_mann_b2
    cromer_mann_b3                      Real       _atom_type_scat.cromer_mann_b3
    cromer_mann_b4                      Real       _atom_type_scat.cromer_mann_b4
    cromer_mann_c                       Real       _atom_type_scat.cromer_mann_c
    cromer_mann_coeffs                  Real       _atom_type_scat.cromer_mann_coeffs
    dispersion                          Complex    _atom_type_scat.dispersion
    dispersion_imag                     Real       _atom_type_scat.dispersion_imag
    dispersion_imag_cu                  Real       _atom_type_scat.dispersion_imag_cu
    dispersion_imag_mo                  Real       _atom_type_scat.dispersion_imag_mo
    dispersion_real                     Real       _atom_type_scat.dispersion_real
    dispersion_real_cu                  Real       _atom_type_scat.dispersion_real_cu
    dispersion_real_mo                  Real       _atom_type_scat.dispersion_real_mo
    dispersion_source                   Text       _atom_type_scat.dispersion_source
    exponential_polynomial_coefs        Real       _atom_type_scat.exponential_polynomial_coefs
    exponential_polynomial_coefs_su     Real       _atom_type_scat.exponential_polynomial_coefs_su  ->su _atom_type_scat.exponential_polynomial_coefs
    exponential_polynomial_lower_limit  Real       _atom_type_scat.exponential_polynomial_lower_limit
    exponential_polynomial_upper_limit  Real       _atom_type_scat.exponential_polynomial_upper_limit
    gaussian_coefs                      Real       _atom_type_scat.gaussian_coefs
    gaussian_coefs_su                   Real       _atom_type_scat.gaussian_coefs_su  ->su _atom_type_scat.gaussian_coefs
    gaussian_lower_limit                Real       _atom_type_scat.gaussian_lower_limit
    gaussian_upper_limit                Real       _atom_type_scat.gaussian_upper_limit
    hi_ang_fox_c0                       Real       _atom_type_scat.hi_ang_fox_c0
    hi_ang_fox_c1                       Real       _atom_type_scat.hi_ang_fox_c1
    hi_ang_fox_c2                       Real       _atom_type_scat.hi_ang_fox_c2
    hi_ang_fox_c3                       Real       _atom_type_scat.hi_ang_fox_c3
    hi_ang_fox_coeffs                   Real       _atom_type_scat.hi_ang_fox_coeffs
    inv_mott_bethe_coefs                Real       _atom_type_scat.inv_mott_bethe_coefs
    inv_mott_bethe_coefs_su             Real       _atom_type_scat.inv_mott_bethe_coefs_su  ->su _atom_type_scat.inv_mott_bethe_coefs
    inv_mott_bethe_lower_limit          Real       _atom_type_scat.inv_mott_bethe_lower_limit
    inv_mott_bethe_upper_limit          Real       _atom_type_scat.inv_mott_bethe_upper_limit
    length_neutron                      Real       _atom_type_scat.length_neutron
    source                              Text       _atom_type_scat.source
    versus_stol_list                    Text       _atom_type_scat.versus_stol_list  DEPRECATED -> _atom_scat_versus_stol.atom_type, _atom_scat_versus_stol.stol_value, _atom_scat_versus_stol.scat_value
  foreign keys
    symbol -> atom_type.symbol  DEFERRABLE

audit  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT      NOT NULL  synthetic
    _cifflow_id        TEXT      NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER   NOT NULL  UNIQUE  synthetic
    block_code         Word        _audit.block_code
    block_doi          Text        _audit.block_doi
    creation_date      DateTime    _audit.creation_date
    creation_method    Text        _audit.creation_method
    schema             Text        _audit.schema
    update_record      Text        _audit.update_record

audit_author  [Loop]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _audit_author.id
    address            Text       _audit_author.address
    email              Text       _audit_author.email
    fax                Text       _audit_author.fax
    id_orcid           Code       _audit_author.id_orcid
    name               Text       _audit_author.name
    phone              Text       _audit_author.phone

audit_author_role  [Loop]
  PK  id, role
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     PK  _audit_author_role.id
    role               Text     NOT NULL  PK  _audit_author_role.role
    special_details    Text       _audit_author_role.special_details
  foreign keys
    id -> audit_author.id  DEFERRABLE

audit_conform  [Loop]
  PK  dict_name
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    dict_name          Text     NOT NULL  PK  _audit_conform.dict_name
    dict_doi           Text       _audit_conform.dict_doi
    dict_location      Text       _audit_conform.dict_location
    dict_version       Word       _audit_conform.dict_version

audit_contact_author  [Loop]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     PK  _audit_contact_author.id
    address            Text       _audit_contact_author.address
    email              Text       _audit_contact_author.email
    fax                Text       _audit_contact_author.fax
    name               Text       _audit_contact_author.name
    phone              Text       _audit_contact_author.phone
  foreign keys
    id -> audit_author.id  DEFERRABLE

audit_dataset  [Loop]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _audit_dataset.id

audit_link  [Loop]
  PK  block_code
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    block_code         Word     NOT NULL  PK  _audit_link.block_code
    block_description  Text       _audit_link.block_description

audit_support  [Loop]
  PK  id
  columns
    _cifflow_block_id         TEXT     NOT NULL  synthetic
    _cifflow_row_id           INTEGER  NOT NULL  UNIQUE  synthetic
    id                        Word     NOT NULL  PK  _audit_support.id
    award_number              Text       _audit_support.award_number
    award_recipient           Text       _audit_support.award_recipient
    award_type                Text       _audit_support.award_type
    funding_organization      Text       _audit_support.funding_organization
    funding_organization_doi  Word       _audit_support.funding_organization_doi
    funding_organization_url  Uri        _audit_support.funding_organization_url
    special_details           Text       _audit_support.special_details

axis  [Loop]
  PK  id, equipment
  columns
    _cifflow_block_id    TEXT     NOT NULL  synthetic
    _cifflow_row_id      INTEGER  NOT NULL  UNIQUE  synthetic
    id                   Word     NOT NULL  PK  _axis.id
    equipment            Code     NOT NULL  PK  _axis.equipment
    depends_on           Word       _axis.depends_on
    equipment_component  Code       _axis.equipment_component
    offset_1_            Real       _axis.offset[1]
    offset_2_            Real       _axis.offset[2]
    offset_3_            Real       _axis.offset[3]
    rotation             Real       _axis.rotation
    rotation_axis        Code       _axis.rotation_axis
    system               Code       _axis.system
    type                 Code       _axis.type
    vector_1_            Real       _axis.vector[1]
    vector_2_            Real       _axis.vector[2]
    vector_3_            Real       _axis.vector[3]
  foreign keys
    (depends_on, equipment) -> axis.(id, equipment)  DEFERRABLE

cell  [Set]
  PK  structure_id
  columns
    _cifflow_block_id                TEXT     NOT NULL  synthetic
    _cifflow_row_id                  INTEGER  NOT NULL  UNIQUE  synthetic
    structure_id                     Word     PK  _cell.structure_id
    angle_alpha                      Real       _cell.angle_alpha
    angle_alpha_su                   Real       _cell.angle_alpha_su  ->su _cell.angle_alpha
    angle_beta                       Real       _cell.angle_beta
    angle_beta_su                    Real       _cell.angle_beta_su  ->su _cell.angle_beta
    angle_gamma                      Real       _cell.angle_gamma
    angle_gamma_su                   Real       _cell.angle_gamma_su  ->su _cell.angle_gamma
    atomic_mass                      Real       _cell.atomic_mass
    convert_uij_to_betaij            Real       _cell.convert_uij_to_betaij
    convert_uij_to_betaij_su         Real       _cell.convert_uij_to_betaij_su  ->su _cell.convert_uij_to_betaij
    convert_uiso_to_uij              Real       _cell.convert_uiso_to_uij
    convert_uiso_to_uij_su           Real       _cell.convert_uiso_to_uij_su  ->su _cell.convert_uiso_to_uij
    diffrn_id                        Word       _cell.diffrn_id
    formula_units_z                  Real       _cell.formula_units_z
    formula_units_z_details          Text       _cell.formula_units_z_details
    formula_units_z_prime            Real       _cell.formula_units_z_prime
    formula_units_z_prime_details    Text       _cell.formula_units_z_prime_details
    length_a                         Real       _cell.length_a
    length_a_su                      Real       _cell.length_a_su  ->su _cell.length_a
    length_b                         Real       _cell.length_b
    length_b_su                      Real       _cell.length_b_su  ->su _cell.length_b
    length_c                         Real       _cell.length_c
    length_c_su                      Real       _cell.length_c_su  ->su _cell.length_c
    metric_tensor                    Real       _cell.metric_tensor
    orthogonal_matrix                Real       _cell.orthogonal_matrix
    reciprocal_angle_alpha           Real       _cell.reciprocal_angle_alpha
    reciprocal_angle_alpha_su        Real       _cell.reciprocal_angle_alpha_su  ->su _cell.reciprocal_angle_alpha
    reciprocal_angle_beta            Real       _cell.reciprocal_angle_beta
    reciprocal_angle_beta_su         Real       _cell.reciprocal_angle_beta_su  ->su _cell.reciprocal_angle_beta
    reciprocal_angle_gamma           Real       _cell.reciprocal_angle_gamma
    reciprocal_angle_gamma_su        Real       _cell.reciprocal_angle_gamma_su  ->su _cell.reciprocal_angle_gamma
    reciprocal_length_a              Real       _cell.reciprocal_length_a
    reciprocal_length_a_su           Real       _cell.reciprocal_length_a_su  ->su _cell.reciprocal_length_a
    reciprocal_length_b              Real       _cell.reciprocal_length_b
    reciprocal_length_b_su           Real       _cell.reciprocal_length_b_su  ->su _cell.reciprocal_length_b
    reciprocal_length_c              Real       _cell.reciprocal_length_c
    reciprocal_length_c_su           Real       _cell.reciprocal_length_c_su  ->su _cell.reciprocal_length_c
    reciprocal_metric_tensor         Real       _cell.reciprocal_metric_tensor
    reciprocal_metric_tensor_su      Real       _cell.reciprocal_metric_tensor_su  ->su _cell.reciprocal_metric_tensor
    reciprocal_orthogonal_matrix     Real       _cell.reciprocal_orthogonal_matrix
    reciprocal_orthogonal_matrix_su  Real       _cell.reciprocal_orthogonal_matrix_su  ->su _cell.reciprocal_orthogonal_matrix
    reciprocal_vector_a              Real       _cell.reciprocal_vector_a
    reciprocal_vector_a_su           Real       _cell.reciprocal_vector_a_su  ->su _cell.reciprocal_vector_a
    reciprocal_vector_b              Real       _cell.reciprocal_vector_b
    reciprocal_vector_b_su           Real       _cell.reciprocal_vector_b_su  ->su _cell.reciprocal_vector_b
    reciprocal_vector_c              Real       _cell.reciprocal_vector_c
    reciprocal_vector_c_su           Real       _cell.reciprocal_vector_c_su  ->su _cell.reciprocal_vector_c
    special_details                  Text       _cell.special_details
    vector_a                         Real       _cell.vector_a
    vector_a_su                      Real       _cell.vector_a_su  ->su _cell.vector_a
    vector_b                         Real       _cell.vector_b
    vector_b_su                      Real       _cell.vector_b_su  ->su _cell.vector_b
    vector_c                         Real       _cell.vector_c
    vector_c_su                      Real       _cell.vector_c_su  ->su _cell.vector_c
    volume                           Real       _cell.volume
    volume_su                        Real       _cell.volume_su  ->su _cell.volume
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE
    structure_id -> structure.id  DEFERRABLE

cell_measurement  [Set]
  PK  structure_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    structure_id       Word     PK  _cell_measurement.structure_id
    condition_id       Word       _cell_measurement.condition_id
    diffrn_id          Word       _cell_measurement.diffrn_id
    pressure           Real       _cell_measurement.pressure  DEPRECATED -> _diffrn.ambient_pressure
    pressure_su        Real       _cell_measurement.pressure_su  ->su _cell_measurement.pressure  DEPRECATED -> _diffrn.ambient_pressure_su
    radiation          Text       _cell_measurement.radiation  DEPRECATED
    reflns_used        Integer    _cell_measurement.reflns_used
    temperature        Real       _cell_measurement.temperature  DEPRECATED -> _diffrn.ambient_temperature
    temperature_su     Real       _cell_measurement.temperature_su  ->su _cell_measurement.temperature  DEPRECATED -> _diffrn.ambient_temperature_su
    theta_max          Real       _cell_measurement.theta_max
    theta_min          Real       _cell_measurement.theta_min
    wavelength         Real       _cell_measurement.wavelength  DEPRECATED -> _diffrn_radiation_wavelength.value
    wavelength_su      Real       _cell_measurement.wavelength_su  ->su _cell_measurement.wavelength  DEPRECATED -> _diffrn_radiation_wavelength.value_su
  foreign keys
    condition_id -> diffrn.id  DEFERRABLE
    diffrn_id -> diffrn.id  DEFERRABLE
    structure_id -> structure.id  DEFERRABLE

cell_measurement_refln  [Loop]
  PK  index_h, index_k, index_l, structure_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    index_h            Integer  NOT NULL  PK  _cell_measurement_refln.index_h
    index_k            Integer  NOT NULL  PK  _cell_measurement_refln.index_k
    index_l            Integer  NOT NULL  PK  _cell_measurement_refln.index_l
    structure_id       Word     PK  _cell_measurement_refln.structure_id
    hkl                Integer    _cell_measurement_refln.hkl
    theta              Real       _cell_measurement_refln.theta
    theta_su           Real       _cell_measurement_refln.theta_su  ->su _cell_measurement_refln.theta
  foreign keys
    structure_id -> structure.id  DEFERRABLE

chemical  [Set]
  PK  phase_id
  columns
    _cifflow_block_id                TEXT     NOT NULL  synthetic
    _cifflow_row_id                  INTEGER  NOT NULL  UNIQUE  synthetic
    phase_id                         Text     PK  _chemical.phase_id
    absolute_configuration           Text       _chemical.absolute_configuration
    compound_source                  Text       _chemical.compound_source
    enantioexcess_bulk               Real       _chemical.enantioexcess_bulk
    enantioexcess_bulk_su            Real       _chemical.enantioexcess_bulk_su  ->su _chemical.enantioexcess_bulk
    enantioexcess_bulk_technique     Text       _chemical.enantioexcess_bulk_technique
    enantioexcess_crystal            Real       _chemical.enantioexcess_crystal
    enantioexcess_crystal_su         Real       _chemical.enantioexcess_crystal_su  ->su _chemical.enantioexcess_crystal
    enantioexcess_crystal_technique  Text       _chemical.enantioexcess_crystal_technique
    identifier_inchi                 Word       _chemical.identifier_inchi
    identifier_inchi_key             Word       _chemical.identifier_inchi_key
    identifier_inchi_version         Code       _chemical.identifier_inchi_version
    melting_point                    Real       _chemical.melting_point
    melting_point_gt                 Real       _chemical.melting_point_gt
    melting_point_lt                 Real       _chemical.melting_point_lt
    melting_point_su                 Real       _chemical.melting_point_su  ->su _chemical.melting_point
    name_common                      Text       _chemical.name_common
    name_mineral                     Text       _chemical.name_mineral
    name_structure_type              Text       _chemical.name_structure_type
    name_systematic                  Text       _chemical.name_systematic
    optical_rotation                 Text       _chemical.optical_rotation
    properties_biological            Text       _chemical.properties_biological
    properties_physical              Text       _chemical.properties_physical
    temperature_decomposition        Real       _chemical.temperature_decomposition
    temperature_decomposition_gt     Real       _chemical.temperature_decomposition_gt
    temperature_decomposition_lt     Real       _chemical.temperature_decomposition_lt
    temperature_decomposition_su     Real       _chemical.temperature_decomposition_su  ->su _chemical.temperature_decomposition
    temperature_sublimation          Real       _chemical.temperature_sublimation
    temperature_sublimation_gt       Real       _chemical.temperature_sublimation_gt
    temperature_sublimation_lt       Real       _chemical.temperature_sublimation_lt
    temperature_sublimation_su       Real       _chemical.temperature_sublimation_su  ->su _chemical.temperature_sublimation
  foreign keys
    phase_id -> pd_phase.id  DEFERRABLE

chemical_conn_atom  [Loop]
  PK  number, phase_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    number             Integer  NOT NULL  PK  _chemical_conn_atom.number
    phase_id           Text     PK  _chemical_conn_atom.phase_id
    charge             Integer    _chemical_conn_atom.charge
    display_x          Real       _chemical_conn_atom.display_x
    display_y          Real       _chemical_conn_atom.display_y
    nca                Integer    _chemical_conn_atom.nca
    nh                 Integer    _chemical_conn_atom.nh
    type_symbol        Word       _chemical_conn_atom.type_symbol
  foreign keys
    type_symbol -> atom_type.symbol  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

chemical_conn_bond  [Loop]
  PK  phase_id, atom_1, atom_2
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    phase_id           Text     PK  _chemical_conn_bond.phase_id
    atom_1             Integer  PK  _chemical_conn_bond.atom_1
    atom_2             Integer  PK  _chemical_conn_bond.atom_2
    distance           Real       _chemical_conn_bond.distance
    id                 Word       _chemical_conn_bond.id
    type               Text       _chemical_conn_bond.type
  foreign keys
    (atom_1, phase_id) -> chemical_conn_atom.(number, phase_id)  DEFERRABLE
    (atom_2, phase_id) -> chemical_conn_atom.(number, phase_id)  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

chemical_formula  [Set]
  PK  phase_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    phase_id           Text     PK  _chemical_formula.phase_id
    analytical         Text       _chemical_formula.analytical
    iupac              Text       _chemical_formula.iupac
    moiety             Text       _chemical_formula.moiety
    structural         Text       _chemical_formula.structural
    sum                Text       _chemical_formula.sum
    weight             Real       _chemical_formula.weight
    weight_meas        Real       _chemical_formula.weight_meas
    weight_meas_su     Real       _chemical_formula.weight_meas_su  ->su _chemical_formula.weight_meas
  foreign keys
    phase_id -> pd_phase.id  DEFERRABLE

citation  [Loop]
  PK  id
  columns
    _cifflow_block_id    TEXT     NOT NULL  synthetic
    _cifflow_row_id      INTEGER  NOT NULL  UNIQUE  synthetic
    id                   Word     NOT NULL  PK  _citation.id
    abstract             Text       _citation.abstract
    abstract_id_cas      Text       _citation.abstract_id_cas
    book_id_isbn         Code       _citation.book_id_isbn
    book_publisher       Text       _citation.book_publisher
    book_publisher_city  Text       _citation.book_publisher_city
    book_title           Text       _citation.book_title
    coordinate_linkage   Text       _citation.coordinate_linkage
    country              Text       _citation.country
    database_id_csd      Word       _citation.database_id_csd
    database_id_medline  Code       _citation.database_id_medline
    doi                  Text       _citation.doi
    journal_abbrev       Text       _citation.journal_abbrev
    journal_full         Text       _citation.journal_full
    journal_id_astm      Code       _citation.journal_id_astm
    journal_id_csd       Code       _citation.journal_id_csd
    journal_id_issn      Code       _citation.journal_id_issn
    journal_issue        Text       _citation.journal_issue
    journal_volume       Integer    _citation.journal_volume
    language             Text       _citation.language
    page_first           Text       _citation.page_first
    page_last            Text       _citation.page_last
    publisher            Text       _citation.publisher
    special_details      Text       _citation.special_details
    title                Text       _citation.title
    url                  Uri        _citation.url
    year                 Integer    _citation.year

citation_author  [Loop]
  PK  citation_id, ordinal
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    citation_id        Word     PK  _citation_author.citation_id
    ordinal            Integer  NOT NULL  PK  _citation_author.ordinal
    name               Text       _citation_author.name
  foreign keys
    citation_id -> citation.id  DEFERRABLE

citation_editor  [Loop]
  PK  citation_id, ordinal
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    citation_id        Word     PK  _citation_editor.citation_id
    ordinal            Integer  NOT NULL  PK  _citation_editor.ordinal
    name               Text       _citation_editor.name
  foreign keys
    citation_id -> citation.id  DEFERRABLE

computing  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id     TEXT     NOT NULL  synthetic
    _cifflow_id           TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id       INTEGER  NOT NULL  UNIQUE  synthetic
    cell_refinement       Text       _computing.cell_refinement
    diffrn_collection     Text       _computing.diffrn_collection
    diffrn_reduction      Text       _computing.diffrn_reduction
    molecular_graphics    Text       _computing.molecular_graphics
    publication_material  Text       _computing.publication_material
    sample_tracking       Text       _computing.sample_tracking
    structure_refinement  Text       _computing.structure_refinement
    structure_solution    Text       _computing.structure_solution

database  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    csd_history        Text       _database.csd_history
    dataset_doi        Text       _database.dataset_doi
    journal_astm       Code       _database.journal_astm
    journal_csd        Code       _database.journal_csd

database_code  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id    TEXT     NOT NULL  synthetic
    _cifflow_id          TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id      INTEGER  NOT NULL  UNIQUE  synthetic
    amcsd                Code       _database_code.amcsd
    bincstrdb            Code       _database_code.bincstrdb
    cas                  Code       _database_code.cas
    cod                  Code       _database_code.cod
    csd                  Word       _database_code.csd
    depnum_ccdc_archive  Code       _database_code.depnum_ccdc_archive
    depnum_ccdc_fiz      Code       _database_code.depnum_ccdc_fiz
    depnum_ccdc_journal  Code       _database_code.depnum_ccdc_journal
    icsd                 Code       _database_code.icsd
    mdf                  Code       _database_code.mdf
    nbs                  Code       _database_code.nbs
    pdb                  Word       _database_code.pdb
    pdf                  Code       _database_code.pdf

database_related  [Loop]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _database_related.id
    database_id        Word       _database_related.database_id
    entry_code         Text       _database_related.entry_code
    relation           Text       _database_related.relation
    special_details    Text       _database_related.special_details

diffraction  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic

diffrn  [Set]
  PK  id
  columns
    _cifflow_block_id             TEXT     NOT NULL  synthetic
    _cifflow_row_id               INTEGER  NOT NULL  UNIQUE  synthetic
    id                            Word     NOT NULL  PK  _diffrn.id
    ambient_environment           Text       _diffrn.ambient_environment
    ambient_pressure              Real       _diffrn.ambient_pressure
    ambient_pressure_gt           Real       _diffrn.ambient_pressure_gt
    ambient_pressure_lt           Real       _diffrn.ambient_pressure_lt
    ambient_pressure_su           Real       _diffrn.ambient_pressure_su  ->su _diffrn.ambient_pressure
    ambient_temperature           Real       _diffrn.ambient_temperature
    ambient_temperature_details   Text       _diffrn.ambient_temperature_details
    ambient_temperature_gt        Real       _diffrn.ambient_temperature_gt
    ambient_temperature_lt        Real       _diffrn.ambient_temperature_lt
    ambient_temperature_su        Real       _diffrn.ambient_temperature_su  ->su _diffrn.ambient_temperature
    crystal_id                    Word       _diffrn.crystal_id
    crystal_support               Text       _diffrn.crystal_support
    crystal_treatment             Text       _diffrn.crystal_treatment
    diffrn_measurement_id         Word       _diffrn.diffrn_measurement_id
    diffrn_radiation_id           Word       _diffrn.diffrn_radiation_id
    flux_density                  Real       _diffrn.flux_density
    measured_fraction_theta_full  Real       _diffrn.measured_fraction_theta_full
    measured_fraction_theta_max   Real       _diffrn.measured_fraction_theta_max
    precession_semi_angle         Real       _diffrn.precession_semi_angle
    precession_semi_angle_su      Real       _diffrn.precession_semi_angle_su  ->su _diffrn.precession_semi_angle
    special_details               Text       _diffrn.special_details
    symmetry_description          Text       _diffrn.symmetry_description
    total_dose                    Real       _diffrn.total_dose
    total_dose_su                 Real       _diffrn.total_dose_su  ->su _diffrn.total_dose
    total_exposure_time           Real       _diffrn.total_exposure_time
  foreign keys
    diffrn_measurement_id -> diffrn_measurement.id  DEFERRABLE
    diffrn_radiation_id -> diffrn_radiation.id  DEFERRABLE
    crystal_id -> exptl_crystal.id  DEFERRABLE

diffrn_attenuator  [Loop]
  PK  code
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    code               Word     NOT NULL  PK  _diffrn_attenuator.code
    material           Text       _diffrn_attenuator.material
    scale              Real       _diffrn_attenuator.scale

diffrn_component_pid  [Loop]
  PK  pid, framework
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    pid                Text     NOT NULL  PK  _diffrn_component_pid.pid
    framework          Text     NOT NULL  PK  _diffrn_component_pid.framework
    details            Text       _diffrn_component_pid.details

diffrn_data_frame  [Loop]
  PK  id, detector_element_id
  columns
    _cifflow_block_id    TEXT     NOT NULL  synthetic
    _cifflow_row_id      INTEGER  NOT NULL  UNIQUE  synthetic
    id                   Word     NOT NULL  PK  _diffrn_data_frame.id
    detector_element_id  Word     PK  _diffrn_data_frame.detector_element_id
    array_id             Word       _diffrn_data_frame.array_id
    array_section_id     Word       _diffrn_data_frame.array_section_id
    binary_id            Integer    _diffrn_data_frame.binary_id
    center_derived       Code       _diffrn_data_frame.center_derived
    center_fast          Real       _diffrn_data_frame.center_fast
    center_slow          Real       _diffrn_data_frame.center_slow
    center_units         Word       _diffrn_data_frame.center_units
    details              Text       _diffrn_data_frame.details
    diffrn_id            Word       _diffrn_data_frame.diffrn_id
  foreign keys
    (array_id, binary_id) -> array_data.(array_id, binary_id)  DEFERRABLE
    array_id -> array_structure.id  DEFERRABLE
    diffrn_id -> diffrn.id  DEFERRABLE

diffrn_detector  [Set]
  PK  diffrn_id, id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    diffrn_id          Word     PK  _diffrn_detector.diffrn_id
    id                 Word     NOT NULL  PK  _diffrn_detector.id
    area_resol_mean    Real       _diffrn_detector.area_resol_mean
    description        Text       _diffrn_detector.description
    details            Text       _diffrn_detector.details
    dtime              Real       _diffrn_detector.dtime
    gain_setting       Text       _diffrn_detector.gain_setting
    layer_thickness    Real       _diffrn_detector.layer_thickness
    make               Text       _diffrn_detector.make
    number_of_axes     Integer    _diffrn_detector.number_of_axes
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE

diffrn_detector_axis  [Loop]
  PK  detector_id, axis_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    detector_id        Word     PK  _diffrn_detector_axis.detector_id
    axis_id            Word     PK  _diffrn_detector_axis.axis_id
    diffrn_id          Word       _diffrn_detector_axis.diffrn_id
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE
    (diffrn_id, detector_id) -> diffrn_detector.(diffrn_id, id)  DEFERRABLE

diffrn_detector_element  [Loop]
  PK  id, detector_id
  columns
    _cifflow_block_id       TEXT     NOT NULL  synthetic
    _cifflow_row_id         INTEGER  NOT NULL  UNIQUE  synthetic
    id                      Word     NOT NULL  PK  _diffrn_detector_element.id
    detector_id             Word     NOT NULL  PK  _diffrn_detector_element.detector_id
    center_1_               Real       _diffrn_detector_element.center[1]
    center_2_               Real       _diffrn_detector_element.center[2]
    diffrn_id               Word       _diffrn_detector_element.diffrn_id
    reference_center_fast   Real       _diffrn_detector_element.reference_center_fast
    reference_center_slow   Real       _diffrn_detector_element.reference_center_slow
    reference_center_units  Word       _diffrn_detector_element.reference_center_units
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE

diffrn_measurement  [Set]
  PK  id
  columns
    _cifflow_block_id                 TEXT     NOT NULL  synthetic
    _cifflow_row_id                   INTEGER  NOT NULL  UNIQUE  synthetic
    id                                Word     NOT NULL  PK  _diffrn_measurement.id
    details                           Text       _diffrn_measurement.details
    device_class                      Text       _diffrn_measurement.device_class
    device_details                    Text       _diffrn_measurement.device_details
    device_make                       Text       _diffrn_measurement.device_make
    diffrn_id                         Word       _diffrn_measurement.diffrn_id
    method                            Text       _diffrn_measurement.method
    method_precession                 Code       _diffrn_measurement.method_precession
    number_of_axes                    Integer    _diffrn_measurement.number_of_axes
    rotation_mode                     Code       _diffrn_measurement.rotation_mode
    sample_detector_distance          Real       _diffrn_measurement.sample_detector_distance
    sample_detector_distance_derived  Code       _diffrn_measurement.sample_detector_distance_derived
    sample_detector_voffset           Real       _diffrn_measurement.sample_detector_voffset
    sample_tracking                   Code       _diffrn_measurement.sample_tracking
    sample_tracking_method            Text       _diffrn_measurement.sample_tracking_method
    specimen_attachment_type          Word       _diffrn_measurement.specimen_attachment_type
    specimen_support                  Text       _diffrn_measurement.specimen_support
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE

diffrn_measurement_axis  [Loop]
  PK  measurement_device, measurement_id, axis_id
  columns
    _cifflow_block_id   TEXT     NOT NULL  synthetic
    _cifflow_row_id     INTEGER  NOT NULL  UNIQUE  synthetic
    measurement_device  Text     PK  _diffrn_measurement_axis.measurement_device
    measurement_id      Word     PK  _diffrn_measurement_axis.measurement_id
    axis_id             Word     PK  _diffrn_measurement_axis.axis_id
    diffrn_id           Word       _diffrn_measurement_axis.diffrn_id
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE
    measurement_id -> diffrn_measurement.id  DEFERRABLE

diffrn_orient  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic

diffrn_orient_matrix  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    type               Text       _diffrn_orient_matrix.type
    ub_11              Real       _diffrn_orient_matrix.ub_11
    ub_12              Real       _diffrn_orient_matrix.ub_12
    ub_13              Real       _diffrn_orient_matrix.ub_13
    ub_21              Real       _diffrn_orient_matrix.ub_21
    ub_22              Real       _diffrn_orient_matrix.ub_22
    ub_23              Real       _diffrn_orient_matrix.ub_23
    ub_31              Real       _diffrn_orient_matrix.ub_31
    ub_32              Real       _diffrn_orient_matrix.ub_32
    ub_33              Real       _diffrn_orient_matrix.ub_33
    ubij               Real       _diffrn_orient_matrix.ubij

diffrn_orient_refln  [Loop]
  PK  index_h, index_k, index_l
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    index_h            Integer  NOT NULL  PK  _diffrn_orient_refln.index_h
    index_k            Integer  NOT NULL  PK  _diffrn_orient_refln.index_k
    index_l            Integer  NOT NULL  PK  _diffrn_orient_refln.index_l
    angle_chi          Real       _diffrn_orient_refln.angle_chi
    angle_chi_su       Real       _diffrn_orient_refln.angle_chi_su  ->su _diffrn_orient_refln.angle_chi
    angle_kappa        Real       _diffrn_orient_refln.angle_kappa
    angle_kappa_su     Real       _diffrn_orient_refln.angle_kappa_su  ->su _diffrn_orient_refln.angle_kappa
    angle_omega        Real       _diffrn_orient_refln.angle_omega
    angle_omega_su     Real       _diffrn_orient_refln.angle_omega_su  ->su _diffrn_orient_refln.angle_omega
    angle_phi          Real       _diffrn_orient_refln.angle_phi
    angle_phi_su       Real       _diffrn_orient_refln.angle_phi_su  ->su _diffrn_orient_refln.angle_phi
    angle_psi          Real       _diffrn_orient_refln.angle_psi
    angle_psi_su       Real       _diffrn_orient_refln.angle_psi_su  ->su _diffrn_orient_refln.angle_psi
    angle_theta        Real       _diffrn_orient_refln.angle_theta
    angle_theta_su     Real       _diffrn_orient_refln.angle_theta_su  ->su _diffrn_orient_refln.angle_theta
    hkl                Integer    _diffrn_orient_refln.hkl

diffrn_radiation  [Set]
  PK  id
  columns
    _cifflow_block_id              TEXT     NOT NULL  synthetic
    _cifflow_row_id                INTEGER  NOT NULL  UNIQUE  synthetic
    id                             Word     NOT NULL  PK  _diffrn_radiation.id
    beam_flux                      Real       _diffrn_radiation.beam_flux
    beam_flux_density              Real       _diffrn_radiation.beam_flux_density
    beam_flux_density_integrated   Real       _diffrn_radiation.beam_flux_density_integrated
    beam_flux_integrated           Real       _diffrn_radiation.beam_flux_integrated
    beam_flux_integration_time     Real       _diffrn_radiation.beam_flux_integration_time
    beam_incident_flux             Real       _diffrn_radiation.beam_incident_flux
    beam_incident_flux_integrated  Real       _diffrn_radiation.beam_incident_flux_integrated
    beam_width                     Real       _diffrn_radiation.beam_width
    collimation                    Text       _diffrn_radiation.collimation
    diffrn_id                      Word       _diffrn_radiation.diffrn_id
    div_x_source                   Real       _diffrn_radiation.div_x_source
    div_x_y_source                 Real       _diffrn_radiation.div_x_y_source
    div_y_source                   Real       _diffrn_radiation.div_y_source
    filter_edge                    Real       _diffrn_radiation.filter_edge
    illumination_mode              Code       _diffrn_radiation.illumination_mode
    inhomogeneity                  Real       _diffrn_radiation.inhomogeneity
    monochromator                  Text       _diffrn_radiation.monochromator
    polarisn_norm                  Real       _diffrn_radiation.polarisn_norm
    polarisn_norm_esd              Real       _diffrn_radiation.polarisn_norm_esd
    polarisn_ratio                 Real       _diffrn_radiation.polarisn_ratio
    polarisn_ratio_esd             Real       _diffrn_radiation.polarisn_ratio_esd
    polarizn_source_norm           Real       _diffrn_radiation.polarizn_source_norm
    polarizn_source_norm_esd       Real       _diffrn_radiation.polarizn_source_norm_esd
    polarizn_source_ratio          Real       _diffrn_radiation.polarizn_source_ratio
    polarizn_source_ratio_esd      Real       _diffrn_radiation.polarizn_source_ratio_esd
    polarizn_stokes_i              Real       _diffrn_radiation.polarizn_stokes_i
    polarizn_stokes_i_esd          Real       _diffrn_radiation.polarizn_stokes_i_esd
    polarizn_stokes_q              Real       _diffrn_radiation.polarizn_stokes_q
    polarizn_stokes_q_esd          Real       _diffrn_radiation.polarizn_stokes_q_esd
    polarizn_stokes_u              Real       _diffrn_radiation.polarizn_stokes_u
    polarizn_stokes_u_esd          Real       _diffrn_radiation.polarizn_stokes_u_esd
    polarizn_stokes_v              Real       _diffrn_radiation.polarizn_stokes_v
    polarizn_stokes_v_esd          Real       _diffrn_radiation.polarizn_stokes_v_esd
    probe                          Text       _diffrn_radiation.probe
    type                           Text       _diffrn_radiation.type  DEPRECATED -> _diffrn_radiation_wavelength.type
    wavelength_id                  Word       _diffrn_radiation.wavelength_id
    xray_symbol                    Text       _diffrn_radiation.xray_symbol  DEPRECATED -> _diffrn_radiation_wavelength.xray_symbol
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE

diffrn_radiation_wavelength  [Loop]
  PK  id, radiation_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _diffrn_radiation_wavelength.id
    radiation_id       Word     PK  _diffrn_radiation_wavelength.radiation_id
    details            Text       _diffrn_radiation_wavelength.details
    determination      Text       _diffrn_radiation_wavelength.determination
    diffractogram_id   Text       _diffrn_radiation_wavelength.diffractogram_id
    phase_id           Text       _diffrn_radiation_wavelength.phase_id
    special_details    Text       _diffrn_radiation_wavelength.special_details
    type               Text       _diffrn_radiation_wavelength.type
    value              Real       _diffrn_radiation_wavelength.value
    value_su           Real       _diffrn_radiation_wavelength.value_su  ->su _diffrn_radiation_wavelength.value
    wt                 Real       _diffrn_radiation_wavelength.wt
    xray_symbol        Text       _diffrn_radiation_wavelength.xray_symbol
  foreign keys
    radiation_id -> diffrn_radiation.id  DEFERRABLE
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

diffrn_refln  [Loop]
  PK  id
  columns
    _cifflow_block_id      TEXT     NOT NULL  synthetic
    _cifflow_row_id        INTEGER  NOT NULL  UNIQUE  synthetic
    id                     Word     NOT NULL  PK  _diffrn_refln.id
    angle_chi              Real       _diffrn_refln.angle_chi
    angle_kappa            Real       _diffrn_refln.angle_kappa
    angle_omega            Real       _diffrn_refln.angle_omega
    angle_phi              Real       _diffrn_refln.angle_phi
    angle_psi              Real       _diffrn_refln.angle_psi
    angle_theta            Real       _diffrn_refln.angle_theta
    attenuator_code        Word       _diffrn_refln.attenuator_code
    class_code             Word       _diffrn_refln.class_code
    counts_bg_1            Integer    _diffrn_refln.counts_bg_1
    counts_bg_2            Integer    _diffrn_refln.counts_bg_2
    counts_net             Real       _diffrn_refln.counts_net
    counts_net_su          Real       _diffrn_refln.counts_net_su  ->su _diffrn_refln.counts_net
    counts_peak            Integer    _diffrn_refln.counts_peak
    counts_total           Integer    _diffrn_refln.counts_total
    detect_slit_horiz      Real       _diffrn_refln.detect_slit_horiz
    detect_slit_vert       Real       _diffrn_refln.detect_slit_vert
    diffrn_id              Word       _diffrn_refln.diffrn_id
    elapsed_time           Real       _diffrn_refln.elapsed_time
    frame_id               Word       _diffrn_refln.frame_id
    hkl                    Integer    _diffrn_refln.hkl
    index_h                Integer    _diffrn_refln.index_h
    index_k                Integer    _diffrn_refln.index_k
    index_l                Integer    _diffrn_refln.index_l
    intensity_bg_1         Real       _diffrn_refln.intensity_bg_1
    intensity_bg_1_su      Real       _diffrn_refln.intensity_bg_1_su  ->su _diffrn_refln.intensity_bg_1
    intensity_bg_2         Real       _diffrn_refln.intensity_bg_2
    intensity_bg_2_su      Real       _diffrn_refln.intensity_bg_2_su  ->su _diffrn_refln.intensity_bg_2
    intensity_net          Real       _diffrn_refln.intensity_net
    intensity_net_su       Real       _diffrn_refln.intensity_net_su  ->su _diffrn_refln.intensity_net
    intensity_peak         Real       _diffrn_refln.intensity_peak
    intensity_peak_su      Real       _diffrn_refln.intensity_peak_su  ->su _diffrn_refln.intensity_peak
    intensity_total        Real       _diffrn_refln.intensity_total
    intensity_total_su     Real       _diffrn_refln.intensity_total_su  ->su _diffrn_refln.intensity_total
    scale_group_code       Word       _diffrn_refln.scale_group_code
    scan_mode              Text       _diffrn_refln.scan_mode
    scan_mode_backgd       Text       _diffrn_refln.scan_mode_backgd
    scan_rate              Real       _diffrn_refln.scan_rate
    scan_time_backgd       Real       _diffrn_refln.scan_time_backgd
    scan_width             Real       _diffrn_refln.scan_width
    sin_theta_over_lambda  Real       _diffrn_refln.sin_theta_over_lambda
    standard_code          Word       _diffrn_refln.standard_code
    wavelength             Real       _diffrn_refln.wavelength
    wavelength_id          Word       _diffrn_refln.wavelength_id
    radiation_id           TEXT     synthetic
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE
    attenuator_code -> diffrn_attenuator.code  DEFERRABLE
    (wavelength_id, radiation_id) -> diffrn_radiation_wavelength.(id, radiation_id)  DEFERRABLE
    class_code -> diffrn_reflns_class.code  DEFERRABLE
    scale_group_code -> diffrn_scale_group.code  DEFERRABLE

diffrn_reflns  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id             TEXT     NOT NULL  synthetic
    _cifflow_id                   TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id               INTEGER  NOT NULL  UNIQUE  synthetic
    av_r_equivalents              Real       _diffrn_reflns.av_r_equivalents
    av_suneti_over_neti           Real       _diffrn_reflns.av_suneti_over_neti
    diffrn_id                     Word       _diffrn_reflns.diffrn_id
    laue_measured_fraction_full   Real       _diffrn_reflns.laue_measured_fraction_full
    laue_measured_fraction_max    Real       _diffrn_reflns.laue_measured_fraction_max
    limit_h_max                   Integer    _diffrn_reflns.limit_h_max
    limit_h_min                   Integer    _diffrn_reflns.limit_h_min
    limit_k_max                   Integer    _diffrn_reflns.limit_k_max
    limit_k_min                   Integer    _diffrn_reflns.limit_k_min
    limit_l_max                   Integer    _diffrn_reflns.limit_l_max
    limit_l_min                   Integer    _diffrn_reflns.limit_l_min
    limit_max                     Integer    _diffrn_reflns.limit_max
    limit_min                     Integer    _diffrn_reflns.limit_min
    number                        Integer    _diffrn_reflns.number
    point_measured_fraction_full  Real       _diffrn_reflns.point_measured_fraction_full
    point_measured_fraction_max   Real       _diffrn_reflns.point_measured_fraction_max
    reduction_process             Text       _diffrn_reflns.reduction_process
    resolution_full               Real       _diffrn_reflns.resolution_full
    resolution_max                Real       _diffrn_reflns.resolution_max
    theta_full                    Real       _diffrn_reflns.theta_full
    theta_max                     Real       _diffrn_reflns.theta_max
    theta_min                     Real       _diffrn_reflns.theta_min
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE

diffrn_reflns_class  [Loop]
  PK  code
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    code               Word     NOT NULL  PK  _diffrn_reflns_class.code
    av_r_eq            Real       _diffrn_reflns_class.av_r_eq
    av_sui_over_i      Real       _diffrn_reflns_class.av_sui_over_i
    d_res_high         Real       _diffrn_reflns_class.d_res_high
    d_res_low          Real       _diffrn_reflns_class.d_res_low
    description        Text       _diffrn_reflns_class.description
    number             Integer    _diffrn_reflns_class.number

diffrn_reflns_transf_matrix  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    11                 Real       _diffrn_reflns_transf_matrix.11
    12                 Real       _diffrn_reflns_transf_matrix.12
    13                 Real       _diffrn_reflns_transf_matrix.13
    21                 Real       _diffrn_reflns_transf_matrix.21
    22                 Real       _diffrn_reflns_transf_matrix.22
    23                 Real       _diffrn_reflns_transf_matrix.23
    31                 Real       _diffrn_reflns_transf_matrix.31
    32                 Real       _diffrn_reflns_transf_matrix.32
    33                 Real       _diffrn_reflns_transf_matrix.33
    tij                Real       _diffrn_reflns_transf_matrix.tij

diffrn_scale_group  [Loop]
  PK  code
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    code               Word     NOT NULL  PK  _diffrn_scale_group.code
    i_net              Real       _diffrn_scale_group.i_net
    i_net_su           Real       _diffrn_scale_group.i_net_su  ->su _diffrn_scale_group.i_net

diffrn_scan  [Loop]
  PK  id
  columns
    _cifflow_block_id   TEXT     NOT NULL  synthetic
    _cifflow_row_id     INTEGER  NOT NULL  UNIQUE  synthetic
    id                  Word     NOT NULL  PK  _diffrn_scan.id
    date_end            Text       _diffrn_scan.date_end
    date_end_estimated  Text       _diffrn_scan.date_end_estimated
    date_start          Text       _diffrn_scan.date_start
    diffrn_id           Word       _diffrn_scan.diffrn_id
    frame_id_end        Word       _diffrn_scan.frame_id_end
    frame_id_start      Word       _diffrn_scan.frame_id_start
    frames              Integer    _diffrn_scan.frames
    integration_time    Real       _diffrn_scan.integration_time
    time_period         Real       _diffrn_scan.time_period
    time_rstrt_incr     Real       _diffrn_scan.time_rstrt_incr
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE

diffrn_scan_axis  [Loop]
  PK  scan_id, axis_id
  columns
    _cifflow_block_id        TEXT     NOT NULL  synthetic
    _cifflow_row_id          INTEGER  NOT NULL  UNIQUE  synthetic
    scan_id                  Word     PK  _diffrn_scan_axis.scan_id
    axis_id                  Word     PK  _diffrn_scan_axis.axis_id
    angle_increment          Real       _diffrn_scan_axis.angle_increment
    angle_range              Real       _diffrn_scan_axis.angle_range
    angle_rstrt_incr         Real       _diffrn_scan_axis.angle_rstrt_incr
    angle_start              Real       _diffrn_scan_axis.angle_start
    diffrn_id                Word       _diffrn_scan_axis.diffrn_id
    displacement_increment   Real       _diffrn_scan_axis.displacement_increment
    displacement_range       Real       _diffrn_scan_axis.displacement_range
    displacement_rstrt_incr  Real       _diffrn_scan_axis.displacement_rstrt_incr
    displacement_start       Real       _diffrn_scan_axis.displacement_start
    reference_angle          Real       _diffrn_scan_axis.reference_angle
    reference_displacement   Real       _diffrn_scan_axis.reference_displacement
  foreign keys
    scan_id -> diffrn_scan.id  DEFERRABLE

diffrn_scan_collection  [Loop]
  PK  scan_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    scan_id            Word     NOT NULL  PK  _diffrn_scan_collection.scan_id
    details            Text       _diffrn_scan_collection.details
    diffrn_id          Word       _diffrn_scan_collection.diffrn_id
    translation_width  Real       _diffrn_scan_collection.translation_width
    type               Text       _diffrn_scan_collection.type
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE

diffrn_scan_frame  [Loop]
  PK  scan_id, frame_id
  columns
    _cifflow_block_id      TEXT     NOT NULL  synthetic
    _cifflow_row_id        INTEGER  NOT NULL  UNIQUE  synthetic
    scan_id                Word     PK  _diffrn_scan_frame.scan_id
    frame_id               Word     PK  _diffrn_scan_frame.frame_id
    date                   Text       _diffrn_scan_frame.date
    diffrn_id              Word       _diffrn_scan_frame.diffrn_id
    frame_number           Integer    _diffrn_scan_frame.frame_number
    integration_time       Real       _diffrn_scan_frame.integration_time
    polarizn_stokes_i      Real       _diffrn_scan_frame.polarizn_stokes_i
    polarizn_stokes_i_esd  Real       _diffrn_scan_frame.polarizn_stokes_i_esd
    polarizn_stokes_q      Real       _diffrn_scan_frame.polarizn_stokes_q
    polarizn_stokes_q_esd  Real       _diffrn_scan_frame.polarizn_stokes_q_esd
    polarizn_stokes_u      Real       _diffrn_scan_frame.polarizn_stokes_u
    polarizn_stokes_u_esd  Real       _diffrn_scan_frame.polarizn_stokes_u_esd
    polarizn_stokes_v      Real       _diffrn_scan_frame.polarizn_stokes_v
    polarizn_stokes_v_esd  Real       _diffrn_scan_frame.polarizn_stokes_v_esd
    time_period            Real       _diffrn_scan_frame.time_period
    time_rstrt_incr        Real       _diffrn_scan_frame.time_rstrt_incr
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE
    scan_id -> diffrn_scan.id  DEFERRABLE

diffrn_scan_frame_axis  [Loop]
  PK  frame_id, axis_id
  columns
    _cifflow_block_id        TEXT     NOT NULL  synthetic
    _cifflow_row_id          INTEGER  NOT NULL  UNIQUE  synthetic
    frame_id                 Word     PK  _diffrn_scan_frame_axis.frame_id
    axis_id                  Word     PK  _diffrn_scan_frame_axis.axis_id
    angle                    Real       _diffrn_scan_frame_axis.angle
    angle_increment          Real       _diffrn_scan_frame_axis.angle_increment
    angle_rstrt_incr         Real       _diffrn_scan_frame_axis.angle_rstrt_incr
    diffrn_id                Word       _diffrn_scan_frame_axis.diffrn_id
    displacement             Real       _diffrn_scan_frame_axis.displacement
    displacement_increment   Real       _diffrn_scan_frame_axis.displacement_increment
    displacement_rstrt_incr  Real       _diffrn_scan_frame_axis.displacement_rstrt_incr
    reference_angle          Real       _diffrn_scan_frame_axis.reference_angle
    reference_displacement   Real       _diffrn_scan_frame_axis.reference_displacement
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE

diffrn_scan_frame_monitor  [Loop]
  PK  id, detector_id, scan_id, frame_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Integer  NOT NULL  PK  _diffrn_scan_frame_monitor.id
    detector_id        Word     PK  _diffrn_scan_frame_monitor.detector_id
    scan_id            Word     NOT NULL  PK  _diffrn_scan_frame_monitor.scan_id
    frame_id           Word     PK  _diffrn_scan_frame_monitor.frame_id
    diffrn_id          Word       _diffrn_scan_frame_monitor.diffrn_id
    integration_time   Real       _diffrn_scan_frame_monitor.integration_time
    monitor_value      Real       _diffrn_scan_frame_monitor.monitor_value
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE
    (diffrn_id, detector_id) -> diffrn_detector.(diffrn_id, id)  DEFERRABLE

diffrn_source  [Set]
  PK  radiation_id
  columns
    _cifflow_block_id              TEXT     NOT NULL  synthetic
    _cifflow_row_id                INTEGER  NOT NULL  UNIQUE  synthetic
    radiation_id                   Word     PK  _diffrn_source.radiation_id
    beamline                       Text       _diffrn_source.beamline
    convergence_angle              Real       _diffrn_source.convergence_angle
    current                        Real       _diffrn_source.current
    description                    Text       _diffrn_source.description  DEPRECATED -> _diffrn_source.device, _diffrn_source.details
    details                        Text       _diffrn_source.details
    device                         Text       _diffrn_source.device
    diffrn_id                      Word       _diffrn_source.diffrn_id
    ed_diffracting_area_selection  Text       _diffrn_source.ed_diffracting_area_selection
    facility                       Text       _diffrn_source.facility
    make                           Text       _diffrn_source.make
    power                          Real       _diffrn_source.power
    size                           Text       _diffrn_source.size
    take_off_angle                 Real       _diffrn_source.take_off_angle
    target                         Word       _diffrn_source.target
    voltage                        Real       _diffrn_source.voltage
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE
    radiation_id -> diffrn_radiation.id  DEFERRABLE

diffrn_standard_refln  [Loop]
  PK  index_h, index_k, index_l
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    index_h            Integer  NOT NULL  PK  _diffrn_standard_refln.index_h
    index_k            Integer  NOT NULL  PK  _diffrn_standard_refln.index_k
    index_l            Integer  NOT NULL  PK  _diffrn_standard_refln.index_l
    code               Word       _diffrn_standard_refln.code
    hkl                Integer    _diffrn_standard_refln.hkl

diffrn_standards  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id    TEXT     NOT NULL  synthetic
    _cifflow_id          TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id      INTEGER  NOT NULL  UNIQUE  synthetic
    decay_percent        Real       _diffrn_standards.decay_percent
    decay_percent_su     Real       _diffrn_standards.decay_percent_su  ->su _diffrn_standards.decay_percent
    interval_count       Integer    _diffrn_standards.interval_count
    interval_time        Real       _diffrn_standards.interval_time
    number               Integer    _diffrn_standards.number
    scale_su_average     Real       _diffrn_standards.scale_su_average
    scale_su_average_su  Real       _diffrn_standards.scale_su_average_su  ->su _diffrn_standards.scale_su_average

display  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic

display_colour  [Loop]
  PK  hue
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    hue                Word     NOT NULL  PK  _display_colour.hue
    blue               Integer    _display_colour.blue
    green              Integer    _display_colour.green
    red                Integer    _display_colour.red
    rgb                Integer    _display_colour.rgb

exptl  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id           TEXT     NOT NULL  synthetic
    _cifflow_id                 TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id             INTEGER  NOT NULL  UNIQUE  synthetic
    crystals_number             Integer    _exptl.crystals_number
    method                      Text       _exptl.method
    method_details              Text       _exptl.method_details
    method_id_panet             Iri        _exptl.method_id_panet
    special_details             Text       _exptl.special_details
    transmission_factor_max     Real       _exptl.transmission_factor_max
    transmission_factor_max_su  Real       _exptl.transmission_factor_max_su  ->su _exptl.transmission_factor_max
    transmission_factor_min     Real       _exptl.transmission_factor_min
    transmission_factor_min_su  Real       _exptl.transmission_factor_min_su  ->su _exptl.transmission_factor_min

exptl_absorpt  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    coefficient_mu     Real       _exptl_absorpt.coefficient_mu
    coefficient_mu_su  Real       _exptl_absorpt.coefficient_mu_su  ->su _exptl_absorpt.coefficient_mu
    correction_t_max   Real       _exptl_absorpt.correction_t_max
    correction_t_min   Real       _exptl_absorpt.correction_t_min
    correction_type    Text       _exptl_absorpt.correction_type
    process_details    Text       _exptl_absorpt.process_details
    special_details    Text       _exptl_absorpt.special_details

exptl_crystal  [Set]
  PK  id
  columns
    _cifflow_block_id         TEXT     NOT NULL  synthetic
    _cifflow_row_id           INTEGER  NOT NULL  UNIQUE  synthetic
    id                        Word     NOT NULL  PK  _exptl_crystal.id
    colour                    Text       _exptl_crystal.colour
    density_diffrn            Real       _exptl_crystal.density_diffrn
    density_diffrn_su         Real       _exptl_crystal.density_diffrn_su  ->su _exptl_crystal.density_diffrn
    density_meas              Real       _exptl_crystal.density_meas
    density_meas_gt           Real       _exptl_crystal.density_meas_gt
    density_meas_lt           Real       _exptl_crystal.density_meas_lt
    density_meas_su           Real       _exptl_crystal.density_meas_su  ->su _exptl_crystal.density_meas
    density_meas_temp         Real       _exptl_crystal.density_meas_temp
    density_meas_temp_gt      Real       _exptl_crystal.density_meas_temp_gt
    density_meas_temp_lt      Real       _exptl_crystal.density_meas_temp_lt
    density_meas_temp_su      Real       _exptl_crystal.density_meas_temp_su  ->su _exptl_crystal.density_meas_temp
    density_method            Text       _exptl_crystal.density_method
    description               Text       _exptl_crystal.description
    f_000                     Real       _exptl_crystal.f_000
    mosaic_block_size         Real       _exptl_crystal.mosaic_block_size
    mosaic_block_size_su      Real       _exptl_crystal.mosaic_block_size_su  ->su _exptl_crystal.mosaic_block_size
    mosaic_method             Text       _exptl_crystal.mosaic_method
    mosaicity                 Real       _exptl_crystal.mosaicity
    mosaicity_su              Real       _exptl_crystal.mosaicity_su  ->su _exptl_crystal.mosaicity
    preparation               Text       _exptl_crystal.preparation
    pressure_history          Text       _exptl_crystal.pressure_history
    recrystallization_method  Text       _exptl_crystal.recrystallization_method
    size_length               Real       _exptl_crystal.size_length
    size_length_su            Real       _exptl_crystal.size_length_su  ->su _exptl_crystal.size_length
    size_max                  Real       _exptl_crystal.size_max
    size_max_su               Real       _exptl_crystal.size_max_su  ->su _exptl_crystal.size_max
    size_mid                  Real       _exptl_crystal.size_mid
    size_mid_su               Real       _exptl_crystal.size_mid_su  ->su _exptl_crystal.size_mid
    size_min                  Real       _exptl_crystal.size_min
    size_min_su               Real       _exptl_crystal.size_min_su  ->su _exptl_crystal.size_min
    size_rad                  Real       _exptl_crystal.size_rad
    size_rad_su               Real       _exptl_crystal.size_rad_su  ->su _exptl_crystal.size_rad
    thermal_history           Text       _exptl_crystal.thermal_history

exptl_crystal_appearance  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    general            Word       _exptl_crystal_appearance.general
    hue                Word       _exptl_crystal_appearance.hue
    intensity          Word       _exptl_crystal_appearance.intensity

exptl_crystal_face  [Loop]
  PK  index_h, index_k, index_l
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    index_h            Integer  NOT NULL  PK  _exptl_crystal_face.index_h
    index_k            Integer  NOT NULL  PK  _exptl_crystal_face.index_k
    index_l            Integer  NOT NULL  PK  _exptl_crystal_face.index_l
    diffr_chi          Real       _exptl_crystal_face.diffr_chi
    diffr_chi_su       Real       _exptl_crystal_face.diffr_chi_su  ->su _exptl_crystal_face.diffr_chi
    diffr_kappa        Real       _exptl_crystal_face.diffr_kappa
    diffr_kappa_su     Real       _exptl_crystal_face.diffr_kappa_su  ->su _exptl_crystal_face.diffr_kappa
    diffr_phi          Real       _exptl_crystal_face.diffr_phi
    diffr_phi_su       Real       _exptl_crystal_face.diffr_phi_su  ->su _exptl_crystal_face.diffr_phi
    diffr_psi          Real       _exptl_crystal_face.diffr_psi
    diffr_psi_su       Real       _exptl_crystal_face.diffr_psi_su  ->su _exptl_crystal_face.diffr_psi
    hkl                Integer    _exptl_crystal_face.hkl
    perp_dist          Real       _exptl_crystal_face.perp_dist
    perp_dist_su       Real       _exptl_crystal_face.perp_dist_su  ->su _exptl_crystal_face.perp_dist

geom  [Set]
  PK  model_id
  columns
    _cifflow_block_id            TEXT     NOT NULL  synthetic
    _cifflow_row_id              INTEGER  NOT NULL  UNIQUE  synthetic
    model_id                     Word     PK  _geom.model_id
    bond_distance_incr           Real       _geom.bond_distance_incr
    contact_distance_incr        Real       _geom.contact_distance_incr
    min_bond_distance_cutoff     Real       _geom.min_bond_distance_cutoff
    min_contact_distance_cutoff  Real       _geom.min_contact_distance_cutoff
    special_details              Text       _geom.special_details
  foreign keys
    model_id -> model.id  DEFERRABLE

geom_angle  [Loop]
  PK  atom_site_label_1, atom_site_label_2, atom_site_label_3, model_id, site_symmetry_1, site_symmetry_2, site_symmetry_3
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    atom_site_label_1  Word     PK  _geom_angle.atom_site_label_1
    atom_site_label_2  Word     PK  _geom_angle.atom_site_label_2
    atom_site_label_3  Word     PK  _geom_angle.atom_site_label_3
    model_id           Word     PK  _geom_angle.model_id
    site_symmetry_1    Symop    NOT NULL  PK  _geom_angle.site_symmetry_1
    site_symmetry_2    Symop    NOT NULL  PK  _geom_angle.site_symmetry_2
    site_symmetry_3    Symop    NOT NULL  PK  _geom_angle.site_symmetry_3
    distances          Real       _geom_angle.distances
    distances_su       Real       _geom_angle.distances_su  ->su _geom_angle.distances
    id                 Word       _geom_angle.id
    publ_flag          Text       _geom_angle.publ_flag
    value              Real       _geom_angle.value
    value_su           Real       _geom_angle.value_su  ->su _geom_angle.value
    structure_id       TEXT     synthetic
  foreign keys
    (atom_site_label_1, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    (atom_site_label_2, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    (atom_site_label_3, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    model_id -> model.id  DEFERRABLE

geom_bond  [Loop]
  PK  atom_site_label_1, atom_site_label_2, model_id, site_symmetry_1, site_symmetry_2
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    atom_site_label_1  Word     PK  _geom_bond.atom_site_label_1
    atom_site_label_2  Word     PK  _geom_bond.atom_site_label_2
    model_id           Word     PK  _geom_bond.model_id
    site_symmetry_1    Symop    NOT NULL  PK  _geom_bond.site_symmetry_1
    site_symmetry_2    Symop    NOT NULL  PK  _geom_bond.site_symmetry_2
    distance           Real       _geom_bond.distance
    distance_su        Real       _geom_bond.distance_su  ->su _geom_bond.distance
    id                 Word       _geom_bond.id
    multiplicity       Integer    _geom_bond.multiplicity
    publ_flag          Text       _geom_bond.publ_flag
    valence            Real       _geom_bond.valence
    valence_su         Real       _geom_bond.valence_su  ->su _geom_bond.valence
    structure_id       TEXT     synthetic
  foreign keys
    (atom_site_label_1, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    (atom_site_label_2, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    model_id -> model.id  DEFERRABLE

geom_contact  [Loop]
  PK  atom_site_label_1, atom_site_label_2, model_id, site_symmetry_1, site_symmetry_2
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    atom_site_label_1  Word     PK  _geom_contact.atom_site_label_1
    atom_site_label_2  Word     PK  _geom_contact.atom_site_label_2
    model_id           Word     PK  _geom_contact.model_id
    site_symmetry_1    Symop    NOT NULL  PK  _geom_contact.site_symmetry_1
    site_symmetry_2    Symop    NOT NULL  PK  _geom_contact.site_symmetry_2
    distance           Real       _geom_contact.distance
    distance_su        Real       _geom_contact.distance_su  ->su _geom_contact.distance
    id                 Word       _geom_contact.id
    publ_flag          Text       _geom_contact.publ_flag
    structure_id       TEXT     synthetic
  foreign keys
    (atom_site_label_1, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    (atom_site_label_2, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    model_id -> model.id  DEFERRABLE

geom_hbond  [Loop]
  PK  atom_site_label_d, atom_site_label_h, atom_site_label_a, model_id, site_symmetry_d, site_symmetry_h, site_symmetry_a
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    atom_site_label_d  Word     PK  _geom_hbond.atom_site_label_d
    atom_site_label_h  Word     PK  _geom_hbond.atom_site_label_h
    atom_site_label_a  Word     PK  _geom_hbond.atom_site_label_a
    model_id           Word     PK  _geom_hbond.model_id
    site_symmetry_d    Symop    NOT NULL  PK  _geom_hbond.site_symmetry_d
    site_symmetry_h    Symop    NOT NULL  PK  _geom_hbond.site_symmetry_h
    site_symmetry_a    Symop    NOT NULL  PK  _geom_hbond.site_symmetry_a
    angle_dha          Real       _geom_hbond.angle_dha
    angle_dha_su       Real       _geom_hbond.angle_dha_su  ->su _geom_hbond.angle_dha
    distance_da        Real       _geom_hbond.distance_da
    distance_da_su     Real       _geom_hbond.distance_da_su  ->su _geom_hbond.distance_da
    distance_dh        Real       _geom_hbond.distance_dh
    distance_dh_su     Real       _geom_hbond.distance_dh_su  ->su _geom_hbond.distance_dh
    distance_ha        Real       _geom_hbond.distance_ha
    distance_ha_su     Real       _geom_hbond.distance_ha_su  ->su _geom_hbond.distance_ha
    id                 Word       _geom_hbond.id
    publ_flag          Text       _geom_hbond.publ_flag
    structure_id       TEXT     synthetic
  foreign keys
    (atom_site_label_a, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    (atom_site_label_d, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    (atom_site_label_h, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    model_id -> model.id  DEFERRABLE

geom_torsion  [Loop]
  PK  atom_site_label_1, atom_site_label_2, atom_site_label_3, atom_site_label_4, model_id, site_symmetry_1, site_symmetry_2, site_symmetry_3, site_symmetry_4
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    atom_site_label_1  Word     PK  _geom_torsion.atom_site_label_1
    atom_site_label_2  Word     PK  _geom_torsion.atom_site_label_2
    atom_site_label_3  Word     PK  _geom_torsion.atom_site_label_3
    atom_site_label_4  Word     PK  _geom_torsion.atom_site_label_4
    model_id           Word     PK  _geom_torsion.model_id
    site_symmetry_1    Symop    NOT NULL  PK  _geom_torsion.site_symmetry_1
    site_symmetry_2    Symop    NOT NULL  PK  _geom_torsion.site_symmetry_2
    site_symmetry_3    Symop    NOT NULL  PK  _geom_torsion.site_symmetry_3
    site_symmetry_4    Symop    NOT NULL  PK  _geom_torsion.site_symmetry_4
    angle              Real       _geom_torsion.angle
    angle_su           Real       _geom_torsion.angle_su  ->su _geom_torsion.angle
    distances          Real       _geom_torsion.distances
    distances_su       Real       _geom_torsion.distances_su  ->su _geom_torsion.distances
    id                 Word       _geom_torsion.id
    publ_flag          Text       _geom_torsion.publ_flag
    structure_id       TEXT     synthetic
  foreign keys
    (atom_site_label_1, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    (atom_site_label_2, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    (atom_site_label_3, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    (atom_site_label_4, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    model_id -> model.id  DEFERRABLE

journal  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    coden_astm         Code       _journal.coden_astm
    coden_cambridge    Code       _journal.coden_cambridge
    issue              Text       _journal.issue
    language           Text       _journal.language
    name_full          Text       _journal.name_full
    page_first         Text       _journal.page_first
    page_last          Text       _journal.page_last
    paper_category     Text       _journal.paper_category
    paper_doi          Text       _journal.paper_doi
    paper_number       Text       _journal.paper_number
    paper_pages        Integer    _journal.paper_pages
    paper_url          Uri        _journal.paper_url
    suppl_publ_number  Text       _journal.suppl_publ_number
    suppl_publ_pages   Integer    _journal.suppl_publ_pages
    validation_number  Word       _journal.validation_number
    volume             Integer    _journal.volume
    year               Integer    _journal.year

journal_coeditor  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    address            Text       _journal_coeditor.address
    code               Code       _journal_coeditor.code
    email              Text       _journal_coeditor.email
    fax                Text       _journal_coeditor.fax
    name               Text       _journal_coeditor.name
    notes              Text       _journal_coeditor.notes
    phone              Text       _journal_coeditor.phone

journal_date  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    accepted           Date       _journal_date.accepted
    from_coeditor      Date       _journal_date.from_coeditor
    printers_final     Date       _journal_date.printers_final
    printers_first     Date       _journal_date.printers_first
    proofs_in          Date       _journal_date.proofs_in
    proofs_out         Date       _journal_date.proofs_out
    recd_copyright     Date       _journal_date.recd_copyright
    recd_electronic    Date       _journal_date.recd_electronic
    recd_hard_copy     Date       _journal_date.recd_hard_copy
    to_coeditor        Date       _journal_date.to_coeditor

journal_index  [Loop]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _journal_index.id
    subterm            Text       _journal_index.subterm
    term               Text       _journal_index.term
    type               Text       _journal_index.type

journal_techeditor  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    address            Text       _journal_techeditor.address
    code               Text       _journal_techeditor.code
    email              Text       _journal_techeditor.email
    fax                Text       _journal_techeditor.fax
    name               Text       _journal_techeditor.name
    notes              Text       _journal_techeditor.notes
    phone              Text       _journal_techeditor.phone

map  [Loop]
  PK  id, diffrn_id, entry_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _map.id
    diffrn_id          Word     PK  _map.diffrn_id
    entry_id           Word     NOT NULL  PK  _map.entry_id
    details            Text       _map.details
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE

map_segment  [Loop]
  PK  id, map_id
  columns
    _cifflow_block_id      TEXT     NOT NULL  synthetic
    _cifflow_row_id        INTEGER  NOT NULL  UNIQUE  synthetic
    id                     Word     PK  _map_segment.id
    map_id                 Word     NOT NULL  PK  _map_segment.map_id
    array_id               Word       _map_segment.array_id
    array_section_id       Word       _map_segment.array_section_id
    binary_id              Integer    _map_segment.binary_id
    details                Text       _map_segment.details
    mask_array_id          Word       _map_segment.mask_array_id
    mask_array_section_id  Word       _map_segment.mask_array_section_id
    mask_binary_id         Integer    _map_segment.mask_binary_id

model  [Set]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _model.id
    structure_id       Word       _model.structure_id
  foreign keys
    structure_id -> structure.id  DEFERRABLE

model_site  [Loop]
  PK  label, model_id, symop
  columns
    _cifflow_block_id    TEXT     NOT NULL  synthetic
    _cifflow_row_id      INTEGER  NOT NULL  UNIQUE  synthetic
    label                Word     PK  _model_site.label
    model_id             Word     PK  _model_site.model_id
    symop                Symop    NOT NULL  PK  _model_site.symop
    adp_eigenvalues      Real       _model_site.adp_eigenvalues
    adp_eigenvalues_su   Real       _model_site.adp_eigenvalues_su  ->su _model_site.adp_eigenvalues
    adp_eigenvectors     Real       _model_site.adp_eigenvectors
    adp_eigenvectors_su  Real       _model_site.adp_eigenvectors_su  ->su _model_site.adp_eigenvectors
    adp_matrix_beta      Real       _model_site.adp_matrix_beta
    adp_matrix_beta_su   Real       _model_site.adp_matrix_beta_su  ->su _model_site.adp_matrix_beta
    cartn_xyz            Real       _model_site.cartn_xyz
    cartn_xyz_su         Real       _model_site.cartn_xyz_su  ->su _model_site.cartn_xyz
    display_colour       Word       _model_site.display_colour
    fract_xyz            Real       _model_site.fract_xyz
    fract_xyz_su         Real       _model_site.fract_xyz_su  ->su _model_site.fract_xyz
    id                   Word       _model_site.id
    index                Integer    _model_site.index
    mole_index           Integer    _model_site.mole_index
    radius_bond          Real       _model_site.radius_bond
    radius_contact       Real       _model_site.radius_contact
    type_symbol          Word       _model_site.type_symbol
    structure_id         TEXT     synthetic
  foreign keys
    (label, structure_id) -> atom_site.(label, structure_id)  DEFERRABLE
    type_symbol -> atom_type.symbol  DEFERRABLE
    model_id -> model.id  DEFERRABLE

pd_amorphous  [Loop]
  PK  peak_id, phase_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    peak_id            Code     PK  _pd_amorphous.peak_id
    phase_id           Text     PK  _pd_amorphous.phase_id
    peak_overall_id    Code       _pd_amorphous.peak_overall_id
  foreign keys
    peak_overall_id -> pd_peak_overall.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

pd_background  [Loop]
  PK  diffractogram_id, id
  columns
    _cifflow_block_id                  TEXT     NOT NULL  synthetic
    _cifflow_row_id                    INTEGER  NOT NULL  UNIQUE  synthetic
    diffractogram_id                   Text     PK  _pd_background.diffractogram_id
    id                                 Word     NOT NULL  PK  _pd_background.id
    air_or_thermal_diffuse_coef_1      Real       _pd_background.air_or_thermal_diffuse_coef_1
    air_or_thermal_diffuse_coef_1_su   Real       _pd_background.air_or_thermal_diffuse_coef_1_su  ->su _pd_background.air_or_thermal_diffuse_coef_1
    air_or_thermal_diffuse_coef_2      Real       _pd_background.air_or_thermal_diffuse_coef_2
    air_or_thermal_diffuse_coef_2_su   Real       _pd_background.air_or_thermal_diffuse_coef_2_su  ->su _pd_background.air_or_thermal_diffuse_coef_2
    air_or_thermal_diffuse_coefs_1     Real       _pd_background.air_or_thermal_diffuse_coefs_1
    air_or_thermal_diffuse_coefs_1_su  Real       _pd_background.air_or_thermal_diffuse_coefs_1_su  ->su _pd_background.air_or_thermal_diffuse_coefs_1
    air_or_thermal_diffuse_coefs_2     Real       _pd_background.air_or_thermal_diffuse_coefs_2
    air_or_thermal_diffuse_coefs_2_su  Real       _pd_background.air_or_thermal_diffuse_coefs_2_su  ->su _pd_background.air_or_thermal_diffuse_coefs_2
    air_or_thermal_diffuse_order       Integer    _pd_background.air_or_thermal_diffuse_order
    chebyshev_coef                     Real       _pd_background.chebyshev_coef
    chebyshev_coef_su                  Real       _pd_background.chebyshev_coef_su  ->su _pd_background.chebyshev_coef
    chebyshev_coefs                    Real       _pd_background.chebyshev_coefs
    chebyshev_coefs_su                 Real       _pd_background.chebyshev_coefs_su  ->su _pd_background.chebyshev_coefs
    chebyshev_order                    Integer    _pd_background.chebyshev_order
    cosine_fourier_series_coef         Real       _pd_background.cosine_fourier_series_coef
    cosine_fourier_series_coef_su      Real       _pd_background.cosine_fourier_series_coef_su  ->su _pd_background.cosine_fourier_series_coef
    cosine_fourier_series_coefs        Real       _pd_background.cosine_fourier_series_coefs
    cosine_fourier_series_coefs_su     Real       _pd_background.cosine_fourier_series_coefs_su  ->su _pd_background.cosine_fourier_series_coefs
    cosine_fourier_series_order        Integer    _pd_background.cosine_fourier_series_order
    debye_diffuse_amp                  Real       _pd_background.debye_diffuse_amp
    debye_diffuse_amp_su               Real       _pd_background.debye_diffuse_amp_su  ->su _pd_background.debye_diffuse_amp
    debye_diffuse_displace             Real       _pd_background.debye_diffuse_displace
    debye_diffuse_displace_su          Real       _pd_background.debye_diffuse_displace_su  ->su _pd_background.debye_diffuse_displace
    debye_diffuse_dist                 Real       _pd_background.debye_diffuse_dist
    debye_diffuse_dist_su              Real       _pd_background.debye_diffuse_dist_su  ->su _pd_background.debye_diffuse_dist
    line_segment_intensities           Real       _pd_background.line_segment_intensities
    line_segment_intensities_su        Real       _pd_background.line_segment_intensities_su  ->su _pd_background.line_segment_intensities
    line_segment_intensity             Real       _pd_background.line_segment_intensity
    line_segment_intensity_su          Real       _pd_background.line_segment_intensity_su  ->su _pd_background.line_segment_intensity
    line_segment_x                     Real       _pd_background.line_segment_x
    line_segment_xs                    Real       _pd_background.line_segment_xs
    peak_id                            Code       _pd_background.peak_id
    peak_overall_id                    Code       _pd_background.peak_overall_id
    polynomial_coef                    Real       _pd_background.polynomial_coef
    polynomial_coef_su                 Real       _pd_background.polynomial_coef_su  ->su _pd_background.polynomial_coef
    polynomial_coefs                   Real       _pd_background.polynomial_coefs
    polynomial_coefs_su                Real       _pd_background.polynomial_coefs_su  ->su _pd_background.polynomial_coefs
    polynomial_power                   Real       _pd_background.polynomial_power
    polynomial_power_su                Real       _pd_background.polynomial_power_su  ->su _pd_background.polynomial_power
    polynomial_powers                  Real       _pd_background.polynomial_powers
    polynomial_powers_su               Real       _pd_background.polynomial_powers_su  ->su _pd_background.polynomial_powers
    special_details                    Text       _pd_background.special_details
    x_coordinate                       Word       _pd_background.x_coordinate
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    (diffractogram_id, peak_id) -> pd_peak.(diffractogram_id, id)  DEFERRABLE
    peak_overall_id -> pd_peak_overall.id  DEFERRABLE

pd_block  [Loop]  DEPRECATED
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Text     NOT NULL  PK  _pd_block.id  DEPRECATED -> _pd_phase.id, _pd_diffractogram.id, _audit.block_code

pd_block_diffractogram  [Loop]  DEPRECATED
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Text     PK  _pd_block_diffractogram.id  DEPRECATED -> _pd_diffractogram.id
  foreign keys
    id -> pd_block.id  DEFERRABLE

pd_calc  [Loop]
  PK  point_id, diffractogram_id
  columns
    _cifflow_block_id            TEXT     NOT NULL  synthetic
    _cifflow_row_id              INTEGER  NOT NULL  UNIQUE  synthetic
    point_id                     Code     PK  _pd_calc.point_id
    diffractogram_id             Text     PK  _pd_calc.diffractogram_id
    component_intensities_net    Real       _pd_calc.component_intensities_net
    component_intensities_total  Real       _pd_calc.component_intensities_total
    intensity_bkg                Real       _pd_calc.intensity_bkg
    intensity_net                Real       _pd_calc.intensity_net
    intensity_total              Real       _pd_calc.intensity_total
  foreign keys
    (point_id, diffractogram_id) -> pd_data.(point_id, diffractogram_id)  DEFERRABLE

pd_calc_component  [Loop]
  PK  diffractogram_id, point_id, phase_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    diffractogram_id   Text     PK  _pd_calc_component.diffractogram_id
    point_id           Code     PK  _pd_calc_component.point_id
    phase_id           Text     PK  _pd_calc_component.phase_id
    intensity_net      Real       _pd_calc_component.intensity_net
    intensity_total    Real       _pd_calc_component.intensity_total
  foreign keys
    (point_id, diffractogram_id) -> pd_data.(point_id, diffractogram_id)  DEFERRABLE
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

pd_calc_overall  [Set]
  PK  diffractogram_id
  columns
    _cifflow_block_id             TEXT     NOT NULL  synthetic
    _cifflow_row_id               INTEGER  NOT NULL  UNIQUE  synthetic
    diffractogram_id              Text     PK  _pd_calc_overall.diffractogram_id
    component_presentation_order  Code       _pd_calc_overall.component_presentation_order
    method                        Text       _pd_calc.method
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE

pd_calib  [Loop]  DEPRECATED
  PK  detector_id
  columns
    _cifflow_block_id             TEXT     NOT NULL  synthetic
    _cifflow_row_id               INTEGER  NOT NULL  UNIQUE  synthetic
    detector_id                   Code     PK  _pd_calib.detector_id  DEPRECATED -> _pd_calib_detected_intensity.detector_id
    detector_response             Real       _pd_calib.detector_response  DEPRECATED -> _pd_calib_detected_intensity.detector_response
    detector_response_su          Real       _pd_calib.detector_response_su  ->su _pd_calib.detector_response  DEPRECATED -> _pd_calib_detected_intensity.detector_response_su
    std_internal_mass_percent     Real       _pd_calib.std_internal_mass_percent  DEPRECATED -> _pd_qpa_internal_std.mass_percent
    std_internal_mass_percent_su  Real       _pd_calib.std_internal_mass_percent_su  ->su _pd_calib.std_internal_mass_percent  DEPRECATED -> _pd_qpa_internal_std.mass_percent_su
    std_internal_name             Text       _pd_calib.std_internal_name  DEPRECATED
  foreign keys
    detector_id -> pd_instr_detector.id  DEFERRABLE

pd_calib_d_to_tof  [Loop]
  PK  diffractogram_id, id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    diffractogram_id   Text     PK  _pd_calib_d_to_tof.diffractogram_id
    id                 Code     NOT NULL  PK  _pd_calib_d_to_tof.id
    coeff              Real       _pd_calib_d_to_tof.coeff
    coeff_su           Real       _pd_calib_d_to_tof.coeff_su  ->su _pd_calib_d_to_tof.coeff
    power              Real       _pd_calib_d_to_tof.power
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE

pd_calib_detected_intensity  [Loop]
  PK  detector_id
  columns
    _cifflow_block_id     TEXT     NOT NULL  synthetic
    _cifflow_row_id       INTEGER  NOT NULL  UNIQUE  synthetic
    detector_id           Code     PK  _pd_calib_detected_intensity.detector_id
    detector_response     Real       _pd_calib_detected_intensity.detector_response
    detector_response_su  Real       _pd_calib_detected_intensity.detector_response_su  ->su _pd_calib_detected_intensity.detector_response
    diffractogram_id      Text       _pd_calib_detected_intensity.diffractogram_id
    phase_id              Text       _pd_calib_detected_intensity.phase_id
    special_details       Text       _pd_calib_detected_intensity.special_details
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    detector_id -> pd_instr_detector.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

pd_calib_incident_intensity  [Set]
  PK  instr_id
  columns
    _cifflow_block_id      TEXT     NOT NULL  synthetic
    _cifflow_row_id        INTEGER  NOT NULL  UNIQUE  synthetic
    instr_id               Text     PK  _pd_calib_incident_intensity.instr_id
    diffractogram_id       Text       _pd_calib_incident_intensity.diffractogram_id
    incident_counts        Integer    _pd_calib_incident_intensity.incident_counts
    incident_intensity     Real       _pd_calib_incident_intensity.incident_intensity
    incident_intensity_su  Real       _pd_calib_incident_intensity.incident_intensity_su  ->su _pd_calib_incident_intensity.incident_intensity
    phase_id               Text       _pd_calib_incident_intensity.phase_id
    special_details        Text       _pd_calib_incident_intensity.special_details
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    instr_id -> pd_instr.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

pd_calib_offset  [Loop]  DEPRECATED
  PK  id, detector_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Code     NOT NULL  PK  _pd_calib_offset.id  DEPRECATED -> _pd_calib_xcoord.id
    detector_id        Code     PK  _pd_calib_offset.detector_id  DEPRECATED -> _pd_calib_xcoord.detector_id
    2theta_off_max     Real       _pd_calib.2theta_off_max  DEPRECATED
    2theta_off_min     Real       _pd_calib.2theta_off_min  DEPRECATED
    2theta_off_point   Real       _pd_calib.2theta_off_point  DEPRECATED -> _pd_calib_xcoord.nominal_2theta
    2theta_offset      Real       _pd_calib.2theta_offset  DEPRECATED
    2theta_offset_su   Real       _pd_calib.2theta_offset_su  ->su _pd_calib.2theta_offset  DEPRECATED
  foreign keys
    detector_id -> pd_calib.detector_id  DEFERRABLE

pd_calib_std  [Loop]  DEPRECATED
  PK  detector_id, external_block_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    detector_id        Code     PK  _pd_calib_std.detector_id  DEPRECATED -> _pd_calib_detected_intensity.detector_id, _pd_calib_xcoord.detector_id, _pd_calib_xcoord.nominal_channel
    external_block_id  Text     PK  _pd_calib_std.external_block_id  DEPRECATED -> _pd_calib_detected_intensity.diffractogram_id, _pd_calib_incident_intensity.diffractogram_id, _diffrn_radiation_wavelength.diffractogram_id, _pd_calib_xcoord_overall.diffractogram_id
    external_name      Text       _pd_calib_std.external_name  DEPRECATED
  foreign keys
    external_block_id -> pd_block.id  DEFERRABLE
    detector_id -> pd_instr_detector.id  DEFERRABLE

pd_calib_xcoord  [Loop]
  PK  id, xcoord_overall_id
  columns
    _cifflow_block_id           TEXT     NOT NULL  synthetic
    _cifflow_row_id             INTEGER  NOT NULL  UNIQUE  synthetic
    id                          Text     NOT NULL  PK  _pd_calib_xcoord.id
    xcoord_overall_id           Text     PK  _pd_calib_xcoord.xcoord_overall_id
    actual_2theta               Real       _pd_calib_xcoord.actual_2theta
    actual_2theta_su            Real       _pd_calib_xcoord.actual_2theta_su  ->su _pd_calib_xcoord.actual_2theta
    actual_d_spacing            Real       _pd_calib_xcoord.actual_d_spacing
    actual_d_spacing_su         Real       _pd_calib_xcoord.actual_d_spacing_su  ->su _pd_calib_xcoord.actual_d_spacing
    actual_energy_detection     Real       _pd_calib_xcoord.actual_energy_detection
    actual_energy_detection_su  Real       _pd_calib_xcoord.actual_energy_detection_su  ->su _pd_calib_xcoord.actual_energy_detection
    actual_energy_incident      Real       _pd_calib_xcoord.actual_energy_incident
    actual_energy_incident_su   Real       _pd_calib_xcoord.actual_energy_incident_su  ->su _pd_calib_xcoord.actual_energy_incident
    actual_position             Real       _pd_calib_xcoord.actual_position
    actual_position_su          Real       _pd_calib_xcoord.actual_position_su  ->su _pd_calib_xcoord.actual_position
    actual_recip_len_q          Real       _pd_calib_xcoord.actual_recip_len_q
    actual_recip_len_q_su       Real       _pd_calib_xcoord.actual_recip_len_q_su  ->su _pd_calib_xcoord.actual_recip_len_q
    actual_time_of_flight       Real       _pd_calib_xcoord.actual_time_of_flight
    actual_time_of_flight_su    Real       _pd_calib_xcoord.actual_time_of_flight_su  ->su _pd_calib_xcoord.actual_time_of_flight
    actual_wavelength           Real       _pd_calib_xcoord.actual_wavelength
    actual_wavelength_su        Real       _pd_calib_xcoord.actual_wavelength_su  ->su _pd_calib_xcoord.actual_wavelength
    detector_id                 Code       _pd_calib_xcoord.detector_id
    nominal_2theta              Real       _pd_calib_xcoord.nominal_2theta
    nominal_channel             Integer    _pd_calib_xcoord.nominal_channel
    nominal_d_spacing           Real       _pd_calib_xcoord.nominal_d_spacing
    nominal_energy_detection    Real       _pd_calib_xcoord.nominal_energy_detection
    nominal_energy_incident     Real       _pd_calib_xcoord.nominal_energy_incident
    nominal_position            Real       _pd_calib_xcoord.nominal_position
    nominal_recip_len_q         Real       _pd_calib_xcoord.nominal_recip_len_q
    nominal_time_of_flight      Real       _pd_calib_xcoord.nominal_time_of_flight
    nominal_wavelength          Real       _pd_calib_xcoord.nominal_wavelength
  foreign keys
    xcoord_overall_id -> pd_calib_xcoord_overall.id  DEFERRABLE
    detector_id -> pd_instr_detector.id  DEFERRABLE

pd_calib_xcoord_overall  [Set]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Text     NOT NULL  PK  _pd_calib_xcoord_overall.id
    diffractogram_id   Text       _pd_calib_xcoord_overall.diffractogram_id
    phase_id           Text       _pd_calib_xcoord_overall.phase_id
    special_details    Text       _pd_calib_xcoord_overall.special_details
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

pd_calibration  [Set]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _pd_calibration.id
    conversion_eqn     Text       _pd_calibration.conversion_eqn
    diffractogram_id   Text       _pd_calibration.diffractogram_id
    special_details    Text       _pd_calibration.special_details
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE

pd_char  [Set]
  PK  id
  columns
    _cifflow_block_id           TEXT     NOT NULL  synthetic
    _cifflow_row_id             INTEGER  NOT NULL  UNIQUE  synthetic
    id                          Text     NOT NULL  PK  _pd_char.id
    atten_coef_mu_calc          Real       _pd_char.atten_coef_mu_calc
    atten_coef_mu_calc_su       Real       _pd_char.atten_coef_mu_calc_su  ->su _pd_char.atten_coef_mu_calc
    atten_coef_mu_obs           Real       _pd_char.atten_coef_mu_obs
    atten_coef_mu_obs_su        Real       _pd_char.atten_coef_mu_obs_su  ->su _pd_char.atten_coef_mu_obs
    colour                      Code       _pd_char.colour
    mass_atten_coef_mu_calc     Real       _pd_char.mass_atten_coef_mu_calc
    mass_atten_coef_mu_calc_su  Real       _pd_char.mass_atten_coef_mu_calc_su  ->su _pd_char.mass_atten_coef_mu_calc
    mass_atten_coef_mu_meas     Real       _pd_char.mass_atten_coef_mu_meas
    mass_atten_coef_mu_meas_su  Real       _pd_char.mass_atten_coef_mu_meas_su  ->su _pd_char.mass_atten_coef_mu_meas
    particle_morphology         Text       _pd_char.particle_morphology
    special_details             Text       _pd_char.special_details

pd_data  [Loop]
  PK  point_id, diffractogram_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    point_id           Code     NOT NULL  PK  _pd_data.point_id
    diffractogram_id   Text     PK  _pd_data.diffractogram_id
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE

pd_diffractogram  [Set]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Text     NOT NULL  PK  _pd_diffractogram.id
    diffrn_id          Word       _pd_diffractogram.diffrn_id
    instr_id           Text       _pd_diffractogram.instr_id
    scan_id            Word       _pd_diffractogram.scan_id
    spec_id            Text       _pd_diffractogram.spec_id
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE
    scan_id -> diffrn_scan.id  DEFERRABLE
    instr_id -> pd_instr.id  DEFERRABLE
    spec_id -> pd_spec.id  DEFERRABLE

pd_instr  [Set]
  PK  id
  columns
    _cifflow_block_id       TEXT     NOT NULL  synthetic
    _cifflow_row_id         INTEGER  NOT NULL  UNIQUE  synthetic
    id                      Text     NOT NULL  PK  _pd_instr.id
    2theta_monochr_pre      Real       _pd_instr.2theta_monochr_pre
    beam_size_ax            Real       _pd_instr.beam_size_ax
    beam_size_eq            Real       _pd_instr.beam_size_eq
    cons_illum_flag         Code       _pd_instr.cons_illum_flag
    cons_illum_len          Real       _pd_instr.cons_illum_len
    detector_circle_radius  Real       _pd_instr.detector_circle_radius
    dist_mono_spec          Real       _pd_instr.dist_mono_spec
    dist_src_mono           Real       _pd_instr.dist_src_mono
    dist_src_spec           Real       _pd_instr.dist_src_spec
    divg_ax_mono_spec       Real       _pd_instr.divg_ax_mono_spec
    divg_ax_src_mono        Real       _pd_instr.divg_ax_src_mono
    divg_ax_src_spec        Real       _pd_instr.divg_ax_src_spec
    divg_eq_mono_spec       Real       _pd_instr.divg_eq_mono_spec
    divg_eq_src_mono        Real       _pd_instr.divg_eq_src_mono
    divg_eq_src_spec        Real       _pd_instr.divg_eq_src_spec
    geometry                Text       _pd_instr.geometry
    location                Text       _pd_instr.location
    monochr_pre_spec        Text       _pd_instr.monochr_pre_spec
    radiation_id            Word       _pd_instr.radiation_id
    slit_ax_mono_spec       Real       _pd_instr.slit_ax_mono_spec
    slit_ax_src_mono        Real       _pd_instr.slit_ax_src_mono
    slit_ax_src_spec        Real       _pd_instr.slit_ax_src_spec
    slit_eq_mono_spec       Real       _pd_instr.slit_eq_mono_spec
    slit_eq_src_mono        Real       _pd_instr.slit_eq_src_mono
    slit_eq_src_spec        Real       _pd_instr.slit_eq_src_spec
    soller_ax_mono_spec     Real       _pd_instr.soller_ax_mono_spec
    soller_ax_src_mono      Real       _pd_instr.soller_ax_src_mono
    soller_ax_src_spec      Real       _pd_instr.soller_ax_src_spec
    soller_eq_mono_spec     Real       _pd_instr.soller_eq_mono_spec
    soller_eq_src_mono      Real       _pd_instr.soller_eq_src_mono
    soller_eq_src_spec      Real       _pd_instr.soller_eq_src_spec
    source_size_ax          Real       _pd_instr.source_size_ax
    source_size_eq          Real       _pd_instr.source_size_eq
    special_details         Text       _pd_instr.special_details
  foreign keys
    radiation_id -> diffrn_radiation.id  DEFERRABLE

pd_instr_detector  [Loop]
  PK  id
  columns
    _cifflow_block_id    TEXT     NOT NULL  synthetic
    _cifflow_row_id      INTEGER  NOT NULL  UNIQUE  synthetic
    id                   Code     NOT NULL  PK  _pd_instr_detector.id
    2theta_monochr_post  Real       _pd_instr.2theta_monochr_post
    diffrn_detector_id   Word       _pd_instr_detector.diffrn_detector_id
    diffrn_id            Word       _pd_instr_detector.diffrn_id
    dist_anal_detc       Real       _pd_instr.dist_anal_detc
    dist_spec_anal       Real       _pd_instr.dist_spec_anal
    dist_spec_detc       Real       _pd_instr.dist_spec_detc
    divg_ax_anal_detc    Real       _pd_instr.divg_ax_anal_detc
    divg_ax_spec_anal    Real       _pd_instr.divg_ax_spec_anal
    divg_ax_spec_detc    Real       _pd_instr.divg_ax_spec_detc
    divg_eq_anal_detc    Real       _pd_instr.divg_eq_anal_detc
    divg_eq_spec_anal    Real       _pd_instr.divg_eq_spec_anal
    divg_eq_spec_detc    Real       _pd_instr.divg_eq_spec_detc
    instr_id             Text       _pd_instr_detector.instr_id
    monochr_post_spec    Text       _pd_instr.monochr_post_spec
    slit_ax_anal_detc    Real       _pd_instr.slit_ax_anal_detc
    slit_ax_spec_anal    Real       _pd_instr.slit_ax_spec_anal
    slit_ax_spec_detc    Real       _pd_instr.slit_ax_spec_detc
    slit_eq_anal_detc    Real       _pd_instr.slit_eq_anal_detc
    slit_eq_spec_anal    Real       _pd_instr.slit_eq_spec_anal
    slit_eq_spec_detc    Real       _pd_instr.slit_eq_spec_detc
    soller_ax_anal_detc  Real       _pd_instr.soller_ax_anal_detc
    soller_ax_spec_anal  Real       _pd_instr.soller_ax_spec_anal
    soller_ax_spec_detc  Real       _pd_instr.soller_ax_spec_detc
    soller_eq_anal_detc  Real       _pd_instr.soller_eq_anal_detc
    soller_eq_spec_anal  Real       _pd_instr.soller_eq_spec_anal
    soller_eq_spec_detc  Real       _pd_instr.soller_eq_spec_detc
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE
    (diffrn_id, diffrn_detector_id) -> diffrn_detector.(diffrn_id, id)  DEFERRABLE
    instr_id -> pd_instr.id  DEFERRABLE

pd_meas  [Loop]
  PK  point_id, diffractogram_id
  columns
    _cifflow_block_id        TEXT     NOT NULL  synthetic
    _cifflow_row_id          INTEGER  NOT NULL  UNIQUE  synthetic
    point_id                 Code     PK  _pd_meas.point_id
    diffractogram_id         Text     PK  _pd_meas.diffractogram_id
    2theta_scan              Real       _pd_meas.2theta_scan
    2theta_scan_su           Real       _pd_meas.2theta_scan_su  ->su _pd_meas.2theta_scan
    channel                  Integer    _pd_meas.channel
    counts_background        Integer    _pd_meas.counts_background
    counts_container         Integer    _pd_meas.counts_container
    counts_monitor           Integer    _pd_meas.counts_monitor
    counts_total             Integer    _pd_meas.counts_total
    detector_id              Code       _pd_meas.detector_id
    dist_spec_vdetc          Real       _pd_instr.dist_spec_vdetc
    dist_vsrc_spec           Real       _pd_instr.dist_vsrc_spec
    intensity_background     Real       _pd_meas.intensity_background
    intensity_background_su  Real       _pd_meas.intensity_background_su  ->su _pd_meas.intensity_background
    intensity_container      Real       _pd_meas.intensity_container
    intensity_container_su   Real       _pd_meas.intensity_container_su  ->su _pd_meas.intensity_container
    intensity_monitor        Real       _pd_meas.intensity_monitor
    intensity_monitor_su     Real       _pd_meas.intensity_monitor_su  ->su _pd_meas.intensity_monitor
    intensity_total          Real       _pd_meas.intensity_total
    intensity_total_su       Real       _pd_meas.intensity_total_su  ->su _pd_meas.intensity_total
    position                 Real       _pd_meas.position
    position_su              Real       _pd_meas.position_su  ->su _pd_meas.position
    step_count_time          Real       _pd_meas.step_count_time
    step_count_time_su       Real       _pd_meas.step_count_time_su  ->su _pd_meas.step_count_time
    time_of_flight           Real       _pd_meas.time_of_flight
    time_of_flight_su        Real       _pd_meas.time_of_flight_su  ->su _pd_meas.time_of_flight
    var_illum_len            Real       _pd_instr.var_illum_len
  foreign keys
    (point_id, diffractogram_id) -> pd_data.(point_id, diffractogram_id)  DEFERRABLE
    detector_id -> pd_instr_detector.id  DEFERRABLE

pd_meas_info_author  [Loop]  DEPRECATED
  PK  name
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    name               Text     NOT NULL  PK  _pd_meas_info_author.name  DEPRECATED -> _audit_author.name, _audit_author_role.role
    address            Text       _pd_meas_info_author.address  DEPRECATED -> _audit_author.address, _audit_author_role.role
    email              Text       _pd_meas_info_author.email  DEPRECATED -> _audit_author.email, _audit_author_role.role
    fax                Text       _pd_meas_info_author.fax  DEPRECATED -> _audit_author.fax, _audit_author_role.role
    phone              Text       _pd_meas_info_author.phone  DEPRECATED -> _audit_author.phone, _audit_author_role.role

pd_meas_overall  [Set]
  PK  diffractogram_id
  columns
    _cifflow_block_id   TEXT      NOT NULL  synthetic
    _cifflow_row_id     INTEGER   NOT NULL  UNIQUE  synthetic
    diffractogram_id    Text      PK  _pd_meas_overall.diffractogram_id
    2theta_fixed        Real        _pd_meas.2theta_fixed
    2theta_fixed_su     Real        _pd_meas.2theta_fixed_su  ->su _pd_meas.2theta_fixed
    2theta_range_inc    Real        _pd_meas.2theta_range_inc
    2theta_range_max    Real        _pd_meas.2theta_range_max
    2theta_range_min    Real        _pd_meas.2theta_range_min
    angle_chi           Real        _pd_meas.angle_chi
    angle_chi_su        Real        _pd_meas.angle_chi_su  ->su _pd_meas.angle_chi
    angle_omega         Real        _pd_meas.angle_omega
    angle_omega_su      Real        _pd_meas.angle_omega_su  ->su _pd_meas.angle_omega
    angle_phi           Real        _pd_meas.angle_phi
    angle_phi_su        Real        _pd_meas.angle_phi_su  ->su _pd_meas.angle_phi
    datetime_initiated  DateTime    _pd_meas.datetime_initiated
    number_of_points    Integer     _pd_meas.number_of_points
    rocking_angle       Real        _pd_meas.rocking_angle
    rocking_angle_su    Real        _pd_meas.rocking_angle_su  ->su _pd_meas.rocking_angle
    rocking_axis        Code        _pd_meas.rocking_axis
    scan_method         Code        _pd_meas.scan_method
    special_details     Text        _pd_meas.special_details
    step_count_time     Real        _pd_meas_overall.step_count_time
    step_count_time_su  Real        _pd_meas_overall.step_count_time_su  ->su _pd_meas_overall.step_count_time
    units_of_intensity  Text        _pd_meas.units_of_intensity
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE

pd_peak  [Loop]
  PK  diffractogram_id, id
  columns
    _cifflow_block_id   TEXT     NOT NULL  synthetic
    _cifflow_row_id     INTEGER  NOT NULL  UNIQUE  synthetic
    diffractogram_id    Text     PK  _pd_peak.diffractogram_id
    id                  Code     NOT NULL  PK  _pd_peak.id
    2theta_centroid     Real       _pd_peak.2theta_centroid
    2theta_centroid_su  Real       _pd_peak.2theta_centroid_su  ->su _pd_peak.2theta_centroid
    2theta_maximum      Real       _pd_peak.2theta_maximum
    2theta_maximum_su   Real       _pd_peak.2theta_maximum_su  ->su _pd_peak.2theta_maximum
    d_spacing           Real       _pd_peak.d_spacing
    d_spacing_su        Real       _pd_peak.d_spacing_su  ->su _pd_peak.d_spacing
    intensity           Real       _pd_peak.intensity
    intensity_su        Real       _pd_peak.intensity_su  ->su _pd_peak.intensity
    peak_overall_id     Code       _pd_peak.peak_overall_id
    pk_height           Real       _pd_peak.pk_height
    pk_height_su        Real       _pd_peak.pk_height_su  ->su _pd_peak.pk_height
    wavelength_id       Word       _pd_peak.wavelength_id
    width_2theta        Real       _pd_peak.width_2theta
    width_2theta_su     Real       _pd_peak.width_2theta_su  ->su _pd_peak.width_2theta
    width_d_spacing     Real       _pd_peak.width_d_spacing
    width_d_spacing_su  Real       _pd_peak.width_d_spacing_su  ->su _pd_peak.width_d_spacing
    radiation_id        TEXT     synthetic
  foreign keys
    (wavelength_id, radiation_id) -> diffrn_radiation_wavelength.(id, radiation_id)  DEFERRABLE
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    peak_overall_id -> pd_peak_overall.id  DEFERRABLE

pd_peak_overall  [Set]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Code     NOT NULL  PK  _pd_peak_overall.id
    special_details    Text       _pd_peak.special_details

pd_phase  [Set]
  PK  id
  columns
    _cifflow_block_id           TEXT     NOT NULL  synthetic
    _cifflow_row_id             INTEGER  NOT NULL  UNIQUE  synthetic
    id                          Text     NOT NULL  PK  _pd_phase.id
    atten_coef_mu_calc          Real       _pd_phase.atten_coef_mu_calc
    atten_coef_mu_calc_su       Real       _pd_phase.atten_coef_mu_calc_su  ->su _pd_phase.atten_coef_mu_calc
    density_diffrn              Real       _pd_phase.density_diffrn
    density_diffrn_su           Real       _pd_phase.density_diffrn_su  ->su _pd_phase.density_diffrn
    mass_atten_coef_mu_calc     Real       _pd_phase.mass_atten_coef_mu_calc
    mass_atten_coef_mu_calc_su  Real       _pd_phase.mass_atten_coef_mu_calc_su  ->su _pd_phase.mass_atten_coef_mu_calc
    name                        Text       _pd_phase.name

pd_phase_block  [Loop]  DEPRECATED
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Text     PK  _pd_phase_block.id  DEPRECATED -> _pd_phase.id
  foreign keys
    id -> pd_block.id  DEFERRABLE

pd_phase_mass  [Loop]
  PK  diffractogram_id, phase_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    diffractogram_id   Text     PK  _pd_phase_mass.diffractogram_id
    phase_id           Text     PK  _pd_phase_mass.phase_id
    absolute           Real       _pd_phase_mass.absolute
    absolute_su        Real       _pd_phase_mass.absolute_su  ->su _pd_phase_mass.absolute
    original           Real       _pd_phase_mass.original
    original_su        Real       _pd_phase_mass.original_su  ->su _pd_phase_mass.original
    percent            Real       _pd_phase_mass.percent
    percent_su         Real       _pd_phase_mass.percent_su  ->su _pd_phase_mass.percent
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

pd_pref_orient  [Set]
  PK  diffractogram_id, phase_id
  columns
    _cifflow_block_id                     TEXT     NOT NULL  synthetic
    _cifflow_row_id                       INTEGER  NOT NULL  UNIQUE  synthetic
    diffractogram_id                      Text     PK  _pd_pref_orient.diffractogram_id
    phase_id                              Text     PK  _pd_pref_orient.phase_id
    geom                                  Code       _pd_pref_orient.geom
    special_details                       Text       _pd_pref_orient.special_details
    spherical_harmonics_texture_index     Real       _pd_pref_orient.spherical_harmonics_texture_index
    spherical_harmonics_texture_index_su  Real       _pd_pref_orient.spherical_harmonics_texture_index_su  ->su _pd_pref_orient.spherical_harmonics_texture_index
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

pd_pref_orient_march_dollase  [Loop]
  PK  diffractogram_id, id, phase_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    diffractogram_id   Text     PK  _pd_pref_orient_march_dollase.diffractogram_id
    id                 Text     NOT NULL  PK  _pd_pref_orient_march_dollase.id
    phase_id           Text     PK  _pd_pref_orient_march_dollase.phase_id
    fract              Real       _pd_pref_orient_march_dollase.fract
    fract_su           Real       _pd_pref_orient_march_dollase.fract_su  ->su _pd_pref_orient_march_dollase.fract
    hkl                Integer    _pd_pref_orient_march_dollase.hkl
    index_h            Integer    _pd_pref_orient_march_dollase.index_h
    index_k            Integer    _pd_pref_orient_march_dollase.index_k
    index_l            Integer    _pd_pref_orient_march_dollase.index_l
    r                  Real       _pd_pref_orient_march_dollase.r
    r_su               Real       _pd_pref_orient_march_dollase.r_su  ->su _pd_pref_orient_march_dollase.r
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

pd_pref_orient_spherical_harmonics  [Loop]
  PK  diffractogram_id, id, phase_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    diffractogram_id   Text     PK  _pd_pref_orient_spherical_harmonics.diffractogram_id
    id                 Code     NOT NULL  PK  _pd_pref_orient_spherical_harmonics.id
    phase_id           Text     PK  _pd_pref_orient_spherical_harmonics.phase_id
    c_ij               Real       _pd_pref_orient_spherical_harmonics.c_ij
    c_ij_su            Real       _pd_pref_orient_spherical_harmonics.c_ij_su  ->su _pd_pref_orient_spherical_harmonics.c_ij
    y_i                Integer    _pd_pref_orient_spherical_harmonics.y_i
    y_ij               Integer    _pd_pref_orient_spherical_harmonics.y_ij
    y_j                Integer    _pd_pref_orient_spherical_harmonics.y_j
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

pd_prep  [Set]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Text     NOT NULL  PK  _pd_prep.id
    char_id            Text       _pd_prep.char_id
    conditions         Text       _pd_prep.conditions
    cool_rate          Real       _pd_prep.cool_rate
    cool_rate_su       Real       _pd_prep.cool_rate_su  ->su _pd_prep.cool_rate
    pressure           Real       _pd_prep.pressure
    pressure_su        Real       _pd_prep.pressure_su  ->su _pd_prep.pressure
    special_details    Text       _pd_prep.special_details
    temperature        Real       _pd_prep.temperature
    temperature_su     Real       _pd_prep.temperature_su  ->su _pd_prep.temperature
  foreign keys
    char_id -> pd_char.id  DEFERRABLE

pd_proc  [Loop]
  PK  point_id, diffractogram_id
  columns
    _cifflow_block_id      TEXT     NOT NULL  synthetic
    _cifflow_row_id        INTEGER  NOT NULL  UNIQUE  synthetic
    point_id               Code     PK  _pd_proc.point_id
    diffractogram_id       Text     PK  _pd_proc.diffractogram_id
    2theta_corrected       Real       _pd_proc.2theta_corrected
    2theta_corrected_su    Real       _pd_proc.2theta_corrected_su  ->su _pd_proc.2theta_corrected
    d_spacing              Real       _pd_proc.d_spacing
    d_spacing_su           Real       _pd_proc.d_spacing_su  ->su _pd_proc.d_spacing
    energy_detection       Real       _pd_proc.energy_detection
    energy_detection_su    Real       _pd_proc.energy_detection_su  ->su _pd_proc.energy_detection
    energy_incident        Real       _pd_proc.energy_incident
    energy_incident_su     Real       _pd_proc.energy_incident_su  ->su _pd_proc.energy_incident
    intensity_bkg_calc     Real       _pd_proc.intensity_bkg_calc
    intensity_bkg_calc_su  Real       _pd_proc.intensity_bkg_calc_su  ->su _pd_proc.intensity_bkg_calc
    intensity_bkg_fix      Real       _pd_proc.intensity_bkg_fix
    intensity_bkg_fix_su   Real       _pd_proc.intensity_bkg_fix_su  ->su _pd_proc.intensity_bkg_fix
    intensity_incident     Real       _pd_proc.intensity_incident
    intensity_incident_su  Real       _pd_proc.intensity_incident_su  ->su _pd_proc.intensity_incident
    intensity_net          Real       _pd_proc.intensity_net
    intensity_net_su       Real       _pd_proc.intensity_net_su  ->su _pd_proc.intensity_net
    intensity_norm         Real       _pd_proc.intensity_norm
    intensity_norm_su      Real       _pd_proc.intensity_norm_su  ->su _pd_proc.intensity_norm
    intensity_total        Real       _pd_proc.intensity_total
    intensity_total_su     Real       _pd_proc.intensity_total_su  ->su _pd_proc.intensity_total
    ls_weight              Real       _pd_proc.ls_weight
    recip_len_q            Real       _pd_proc.recip_len_q
    recip_len_q_su         Real       _pd_proc.recip_len_q_su  ->su _pd_proc.recip_len_q
    wavelength             Real       _pd_proc.wavelength
    wavelength_su          Real       _pd_proc.wavelength_su  ->su _pd_proc.wavelength
  foreign keys
    (point_id, diffractogram_id) -> pd_data.(point_id, diffractogram_id)  DEFERRABLE

pd_proc_info_author  [Loop]  DEPRECATED
  PK  name
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    name               Text     NOT NULL  PK  _pd_proc_info_author.name  DEPRECATED -> _audit_author.name, _audit_author_role.role
    address            Text       _pd_proc_info_author.address  DEPRECATED -> _audit_author.address, _audit_author_role.role
    email              Text       _pd_proc_info_author.email  DEPRECATED -> _audit_author.email, _audit_author_role.role
    fax                Text       _pd_proc_info_author.fax  DEPRECATED -> _audit_author.fax, _audit_author_role.role
    phone              Text       _pd_proc_info_author.phone  DEPRECATED -> _audit_author.phone, _audit_author_role.role

pd_proc_ls  [Set]
  PK  diffractogram_id
  columns
    _cifflow_block_id    TEXT     NOT NULL  synthetic
    _cifflow_row_id      INTEGER  NOT NULL  UNIQUE  synthetic
    diffractogram_id     Text     PK  _pd_proc_ls.diffractogram_id
    background_function  Text       _pd_proc_ls.background_function
    peak_cutoff          Text       _pd_proc_ls.peak_cutoff
    pref_orient_corr     Text       _pd_proc_ls.pref_orient_corr  DEPRECATED -> _pd_pref_orient.special_details
    prof_r_factor        Real       _pd_proc_ls.prof_r_factor
    prof_wr_expected     Real       _pd_proc_ls.prof_wr_expected
    prof_wr_factor       Real       _pd_proc_ls.prof_wr_factor
    profile_function     Text       _pd_proc_ls.profile_function
    special_details      Text       _pd_proc_ls.special_details
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE

pd_proc_overall  [Set]
  PK  diffractogram_id
  columns
    _cifflow_block_id      TEXT      NOT NULL  synthetic
    _cifflow_row_id        INTEGER   NOT NULL  UNIQUE  synthetic
    diffractogram_id       Text      PK  _pd_proc_overall.diffractogram_id
    2theta_range_inc       Real        _pd_proc.2theta_range_inc
    2theta_range_max       Real        _pd_proc.2theta_range_max
    2theta_range_min       Real        _pd_proc.2theta_range_min
    info_data_reduction    Text        _pd_proc.info_data_reduction
    info_datetime          DateTime    _pd_proc.info_datetime
    info_excluded_regions  Text        _pd_proc.info_excluded_regions
    info_special_details   Text        _pd_proc.info_special_details
    number_of_points       Integer     _pd_proc.number_of_points
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE

pd_qpa_calib_factor  [Set]
  PK  phase_id
  columns
    _cifflow_block_id          TEXT     NOT NULL  synthetic
    _cifflow_row_id            INTEGER  NOT NULL  UNIQUE  synthetic
    phase_id                   Text     PK  _pd_qpa_calib_factor.phase_id
    absorption_diffraction     Real       _pd_qpa_calib_factor.absorption_diffraction
    absorption_diffraction_su  Real       _pd_qpa_calib_factor.absorption_diffraction_su  ->su _pd_qpa_calib_factor.absorption_diffraction
    ddm                        Real       _pd_qpa_calib_factor.ddm
    ddm_su                     Real       _pd_qpa_calib_factor.ddm_su  ->su _pd_qpa_calib_factor.ddm
    external_standard          Real       _pd_qpa_calib_factor.external_standard
    external_standard_su       Real       _pd_qpa_calib_factor.external_standard_su  ->su _pd_qpa_calib_factor.external_standard
    i_over_ic                  Real       _pd_qpa_calib_factor.i_over_ic
    i_over_ic_su               Real       _pd_qpa_calib_factor.i_over_ic_su  ->su _pd_qpa_calib_factor.i_over_ic
    other                      Real       _pd_qpa_calib_factor.other
    other_su                   Real       _pd_qpa_calib_factor.other_su  ->su _pd_qpa_calib_factor.other
    ponkcs                     Real       _pd_qpa_calib_factor.ponkcs
    ponkcs_su                  Real       _pd_qpa_calib_factor.ponkcs_su  ->su _pd_qpa_calib_factor.ponkcs
    rir                        Real       _pd_qpa_calib_factor.rir
    rir_su                     Real       _pd_qpa_calib_factor.rir_su  ->su _pd_qpa_calib_factor.rir
    special_details            Text       _pd_qpa_calib_factor.special_details
    zmv                        Real       _pd_qpa_calib_factor.zmv
    zmv_su                     Real       _pd_qpa_calib_factor.zmv_su  ->su _pd_qpa_calib_factor.zmv
  foreign keys
    phase_id -> pd_phase.id  DEFERRABLE

pd_qpa_external_std  [Set]
  PK  diffractogram_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    diffractogram_id   Text     PK  _pd_qpa_external_std.diffractogram_id
    k_factor           Real       _pd_qpa_external_std.k_factor
    k_factor_su        Real       _pd_qpa_external_std.k_factor_su  ->su _pd_qpa_external_std.k_factor
    phase_id           Text       _pd_qpa_external_std.phase_id
    special_details    Text       _pd_qpa_external_std.special_details
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

pd_qpa_intensity_factor  [Loop]
  PK  diffractogram_id, phase_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    diffractogram_id   Text     PK  _pd_qpa_intensity_factor.diffractogram_id
    phase_id           Text     PK  _pd_qpa_intensity_factor.phase_id
    value              Real       _pd_qpa_intensity_factor.value
    value_su           Real       _pd_qpa_intensity_factor.value_su  ->su _pd_qpa_intensity_factor.value
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

pd_qpa_internal_std  [Set]
  PK  diffractogram_id, phase_id
  columns
    _cifflow_block_id         TEXT     NOT NULL  synthetic
    _cifflow_row_id           INTEGER  NOT NULL  UNIQUE  synthetic
    diffractogram_id          Text     PK  _pd_qpa_internal_std.diffractogram_id
    phase_id                  Text     PK  _pd_qpa_internal_std.phase_id
    crystallinity_percent     Real       _pd_qpa_internal_std.crystallinity_percent
    crystallinity_percent_su  Real       _pd_qpa_internal_std.crystallinity_percent_su  ->su _pd_qpa_internal_std.crystallinity_percent
    mass_percent              Real       _pd_qpa_internal_std.mass_percent
    mass_percent_su           Real       _pd_qpa_internal_std.mass_percent_su  ->su _pd_qpa_internal_std.mass_percent
    special_details           Text       _pd_qpa_internal_std.special_details
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE

pd_qpa_overall  [Set]
  PK  diffractogram_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    diffractogram_id   Text     PK  _pd_qpa_overall.diffractogram_id
    method             Code       _pd_qpa_overall.method
    special_details    Text       _pd_qpa_overall.special_details
  foreign keys
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE

pd_spec  [Set]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Text     NOT NULL  PK  _pd_spec.id
    description        Text       _pd_spec.description
    mount_mode         Code       _pd_spec.mount_mode
    mounting           Text       _pd_spec.mounting
    orientation        Code       _pd_spec.orientation
    prep_id            Text       _pd_spec.prep_id
    preparation        Text       _pd_spec.preparation
    shape              Code       _pd_spec.shape
    size_axial         Real       _pd_spec.size_axial
    size_equat         Real       _pd_spec.size_equat
    size_thick         Real       _pd_spec.size_thick
    special_details    Text       _pd_spec.special_details
  foreign keys
    prep_id -> pd_prep.id  DEFERRABLE

publ  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    contact_letter     Text       _publ.contact_letter

publ_author  [Loop]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _publ_author.id
    address            Text       _publ_author.address
    email              Text       _publ_author.email
    footnote           Text       _publ_author.footnote
    id_audit           Word       _publ_author.id_audit
    id_iucr            Word       _publ_author.id_iucr
    id_orcid           Code       _publ_author.id_orcid
    name               Text       _publ_author.name
    phone              Text       _publ_author.phone
  foreign keys
    id_audit -> audit_author.id  DEFERRABLE

publ_body  [Loop]
  PK  label
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    label              Word     NOT NULL  PK  _publ_body.label
    contents           Text       _publ_body.contents
    element            Text       _publ_body.element
    format             Text       _publ_body.format
    title              Text       _publ_body.title

publ_contact_author  [Loop]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     PK  _publ_contact_author.id
    address            Text       _publ_contact_author.address
    contact_details    Text       _publ_contact_author.contact_details  DEPRECATED -> _publ_contact_author.name, _publ_contact_author.address
    email              Text       _publ_contact_author.email
    fax                Text       _publ_contact_author.fax
    id_iucr            Word       _publ_contact_author.id_iucr
    id_orcid           Code       _publ_contact_author.id_orcid
    name               Text       _publ_contact_author.name
    phone              Text       _publ_contact_author.phone
  foreign keys
    id -> publ_author.id  DEFERRABLE

publ_manuscript  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    creation           Text       _publ_manuscript.creation
    processed          Text       _publ_manuscript.processed
    text               Text       _publ_manuscript.text

publ_manuscript_incl_extra  [Loop]
  PK  item
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    item               Tag      NOT NULL  PK  _publ_manuscript_incl_extra.item
    defn               Text       _publ_manuscript_incl_extra.defn
    info               Text       _publ_manuscript_incl_extra.info

publ_requested  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    category           Text       _publ_requested.category
    coeditor_name      Text       _publ_requested.coeditor_name
    journal            Text       _publ_requested.journal

publ_section  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id   TEXT     NOT NULL  synthetic
    _cifflow_id         TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id     INTEGER  NOT NULL  UNIQUE  synthetic
    abstract            Text       _publ_section.abstract
    acknowledgements    Text       _publ_section.acknowledgements
    comment             Text       _publ_section.comment
    discussion          Text       _publ_section.discussion
    experimental        Text       _publ_section.experimental
    exptl_prep          Text       _publ_section.exptl_prep
    exptl_refinement    Text       _publ_section.exptl_refinement
    exptl_solution      Text       _publ_section.exptl_solution
    figure_captions     Text       _publ_section.figure_captions
    introduction        Text       _publ_section.introduction
    keywords            Text       _publ_section.keywords
    references          Text       _publ_section.references
    related_literature  Text       _publ_section.related_literature
    synopsis            Text       _publ_section.synopsis
    table_legends       Text       _publ_section.table_legends
    title               Text       _publ_section.title
    title_footnote      Text       _publ_section.title_footnote

publication  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic

refine  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id           TEXT     NOT NULL  synthetic
    _cifflow_id                 TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id             INTEGER  NOT NULL  UNIQUE  synthetic
    diffraction_theory          Code       _refine.diffraction_theory
    diffraction_theory_details  Text       _refine.diffraction_theory_details
    special_details             Text       _refine.special_details

refine_diff  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    density_max        Real       _refine_diff.density_max
    density_max_su     Real       _refine_diff.density_max_su  ->su _refine_diff.density_max
    density_min        Real       _refine_diff.density_min
    density_min_su     Real       _refine_diff.density_min_su  ->su _refine_diff.density_min
    density_rms        Real       _refine_diff.density_rms
    density_rms_su     Real       _refine_diff.density_rms_su  ->su _refine_diff.density_rms
    potential_max      Real       _refine_diff.potential_max
    potential_max_su   Real       _refine_diff.potential_max_su  ->su _refine_diff.potential_max
    potential_min      Real       _refine_diff.potential_min
    potential_min_su   Real       _refine_diff.potential_min_su  ->su _refine_diff.potential_min
    potential_rms      Real       _refine_diff.potential_rms
    potential_rms_su   Real       _refine_diff.potential_rms_su  ->su _refine_diff.potential_rms

refine_ls  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id        TEXT     NOT NULL  synthetic
    _cifflow_id              TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id          INTEGER  NOT NULL  UNIQUE  synthetic
    abs_structure_details    Text       _refine_ls.abs_structure_details
    abs_structure_flack      Real       _refine_ls.abs_structure_flack
    abs_structure_flack_su   Real       _refine_ls.abs_structure_flack_su  ->su _refine_ls.abs_structure_flack
    abs_structure_rogers     Real       _refine_ls.abs_structure_rogers
    abs_structure_rogers_su  Real       _refine_ls.abs_structure_rogers_su  ->su _refine_ls.abs_structure_rogers
    abs_structure_z_score    Real       _refine_ls.abs_structure_z-score
    d_res_high               Real       _refine_ls.d_res_high
    d_res_low                Real       _refine_ls.d_res_low
    extinction_coef          Real       _refine_ls.extinction_coef
    extinction_coef_su       Real       _refine_ls.extinction_coef_su  ->su _refine_ls.extinction_coef
    extinction_expression    Text       _refine_ls.extinction_expression
    extinction_method        Text       _refine_ls.extinction_method
    f_calc_details           Text       _refine_ls.f_calc_details
    f_calc_formula           Text       _refine_ls.f_calc_formula
    f_calc_precision         Real       _refine_ls.f_calc_precision
    f_calc_precision_su      Real       _refine_ls.f_calc_precision_su  ->su _refine_ls.f_calc_precision
    goodness_of_fit_all      Real       _refine_ls.goodness_of_fit_all
    goodness_of_fit_all_su   Real       _refine_ls.goodness_of_fit_all_su  ->su _refine_ls.goodness_of_fit_all
    goodness_of_fit_gt       Real       _refine_ls.goodness_of_fit_gt
    goodness_of_fit_gt_su    Real       _refine_ls.goodness_of_fit_gt_su  ->su _refine_ls.goodness_of_fit_gt
    goodness_of_fit_ref      Real       _refine_ls.goodness_of_fit_ref
    goodness_of_fit_ref_su   Real       _refine_ls.goodness_of_fit_ref_su  ->su _refine_ls.goodness_of_fit_ref
    hydrogen_treatment       Text       _refine_ls.hydrogen_treatment
    matrix_type              Text       _refine_ls.matrix_type
    number_constraints       Integer    _refine_ls.number_constraints
    number_parameters        Integer    _refine_ls.number_parameters
    number_reflns            Integer    _refine_ls.number_reflns
    number_reflns_gt         Integer    _refine_ls.number_reflns_gt
    number_restraints        Integer    _refine_ls.number_restraints
    r_factor_all             Real       _refine_ls.r_factor_all
    r_factor_gt              Real       _refine_ls.r_factor_gt
    r_fsqd_factor            Real       _refine_ls.r_fsqd_factor
    r_i_factor               Real       _refine_ls.r_i_factor
    restrained_s_all         Real       _refine_ls.restrained_s_all
    restrained_s_all_su      Real       _refine_ls.restrained_s_all_su  ->su _refine_ls.restrained_s_all
    restrained_s_gt          Real       _refine_ls.restrained_s_gt
    restrained_s_gt_su       Real       _refine_ls.restrained_s_gt_su  ->su _refine_ls.restrained_s_gt
    sample_shape_details     Text       _refine_ls.sample_shape_details
    sample_shape_expression  Text       _refine_ls.sample_shape_expression
    sample_thickness         Real       _refine_ls.sample_thickness
    sample_thickness_su      Real       _refine_ls.sample_thickness_su  ->su _refine_ls.sample_thickness
    shift_over_su_max        Real       _refine_ls.shift_over_su_max
    shift_over_su_max_lt     Real       _refine_ls.shift_over_su_max_lt
    shift_over_su_mean       Real       _refine_ls.shift_over_su_mean
    shift_over_su_mean_lt    Real       _refine_ls.shift_over_su_mean_lt
    structure_factor_coef    Text       _refine_ls.structure_factor_coef
    weighting_details        Text       _refine_ls.weighting_details
    weighting_scheme         Text       _refine_ls.weighting_scheme
    wr_factor_all            Real       _refine_ls.wr_factor_all
    wr_factor_gt             Real       _refine_ls.wr_factor_gt
    wr_factor_ref            Real       _refine_ls.wr_factor_ref

refine_ls_class  [Loop]
  PK  code
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    code               Word     PK  _refine_ls_class.code
    d_res_high         Real       _refine_ls_class.d_res_high
    d_res_low          Real       _refine_ls_class.d_res_low
    r_factor_all       Real       _refine_ls_class.r_factor_all
    r_factor_gt        Real       _refine_ls_class.r_factor_gt
    r_fsqd_factor      Real       _refine_ls_class.r_fsqd_factor
    r_i_factor         Real       _refine_ls_class.r_i_factor
    wr_factor_all      Real       _refine_ls_class.wr_factor_all
  foreign keys
    code -> reflns_class.code  DEFERRABLE

refln  [Loop]
  PK  id, phase_id, diffractogram_id
  columns
    _cifflow_block_id      TEXT     NOT NULL  synthetic
    _cifflow_row_id        INTEGER  NOT NULL  UNIQUE  synthetic
    id                     Word     NOT NULL  PK  _refln.id
    phase_id               Text     PK  _pd_refln.phase_id
    diffractogram_id       Text     PK  _refln.diffractogram_id
    a_calc                 Real       _refln.a_calc
    a_calc_su              Real       _refln.a_calc_su  ->su _refln.a_calc
    a_meas                 Real       _refln.a_meas
    a_meas_su              Real       _refln.a_meas_su  ->su _refln.a_meas
    b_calc                 Real       _refln.b_calc
    b_calc_su              Real       _refln.b_calc_su  ->su _refln.b_calc
    b_meas                 Real       _refln.b_meas
    b_meas_su              Real       _refln.b_meas_su  ->su _refln.b_meas
    class_code             Word       _refln.class_code
    d_spacing              Real       _refln.d_spacing
    f_calc                 Real       _refln.f_calc
    f_calc_su              Real       _refln.f_calc_su  ->su _refln.f_calc
    f_complex              Complex    _refln.f_complex
    f_complex_su           Complex    _refln.f_complex_su  ->su _refln.f_complex
    f_meas                 Real       _refln.f_meas
    f_meas_su              Real       _refln.f_meas_su  ->su _refln.f_meas
    f_squared_calc         Real       _refln.f_squared_calc
    f_squared_calc_su      Real       _refln.f_squared_calc_su  ->su _refln.f_squared_calc
    f_squared_meas         Real       _refln.f_squared_meas
    f_squared_meas_su      Real       _refln.f_squared_meas_su  ->su _refln.f_squared_meas
    fom                    Real       _refln.fom
    form_factor_table      Real       _refln.form_factor_table
    hkl                    Integer    _refln.hkl
    include_status         Text       _refln.include_status
    index_h                Integer    _refln.index_h
    index_k                Integer    _refln.index_k
    index_l                Integer    _refln.index_l
    intensity_calc         Real       _refln.intensity_calc
    intensity_calc_su      Real       _refln.intensity_calc_su  ->su _refln.intensity_calc
    intensity_meas         Real       _refln.intensity_meas
    intensity_meas_su      Real       _refln.intensity_meas_su  ->su _refln.intensity_meas
    lp_factor              Real       _refln.lp_factor
    mean_path_length_tbar  Real       _refln.mean_path_length_tbar
    peak_id                Code       _pd_refln.peak_id
    peak_overall_id        Code       _pd_refln.peak_overall_id
    phase_calc             Real       _refln.phase_calc
    phase_calc_su          Real       _refln.phase_calc_su  ->su _refln.phase_calc
    phase_meas             Real       _refln.phase_meas
    phase_meas_su          Real       _refln.phase_meas_su  ->su _refln.phase_meas
    refinement_status      Text       _refln.refinement_status
    scale_group_code       Word       _refln.scale_group_code
    sin_theta_over_lambda  Real       _refln.sin_theta_over_lambda
    symmetry_epsilon       Integer    _refln.symmetry_epsilon
    symmetry_multiplicity  Integer    _refln.symmetry_multiplicity
    wavelength             Real       _refln.wavelength
    wavelength_id          Word       _refln.wavelength_id
    radiation_id           TEXT     synthetic
  foreign keys
    (wavelength_id, radiation_id) -> diffrn_radiation_wavelength.(id, radiation_id)  DEFERRABLE
    diffractogram_id -> pd_diffractogram.id  DEFERRABLE
    (diffractogram_id, peak_id) -> pd_peak.(diffractogram_id, id)  DEFERRABLE
    peak_overall_id -> pd_peak_overall.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE
    class_code -> reflns_class.code  DEFERRABLE
    scale_group_code -> reflns_scale.group_code  DEFERRABLE

reflns  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id          TEXT     NOT NULL  synthetic
    _cifflow_id                TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id            INTEGER  NOT NULL  UNIQUE  synthetic
    apply_dispersion_to_fcalc  Text       _reflns.apply_dispersion_to_fcalc
    d_resolution_high          Real       _reflns.d_resolution_high
    d_resolution_low           Real       _reflns.d_resolution_low
    friedel_coverage           Real       _reflns.friedel_coverage
    friedel_fraction_full      Real       _reflns.friedel_fraction_full
    friedel_fraction_max       Real       _reflns.friedel_fraction_max
    limit_h_max                Integer    _reflns.limit_h_max
    limit_h_min                Integer    _reflns.limit_h_min
    limit_k_max                Integer    _reflns.limit_k_max
    limit_k_min                Integer    _reflns.limit_k_min
    limit_l_max                Integer    _reflns.limit_l_max
    limit_l_min                Integer    _reflns.limit_l_min
    limit_max                  Real       _reflns.limit_max
    limit_min                  Integer    _reflns.limit_min
    number_gt                  Integer    _reflns.number_gt
    number_total               Integer    _reflns.number_total
    special_details            Text       _reflns.special_details
    threshold_expression       Text       _reflns.threshold_expression

reflns_class  [Loop]
  PK  code
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    code               Word     NOT NULL  PK  _reflns_class.code
    d_res_high         Real       _reflns_class.d_res_high
    d_res_low          Real       _reflns_class.d_res_low
    description        Text       _reflns_class.description
    number_gt          Integer    _reflns_class.number_gt
    number_total       Integer    _reflns_class.number_total
    r_factor_all       Real       _reflns_class.r_factor_all
    r_factor_gt        Real       _reflns_class.r_factor_gt
    r_fsqd_factor      Real       _reflns_class.r_fsqd_factor
    r_i_factor         Real       _reflns_class.r_i_factor
    wr_factor_all      Real       _reflns_class.wr_factor_all

reflns_scale  [Loop]
  PK  group_code
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    group_code         Word     NOT NULL  PK  _reflns_scale.group_code
    meas_f             Real       _reflns_scale.meas_f
    meas_f_squared     Real       _reflns_scale.meas_f_squared
    meas_f_squared_su  Real       _reflns_scale.meas_f_squared_su  ->su _reflns_scale.meas_f_squared
    meas_f_su          Real       _reflns_scale.meas_f_su  ->su _reflns_scale.meas_f
    meas_intensity     Real       _reflns_scale.meas_intensity
    meas_intensity_su  Real       _reflns_scale.meas_intensity_su  ->su _reflns_scale.meas_intensity

reflns_shell  [Loop]
  PK  d_res_low, d_res_high
  columns
    _cifflow_block_id     TEXT     NOT NULL  synthetic
    _cifflow_row_id       INTEGER  NOT NULL  UNIQUE  synthetic
    d_res_low             Real     NOT NULL  PK  _reflns_shell.d_res_low
    d_res_high            Real     NOT NULL  PK  _reflns_shell.d_res_high
    d_res_limits          Real       _reflns_shell.d_res_limits
    meani_over_sui_all    Real       _reflns_shell.meani_over_sui_all
    meani_over_sui_gt     Real       _reflns_shell.meani_over_sui_gt
    number_measured_all   Integer    _reflns_shell.number_measured_all
    number_measured_gt    Integer    _reflns_shell.number_measured_gt
    number_possible       Integer    _reflns_shell.number_possible
    number_unique_all     Integer    _reflns_shell.number_unique_all
    number_unique_gt      Integer    _reflns_shell.number_unique_gt
    percent_possible_all  Real       _reflns_shell.percent_possible_all
    percent_possible_gt   Real       _reflns_shell.percent_possible_gt
    rmerge_f_all          Real       _reflns_shell.rmerge_f_all
    rmerge_f_gt           Real       _reflns_shell.rmerge_f_gt
    rmerge_i_all          Real       _reflns_shell.rmerge_i_all
    rmerge_i_gt           Real       _reflns_shell.rmerge_i_gt

space_group  [Set]
  PK  id
  columns
    _cifflow_block_id          TEXT     NOT NULL  synthetic
    _cifflow_row_id            INTEGER  NOT NULL  UNIQUE  synthetic
    id                         Word     NOT NULL  PK  _space_group.id
    bravais_type               Text       _space_group.bravais_type
    centring_type              Text       _space_group.centring_type
    crystal_system             Text       _space_group.crystal_system
    deprecated_setting         Text       _symmetry.cell_setting  DEPRECATED -> _space_group.crystal_system
    it_coordinate_system_code  Text       _space_group.it_coordinate_system_code
    it_number                  Integer    _space_group.it_number
    laue_class                 Text       _space_group.laue_class
    multiplicity               Integer    _space_group.multiplicity
    name_h_m_alt               Text       _space_group.name_h-m_alt
    name_h_m_alt_description   Text       _space_group.name_h-m_alt_description
    name_h_m_full              Text       _space_group.name_h-m_full
    name_h_m_ref               Text       _space_group.name_h-m_ref
    name_hall                  Text       _space_group.name_hall
    name_schoenflies           Word       _space_group.name_schoenflies
    patterson_name_h_m         Text       _space_group.patterson_name_h-m
    point_group_h_m            Text       _space_group.point_group_h-m

space_group_generator  [Loop]
  PK  id, space_group_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _space_group_generator.id
    space_group_id     Word     PK  _space_group_generator.space_group_id
    xyz                Code       _space_group_generator.xyz
  foreign keys
    space_group_id -> space_group.id  DEFERRABLE

space_group_symop  [Loop]
  PK  id, space_group_id
  columns
    _cifflow_block_id      TEXT     NOT NULL  synthetic
    _cifflow_row_id        INTEGER  NOT NULL  UNIQUE  synthetic
    id                     Integer  NOT NULL  PK  _space_group_symop.id
    space_group_id         Word     PK  _space_group_symop.space_group_id
    operation_description  Text       _space_group_symop.operation_description
    operation_xyz          Text       _space_group_symop.operation_xyz
    r                      Real       _space_group_symop.r
    rt                     Real       _space_group_symop.rt
    seitz_matrix           Real       _space_group_symop.seitz_matrix
    t                      Real       _space_group_symop.t
  foreign keys
    space_group_id -> space_group.id  DEFERRABLE

space_group_wyckoff  [Loop]
  PK  id, space_group_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _space_group_wyckoff.id
    space_group_id     Word     PK  _space_group_wyckoff.space_group_id
    coords_xyz         Code       _space_group_wyckoff.coords_xyz
    letter             Text       _space_group_wyckoff.letter
    multiplicity       Integer    _space_group_wyckoff.multiplicity
    site_symmetry      Code       _space_group_wyckoff.site_symmetry
  foreign keys
    space_group_id -> space_group.id  DEFERRABLE

structure  [Set]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _structure.id
    diffrn_id          Word       _structure.diffrn_id
    phase_id           Text       _structure.phase_id
    space_group_id     Word       _structure.space_group_id
  foreign keys
    diffrn_id -> diffrn.id  DEFERRABLE
    phase_id -> pd_phase.id  DEFERRABLE
    space_group_id -> space_group.id  DEFERRABLE

valence  [Set]
  PK  _cifflow_id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_id        TEXT     NOT NULL  PK  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic

valence_param  [Loop]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Integer  NOT NULL  PK  _valence_param.id
    atom_1             Word       _valence_param.atom_1
    atom_1_valence     Real       _valence_param.atom_1_valence
    atom_2             Word       _valence_param.atom_2
    atom_2_valence     Real       _valence_param.atom_2_valence
    b                  Real       _valence_param.b
    citation_id        Word       _valence_param.citation_id
    details            Text       _valence_param.details
    ref_id             Word       _valence_param.ref_id
    ro                 Real       _valence_param.ro
  foreign keys
    atom_1 -> atom_type.symbol  DEFERRABLE
    atom_2 -> atom_type.symbol  DEFERRABLE
    citation_id -> citation.id  DEFERRABLE
    ref_id -> valence_ref.id  DEFERRABLE

valence_ref  [Loop]
  PK  id
  columns
    _cifflow_block_id  TEXT     NOT NULL  synthetic
    _cifflow_row_id    INTEGER  NOT NULL  UNIQUE  synthetic
    id                 Word     NOT NULL  PK  _valence_ref.id
    reference          Text       _valence_ref.reference

-- loop tables without Set-derived category key --
  array_data  PK: array_id, binary_id
  array_data_external_data  PK: id
  array_element_size  PK: array_id, index
  array_intensities  PK: array_id, binary_id
  array_structure  PK: id
  array_structure_list  PK: array_id, index
  array_structure_list_axis  PK: axis_set_id, axis_id
  array_structure_list_section  PK: id, array_id, index
  atom_analytical  PK: id
  atom_analytical_mass_loss  PK: id
  atom_analytical_source  PK: id
  atom_scat_versus_stol  PK: atom_type, stol_value
  atom_type  PK: symbol
  atom_type_scat  PK: symbol
  audit_author  PK: id
  audit_author_role  PK: id, role
  audit_conform  PK: dict_name
  audit_contact_author  PK: id
  audit_dataset  PK: id
  audit_link  PK: block_code
  audit_support  PK: id
  axis  PK: id, equipment
  citation  PK: id
  citation_author  PK: citation_id, ordinal
  citation_editor  PK: citation_id, ordinal
  database_related  PK: id
  diffrn_attenuator  PK: code
  diffrn_component_pid  PK: pid, framework
  diffrn_data_frame  PK: id, detector_element_id
  diffrn_detector_element  PK: id, detector_id
  diffrn_orient_refln  PK: index_h, index_k, index_l
  diffrn_refln  PK: id
  diffrn_reflns_class  PK: code
  diffrn_scale_group  PK: code
  diffrn_scan  PK: id
  diffrn_scan_axis  PK: scan_id, axis_id
  diffrn_scan_collection  PK: scan_id
  diffrn_scan_frame  PK: scan_id, frame_id
  diffrn_scan_frame_axis  PK: frame_id, axis_id
  diffrn_standard_refln  PK: index_h, index_k, index_l
  display_colour  PK: hue
  exptl_crystal_face  PK: index_h, index_k, index_l
  journal_index  PK: id
  map_segment  PK: id, map_id
  pd_block  PK: id
  pd_block_diffractogram  PK: id
  pd_calib  PK: detector_id
  pd_calib_detected_intensity  PK: detector_id
  pd_calib_offset  PK: id, detector_id
  pd_calib_std  PK: detector_id, external_block_id
  pd_instr_detector  PK: id
  pd_meas_info_author  PK: name
  pd_phase_block  PK: id
  pd_proc_info_author  PK: name
  publ_author  PK: id
  publ_body  PK: label
  publ_contact_author  PK: id
  publ_manuscript_incl_extra  PK: item
  refine_ls_class  PK: code
  reflns_class  PK: code
  reflns_scale  PK: group_code
  reflns_shell  PK: d_res_low, d_res_high
  valence_param  PK: id
  valence_ref  PK: id

-- schema warnings --
  !  category 'diffraction' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'diffrn_orient' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'diffrn_orient_matrix' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'diffrn_reflns' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'diffrn_reflns_transf_matrix' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'diffrn_standards' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'reflns' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'exptl' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'exptl_absorpt' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'exptl_crystal_appearance' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'valence' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'publication' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'audit' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'computing' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'database' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'database_code' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'display' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'journal' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'journal_coeditor' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'journal_date' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'journal_techeditor' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'publ' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'publ_manuscript' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'publ_requested' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'publ_section' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'atom' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'atom_sites' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'atom_sites_cartn_transform' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'atom_sites_fract_transform' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'refine' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'refine_diff' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'refine_ls' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  FK: '_diffrn_refln.standard_code' -> '_diffrn_standard_refln.code': target is not a declared category key of 'diffrn_standard_refln' (PKs=['index_h', 'index_k', 'index_l']) -- attempting FK resolution
  !  FK: '_diffrn_measurement_axis.measurement_device' -> '_diffrn_measurement.device': target is not a declared category key of 'diffrn_measurement' (PKs=['id']) -- attempting FK resolution
  !  FK: '_array_structure_list.axis_set_id' -> '_array_structure_list_axis.axis_set_id': partial FK to 'array_structure_list_axis' -- covers ['axis_set_id'] of PKs=['axis_set_id', 'axis_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_array_structure_list_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_data_frame.array_section_id' -> '_array_structure_list_section.id': partial FK to 'array_structure_list_section' -- covers ['id'] of PKs=['id', 'array_id', 'index'] (2 missing PKs, bridge search skipped) -- skipping FK constraint
  !  FK: '_diffrn_data_frame.detector_element_id' -> '_diffrn_detector_element.id': partial FK to 'diffrn_detector_element' -- covers ['id'] of PKs=['id', 'detector_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_detector_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_measurement_axis.measurement_device' -> '_diffrn_measurement.device': target column 'device_class' is not a PK of 'diffrn_measurement' (PKs=['id']) -- skipping FK constraint
  !  FK: '_diffrn_refln.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_refln.standard_code' -> '_diffrn_standard_refln.code': target column 'code' is not a PK of 'diffrn_standard_refln' (PKs=['index_h', 'index_k', 'index_l']) -- skipping FK constraint
  !  FK: '_diffrn_scan.frame_id_end' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_scan.frame_id_start' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_scan_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_scan_frame.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_axis.axis_id' -> '_axis.id': partial FK to 'axis' -- covers ['id'] of PKs=['id', 'equipment'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_axis.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_diffrn_scan_frame_monitor.frame_id' -> '_diffrn_data_frame.id': partial FK to 'diffrn_data_frame' -- covers ['id'] of PKs=['id', 'detector_element_id'], no transitive bridge found -- skipping FK constraint
  !  FK: '_map_segment.array_section_id' -> '_array_structure_list_section.id': partial FK to 'array_structure_list_section' -- covers ['id'] of PKs=['id', 'array_id', 'index'] (2 missing PKs, bridge search skipped) -- skipping FK constraint
  !  FK: '_map_segment.id' -> '_map.id': partial FK to 'map' -- covers ['id'] of PKs=['id', 'diffrn_id', 'entry_id'] (2 missing PKs, bridge search skipped) -- skipping FK constraint
  !  FK: '_pd_amorphous.peak_id' -> '_pd_peak.id': partial FK to 'pd_peak' -- covers ['id'] of PKs=['diffractogram_id', 'id'], no transitive bridge found -- skipping FK constraint