Postgres Pro
Downloads
Home   >   mailing lists

Re: Tables design question - Mailing list pgsql-novice

From David G. Johnston
Subject Re: Tables design question
Date
Msg-id CAKFQuwZJ5nQw9Tx0vtFnbuDPu=K4eRHhsXsTq030ioMq9qTX+Q@mail.gmail.com
Whole thread Raw
In response to Tables design question  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-novice
Tree view
On Wednesday, March 28, 2018, JORGE MALDONADO <jorgemal1960@gmail.com> wrote:
The table "corequisites" has data about courses that must be taken at the same time that another course.




I would consider setting up corequisites as (id serial, course_group_members integer[]) with an exclusion constraint that no course_id can appear in more than one array.

David J.
Attachment

pgsql-novice by date:

Previous
From: JORGE MALDONADO
Date:
Subject: Tables design question
Next
From: Garry Chen
Date:
Subject: Question about pg_class column relpartbound