StMarkSchoolApplication / app / DB_schema / user_table.js
user_table.js
Raw
module.exports = (sequelize, Sequelize) => {
	const User = sequelize.define('users', {
		id: {
			type: Sequelize.INTEGER,
            autoIncrement: true,
            primaryKey: true
		},
		name1: {
			type: Sequelize.STRING,
			allowNull: false
		},
		name2: {
			type: Sequelize.STRING,
			allowNull: false
		},
		name3: {
			type: Sequelize.STRING,
			allowNull: false
		},
		username: {
			type: Sequelize.STRING,
			allowNull: false
		},
		phonenumber:{
			type: Sequelize.STRING,
			allowNull: false
		},
		email: {
			type: Sequelize.STRING,
			allowNull: false
		},
		password: {
			type: Sequelize.STRING,
			allowNull: false
		}
	});

	return User;
}