数据库表结构
CREATE TABLE `major` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '专业id',
`code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专业代码',
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专业名称',
`parentId` int(11) NULL DEFAULT NULL COMMENT '上级di',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 457 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '专业表' ROW_FORMAT = Dynamic;
2021-05-25 11:27:32
33KB
SQL
1