SUPPORT:
— All relation types between tables:
One To One
Many To One
Many To Many
— All table field constraints:
Not Null
Unique
Index
Default
— You can also set fields as Nullable while also being a primary key
TABLE CREATION OPTIONS:— Create tables with a default primary key (PK) as ID for straightforward identification and access or set custom a custom primary key to meet specific application needs and ensure data integrity
— Apply Unique Together constraints on single or multiple fields to enforce uniqueness within a table, preventing duplicate entries and maintaining data accuracy across key attributes.
DATABASE DESIGN GENERATION:
— Create designs from an imported SQL file by selecting the file and database type
EXPORT OPTIONS:
— Export whole design visualization as PNG or PDF
ADVANCED VISUALISATION:
— Connect to the database to create designs based on its structure using connection details (driver, host, port, database name, user, password, and additional connection param uses service name for oracle)
EXPORT:
— Generate the preview of DDL statements and export your entire database design as DDL statements
SUPPORTED DATABASE TYPES:
Oracle
MSSQL
PostgreSQL
MariaDB
DB2
ADVANCED DDL GENERATION:
— Connect to the database and generate designs from its structure using connection details (driver, host, port, database name, user, password, and Oracle service name)
— Export database designs as Swagger files, following the OpenAPI 3.0.0 specification or as a Swagger document
TEST DATA GENERATION:
— Generate test data using an SQL file (with INSERT statements) or CSV files
TEST DATA GENERATION ADVANCED:
— Generate test data for all tables or select specific tables to generate data for
— You can specify the number of rows for test data to be generated and the number
of related entities (e.g., tables with foreign keys)
— Additionally, select a localization type, such as de_DE, to produce data tailored to specific regions, including names, cities, and streets
SUPPORTED LOCALES:
de_DE
en_GB
en_US
de_CH
>
es_ES
it_IT
fr_FR
DATA ANONYMIZATION:
— Provide an SQL file with INSERT statements to be anonymized according to GDPR rules for default columns like first name, last name, address, and banking details, or select specific columns directly in the modal
DATA ANONYMIZATION ADVANCED:
— Connect to the database using connection parameters, and generate an anonymized SQL file based on the selected columns. Choose columns manually or use default anonymization settings to ensure compliance with GDPR regulations for sensitive data
HISTORY OF DESIGN TRACKING:
— New revision is created whenever the design is updated. If no revision name is provided, a default name is generated in the following format:
$DESIGN_NAME - $YEAR - $MONTH - $DAY
Example: ctl_2020-01-19
— All changes made within the design are tracked at the table level, including modifications to fields, such as changes to field names, nullable to not null, and default values.
HISTORY - EXPORT DESIGNS:
— Export different revisions as SQL structure files for all supported databases, with history models tracking changes
HISTORY - COMPARE TABLE DDL’s:
— Compare CREATE
and ALTER
statements between different revisions, using a Git-like method to visualize the differences between revisions.
HISTORY - GENERATE:
— Compare CREATE
and ALTER
statements between different revisions, using a Git-like method to visualize the differences between revisions.
- ALTER STATEMENTS between revisions and preview them or download SQL file
SUPPORT:
— All relation types between tables:
One To One
Many To One
Many To Many
— All table field constraints:
Not Null
Unique
Index
Default
— You can also set fields as Nullable while also being a primary key
TABLE CREATION OPTIONS:— Create tables with a default primary key (PK) as ID for straightforward identification and access or set custom a custom primary key to meet specific application needs and ensure data integrity
— Apply Unique Together constraints on single or multiple fields to enforce uniqueness within a table, preventing duplicate entries and maintaining data accuracy across key attributes.
DATABASE DESIGN GENERATION:
— Create designs from an imported SQL file by selecting the file and database type
EXPORT OPTIONS:
— Export whole design visualization as PNG or PDF
ADVANCED VISUALISATION:
— Connect to the database to create designs based on its structure using connection details (driver, host, port, database name, user, password, and additional connection param uses service name for oracle)