gnumed-devel
[Top][All Lists]
Advanced

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

[Gnumed-devel] Schema question about Unique#1


From: James Busser
Subject: [Gnumed-devel] Schema question about Unique#1
Date: Fri, 08 Feb 2008 17:26:20 -0800

In the schema for clin.table.lab-request

http://salaam.homeunix.com/~ncq/gnumed/schema/devel/gnumed- schema.html#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?

And Postgres is happy though the fields are of two different data types?




reply via email to

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