Page 286 - Nodejs 교과서 개정2판

§ Ӓܿ ప੉࠶ ࢏ઁ ݫ׏

੉ߣীח ࢎਊ੗੄ ؆Ӗਸ ੷੢ೞח ప੉࠶ਸ ٜ݅যࠇद׮

콘솔

mysql> CREATE TABLE nodejs.comments (
-> id INT NOT NULL AUTO_INCREMENT,
-> commenter INT NOT NULL,
-> comment VARCHAR(100) NOT NULL,
-> created_at DATETIME NOT NULL DEFAULT now(),
-> PRIMARY KEY(id),
-> INDEX commenter_idx (commenter ASC),
-> CONSTRAINT commenter
-> FOREIGN KEY (commenter)
-> REFERENCES nodejs.users (id)
-> ON DELETE CASCADE
-> ON UPDATE CASCADE)
-> COMMENT = '댓글'
-> DEFAULT CHARSET=utf8mb4
-> ENGINE=InnoDB;
Query OK, 0 row affected (0.09 sec)

DPNNFOUT ప੉࠶ীח id commenter ؆Ӗਸ ॵ ࢎਊ੗ ই੉٣ comment ؆Ӗ ղਊ created_at ۽਋ ࢤࢿੌ
ஸۢ੉ ੓णפ׮

commenter ஸۢীח ؆Ӗਸ ੘ࢿೠ ࢎਊ੗੄ idܳ ੷੢ೡ Ѫੑפ׮ ੉ۧѱ ׮ܲ ప੉࠶੄ ӝࠄ ఃܳ ੷੢ೞח