anyway.
Gary
On Thursday 19 May 2011 01:09:07 David W Noon wrote:
On Wed, 18 May 2011 20:10:19 +0100, Gary Stainburn wrote about [SQL]
foreign keys and lots of tables:
I have the following tables (individual seat allocation removed to
make it simpler)
Omitting details makes the problem
I have the following tables (individual seat allocation removed to make it
simpler)
create table coaches ( -- carriages
c_id serial primary key,
c_namevarchar(20) not null
);
create table trains ( -- one for each train
t_id serial primary key
);
create table train_coaches
On Wed, 18 May 2011 20:10:19 +0100, Gary Stainburn wrote about [SQL]
foreign keys and lots of tables:
I have the following tables (individual seat allocation removed to
make it simpler)
Omitting details makes the problem more difficult to comprehend.
[snip]
create table booking_seats (
b_id