Simple data modeling questions.

[Kyle Miller]

You can set the database for each table. Is there a way to set the database vendor for all tables or the diagram without having to go to each and every table?

Is there way to have a default line style for associations or to change the line style for all associations easily?

[Kyle Miller]

One more question.

How do you create user defined data types (DB domains) and assign them to table attributes in EA?

[Steve_Straley]

Kyle,

On the second question, go to the REFERENCE menu item and select the Database Datatypes option.  This will bring up a dialog window to let you add your own datatypes (works for languages as well) to EA.   You can also add a different type of database (or language).   Keep in mind that if you do the later, EA will not be able to generate schema's or code for those products not specified.  However, you can use the modeled information to generate code if you write your own code generator and pull out EA-based information.

Hope that helps,

Steve

[Kyle Miller]

Steve,

Thanks for the reply! So many Views, so few Replies.  

I noticed you could define new datatypes, even new db vendors. A DB vendor datatype is different than a database domain. You can specify a list of valid values for a domain amongst other possibilities. It also generates incorrect DDL if it is declared as a datatype, which is what I think you were telling me.

[Steve_Straley]

Hi,

Sorry for the confusion, I saw "data types" and that means something specific to me as opposed to "domains".

Just keep in mind that if you go outside the pre-defined vendor support (especially true with languages), EA can't generate the code for the support (to my knowledge).

Steve

[sparks]

Hello,

To answer your first questions.  You can define the default database product, on the 'Local Options - Code Editors' screen.  But there is no easy way to change the defined database product on multiple existing tables.

To define the default association type on the 'Local Options - Object' screen.

Hope this helps.

Paul Mathers

[Kyle A. Miller]

Sparks,

That was very helpful!  

Is it safe for me to assume there is no way to draw/create domains and associate with a table's attributes?

[davewarner]

Actually, I work with a 10 yr old database (migrated several years ago from Sybase 4.9.3 to Sybase 11.5) that almost exclusively uses domains (e.g. document_no_type is a domain internally represented by char(10)).  It was a snap to add in the domain as a 'datatype' and generate the ddl.  One minor wrinkle - I can't specify the internal representation in EA, otherwise the DDL will include it.