Page 309 - Nodejs 교과서 개정2판

§ Ӓܿ द௬ۄ੉ૉ ਊয ࢸݺ

hasMany ݫࢲ٘ীࢲח sourceKey ࣘࢿী idܳ ֍Ҋ belongsTo ݫࢲ٘ীࢲח targetKey ࣘࢿী JEܳ ֍णפ׮

sourceKey੄ id৬ targetKey੄ id ݽف User ݽ؛੄ idੑפ׮ hasManyীࢲח sourceKeyܳ ॳҊ belongsT
oীࢲח UBSHFU,FZܳ ॵ׮Ҋ ࢤпೞݶ ؾפ׮

foreignKeyܳ ٮ۽ ૑੿ೞ૑ ঋח׮ݶ ੉ܴ੉ ݽ؛ݺ ӝࠄ ఃੋ ஸۢ੉ ݽ؛ী ࢤࢿؾפ׮ ৘ܳ ٜয comment
erܳ foreignKey۽ ૒੽ ֍য઱૑ ঋও׮ݶ VTFS ݽ؛ݺ ӝࠄ ః id о ೤୛૓ UserIdо foreignKey۽ ࢤࢿ

ؾפ׮

npm start ݺ۸য۽ ࢲߡܳ द੘ೞҊ աࢲ ௑ࣛਸ ࠁݶ ׮਺җ э਷ ݫद૑о ա২פ׮ द௬ۄ੉ૉо झझ۽ प

೯ೞח 42-ޙੑפ׮

콘솔

$ npm start
Executing (default): CREATE TABLE IF NOT EXISTS `users` (`id` INTEGER NOT NULL auto_increment , `name` VARC
HAR(20) NOT NULL UNIQUE, `age` INTEGER UNSIGNED NOT NULL, `married` TINYINT(1) NOT NULL, `comment` TEXT, `c
reated_at` DATETIME NOT NULL DEFAULT now(), PRIMARY KEY (`id`)) ENGINE=InnoDB;
Executing (default): SHOW INDEX FROM `users` FROM `nodejs`
Executing (default): CREATE TABLE IF NOT EXISTS `comments` (`id` INTEGER NOT NULL auto_increment , `comment
` VARCHAR(100) NOT NULL, `created_at` DATETIME DEFAULT now(), `commenter` INTEGER, PRIMARY KEY (`id`), FORE
IGN KEY (`commenter`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE=InnoDB;
Executing (default): SHOW INDEX FROM `comments` FROM `nodejs`

द௬ۄ੉ૉח ਕ௼߮஖о ప੉࠶ਸ ٜ݅ ٸ प೯೮؍ ҳޙҗ ࠺तೠ 42-ޙਸ ٟ݅פ׮ ੺ ଵઑ CREATE T
ABLE ٍী IF NOT EXISTSۄҊ غয ੓חؘ ੉ ࠗ࠙਷ ప੉࠶੉ ઓ੤ೞ૑ ঋਸ ҃਋ী प೯ػ׮ח ڷੑפ׮ ੉

޷ ਕ௼߮஖ ژח ௑ࣛ۽ ప੉࠶ਸ ٜ݅যف঻ਵ޲۽ ҳޙ਷ प೯غ૑ ঋणפ׮ ؀न पࣻ۽ ప੉࠶ਸ ࢏ઁ೮

ਸ ٸח ਤ੄ ҳޙਵ۽ ੋ೧ ׮द ప੉࠶੉ ࢤࢿؾפ׮

৘ઁীח ࢎਊغ૑ ঋও૑݅ ҙ҅৬ / . ҙ҅ب ঌইࠇद׮