This issue recommends a database relational model design platform——chiner。
chiner meta-modeling platform is a database relational model design platform with rich database ecology, independent of specific databases. It uses React+Electron+Java technology system to build, support Windows,Mac,Linux and other operating systems, is a better free alternative to PowerDesigner, chiner provides simple and intuitive data table and field management and operation, And support PDMan, PowerDesigner, DDL, Word and other ecological docking functions.
Key functions:
- object of management
1.Data table, field operation
Provides simple and intuitive data table and field management and operation, the left list supports drag sorting, more data table Settings can add table remarks, extended attribute list, for example, provides Hive support
2.View of multiple table associations
A view is composed of multiple tables and supports the selection of multiple tables and fields
3.Customize data types and data fields
4.Standard field library
When you create a data table, you can drag common fields into the data table. You can import or export JSON files
5.data dictionary
- Simple mode and multi-module mode
- relation schema
1.ER picture
2.Conceptual model diagram
3.Multiple diagrams for the same module
- Code template
1.DDL for different database dialects
MySQL:
ORACLE:
SQLServer:
2.Extended attributes support similar to Hive
3.JavaBean
4. Code template engine built on doT.js
Read more on your own.chiner download link:「链接」