From the course: Databases for Node.js Developers

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Review the auto-generated database structure

Review the auto-generated database structure

From the course: Databases for Node.js Developers

Start my 1-month free trial

Review the auto-generated database structure

“

- [Instructor] I'm back in MySQLWorkbench to review the database structure that was just created by Sequelize. So open the shopper database and I open the tables and there you now see that we have orders in the order items table. If I click on orders, I can right click and select the table inspector, and there I can select columns, and I see the columns that were created. You also see that there is a created at and updated at column, very similar to Mongoose, it's created automatically. What it attempts is similar, but it also has this foreign key which is the key that points back to the order ID. Let's look also at what are items in the table inspector, and here we also see the columns that were created for us. And that's all fine and interesting, but I will show you something really cool now. So I go to database and reverse engineer, and there I select the stored connection. So this is the connection are currently on.…

Contents