Re: [GENERAL] constrains on two tables

2007-09-14 Thread Bill Moran
In response to finecur <[EMAIL PROTECTED]>: > On Sep 10, 9:55 pm, finecur <[EMAIL PROTECTED]> wrote: > > Hi > > > > Here is my table: > > > > Table School > > ( > > id integer, > > name text > > ); > > > > Table Department > > ( > > id integer, > > school_id integer reference schoo

[GENERAL] constrains on two tables

2007-09-14 Thread finecur
Hi Here is my table: Table School ( id integer, name text ); Table Department ( id integer, school_id integer reference school(id), name text ); Table Course ( department_id integer references department(id), name text, course_number text ) I would like to make

Re: [GENERAL] constrains on two tables

2007-09-14 Thread finecur
On Sep 10, 9:55 pm, finecur <[EMAIL PROTECTED]> wrote: > Hi > > Here is my table: > > Table School > ( > id integer, > name text > ); > > Table Department > ( > id integer, > school_id integer reference school(id), > name text > ); > > Table Course > ( > department_id intege