Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Bad AUI (classes-atoms_ui) 0 Sat Jan 7 09:49:40 2017 (Implemented on MEME-Edit 12/07/2022)

Code Block
select * from atomjpa_alternateterminologyids where alternateTerminologyIds_KEY = 'NCIMTH'
  AND not exists (select * from atom_identity b where b.id = (substr(a.alternateTerminologyIds,2))+0) );


Bad RUI (C rels - relationships_ui) 0 Sat Jan 7 09:50:14 2017 (Implemented on MEME-Edit 12/07/2022)

Code Block
select * from atomrelationshipjpa_alternateterminologyids a where alternateTerminologyIds_KEY = 'NCIMTH'
  AND not exists (select * from relationship_identity b where b.id = (substr(a.alternateTerminologyIds,2))+0) )
UNION ALL
select * from coderelationshipjpa_alternateterminologyids a where alternateTerminologyIds_KEY = 'NCIMTH'
  AND not exists (select * from relationship_identity b where b... same for other XXXrelationshipjpa_alternateterminologyids tablesid = (substr(a.alternateTerminologyIds,2)+0) )
UNION ALL
select * from componentinforelationshipjpa_alternateterminologyids a where alternateTerminologyIds_KEY = 'NCIMTH'
  AND not exists (select * from relationship_identity b where b.id = (substr(a.alternateTerminologyIds,2)+0) )
UNION ALL
select * from conceptrelationshipjpa_alternateterminologyids a where alternateTerminologyIds_KEY = 'NCIMTH'
  AND not exists (select * from relationship_identity b where b.id = (substr(a.alternateTerminologyIds,2)+0) )
UNION ALL
select * from descriptorrelationshipjpa_alternateterminologyids a where alternateTerminologyIds_KEY = 'NCIMTH'
  AND not exists (select * from relationship_identity b where b.id = (substr(a.alternateTerminologyIds,2)+0) )


N/A - Bad RUI (NLM03 rels - relationships_ui) 0 Sat Jan 7 09:50:50 2017
N/A - Bad RUI (S rels - relationships_ui) 0 Sat Jan 7 09:54:43 2017
N/A - Bad RUI (context rels - relationships_ui) 0 Sat Jan 7 09:55:24 2017
N/A - Duplicate ATUI (attributes_ui) 0 Sat Jan 7 09:57:19 2017
N/A - Duplicate ATUI values (attributes_ui) 0 Sat Jan 7 09:57:53 2017
N/A - Duplicate AUI values 0 Sat Jan 7 09:58:30 2017
N/A - Duplicate RUI (inverse_relationships_ui) 0 Sat Jan 7 10:01:33 2017
N/A - Duplicate RUI (relationships_ui) 0 Sat Jan 7 10:03:47 2017
N/A - Duplicate RUI values (relationships_ui) 67 Sat Jan 7 10:04:26 2017
N/A - Duplicate atom_id's (C-dead_C) 0 Sat Jan 7 10:04:31 2017
N/A - Duplicate atom_id's (atoms-dead_atoms) 0 Sat Jan 7 10:04:40 2017
N/A - Duplicate atomic_action_id's 0 Sat Jan 7 10:04:41 2017
N/A - Duplicate attribute_id's (A-dead_A) 0 Sat Jan 7 10:04:55 2017
N/A - Duplicate concept_id's (CS-dead_CS) 0 Sat Jan 7 10:05:00 2017
Duplicate ids in source_id_map (C) 0 Sat Jan 7 10:05:11 2017 - alternate terminology ids

...