Checking for duplicate terms in translation data when updating concept

[filak]

Store all the trx terms in a db table

/* terms */
--drop table if exists terms;
create table audit (
  id integer primary key autoincrement,
  dui text not null,   -- DescriptorUI | QualifierUI
  cui text not null,   -- ConceptUI
  term text not null, 
  created text DEFAULT (strftime('%Y-%m-%dT%H:%M:%S','now', 'localtime'))
);

Analyze how to:

1. populate the table initially
2. check terms for duplicates before concept update
3. insert rows for new terms
4. update when deleting terms

If duplicate is found issue a danger alert - including created + dui + link .../search/dui: