Re: design question

From: stu <smcgouga_at_nospam.co.uk>
Date: Tue, 21 Jan 2003 16:39:26 -0000
Message-ID: <b0jt6e$fe1$1$8302bc10@news.demon.co.uk>

"Tobin Harris" <comedyharris_at_hotmail.com> wrote in message news:b0h3qk$nmsc4$1_at_ID-135366.news.dfncis.de... Personally, I haven't got used to working with super/subtype
> tables, and in practice I would create a union view for this instead
(anyone
> feel free to correct me if you feel this is a bad idea).

I think what you do in this case is have a users table with a primary key (ID).

Then since teachers and students both are of type User the Primary key for teachers will be the foreign key Users.ID combined with a new ID for teachers. A similar thing should happen for the students table.

At least this is what I think is a correct way to model super-sub type relations. Again if somebody knows better please tell me im talking crap!

cheers
Stu Received on Tue Jan 21 2003 - 10:39:26 CST