AmaterasERD_1_0_4 - Amateras Wiki - Amateras

AmaterasERD 1.0.4 New Features

SQL comment generation in DDL

Logical table names and descriptions are added into DDL.

/**********************************
Table Name: User Information
**********************************/
CREATE TABLE USER_INFO(
  USER_ID VARCHAR2(10) PRIMARY KEY,
  USER_NAME VARCHAR2(10),
  PASSWORD VARCHAR2(10)
);

CREATE TABLE with SCHEMA option

If you check With schema name option, CREATE TABLE statements are generated with schema such as SCHEMA_NAME.TABLE_NAME. See below:

CREATE TABLE PUBLIC.USER_INFO(
  USER_ID VARCHAR2(10) PRIMARY KEY,
  USER_NAME VARCHAR2(10),
  PASSWORD VARCHAR2(10)
);

Diagram Validation

AmaterasERD now provides ER-Diagram validation. It will help to keep consistency of your ER-diagram.

You can execute validation by the context menu of the diagram editor.

Errors are shown in the Problem view and tooltip on the diagram.

You can configure validation settings in the preference dialog.

Linked Table

If the diagram has a lot of tables, you'll want to split them to some diagrams. AmaterasERD 1.0.4 provides Linked Table for this purpose.

Linked Table means a table which is imported from the other diagram. You can import from the context menu of the diagram editor.

(Image)

Linked Table is not modified in the diagram (it's shown as gray in the diagram), however you can define foreign keys to the Linked Table.

(Image)

Copy and Paste

You can copy and paste from the context menu of the diagram editor.

Paste action does not copy relations and indices (it copies only table and its columns).