SUPPORT:

• All relation types between tables:

  

  One To One

  Many To One

  Many To Many

• Creating tables with default PK as ID or setting your own PK
• Unique Together on table with single or multiple fields as Unique constraints
• All table field constraints:

  

  Not Null

  Unique

  Index

  Default


- You can also set field to be Nullable and PK (in regards to the upper figure, setting your own PK)

GENERATE design based on imported SQL - generates Design based on imported SQL file after choosing SQL file and selecting type of Database

EXPORT design as PNG or PDF

- exports whole design visualisation to PNG or PDF format


Visualization Advanced

CONNECT to database and generated design by database structure with provided connection details (driver, host, port, DB name, user, password and additional connection param uses service name for oracle)

GENERATE preview of DDL statements (whole database structure) inside the modal which can be quickly copied with Copy Button

EXPORT:

• A database design can be exported as DDL statements (whole database structure) for different database types like:

  

  
Oracle

  MSSQL

  PostgreSQL

  MariaDB

• Export Design SQL structure for different database types


DDL Generation Advanced

GENERATE only preview of Swagger file inside modal which can be quickly copied with Copy Button

EXPORT the database design as Swagger File per open API 3.0.0 spec or Design Swagger document

SQL file (with INSERT statements) or CSV files

GENERATE Test Data for all tables or choose just a range of tables 
to generate data for


Test Data Generation Advance

• SQL file (with INSERT statements) or CSV files
  

  
Oracle

  MSSQL

  PostgreSQL

  MariaDB

• Choose the Number of rows for test data to be generated and the number
of related entities (e.g. related tables with FK)
• In addition you can select the type of localisation for data, e.g. de_DE and generate 
data based on localisation (names, cities, streets, etc.)
• Currently supported locales:
  

  
de_DE

  en_GB

  en_US

  de_CH

  >

  es_ES

  it_IT

  fr_FR

PROVIDE an SQL file with INSERT statements, which will be anonymized by GDPR rules for default columns like first name, last name, address, banking details, etc.

• Also, specific columns from the list can be selected directly in modal



Anonymize Data Advanced

CONNECT to the database (with database connection params) and generate SQL file with anonymized data by GDPR rules for default columns like first name, last name, address banking details, etc.

• Also specific columns can be selected directly in modal, by easily ticking the box in table or by editing the field
  

HISTORY OF DESIGN TRACKING

• new revision is created when design is updated, if revision name is not provided default one is generated in format:
  

  $DESIGN_NAME

  -

  $YEAR

  -

  $MONTH

  -

  $DAY

  example: ctl_2020-01-19

  
  
• All changes made within design are tracked on table level for all fields, e.g changing field name, from nullable to not null, default values will be properly tracked

HISTORY - EXPORT DESIGNS

• different revisions as structure in SQL file for all supported databases tracked with history models

HISTORY - COMPARE TABLE DDL’s

• (CREATE and ALTER statements) between different revisions
• Comparing CREATE table statements in Git-like fashion to see diffs between revision

HISTORY - GENERATE

• ALTER STATEMENTS between revisions and preview them or download SQL file