FM / models

/var/www/qr4y.kz/server/delivery/models/

/var/www/qr4y.kz/server/delivery/models

Name	Size	Mode	Actions
address.js	1272	0644	edit dl rm
branch.js	2121	0644	edit dl rm
branchPayTypes.js	616	0644	edit dl rm
branchPrinters.js	820	0644	edit dl rm
branchProducts.js	1497	0644	edit dl rm
branchReviews.js	767	0644	edit dl rm
branchUsers.js	581	0644	edit dl rm
category.js	945	0644	edit dl rm
categoryImage.js	1074	0644	edit dl rm
company.js	1318	0644	edit dl rm
companyClients.js	684	0644	edit dl rm
companyImage.js	1070	0644	edit dl rm
companyReviews.js	771	0644	edit dl rm
companyType.js	664	0644	edit dl rm
companyUsers.js	586	0644	edit dl rm
countryCode.js	703	0644	edit dl rm
deliveryType.js	854	0644	edit dl rm
driver.js	645	0644	edit dl rm
index.js	15023	0644	edit dl rm
language.js	621	0644	edit dl rm
order.js	2514	0644	edit dl rm
orderAddress.js	870	0644	edit dl rm
orderCancelCause.js	730	0644	edit dl rm
orderHistory.js	960	0644	edit dl rm
orderItems.js	1329	0644	edit dl rm
orderPay.js	900	0644	edit dl rm
orderWaiters.js	495	0644	edit dl rm
payType.js	668	0644	edit dl rm
permission.js	731	0644	edit dl rm
product.js	1460	0644	edit dl rm
productExtra.js	696	0644	edit dl rm
productFeature.js	643	0644	edit dl rm
productGroup.js	1487	0644	edit dl rm
productGroupImage.js	1056	0644	edit dl rm
productImage.js	1035	0644	edit dl rm
productIngridient.js	716	0644	edit dl rm
productReviews.js	841	0644	edit dl rm
productType.js	664	0644	edit dl rm
productTypeFeature.js	660	0644	edit dl rm
productVariant.js	794	0644	edit dl rm
refreshToken.js	1218	0644	edit dl rm
role.js	819	0644	edit dl rm
room.js	837	0644	edit dl rm
shippingRate.js	1810	0644	edit dl rm
table.js	1149	0644	edit dl rm
tableHistory.js	1223	0644	edit dl rm
tableReserv.js	1453	0644	edit dl rm
user.js	2321	0644	edit dl rm
userAccountHistory.js	1036	0644	edit dl rm
userAcount.js	1059	0644	edit dl rm
userCartItem.js	1267	0644	edit dl rm
userGoogleToken.js	874	0644	edit dl rm
userLoginHistory.js	1415	0644	edit dl rm
userPhone.js	836	0644	edit dl rm
userToken.js	1234	0644	edit dl rm
workTime.js	979	0644	edit dl rm

Edit: /var/www/qr4y.kz/server/delivery/models/user.js (2321B)

module.exports = (sequelize, Sequelize) => {
	const User = sequelize.define(
		'user',
		{
			id: {
				type: Sequelize.BIGINT,
				autoIncrement: true,
				allowNull: false,
				primaryKey: true
			},
			uid: {
				type: Sequelize.UUID,
				defaultValue: Sequelize.UUIDV4
			},
			login: {
				type: Sequelize.STRING(30),
				allowNull: true
				//, unique: true
			},
			name: { type: Sequelize.STRING(70), allowNull: false },
			image: { type: Sequelize.STRING, allowNull: true },
			email: {
				type: Sequelize.STRING(100),
				allowNull: true,
				// unique: true,
				validate: {
					isEmail: true
				}
			},
			googleId: {
				type: Sequelize.STRING,
				allowNull: true,
			},
			emailConfirmed: {
				type: Sequelize.BOOLEAN,
				allowNull: false,
				defaultValue: false
			},
			passwordHash: {
				type: Sequelize.STRING,
				allowNull: false,
				defaultValue: ''
			},
			isBlocked: {
				type: Sequelize.BOOLEAN,
				allowNull: false,
				defaultValue: false
			},
			rating: {
				type: Sequelize.INTEGER,
				allowNull: false,
				defaultValue: 0
			},
			ordersCreated: {
				type: Sequelize.INTEGER,
				allowNull: false,
				defaultValue: 0
			},
			ordersCompleted: {
				type: Sequelize.INTEGER,
				allowNull: false,
				defaultValue: 0
			},
			ordersCanceled: {
				type: Sequelize.INTEGER,
				allowNull: false,
				defaultValue: 0
			},
			createdAt: {
				allowNull: false,
				type: Sequelize.DATE,
				defaultValue: new Date()
			},
			updatedAt: {
				allowNull: false,
				type: Sequelize.DATE,
				defaultValue: new Date()
			}
		},
		{
			// add the timestamp attributes (updatedAt, createdAt)
			timestamps: true,

// don't delete database entries but set the newly added attribute deletedAt
			// to the current date (when deletion was done). paranoid will only work if
			// timestamps are enabled
			paranoid: true,

// don't use camelcase for automatically added attributes but underscore style
			// so updatedAt will be updated_at
			underscored: false,

// disable the modification of tablenames; By default, sequelize will automatically
			// transform all passed model names (first parameter of define) into plural.
			// if you don't want that, set the following
			freezeTableName: true,

// define the table's name
			tableName: 'users'
		}
	)
	return User
}

module.exports = (sequelize, Sequelize) => { const User = sequelize.define( 'user', { id: { type: Sequelize.BIGINT, autoIncrement: true, allowNull: false, primaryKey: true }, uid: { type: Sequelize.UUID, defaultValue: Sequelize.UUIDV4 }, login: { type: Sequelize.STRING(30), allowNull: true //, unique: true }, name: { type: Sequelize.STRING(70), allowNull: false }, image: { type: Sequelize.STRING, allowNull: true }, email: { type: Sequelize.STRING(100), allowNull: true, // unique: true, validate: { isEmail: true } }, googleId: { type: Sequelize.STRING, allowNull: true, }, emailConfirmed: { type: Sequelize.BOOLEAN, allowNull: false, defaultValue: false }, passwordHash: { type: Sequelize.STRING, allowNull: false, defaultValue: '' }, isBlocked: { type: Sequelize.BOOLEAN, allowNull: false, defaultValue: false }, rating: { type: Sequelize.INTEGER, allowNull: false, defaultValue: 0 }, ordersCreated: { type: Sequelize.INTEGER, allowNull: false, defaultValue: 0 }, ordersCompleted: { type: Sequelize.INTEGER, allowNull: false, defaultValue: 0 }, ordersCanceled: { type: Sequelize.INTEGER, allowNull: false, defaultValue: 0 }, createdAt: { allowNull: false, type: Sequelize.DATE, defaultValue: new Date() }, updatedAt: { allowNull: false, type: Sequelize.DATE, defaultValue: new Date() } }, { // add the timestamp attributes (updatedAt, createdAt) timestamps: true, // don't delete database entries but set the newly added attribute deletedAt // to the current date (when deletion was done). paranoid will only work if // timestamps are enabled paranoid: true, // don't use camelcase for automatically added attributes but underscore style // so updatedAt will be updated_at underscored: false, // disable the modification of tablenames; By default, sequelize will automatically // transform all passed model names (first parameter of define) into plural. // if you don't want that, set the following freezeTableName: true, // define the table's name tableName: 'users' } ) return User }