Sequelize Basics

gistfile1.txt

//One to One
bookDetail.hasOne(category);
category.belongsTo(bookDetail);

//One to Many
borrowBook.belongsTo(user,{foreignKey: 'user_id',});
user.hasMany(borrowBook,{foreignKey: 'user_id',});

//Many to Many
bookDetail.belongsToMany(author,{through: "book_author",foreignKey:'book_detail_id'});
author.belongsToMany(bookDetail, {through: "book_author",foreign_key:'author_id'});

//Force rewrite the db with new structure (WILL TRUNCATE ALL DB TABLE AND RECREATE THEM)
db.sequelize.sync({force:true});