他的回复:
表结构: CREATE TABLE flow_instance ( id bigint NOT NULL, definition_id bigint NOT NULL, business_id character varying(40) NOT NULL, node_type smallint NOT NULL, node_code character varying(40) NOT NULL, node_name character varying(100), variable text, flow_status character varying(20) NOT NULL, activity_status smallint DEFAULT 1 NOT NULL, create_time timestamp without time zone, create_by character varying(64) DEFAULT NULL::character varying, update_time timestamp without time zone, update_by character varying(64) DEFAULT NULL::character varying, ext character varying(500), del_flag character(1) DEFAULT '0'::character varying, tenant_id character varying(40), def_json text ) WITH (orientation=row, compression=no); COMMENT ON TABLE flow_instance IS '流程实例表'; COMMENT ON COLUMN flow_instance.id IS '主键id'; COMMENT ON COLUMN flow_instance.definition_id IS '对应flow_definition表的id'; COMMENT ON COLUMN flow_instance.business_id IS '业务id'; COMMENT ON COLUMN flow_instance.node_type IS '节点类型(0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关)'; COMMENT ON COLUMN flow_instance.node_code IS '流程节点编码'; COMMENT ON COLUMN flow_instance.node_name IS '流程节点名称'; COMMENT ON COLUMN flow_instance.variable IS '任务变量'; COMMENT ON COLUMN flow_instance.flow_status IS '流程状态(0待提交 1审批中 2审批通过 4终止 5作废 6撤销 8已完成 9已退回 10失效 11拿回)'; COMMENT ON COLUMN flow_instance.activity_status IS '流程激活状态(0挂起 1激活)'; COMMENT ON COLUMN flow_instance.create_time IS '创建时间'; COMMENT ON COLUMN flow_instance.create_by IS '创建人'; COMMENT ON COLUMN flow_instance.update_time IS '更新时间'; COMMENT ON COLUMN flow_instance.update_by IS '更新人'; COMMENT ON COLUMN flow_instance.ext IS '扩展字段,预留给业务系统使用'; COMMENT ON COLUMN flow_instance.del_flag IS '删除标志'; COMMENT ON COLUMN flow_instance.tenant_id IS '租户id'; ALTER TABLE flow_instance ADD CONSTRAINT flow_instance_pkey PRIMARY KEY (id); 插入语句: INSERT INTO flow_instance ( ID, business_id, definition_id, node_code, node_name, node_type, flow_status, activity_status, def_json, create_by, create_time, update_time, del_flag, update_by ) VALUES ( 1441893304693297152, '123', 1441084327969558528, 'submit', '蓝票审核', 1, '1', 1, '{"flowCode":"leaveFlow-serial2","flowName":"测试","modelValue":"CLASSICS","category":"1","version":"1","isPublish":1,"formCustom":"N","formPath":"system/leave/approve.vue","nodeList":[{"nodeType":0,"nodeCode":"start","nodeName":"开始","nodeRatio":0.000,"coordinate":"260,200|260,200","ext":"[]","status":2,"skipList":[{"nowNodeCode":"start","nextNodeCode":"submit","skipType":"PASS","coordinate":"280,200;370,200","status":2,"createBy":"1","updateBy":"1"}],"createBy":"1","updateBy":"1"},{"nodeType":1,"nodeCode":"submit","nodeName":"蓝票审核","permissionFlag":"2","nodeRatio":0.000,"coordinate":"420,200|420,200","formCustom":"N","formPath":"system/leave/approve.vue","ext":"[{\\\"code\\\":\\\"base3\\\",\\\"value\\\":\\\"common\\\"},{\\\"code\\\":\\\"base4\\\",\\\"value\\\":\\\"1\\\"},{\\\"code\\\":\\\"new_tabs1\\\",\\\"value\\\":\\\"3,4\\\"},{\\\"code\\\":\\\"new_tabs2\\\",\\\"value\\\":\\\"1\\\"},{\\\"code\\\":\\\"base1\\\",\\\"value\\\":\\\"测试\\\"},{\\\"code\\\":\\\"base2\\\",\\\"value\\\":\\\"测试\\\"}]","status":1,"skipList":[{"nowNodeCode":"submit","nextNodeCode":"end","skipType":"PASS","coordinate":"470,200;577,200","status":0,"createBy":"1","updateBy":"1"}],"createBy":"1","updateBy":"1"},{"nodeType":2,"nodeCode":"end","nodeName":"结束","nodeRatio":0.000,"coordinate":"597,200|597,200","ext":"[]","status":0,"createBy":"1","updateBy":"1"}],"topTextShow":false,"createBy":"1","updateBy":"1"}', '18775443985', NOW( ), NOW( ), '0', '18775443985' )