Re: Designer2000 - Sub-type implementation
Date: 1996/05/31
Message-ID: <31adeb20.9490634_at_nntp.ix.netcom.com>#1/1
"A. Fischer" <afischer_at_ea.com> wrote:
>Hello,
>
>I am experimenting with DDL generation from ERDs using Designer2000. I am trying to have the DDL Generator
>generate a create table statement that includes a 'discriminator column' for use in determining sub-types. My
>scenario is very simple:
>
>I have one entity (called TABLE1) with two sub-types (TYPE1 and TYPE2). I have an ERD reflecting this. In
>the 'table mapping' part of the DB DEsign Wizard, I have mapped as follows:
>
> TABLE1 No Mapping
> --TYPE1 Include
> --TYPE2 Include
>
- Delete the current tables.
- Set "In set" for the supertype entity *only*.
- Be sure you have Create option set.
- Run the wizard.
This will create a single table with columns for both super and subtype entities
with a discriminator column.
-JJ
Jeffrey Jacobs & Associates
Oracle Designer/2000 Consulting & Training
951-2 Old Country Road, Suite 119, Belmont, CA 94002
Voice: 415-571-7092, FAX: 800-665-1379 CompuServe: 76702,456
Internet: 76702.456_at_compuserve.com
Received on Fri May 31 1996 - 00:00:00 CEST