Re: super type & sub type, interested too

From: Pablo Sanchez <pablo_at_dev.null>
Date: 5 Nov 2002 17:50:54 -0600
Message-ID: <Xns92BDAC64DF596pingottpingottbah@209.189.89.243>

Jayne Heger <hegerthehorrible_at_hotmail.com> wrote in news:1036540108.16447.0_at_dyke.uk.clara.net:

> Yasaswi Pulavarti wrote:
>

>> I have successfully created a super type and 4 subtypes. How do I
>> populate the tables with my application? Do I just ignore the super
>> type table and populate the sub type tables? Let me know.
>> Thanks,
>> Yasaswi

>
> What database application are you using to do this? (Oracle or
> MySQL) I ask as I'm going to have to do the same soon, funnily
> enough with one supertype and 4 subtypes! - I would imagine that as
> long as you have referntial integrity, i.e. foreign key values in,
> then it should be ok, although I don't know as I haven't done this
> yet.

How about you put together a simple example of what you both are trying to do. This way I (we?) can respond with concrete examples.

Thx!

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com

Received on Tue Nov 05 2002 - 17:50:54 CST