Re: super type & sub type, interested too
Date: 5 Nov 2002 17:50:54 -0600
Message-ID: <Xns92BDAC64DF596pingottpingottbah_at_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.comReceived on Wed Nov 06 2002 - 00:50:54 CET