Messages

1

Suggestions and Requests / Re: Database Modeling in EA?

« on: January 06, 2004, 10:04:48 am »

Some other things that would be nice to have.

1) The ability to specify tablespace for foreign key indexes.  In the real world you typically seperate tables and indexes into seperate tablespaces.

Current DDL Generated:
------------------------------
ALTER TABLE ADVODM_DEADLINE_MANAGER ADD CONSTRAINT ADM_PK
PRIMARY KEY (DEADLINE_MANAGER_ID)
;

Desired With USING INDEX clause:
------------------------------------------
ALTER TABLE ADVODM_DEADLINE_MANAGER ADD CONSTRAINT ADM_PK
PRIMARY KEY (DEADLINE_MANAGER_ID)
USING INDEX TABLESPACE <INDEX_TABLESPACE>
;


2) When specifying a column as autonumber, I'd like to be able to change the name for the SEQUENCE it generates.

Right now it creates some funky names for sequences.

DROP SEQUENCE ADVODM_DEADLI_DEADLINE_MAN_SEQ;

A common convention is "<TABLE_NAME>_S".

At the moment, every time I generate, I have to go back and edit the source manually.

3) Can't seem to figure out how to create additional indexes.  Help file talks about adding an operation and stereo typing to INDEX, which is fine, but THEN you cannot select any columns other than the primary or foreign key columns.  I should be able to select other columns from the table, including multiple columns to create a concatenated index.  (Also Specifying tablespace would be usefull).

I work as a consultant, and would like to recommend EA as an alternative to Oracle Designer for data modelling, since it offers so much more.   With a little bit of tweaking it would be there.

Todd

2

Suggestions and Requests / Re: Database Modeling in EA?

« on: December 05, 2003, 08:26:10 am »

I'd like to see TABLE and COLUMN comments be added when they exist in ALL_TAB_COMMENTS and ALL_COL_COMMENTS.

I use the HTML generated documention a lot with Data Models...  Being able to click on the Table and see the descriptions would be a time saver.

I'd admit not a lot of people bother to add comments, but I mostly do this with Oracle Applications Tables.  
The meta data exists in other FND tables for table/column descriptions, as well as primary foreign key info.  (I created tables or materialized views that look identical to  ALL_CONSTRAINTS, ALL_CONS_COLUMNS, and the COMMENT views mentioned above, (in a seperate schema) to trick EA into thinking the information was really in the data dictionary.

Todd