17. DDL (MySQL) - javabasedapplicationsw/EducationalMaterials GitHub Wiki

CREATE TABLE `t_comment` (
`cno` int NOT NULL AUTO_INCREMENT COMMENT ‘댓글번호’,
`bno` int NOT NULL COMMENT ‘게시물번호’,
`pcno` int DEFAULT NULL COMMENT ‘대댓글번호 ’,
`comment` varchar(3000) DEFAULT NULL,
`commenter` varchar(30) DEFAULT NULL,
`reg_date` datetime DEFAULT CURRENT_TIMESTAMP,
`up_date` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`cno`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COMMENT=’comment table’