Page 305 - Nodejs 교과서 개정2판

VARCHAR(100) STRING(100)
INT INTEGER

TINYINT BOOLEAN

DATETIME DATE

INT UNSIGNED INTEGER.UNSIGNED

NOT NULL allowNull: false

UNIQUE unique: true

DEFAULT now() defaultValue: Sequelize.NOW

super.init ݫࢲ٘੄ ف ߣ૩ ੋࣻח ప੉࠶ ২࣌ੑפ׮

• sequelize: static init ݫࢲ٘੄ ݒѐ߸ࣻ৬ োѾغח ২࣌ਵ۽ db.sequelize ё୓ܳ ֍যঠ ೤פ׮ ա

઺ী NPEFM JOEFY KTীࢲ োѾ೤פ׮

• timestamps അ੤ false۽ غয ੓ਵݴ ੉ ࣘࢿ ч੉ trueݶ द௬ۄ੉ૉח DSFBUFE"Uҗ updatedAt ஸۢਸ
୶о೤פ׮ пп ۽਋о ࢤࢿؼ ٸ৬ ࣻ੿ؼ ٸ੄ दр੉ ੗زਵ۽ ੑ۱ؾפ׮ ೞ૑݅ ৘ઁীࢲח ૒੽ cr

eated_at ஸۢਸ ٜ݅঻ਵ޲۽ timestamps ࣘࢿ੉ ೙ਃೞ૑ ঋणפ׮ ٮۄࢲ ࣘࢿчਸ false۽ ೞৈ ੗ز
ਵ۽ զ૞ ஸۢਸ ୶оೞח ӝמਸ ೧ઁ೮णפ׮

• underscored द௬ۄ੉ૉח ӝࠄ੸ਵ۽ ప੉࠶ݺҗ ஸۢݺਸ நݣ ா੉झ DBNFM DBTF ৘द createdAt ۽
ٟ݅פ׮ ੉ܳ झ֎੉௼ ா੉झ TOBLF DBTF ৘द created_at ۽ ߄Բח ২࣌ੑפ׮

• modelName ݽ؛ ੉ܴਸ ࢸ੿ೡ ࣻ ੓णפ׮ ֢٘ ೐۽ં౟ীࢲ ࢎਊ೤פ׮

• tableName पઁ ؘ੉ఠ߬੉झ੄ ప੉࠶ ੉ܴ੉ ؾפ׮ ӝࠄ੸ਵ۽ח ݽ؛ ੉ܴਸ ࣗޙ੗ ߂ ࠂࣻഋਵ۽ ݅
ٟפ׮ ݽ؛ ੉ܴ੉ 6TFSۄݶ ప੉࠶ ੉ܴ਷ VTFSTо ؾפ׮

• paranoid USVF۽ ࢸ੿ೞݶ deletedAt੉ۄח ஸۢ੉ ࢤӤפ׮ ۽਋ܳ ࢏ઁೡ ٸ ৮੹൤ ૑ਕ૑૑ ঋҊ del
etedAtী ૑਍ दп੉ ӝ۾ؾפ׮ ۽਋ܳ ઑഥೞח ݺ۸ਸ ղ۷ਸ ٸח deletedAt੄ ч੉ nullੋ ۽਋ ࢏

ઁغ૑ ঋও׮ח ڷ ܳ ઑഥ೤פ׮ ੉ۧѱ ೞח ੉ਬח ա઺ী ۽਋ܳ ࠂਗೞӝ ਤ೧ࢲੑפ׮ ۽਋ܳ ࠂਗ
೧ঠ ೞח ࢚ട੉ ࢤӡ Ѫ э׮ݶ ޷ܻ true۽ ࢸ੿೧فࣁਃ

• charset과 collate пп utf8җ utf8_general_ci۽ ࢸ੿೧ঠ ೠӖ੉ ੑ۱ؾפ׮ ੉ݽ౭௑ө૑ ੑ۱ೡ

ࣻ ੓ѱ ೞҊ र׮ݶ utf8mb4৬ utf8mb4_general_ciܳ ੑ۱೤פ׮

$PNNFOU ݽ؛ب ٜ݅যࠇद׮

models/comment.js

const Sequelize = require('sequelize');

module.exports = class Comment extends Sequelize.Model {