sqlEnity.html

字段正则描述正则 int类型转换 Long Integer

添加apimodel 添加jpa 添加注释添加excel 特殊字段加强构造器 mybatis-plus

CREATE TABLE `t_inspection_order_item` (
                    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
                    `order_id` bigint(20) DEFAULT NULL COMMENT '订单号',
                    `origin` int(11) DEFAULT NULL COMMENT '数据来源',
                    `materiel_name` varchar(64) DEFAULT '' COMMENT '样本名称',
                    `sample_number` varchar(64) DEFAULT '' COMMENT '取样编号',
                    `standard_name` varchar(255) DEFAULT '' COMMENT '规格名称',
                    `factory_name` varchar(255) DEFAULT '' COMMENT '工厂',
                    `type_id` bigint(20) DEFAULT NULL COMMENT '类型编号',
                    `type_name` varchar(255) DEFAULT '' COMMENT '类型名称',
                    `sweight` double(10,2) DEFAULT NULL COMMENT '平均单重',
                    `lastupdatedstamp` datetime DEFAULT NULL COMMENT 'lastupdatedstamp',
                    `task_id` varchar(64) DEFAULT '' COMMENT '任务号',
                    PRIMARY KEY (`id`) USING BTREE,
                    UNIQUE KEY `AK_onlyKey` (`sample_number`) USING BTREE,
                    KEY `FK_Reference_6` (`order_id`) USING BTREE,
                    CONSTRAINT `FK_Reference_6` FOREIGN KEY (`order_id`) REFERENCES `t_inspection_order` (`id`)
                  ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='检测单项';