深圳智汇创想科技有限公司

003- 3. 维护历史数据
003+ 3. 维护历史数据
004+
005+ #owmsCREATE TABLE `inv_shipmentordershipmentid` ( `Id` int NOT NULL AUTO_INCREMENT COMMENT 'ID', `CustomerCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户编号', `ShipmentOrderCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出库单号', `ShipmentId` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ShipmentId(FBA)', `ShipmentIdMinIndex` int NOT NULL DEFAULT '0' COMMENT 'ShipmentIDU000的最小序号，在此序号使用', `ShipmentIdMaxIndex` int NOT NULL DEFAULT '0' COMMENT 'ShipmentIDU000的最大序号，被下一个单号使用', `CreatorId` int NOT NULL COMMENT '创建人ID', `Creator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人', `CreationTime` datetime NOT NULL COMMENT '创建时间', `LastModifierId` int DEFAULT NULL COMMENT '最近修改人ID', `LastModifier` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '最近修改人', `LastModificationTime` datetime DEFAULT NULL COMMENT '最近修改时间', PRIMARY KEY (`Id`) USING BTREE) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='中转shipmentid关系表';alter table inv_shipmentpackingcarton add COLUMN`ShipmentIdMaxIndex` int NOT NULL DEFAULT 0 COMMENT 'ShipmentIDU000的序号';
006+

003- <p style="font-size:14px;background-color:rgba(0,0,0,.024);"><span style="font-weight:700;"><span style="font-size:24px;">3. 维护历史数据</span></span></p>
003+ <p style="font-size:14px;background-color:rgba(0,0,0,.024);"><span style="font-weight:700;"><span style="font-size:24px;">3. 维护历史数据</span></span></p>
004+ <p style="font-size:14px;background-color:rgba(0,0,0,.024);"><span style="font-weight:700;"><span style="font-size:24px;"><br /></span></span></p>
005+ <p style="font-size:14px;background-color:rgba(0,0,0,.024);"><span style="font-weight:700;"><span style="font-size:24px;">#owms<br />CREATE TABLE `inv_shipmentordershipmentid` (<br /> `Id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',<br /> `CustomerCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户编号',<br /> `ShipmentOrderCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出库单号',<br /> `ShipmentId` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ShipmentId(FBA)',<br /> `ShipmentIdMinIndex` int NOT NULL DEFAULT '0' COMMENT 'ShipmentIDU000的最小序号，在此序号使用',<br /> `ShipmentIdMaxIndex` int NOT NULL DEFAULT '0' COMMENT 'ShipmentIDU000的最大序号，被下一个单号使用',<br /> `CreatorId` int NOT NULL COMMENT '创建人ID',<br /> `Creator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人',<br /> `CreationTime` datetime NOT NULL COMMENT '创建时间',<br /> `LastModifierId` int DEFAULT NULL COMMENT '最近修改人ID',<br /> `LastModifier` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '最近修改人',<br /> `LastModificationTime` datetime DEFAULT NULL COMMENT '最近修改时间',<br /> PRIMARY KEY (`Id`) USING BTREE<br />) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='中转shipmentid关系表';<br /><br /><br />alter table inv_shipmentpackingcarton add COLUMN<br />`ShipmentIdMaxIndex` int NOT NULL DEFAULT 0 COMMENT 'ShipmentIDU000的序号';<br /></span></span></p><div><br /></div>
006+ <br />

005- #owmsCREATE TABLE `inv_shipmentordershipmentid` ( `Id` int NOT NULL AUTO_INCREMENT COMMENT 'ID', `CustomerCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户编号', `ShipmentOrderCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出库单号', `ShipmentId` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ShipmentId(FBA)', `ShipmentIdMinIndex` int NOT NULL DEFAULT '0' COMMENT 'ShipmentIDU000的最小序号，在此序号使用', `ShipmentIdMaxIndex` int NOT NULL DEFAULT '0' COMMENT 'ShipmentIDU000的最大序号，被下一个单号使用', `CreatorId` int NOT NULL COMMENT '创建人ID', `Creator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人', `CreationTime` datetime NOT NULL COMMENT '创建时间', `LastModifierId` int DEFAULT NULL COMMENT '最近修改人ID', `LastModifier` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '最近修改人', `LastModificationTime` datetime DEFAULT NULL COMMENT '最近修改时间', PRIMARY KEY (`Id`) USING BTREE) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='中转shipmentid关系表';alter table inv_shipmentpackingcarton add COLUMN`ShipmentIdMaxIndex` int NOT NULL DEFAULT 0 COMMENT 'ShipmentIDU000的序号';
005+ #owmsCREATE TABLE `inv_shipmentordershipmentid` ( `Id` int NOT NULL AUTO_INCREMENT COMMENT 'ID', `CustomerCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户编号', `ShipmentOrderCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出库单号', `ShipmentId` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ShipmentId(FBA)', `ShipmentIdMinIndex` int NOT NULL DEFAULT '0' COMMENT 'ShipmentIDU000的最小序号，在此序号使用', `ShipmentIdMaxIndex` int NOT NULL DEFAULT '0' COMMENT 'ShipmentIDU000的最大序号，被下一个单号使用', `CreatorId` int NOT NULL COMMENT '创建人ID', `Creator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人', `CreationTime` datetime NOT NULL COMMENT '创建时间', `LastModifierId` int DEFAULT NULL COMMENT '最近修改人ID', `LastModifier` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '最近修改人', `LastModificationTime` datetime DEFAULT NULL COMMENT '最近修改时间', PRIMARY KEY (`Id`) USING BTREE) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='中转shipmentid关系表';alter table inv_shipmentpackingcarton add COLUMN`ShipmentIdMaxIndex` int NOT NULL DEFAULT 0 COMMENT 'ShipmentIDU000的序号';
006-
006+
007+

005- <p style="font-size:14px;background-color:rgba(0,0,0,.024);"><span style="font-weight:700;"><span style="font-size:24px;">#owms<br />CREATE TABLE `inv_shipmentordershipmentid` (<br /> `Id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',<br /> `CustomerCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户编号',<br /> `ShipmentOrderCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出库单号',<br /> `ShipmentId` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ShipmentId(FBA)',<br /> `ShipmentIdMinIndex` int NOT NULL DEFAULT '0' COMMENT 'ShipmentIDU000的最小序号，在此序号使用',<br /> `ShipmentIdMaxIndex` int NOT NULL DEFAULT '0' COMMENT 'ShipmentIDU000的最大序号，被下一个单号使用',<br /> `CreatorId` int NOT NULL COMMENT '创建人ID',<br /> `Creator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人',<br /> `CreationTime` datetime NOT NULL COMMENT '创建时间',<br /> `LastModifierId` int DEFAULT NULL COMMENT '最近修改人ID',<br /> `LastModifier` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '最近修改人',<br /> `LastModificationTime` datetime DEFAULT NULL COMMENT '最近修改时间',<br /> PRIMARY KEY (`Id`) USING BTREE<br />) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='中转shipmentid关系表';<br /><br /><br />alter table inv_shipmentpackingcarton add COLUMN<br />`ShipmentIdMaxIndex` int NOT NULL DEFAULT 0 COMMENT 'ShipmentIDU000的序号';<br /></span></span></p><div><br /></div>
005+ <p style="font-size:14px;background-color:rgba(0,0,0,.024);"><span style="font-weight:700;"><span style="font-size:24px;">#owms<br />CREATE TABLE `inv_shipmentordershipmentid` (<br /> `Id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',<br /> `CustomerCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户编号',<br /> `ShipmentOrderCode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出库单号',<br /> `ShipmentId` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ShipmentId(FBA)',<br /> `ShipmentIdMinIndex` int NOT NULL DEFAULT '0' COMMENT 'ShipmentIDU000的最小序号，在此序号使用',<br /> `ShipmentIdMaxIndex` int NOT NULL DEFAULT '0' COMMENT 'ShipmentIDU000的最大序号，被下一个单号使用',<br /> `CreatorId` int NOT NULL COMMENT '创建人ID',<br /> `Creator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人',<br /> `CreationTime` datetime NOT NULL COMMENT '创建时间',<br /> `LastModifierId` int DEFAULT NULL COMMENT '最近修改人ID',<br /> `LastModifier` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '最近修改人',<br /> `LastModificationTime` datetime DEFAULT NULL COMMENT '最近修改时间',<br /> PRIMARY KEY (`Id`) USING BTREE<br />) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='中转shipmentid关系表';<br /><br /><br />alter table inv_shipmentpackingcarton add COLUMN<br />`ShipmentIdMaxIndex` int NOT NULL DEFAULT 0 COMMENT 'ShipmentIDU000的序号';<br /></span></span></p>
006- <br />
006+ <div><br /></div>
007+ <br />