Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what are the functions of PDMan". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Recently, a new project has just passed the requirements and officially entered the stage of database table structure design, and the company stipulated that the data modeling tool PowerDesigner should be used uniformly. But I do not like to use this tool very much, because it has too many functions, and it appears to be very bloated and cumbersome, and usually only a few functions are used in designing tables.

Here to find a useful tool, non-stop to share with you, PDMan, a domestic open source database modeling tool, its functions PowerDesigner have been implemented, but compared to the bulky PowerDesigner. PDMan is specially used for data table design, the interface is more clean and beautiful, the function is also very simple, no extra settings are easy to use, but also provides three platform versions of Windows,Mac,Linux.

What PDMan saves is a JSON file. Before using it, you have to do some preparatory work, configure JDK and MySQL connections, and the later functions will be used.

Next, let's go over the function points of PDMan one by one.

Generate database documents

PDMan supports DDL execution scripts for one-click export of data table structure, JSON format data, and database table structure documents, in which database documents can generate html, word and markdown formats. The document content includes the field properties of each table and the relationship diagram between data tables.

Html format

Table catalogue

Table diagram

List list

Word format

Word format

Markdown format

Markdown format

Reverse parsing of database

Previously, we have configured the database information, here directly from the existing database of the data table, reverse the table structure, and the relationship between the data table diagram.

Version control

PDMan can control the version of each change and compare the changes between any version, similar to the version control of Git.

Global configuration

Set the global general field properties of the table structure. Usually, when creating a table, each table will have fields such as creation time create_time, update time update_time, delete tag delete_flag, optimistic lock revision, and so on, so that it will be automatically generated when the table is created.

You can also customize data types, for example: character types can be customized varchar (10), varchar (20), varchar (30). When creating fields, you can directly select the corresponding data type, once and for all.

The overall functionality of PDMan is very simple, but it is enough to meet the needs of database design in daily development.

This is the end of the content of "what are the functions of PDMan". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.