[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Schema question about Unique#1
Date: Sat, 09 Feb 2008 10:26:46 +0100

> 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

> 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 ! :-)

GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung:

reply via email to

[Prev in Thread] Current Thread [Next in Thread]