programs_info/无锡市生命线项目/曹殿波/插入语句.txt

INSERT INTO "public"."archives_organization" ("id", "name", "create_time", "create_user", "update_time", "update_user", "del_flag", "business_type", "node_type", "area_code")  (

select replace(gen_random_uuid()::text, '-', '') as id,aaaaa.a3, now(),'1',now(),'1',1,aaaaa.a2,aaaaa.a8,aaaaa.a1 from aaaaa

);



INSERT INTO "public"."archives_personnel" ("id", "org_id", "name", "department", "post", "phone", "order_num", "create_time", "create_user", "update_time", "update_user", "del_flag")  (

select replace(gen_random_uuid()::text, '-', '') as id,
archives_organization.id,aaaaa.a4,'','',aaaaa.a5,null,now(),'1',null,null,1

 from aaaaa  left join archives_organization on aaaaa.a3=archives_organization.name  and archives_organization.business_type=aaaaa.a2


);