-- MDM item numbering: one transactionally locked counter per four-digit item type prefix.
|
-- Existing item codes are considered by MdmItemServiceImpl when the next code is generated.
|
CREATE TABLE IF NOT EXISTS `mdm_item_code_sequence` (
|
`prefix` VARCHAR(4) NOT NULL COMMENT '物料类型前缀 1001-1005',
|
`current_value` INT NOT NULL DEFAULT 0 COMMENT '当前五位流水号',
|
PRIMARY KEY (`prefix`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='MDM 物料编码分段流水';
|
