ショッピングモールの作成-DB設定

Basket model

const Sequelize=require('sequelize');

module.exports=class Basket extends Sequelzie.Model{
	static init(sequelize){
		return super.init({
			basketproduct:{
				type:Sequelize.STRING(50),
				allowNull:false,
			},
			ordercount:{
				type:Sequelize.INTEGER,
				allowNull:false,
			}
		},{
			sequelize,
			timestamps:true,
			underscored:false,
			modelName:'Basket',
			tableName:'baskets',
			charset:'utfmb4',
			collate:'utfmb4_general_ci',
		})
	}
}

Buy model

const Sequelize=require('sequelize');

module.exports=class Buy extends Sequelize.Model{
	static init(sequelize){
		return super.init({
			buyproduct:{
				type:Sequelize.STRING(50),
				allowNull:false,
			},
			buycount:{
				type:Sequelize.INTEGER,
				allowNull:false,
			}
		},{
			sequelize,
			timestamps:true,
			underscored:false,
			modelName:'Buy',
			tableName:'buys',
			charset:'utf8mb4',
			collate:'utf8mb4_general_ci',
		})
	}
}

Comment model

const Sequelize=require('sequelize');

module.exports=class buy extends Sequelize.Model{
	static init(sequelize){
		return super.init({
			rating:{
				type:Sequelize.INTEGER,
				allowNull:false,
			},
			content:{
				type:Sequelize.STRING(500),
				allowNull:false,
			}
		},{
			sequelize,
			timestamps:true,
			underscored:false,
			modelName:'Comment',
			tableName:'comments',
			charset:'utf8',
			collate:'utf8_general_ci',
		})
	}
}

Hashtag model

const Sequelize=require('sequelize');

module.exports=class Hashtag extends Sequelize.Model{
	static init(sequelize){
		return super.init({
			title:{
				type:Sequelize.STRING(50),
				allowNull:false,
				unique:true,
			},
		},{
			sequelize,
			timestamps:true,
			modelName:'Hashtag',
			tableName:'hashtags',
			charset:'utf8mb4',
			collate:'utf8mb4_general_ci',
		})
	}
};

Product model

const Sequelize=require('sequelize');

module.exports=class Product extends Sequelize.Model{
	static init(sequelize){
		return super.init({
			name:{
				type:Sequelize.STRING(50),
				allowNull:false,
			},
			img:{
				type:Sequelize.STRING(300),
				allowNull:false,
			},
			content:{
				type:Sequelize.STRING(500),
				allowNull:false,
			},
			price:{
				type:Sequelize.INTEGER,
				allowNull:false,
			},
			remaincount:{
				type:Sequelize.INTEGER,
				allowNull:false,
			},
			hashtag:{
				type:Sequelize.STRING(500),
				allowNull:true,
			}
		},{
			sequelize,
			timestamps:true,
			underscored:false,
			modelName:'Product',
			tableName:'products',
			charset:'utf8mb4',
			collate:'utf8mb4_general_ci',
		})
	}
}

User model

const Sequelize=require('sequelize');

module.exports=class User extends Sequelize.Model{
	static init(sequelize){
		return super.init({
			email:{
				type:Sequelize.STRING(40),
				allowNull:false,
			},
			nick:{
				type:Sequelize.STRING(50),
				allowNull:false,
			},
			password:{
				type:Sequelize.STRING(200),
				allowNull:false,
			},
			auth:{
				type:Sequelize.STRING(10),
				allowNull:false,
			}
		},{
			sequelize,
			timestamps:true,
			paranoid:true,
			modelName:'User',
			tableName:'users',
			charset:'utf8',
			collate:'utf8_general_ci',
		})
	}
}