表 assets_cards 的id 是表 LETTING_DETAILSES 的外键,表里字段serial_number 的数据也以pre_serial_number字段存在 表LETTING_DETAILSES,id 与serial_number是一一对应的!
由于测试数据库的表assets_cards与研发数据库表assets_cards 中有部分资产数据的id、serial_number不一一对应,删掉测试数据库的不对应的数据,从研发数据库导进这部分数据:
alter table LETTING_DETAILSES disable constraint FK51DEC93ACE7A0619; 停掉外键约束
1.开始导入数据ing:
insert into assets_cards s
(id,
accumulate_depreciation,
address,
amount,
assets_group_code,
assets_state,
brand,
car_number,
category_code,
company_code,
cost_network_code,
created_on,
critical_state,
department_code,
discard_on,
discard_type_code,
duty_by,
idle_code,
init_original_value,
inventory,
invoice_number,
lease_on,
lessee,
lessor,
mainte