Re: [Gnumed-devel] Schema question about Unique#1

[Karsten Hilbert]

> In the schema for clin.table.lab-request
> 
> where it declares
> 
>       fk_test_org     integer UNIQUE#1 NOT NULL
>       request_id      text            UNIQUE#1 NOT NULL
> 
> does the above define the uniqueness to be
> 
>       (fk_test_org + request_id)      UNIQUE
Yes.

> in other words there can be repeats within fk_test_org and repeats  
> within request_id but no repeat in the combined?
Or in yet other words: The value for request_id may need to be repeatable
across labs at the same time.

> And Postgres is happy though the fields are of two different data types?
Sure ! :-)

Karsten
-- 
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail