How to generate mathematical model with table-building sql

Hello, 1. First, preview the established data model. Next, I will gradually generate this data model into the tables of the database.

2. First, the data model is generated as a physical model. Click "model"-"generate physical model", and you will be prompted. Click "Yes".

3. Enter the name of the physical model, just name it casually, and finally select the database type to import. I chose mysql. Then click "Finish". You don't need to write anything on the next page, just click "Close".

4. Then a physical model will be generated. On the left, you can see the generated physical model, including tables, table columns, primary keys and foreign keys.

Next, according to the physical model, sql statements for table construction are generated.

Right-click the physical model and select Generate Database.

You can modify the path to generate sql without changing it, as long as you remember that you can find the path in the end. Others don't need to be modified. There is no need to change this step, just "finish". See the generated sql file below.

6. You can open and view specific sql statements for table construction. Run the sql statement in the database tool and start building the table. Finally, the table is built in the database, as shown below. When you open a table, you can see that the information such as field, field type, whether it is empty, primary key, etc. are all correct.