Page 563 - Nodejs 교과서 개정2판

$ npm i

ؘ੉ఠ߬੉झ۽ח .Z42-ਸ ࢎਊ೤פ׮ द௬ۄ੉ૉܳ ࢸ஖ೞҊ ӝࠄ ٣۩ఠܻܳ ٟ݅פ׮

콘솔

$ npm i sequelize sequelize-cli mysql2
$ npx sequelize init

೐۽ં౟ח ࣁ ݽ؛ ૊ ࢎਊ੗ ݽ؛ ઁಿ ݽ؛ ҃ݒ ݽ؛۽ ҳࢿؾפ׮ ׮਺җ э੉ ࣁ ݽ؛ਸ ٟ݅פ׮

models/user.js
const Sequelize = require('sequelize');

module.exports = class User extends Sequelize.Model {
static init(sequelize) {
return super.init({
email: {
type: Sequelize.STRING(40),
allowNull: false,
unique: true,
},
nick: {
type: Sequelize.STRING(15),
allowNull: false,
},
password: {
type: Sequelize.STRING(100),
allowNull: true,
},
money: {
type: Sequelize.INTEGER,
allowNull: false,
defaultValue: 0,
},
}, {
sequelize,
timestamps: true,
paranoid: true,
modelName: 'User',
tableName: 'users',
charset: 'utf8',
collate: 'utf8_general_ci',