-- 表: program_id_mapping
-- 自动生成于: 2026-03-06 00:39:05

DROP TABLE IF EXISTS `program_id_mapping`;
CREATE TABLE `program_id_mapping` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `original_id` int(11) NOT NULL COMMENT '外部系统的原始ID',
  `new_id` int(11) NOT NULL COMMENT '本地系统的新ID',
  `source_api` varchar(500) NOT NULL COMMENT '来源API地址',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `original_id` (`original_id`),
  KEY `new_id` (`new_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='程序ID映射表';

