官术网_书友最值得收藏!

Checking database tables

We could use your own Mysql console to see if the tables were created successfully. However I will use another feature with a graphical interface that greatly facilitates the work, as it allows a faster and easier display, and perform operations on the basis of data very quickly.

As I am using Mac OSX I will use an application called Sequel Pro, it's a free and lightweight application to manage MySql databases.

Tip

You can find more information about Sequel Pro at: http://www.sequelpro.com/.

The previous command: sequelize db:migrate created the tables as we can see on the following figures:

  1. This picture shows the Bands table selected on the left side, the right side shows its content with the properties we setup on Band schema:

    Band table

  2. This picture shows the SequelizeMeta table selected on the left side, the right side shows its content with Sequelize files generated on the config/migrations folder:

    Migrations files

  3. This picture shows the user table selected on the left side, the right side shows its content with the properties we setup on the User schema:

    User table

The SquelizeMeta table holds the migration files in the same way that we had on migrations folder.

Now that we have created the necessary files for data insertion in our database, we are ready to move on and create other files for the application.

主站蜘蛛池模板: 防城港市| 尚志市| 扎赉特旗| 那坡县| 威海市| 乌拉特后旗| 桦川县| 平乡县| 新竹市| 遂宁市| 老河口市| 丰镇市| 筠连县| 德化县| 治县。| 甘谷县| 乌恰县| 北辰区| 马山县| 西林县| 育儿| 灌南县| 隆德县| 莱州市| 娄烦县| 舒城县| 丽水市| 凤凰县| 阳春市| 安宁市| 图们市| 凤阳县| 灵寿县| 南城县| 仪征市| 资兴市| 宁国市| 苍南县| 清河县| 兰州市| 麻栗坡县|