Recent Changes

2012-10-05
2012-06-13
2011-02-20
2011-02-12
2010-08-09

Latest File Release

AIR GEAR (1.0.4)2009-12-31 01:10
AmaterasERD (1.0.9)2012-06-13 15:15
AmaterasERD Extension (1.0.0)2011-02-11 17:27
AmaterasIDEInstaller (2.0.6)2009-05-11 01:47
AmaterasUML (1.3.4)2012-07-16 23:52
BootJava (1.2)2004-08-30 09:13
csv-lib (1.2)2004-04-24 18:01
EclipseHTMLEditor (2.2.0)2012-12-28 03:18
epcb-csv (1.1.1)2005-04-29 23:30
ExcelPettyCashBook (1.2.0)2005-04-29 23:28
ExcelPettyCashBook-all (20050429)2005-04-29 23:32
ExcelPettyCashBook-src (20050429)2005-04-29 23:34
FacesIDE (2.0.6)2008-09-06 22:46
FuzzyXML (1.0.0)2007-07-17 17:04
IPMsg (1.6)2004-07-12 15:00
JavaCVS (1.4)2005-05-01 06:21
JavadocSearch (0.0.3)2003-12-18 11:14
Java Standard EL Functions (1.1.2)2011-01-19 08:14
Mirage (1.1.5)2012-04-15 18:46
rdiff-backup-browser (1.0.0)2010-11-18 01:12
SAStrutsPlugin (1.0.1)2009-04-16 01:14
sns (3.12)2006-12-05 13:04
StepCounter (3.0.2)2013-06-15 12:10
StrutsIDE (2.0.7)2010-07-05 01:22
Translations (m2eclipse0.0.10)2007-05-18 06:23
XLSBeans (1.2.1)2011-07-05 14:54

Wiki Guide

Side Bar

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

generate_ddl.png

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.

validation_menu.png

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

validation_errors.png

You can configure validation settings in the preference dialog.

validation_settings.png

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.

CopyAndPaste.png

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