SQL Developer

Not sure where to post this (unable to connect to the blog from work due to network restrictions), hope this is the correct forum.

I am testing out the Data Modeler product. I've got a large database that I want to reverse engineer, then work with the resulting model. I used the import feature which successfully imported all 1849 tables from my schema. However, this created a diagram which wasn't really useful. A couple of things I believe would be useful.

1. Add better connectivity between the browser that shows the table listing and the diagram. When I click on a table, I'd like the corresponding element in the diagram to be highlighted (and vice-versa). Also, an option to have the diagram show that table would be useful (maybe a ctrl-click or shift-click).

2. Subviews - I don't see an easy way to add to a subview once it is created. So, add an option to the browser and diagram right-click menu to "Add to SubDiagram". Currently the diagram allows you to create a subdiagram, I didn't see an add option.

3. More keyboard shortcuts. Specifically, CTRL-Z to undo, CTRL-Y to repeat.

4. Defined column types. You've got naming rules, but I'd like to be able to define columns as a predefined type, like "Dollar Amount", which would make my column become a number(9.2) or something like that.

That's it for now - may be more to come.

Don