Data Model - DTR

[lnfloyd]

Hy fellows, good morning.

I'm from Brazil and the company that hired me use Enterprise Architect.

First of all, sorry by any mistake on the english writing (bad pratice).

We are using this case tool to data model.

In our data model, We've some domain tables that needs to have related tables that stores historical data (so, their attributesstructure are, basicly, equals).

In EA, I couldn't copy the table in the same diagram and, to improve de productivity.

I mind to do this and, after that, add the new attributes, set nullable property to the attributes that are equals in the domain and historical data table, etc.

How can I do this?

If it doesn't possible, please, take this as an advice to an upgrade on this case tool.

Thanks.

[Paolo F Cantoni]

Hi Infloyd,

If I understand you correctly, you have a table which has a historical "Child" that has very similar set of columns.

You are developing the model by hand (that is, you are NOT reverse engineering from an existing database).

You want to quickly create the child set of attributes from the "parent table".

Here's how you do it...

Create the the basic table.  Populate the columns, indexes etc.
Create an empty Child (historical table) on the diagram.
Go to the browser, select the Columns and indexes etc you want to copy.
Drag them onto the empty table shape on the diagram.
A copy of the selected features will be created in the Child table.

This works, because EA will let you drag (copy) from the browser to the diagram.

HTH,
Paolo