You need to use as a default value the MySQL function NOW(). So your column declaration should look like : { type: Sequelize.DATEONLY, allowNull: false, defaultValue: Sequelize.NOW } Keep in mind that this will not populate the fields in your migration. They will be empty, since they were not created with sequelize.
You can simple use the type UUIDV4 that comes with Sequelize. Here is more details : UUIDV4 For example making this definition: id: { type: Sequelize.UUID, defaultValue: Sequelize.UUIDV4, allowNull: false, primaryKey: true } This is not using the Sequelize CLI but you can use that native UUIDV4 by manually changing that.
If you are using sequelize-cli you need to create the migration first. This is just a file that tells the engine how to update the database and how to roll back the changes in case something goes wrong. You should always commit this file to your repository $ sequelize migration:create –name name_of_your_migration The migration file … Read more
Yes you can Model.findAll({ raw: true, //Other parameters }); would return just the data and not the model instance