• Showing Page History #15851

AmaterasERD 1.0.3 New Features

PostgreSQL and Oracle support

DDL generation now support PostgreSQL and Oracle.

Table re-importing improved

Table re-importing from JDBC meta data merges existing diagram models. This makes possible to design database with round-trip style.

Foreign keys decoration

FK columns are decorated as (FK) in the table figure.

foreign_key.png

Default column value

You can enter the column default value in the table edit dialog.

column_default_value.png

Also, default value is shown in the HTML report.

Outline view

Thumbnail and schema tree and thumbnail are displayed in the outline view.

outline.png

DDL Generate Option

AmaterasERD provides a new option at the DDL generation wizard to generate constraints as ALTER TABLE.

ddl_option.png

Index Design

index.png

Domain

You can define domain (generic data types). Please double-click the "Domain" node in the Outline view.

domain.png

Defined domains is available as data types in the table editing dialog.

HTML report imprived

HTML report and its CSS have been improved. The generated HTML report contains:

  • Index definitions
  • Domain definitions
  • Combobox to jump to the chosen table

And you can specify your customized HTML template file to generate HTML at the preference dialog. You have to make this template with Velocity.