From: Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>
To: pgsql-sql@postgresql.org
Subject: Re: check constraint on multiple tables?
Date: Wed, 3 Mar 2010 16:38:31 +0100
Message-ID: <20100303153831.GA20503@apartia.fr> (raw)
In-Reply-To: <396486431003030729x17f921bcr7ff439113a5644ab@mail.gmail.com>
References: <20100303150227.GA18661@apartia.fr>
<396486431003030714s48b239e2ub8b58a49b9aa29e4@mail.gmail.com>
<20100303151900.GA19735@apartia.fr>
<396486431003030729x17f921bcr7ff439113a5644ab@mail.gmail.com>
On Wed, Mar 03, 2010 at 07:29:22AM -0800, Richard Broersma wrote:
> On Wed, Mar 3, 2010 at 7:19 AM, Louis-David Mitterrand
> <vindex+lists-pgsql-sql@apartia.org> wrote:
>
> > CREATE TABLE cabin_type (
>
> > CREATE TABLE cabin_category (
>
> > CREATE TABLE cabin (
>
> I'm just curious about a few things.
>
> 1) What is the difference between a cabin_type and a cabin_category.
A cabin_type is: large suite, junior suite, balcony cabin, interior, etc.
A cabin_category is, for say a "balcony cabin", on which deck it is
located (price increases as the deck is higher).
> 2) Does each ship have an exclusive set of cabin_types that no other
> ship can have? The table definitions imply that this is so.
Each ship is different and has specific cabin types and categories. Of
course there is some overlap between ships but I thought it simpler (or
more elegant) to use that hierarchy. Maybe my schema is wrong?
> I'm just guessing here since I don't really understand the
> relationships involved in a ship's cabins. However, I would expect
> that a cabin should be directly related to a ship. Each cabin is
> defined by a category according the set in the cabin_category table.
I could add an id_ship to 'cabin' but that would make two (potentialy
conflicting) relations to 'ship'.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: vindex+lists-pgsql-sql@apartia.org
Subject: Re: check constraint on multiple tables?
In-Reply-To: <20100303153831.GA20503@apartia.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox