Re: [Gnumed-devel] Measurements - lessons from other EMRs - easily finding what we want to see

[Karsten Hilbert]

On Wed, Jul 17, 2013 at 06:05:56AM +0000, Jim Busser wrote:

> Should there, at least, be a constraint that any one lab
> cannot have duplicates of the same-named test type?

Done.

                                                 Tabelle »clin.test_type«
      Spalte       |           Typ            |                                 
Attribute                                 
-------------------+--------------------------+---------------------------------------------------------------------------
 pk_audit          | integer                  | not null Vorgabewert 
nextval('audit.audit_fields_pk_audit_seq'::regclass)
 row_version       | integer                  | not null Vorgabewert 0
 modified_when     | timestamp with time zone | not null Vorgabewert now()
 modified_by       | name                     | not null Vorgabewert 
"current_user"()
 pk                | integer                  | not null Vorgabewert 
nextval('clin.test_type_pk_seq'::regclass)
 fk_test_org       | integer                  | 
 name              | text                     | not null
 comment           | text                     | 
 conversion_unit   | text                     | 
 loinc             | text                     | 
 abbrev            | text                     | not null
 fk_meta_test_type | integer                  | 
Indexe:
    "test_type_pkey" PRIMARY KEY, btree (pk)
    "clin_test_type_uniq_abbrev_per_org" UNIQUE CONSTRAINT, btree (fk_test_org, 
name)
    "clin_test_type_uniq_name_per_org" UNIQUE CONSTRAINT, btree (fk_test_org, 
name)
    "idx_test_type_fk_meta_test_type" btree (fk_meta_test_type)
    "idx_test_type_fk_test_org" btree (fk_test_org)
    "idx_test_type_loinc" btree (loinc)
Fremdschlüssel-Constraints:
    "test_type_fk_meta_test_type_fkey" FOREIGN KEY (fk_meta_test_type) 
REFERENCES clin.meta_test_type(pk)
    "test_type_fk_test_org_fkey" FOREIGN KEY (fk_test_org) REFERENCES 
clin.test_org(pk)
Fremdschlüsselverweise von:
    TABLE "de_de.lab_test_gnr" CONSTRAINT "lab_test_gnr_id_test_fkey" FOREIGN 
KEY (id_test) REFERENCES clin.test_type(pk)
    TABLE "clin.lnk_tst2norm" CONSTRAINT "lnk_tst2norm_id_test_fkey" FOREIGN 
KEY (id_test) REFERENCES clin.test_type(pk)
    TABLE "clin.test_result" CONSTRAINT "test_result_fk_type_fkey" FOREIGN KEY 
(fk_type) REFERENCES clin.test_type(pk)
Trigger:
    zt_del_test_type BEFORE DELETE ON clin.test_type FOR EACH ROW EXECUTE 
PROCEDURE audit.ft_del_test_type()
    zt_ins_test_type BEFORE INSERT ON clin.test_type FOR EACH ROW EXECUTE 
PROCEDURE audit.ft_ins_test_type()
    zt_upd_test_type BEFORE UPDATE ON clin.test_type FOR EACH ROW EXECUTE 
PROCEDURE audit.ft_upd_test_type()
Erbt von: audit.audit_fields

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346