Current state of categories and keys in CIF_CORE_MULTIBLOCK

[rowlesmr]

This is the result of running inspect_schema from my program cifflow on the cif_core_multiblock dictionary. This includes all of the imports and the like.

None of this requires immediate attention; its just recording what the current state is.

loop tables without Set-derived category key

  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_link  PK: block_code
  audit_support  PK: id
  chemical_conn_atom  PK: number
  chemical_conn_bond  PK: atom_1, atom_2
  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_orient_refln  PK: index_h, index_k, index_l
  diffrn_reflns_class  PK: code
  diffrn_scale_group  PK: code
  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
  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

Either a Set category with no key, or insufficient keys to resolve linked items.

  !  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 'chemical' (Set) has no _category_key.name -- using _cifflow_id as primary key
  !  category 'chemical_formula' (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 '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_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