Re: [dtp-dev] Table Manipulation Design document draft

[Anil T Samuel <anil.samuel@xxxxxxxxxx>]

Hi

when multiple tables are modelled simultaneously,  you would have the 
corresponding modelbase elements populated in the background. The 
corresponding script when generated traversing the dependency tree 
bottom-up in a BFS (Breadth First) mode, then ideally the dependee table 
creation scripts will be in right order in the generated script.

Did that make sense ? I am on skype as anthos, if you like to talk to me.

Alternatively, gimme your phone number I can explain to you.

Regards
Anthos

hosokawa wrote:

> Hi Anthos,
>
> Thank you. I tried SQL Developer and I could get a image well.
> And I have another question.
> How can I create multiple tables simultaneousely using such multi 
> tabbed page?
> It seems that tables are created one by one even if using such GUI, 
> like SQL Developer.
> I'm sorry if I have misunderstanding......
>
> > 3. It will be good to have multi(tabbed) page rather than a dialog to 
> > modify
> > the structure of newly creating table. This would allow user to 
> > create multiple
> > tables simultaneously, copy/paste text back and forth and so on.
>
>
> Best regards,
>
> Takehiro Hosokawa
> VALWAY Technology Center, NEC Soft, Ltd.
>
> ----- Original Message ----- From: "Anil T Samuel" 
> <anil.samuel@xxxxxxxxxx>
> To: "DTP development mailing list" <dtp-dev@xxxxxxxxxxx>
> Sent: Monday, November 13, 2006 10:56 AM
> Subject: Re: [dtp-dev] Table Manipulation Design document draft
>
>
> > Hi
> >
> > 1. Check out "SQL Developer" from oracle at 
> > http://www.oracle.com/technology/software/products/sql/index.html. 
> > Try Create Table with "Advanced" option checked and select "Foreign 
> > Keys" on left side.
> >
> > 2. Each tab in this case could correspond to a left side option 
> > mentioned above. One tricky bit will be to have dependency maintained 
> > in the generated DDL script so that 'dependees' are created before 
> > 'depender'.
> >
> > Anthos
> >
> > hosokawa wrote:
> >
> > > Hi Anthos,
> > >
> > > Thank you for great suggestions to bug:162519 
> > > (https://bugs.eclipse.org/bugs/show_bug.cgi?id=162519
> > > ).
> > > Could you tell me if you know good examples of GUI design for 1 and 3?
> > >
> > > > 1. It will be good to have the interface to support creation of 
> > > > referential
> > > > child relations as well; ie, sql equivalent of
> > > > CONSTRAINT person_address FOREIGN KEY("homeaddress") REFERENCES 
> > > > address("id"
> > > > ENABLE
> > > >
> > > > 3. It will be good to have multi(tabbed) page rather than a dialog 
> > > > to modify
> > > > the structure of newly creating table. This would allow user to 
> > > > create multiple
> > > > tables simultaneously, copy/paste text back and forth and so on.
> > >
> > >
> > >
> > > Do you mean each tabbed page has each database table's structure to 
> > > modify
> > > and a new page is added to create a new table?
> > >
> > > Best regards,
> > >
> > > Takehiro Hosokawa
> > > VALWAY Technology Center, NEC Soft, Ltd.
>
> _______________________________________________
> dtp-dev mailing list
> dtp-dev@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/dtp-dev