/
iezhelev
/
cppsh_micro
Обзор
Документация
Войти
/
iezhelev
/
cppsh_micro
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
main
cmd/generator/generated_table_filds_reverse_map.js
1 715 строк
81 KB
iezhelev
mrm_data_for_incident sync timer
27 июн 2025, 12:57
27 июн 2025, 12:57
0c3e5ba
Код
Авторство
О чём код?
// Code generated by 3_cdc_generator.js; DO NOT EDIT. const TableFieldsMapping = { "activity_norm_b0": { ViewName: "v_activity_norm", TargetTable: "activity_norm", PrimaryKey: "activity_normid", Dest2SrcFieldsMapping: { "activity_normid": "activity_norm_id", "createdbyid": "created_by_id", "createdtime": "created_time", "cypher": "string_0", "description": "text_0", "displayname": "display_name", "fullname": "string_1", "isactive": "is_active", "measure": "double_0", "need_off": "boolean_0", "need_speedlimit": "boolean_4", "need_trns": "boolean_2", "need_warn": "boolean_3", "need_wnd": "boolean_1", "shortname": "short_name", "unit_of_measure": "integer_0", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", }, Src2DestFieldsMapping: { "activity_norm_id": "activity_normid", "created_by_id": "createdbyid", "created_time": "createdtime", "string_0": "cypher", "text_0": "description", "display_name": "displayname", "string_1": "fullname", "is_active": "isactive", "double_0": "measure", "boolean_0": "need_off", "boolean_4": "need_speedlimit", "boolean_2": "need_trns", "boolean_3": "need_warn", "boolean_1": "need_wnd", "short_name": "shortname", "integer_0": "unit_of_measure", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", }, SrcFields: ["activity_norm_id","text_0","display_name","string_1","is_active","short_name","updated_time"], DstFields: ["activity_normid","description","displayname","fullname","isactive","shortname","updatedtime"], }, "activity_sh_b0": { ViewName: "v_activity_sh", TargetTable: "activity_sh", PrimaryKey: "activity_shid", Dest2SrcFieldsMapping: { "activity_shid": "activity_sh_id", "autoconfirm": "boolean_1", "automatic": "boolean_0", "createdbyid": "created_by_id", "createdtime": "created_time", "critical": "integer_0", "cypher": "string_4", "description": "text_0", "displayname": "display_name", "fullname": "string_3", "instruction_item": "string_1", "instruction_itemname": "string_5", "instruction_name": "string_0", "instruction_subitem": "string_2", "isactive": "is_active", "shortname": "short_name", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "workflowid": "workflow_id", "workflowstepid": "workflowstep_id", "workflowstepname": "workflowstep_name", }, Src2DestFieldsMapping: { "activity_sh_id": "activity_shid", "boolean_1": "autoconfirm", "boolean_0": "automatic", "created_by_id": "createdbyid", "created_time": "createdtime", "integer_0": "critical", "string_4": "cypher", "text_0": "description", "display_name": "displayname", "string_3": "fullname", "string_1": "instruction_item", "string_5": "instruction_itemname", "string_0": "instruction_name", "string_2": "instruction_subitem", "is_active": "isactive", "short_name": "shortname", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "workflow_id": "workflowid", "workflowstep_id": "workflowstepid", "workflowstep_name": "workflowstepname", }, SrcFields: ["activity_sh_id","string_4","display_name","is_active","short_name","updated_time"], DstFields: ["activity_shid","cypher","displayname","isactive","shortname","updatedtime"], }, "activity_sh_b1": { ViewName: "v_activity_sh", TargetTable: "activity_sh", PrimaryKey: "activity_shid", Dest2SrcFieldsMapping: { "frequency_type": "integer_0", }, Src2DestFieldsMapping: { "integer_0": "frequency_type", }, SrcFields: [], DstFields: [], }, "ipattachment": { ViewName: "v_attachment", TargetTable: "ipattachment", PrimaryKey: "attachmentid", Dest2SrcFieldsMapping: { "attachmentid": "attachment_id", "createdbyid": "created_by_id", "createdtime": "created_time", "displayname": "display_name", "document": "document", "extention": "extention", "isactive": "is_active", "ispublic": "is_public", "shortname": "short_name", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "workspaceid": "workspace_id", }, Src2DestFieldsMapping: { "attachment_id": "attachmentid", "created_by_id": "createdbyid", "created_time": "createdtime", "display_name": "displayname", "document": "document", "extention": "extention", "is_active": "isactive", "is_public": "ispublic", "short_name": "shortname", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "workspace_id": "workspaceid", }, SrcFields: ["attachment_id","created_by_id","created_time","display_name","document","extention","is_active","is_public","short_name","updated_by_id","updated_time","workspace_id"], DstFields: ["attachmentid","createdbyid","createdtime","displayname","document","extention","isactive","ispublic","shortname","updatedbyid","updatedtime","workspaceid"], }, "ciparam_b0": { ViewName: "v_ciparam", TargetTable: "ciparam", PrimaryKey: "ciparamid", Dest2SrcFieldsMapping: { "ci": "integer_4", "ciparam": "integer_9", "ciparamid": "ciparam_id", "citype": "integer_3", "concat_name": "string_5", "createdbyid": "created_by_id", "createdtime": "created_time", "description": "text_0", "displayname": "display_name", "filtr_priz": "integer_7", "healthindicator": "string_1", "incident": "integer_0", "isactive": "is_active", "maximumnorm": "double_1", "minimumnorm": "double_0", "norm": "double_2", "pa_id_link": "integer_2", "param_order": "integer_6", "service_level": "integer_5", "shortname": "short_name", "unitofmeasure": "integer_1", "up_ustr_citype": "integer_11", "up_ustr_citype_string": "string_3", "up_ustr_citype_string2": "string_4", "up_ustr_id": "integer_10", "up_ustr_id_string": "string_2", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "value": "string_0", }, Src2DestFieldsMapping: { "integer_4": "ci", "integer_9": "ciparam", "ciparam_id": "ciparamid", "integer_3": "citype", "string_5": "concat_name", "created_by_id": "createdbyid", "created_time": "createdtime", "text_0": "description", "display_name": "displayname", "integer_7": "filtr_priz", "string_1": "healthindicator", "integer_0": "incident", "is_active": "isactive", "double_1": "maximumnorm", "double_0": "minimumnorm", "double_2": "norm", "integer_2": "pa_id_link", "integer_6": "param_order", "integer_5": "service_level", "short_name": "shortname", "integer_1": "unitofmeasure", "integer_11": "up_ustr_citype", "string_3": "up_ustr_citype_string", "string_4": "up_ustr_citype_string2", "integer_10": "up_ustr_id", "string_2": "up_ustr_id_string", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "string_0": "value", }, SrcFields: ["integer_4","integer_9","ciparam_id","integer_3","string_5","created_by_id","created_time","text_0","display_name","integer_7","string_1","integer_0","is_active","double_1","double_0","double_2","integer_2","integer_6","integer_5","short_name","integer_1","integer_11","string_3","string_4","integer_10","string_2","updated_by_id","updated_time","string_0"], DstFields: ["ci","ciparam","ciparamid","citype","concat_name","createdbyid","createdtime","description","displayname","filtr_priz","healthindicator","incident","isactive","maximumnorm","minimumnorm","norm","pa_id_link","param_order","service_level","shortname","unitofmeasure","up_ustr_citype","up_ustr_citype_string","up_ustr_citype_string2","up_ustr_id","up_ustr_id_string","updatedbyid","updatedtime","value"], }, "citype_b0": { ViewName: "v_citype", TargetTable: "citype", PrimaryKey: "citypeid", Dest2SrcFieldsMapping: { "activeitemsquery": "text_1", "citype_uniquefieldsline": "string_7", "citypeid": "citype_id", "color": "string_5", "createdbyid": "created_by_id", "createdtime": "created_time", "displayname": "display_name", "entitytype": "integer_0", "icon": "string_1", "isactive": "is_active", "level": "string_4", "lvl": "integer_7", "obor_id_asu": "integer_6", "parent_citype": "integer_1", "parent_obor_id_asu": "integer_5", "prefix": "string_6", "row_order": "integer_3", "shortname": "string_0", "unitofmeasure": "integer_2", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", }, Src2DestFieldsMapping: { "text_1": "activeitemsquery", "string_7": "citype_uniquefieldsline", "citype_id": "citypeid", "string_5": "color", "created_by_id": "createdbyid", "created_time": "createdtime", "display_name": "displayname", "integer_0": "entitytype", "string_1": "icon", "is_active": "isactive", "string_4": "level", "integer_7": "lvl", "integer_6": "obor_id_asu", "integer_1": "parent_citype", "integer_5": "parent_obor_id_asu", "string_6": "prefix", "integer_3": "row_order", "string_0": "shortname", "integer_2": "unitofmeasure", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", }, SrcFields: ["citype_id","display_name","is_active","string_0","updated_time"], DstFields: ["citypeid","displayname","isactive","shortname","updatedtime"], }, "citype_b1": { ViewName: "v_citype", TargetTable: "citype", PrimaryKey: "citypeid", Dest2SrcFieldsMapping: { "tablename": "string_4", }, Src2DestFieldsMapping: { "string_4": "tablename", }, SrcFields: [], DstFields: [], }, "ciparams_b0": { ViewName: "v_citypeparams", TargetTable: "citypeparams", PrimaryKey: "shortname", Dest2SrcFieldsMapping: { "calculation": "text_0", "calculationtype": "string_4", "ciparamsid": "ciparams_id", "citype": "integer_3", "createdbyid": "created_by_id", "createdtime": "created_time", "defaultvalue": "string_3", "displayname": "display_name", "fieldtype": "string_2", "isactive": "is_active", "normlistid": "integer_4", "param_type": "string_5", "paramname": "string_1", "shortname": "short_name", "skipvisualization": "boolean_0", "sortorder": "integer_1", "unitofmeasure": "integer_0", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "value": "string_0", "value_format": "integer_2", }, Src2DestFieldsMapping: { "text_0": "calculation", "string_4": "calculationtype", "ciparams_id": "ciparamsid", "integer_3": "citype", "created_by_id": "createdbyid", "created_time": "createdtime", "string_3": "defaultvalue", "display_name": "displayname", "string_2": "fieldtype", "is_active": "isactive", "integer_4": "normlistid", "string_5": "param_type", "string_1": "paramname", "short_name": "shortname", "boolean_0": "skipvisualization", "integer_1": "sortorder", "integer_0": "unitofmeasure", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "string_0": "value", "integer_2": "value_format", }, SrcFields: ["text_0","string_4","ciparams_id","integer_3","created_by_id","created_time","string_3","display_name","string_2","is_active","integer_4","string_5","string_1","short_name","boolean_0","integer_1","integer_0","updated_by_id","updated_time","string_0","integer_2"], DstFields: ["calculation","calculationtype","ciparamsid","citype","createdbyid","createdtime","defaultvalue","displayname","fieldtype","isactive","normlistid","param_type","paramname","shortname","skipvisualization","sortorder","unitofmeasure","updatedbyid","updatedtime","value","value_format"], }, "citypicalfault_b0": { ViewName: "v_citypicalfault", TargetTable: "citypicalfault", PrimaryKey: "citypicalfaultid", Dest2SrcFieldsMapping: { "citype": "integer_3", "citypeparam": "integer_0", "citypicalfaultid": "citypicalfault_id", "createdbyid": "created_by_id", "createdtime": "created_time", "crtlevel": "integer_5", "dangerous": "boolean_4", "deadline": "integer_2", "deadlineunits": "string_0", "displayname": "display_name", "flttype": "integer_6", "id_source_system": "string_2", "isactive": "is_active", "lowervalue": "double_0", "priority": "integer_1", "require_cbl": "boolean_3", "require_mat": "string_4", "require_off": "boolean_0", "require_spdlim": "boolean_2", "require_wnd": "boolean_1", "roles": "string_3", "roles_cnt": "integer_7", "scrname": "string_1", "shortname": "short_name", "situation_group_id": "integer_4", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "uppervalue": "double_1", }, Src2DestFieldsMapping: { "integer_3": "citype", "integer_0": "citypeparam", "citypicalfault_id": "citypicalfaultid", "created_by_id": "createdbyid", "created_time": "createdtime", "integer_5": "crtlevel", "boolean_4": "dangerous", "integer_2": "deadline", "string_0": "deadlineunits", "display_name": "displayname", "integer_6": "flttype", "string_2": "id_source_system", "is_active": "isactive", "double_0": "lowervalue", "integer_1": "priority", "boolean_3": "require_cbl", "string_4": "require_mat", "boolean_0": "require_off", "boolean_2": "require_spdlim", "boolean_1": "require_wnd", "string_3": "roles", "integer_7": "roles_cnt", "string_1": "scrname", "short_name": "shortname", "integer_4": "situation_group_id", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "double_1": "uppervalue", }, SrcFields: ["integer_3","citypicalfault_id","created_by_id","created_time","boolean_4","integer_2","string_0","display_name","is_active","string_4","string_3","short_name","updated_by_id","updated_time"], DstFields: ["citype","citypicalfaultid","createdbyid","createdtime","dangerous","deadline","deadlineunits","displayname","isactive","require_mat","roles","shortname","updatedbyid","updatedtime"], }, "comment": { ViewName: "v_comment", TargetTable: "comment", PrimaryKey: "commentid", Dest2SrcFieldsMapping: { "updatedtime": "updated_time", "isactive": "is_active", "shortname": "short_name", "createdtime": "created_time", "entitytypeid": "entitytype_id", "updatedbyid": "updated_by_id", "commentid": "comment_id", "createdbyid": "created_by_id", "workspaceid": "workspace_id", "entityid": "entity_id", "subject": "subject", "comment": "comment", "parentcommentid": "parent_comment_id", "source": "source", }, Src2DestFieldsMapping: { "updated_time": "updatedtime", "is_active": "isactive", "short_name": "shortname", "created_time": "createdtime", "entitytype_id": "entitytypeid", "updated_by_id": "updatedbyid", "comment_id": "commentid", "created_by_id": "createdbyid", "workspace_id": "workspaceid", "entity_id": "entityid", "subject": "subject", "comment": "comment", "parent_comment_id": "parentcommentid", "source": "source", }, SrcFields: ["updated_time","is_active","short_name","created_time","entitytype_id","updated_by_id","comment_id","created_by_id","workspace_id","entity_id","subject","comment","parent_comment_id","source"], DstFields: ["updatedtime","isactive","shortname","createdtime","entitytypeid","updatedbyid","commentid","createdbyid","workspaceid","entityid","subject","comment","parentcommentid","source"], }, "edizm_b0": { ViewName: "v_edizm", TargetTable: "edizm", PrimaryKey: "edizmid", Dest2SrcFieldsMapping: { "createdbyid": "created_by_id", "createdtime": "created_time", "displayname": "display_name", "edizmid": "edizm_id", "ei_id_asu": "integer_1", "ei_kod": "integer_2", "isactive": "is_active", "name": "string_0", "shortname": "short_name", "sname": "string_1", "tipedizmid": "integer_0", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", }, Src2DestFieldsMapping: { "created_by_id": "createdbyid", "created_time": "createdtime", "display_name": "displayname", "edizm_id": "edizmid", "integer_1": "ei_id_asu", "integer_2": "ei_kod", "is_active": "isactive", "string_0": "name", "short_name": "shortname", "string_1": "sname", "integer_0": "tipedizmid", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", }, SrcFields: ["display_name","edizm_id","is_active","string_0","short_name","string_1","updated_time"], DstFields: ["displayname","edizmid","isactive","name","shortname","sname","updatedtime"], }, "ipentityattachment": { ViewName: "v_entityattachment", TargetTable: "ipentityattachment", PrimaryKey: "entityattachmentid", Dest2SrcFieldsMapping: { "attachmentid": "attachment_id", "createdbyid": "created_by_id", "createdtime": "created_time", "entityattachmentid": "entityattachment_id", "entityfieldid": "entity_field_id", "entityid": "entity_id", "entitytypeid": "entity_type_id", "isactive": "is_active", "shortname": "short_name", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "workspaceid": "workspace_id", }, Src2DestFieldsMapping: { "attachment_id": "attachmentid", "created_by_id": "createdbyid", "created_time": "createdtime", "entityattachment_id": "entityattachmentid", "entity_field_id": "entityfieldid", "entity_id": "entityid", "entity_type_id": "entitytypeid", "is_active": "isactive", "short_name": "shortname", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "workspace_id": "workspaceid", }, SrcFields: ["attachment_id","created_by_id","created_time","entityattachment_id","entity_field_id","entity_id","entity_type_id","is_active","short_name","updated_by_id","updated_time","workspace_id"], DstFields: ["attachmentid","createdbyid","createdtime","entityattachmentid","entityfieldid","entityid","entitytypeid","isactive","shortname","updatedbyid","updatedtime","workspaceid"], }, "mrm_data_for_incident_b0": { ViewName: "v_mrm_data_for_incident", TargetTable: "mrm_data_for_incident", PrimaryKey: "shortname", Dest2SrcFieldsMapping: { "citypicalfaultid": "integer_2", "createdbyid": "created_by_id", "createdtime": "created_time", "displayname": "display_name", "incidentid": "integer_1", "isactive": "is_active", "mrm_data_for_incidentid": "mrm_data_for_incident_id", "plannedactivityid": "integer_0", "shortname": "short_name", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "workflowid": "workflow_id", "workflowstepid": "workflowstep_id", "workflowstepname": "workflowstep_name", }, Src2DestFieldsMapping: { "integer_2": "citypicalfaultid", "created_by_id": "createdbyid", "created_time": "createdtime", "display_name": "displayname", "integer_1": "incidentid", "is_active": "isactive", "mrm_data_for_incident_id": "mrm_data_for_incidentid", "integer_0": "plannedactivityid", "short_name": "shortname", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "workflow_id": "workflowid", "workflowstep_id": "workflowstepid", "workflowstep_name": "workflowstepname", }, SrcFields: ["integer_2","created_by_id","created_time","is_active","integer_0","short_name"], DstFields: ["citypicalfaultid","createdbyid","createdtime","isactive","plannedactivityid","shortname"], }, "obj_inf_b0": { ViewName: "v_obj_inf", TargetTable: "obj_inf", PrimaryKey: "obj_infid", Dest2SrcFieldsMapping: { "conserv_priz": "boolean_3", "cor_tip": "string_2", "createdbyid": "created_by_id", "createdtime": "created_time", "displayname": "display_name", "expl": "double_0", "invert_ordinat": "boolean_0", "isactive": "is_active", "km": "integer_14", "latitude": "double_1", "length_obj": "double_6", "longitude": "double_2", "m": "integer_16", "name": "string_1", "obj_gid": "string_3", "obj_id_asu": "integer_7", "obj_id_k": "integer_5", "obj_id_n": "integer_4", "obj_infid": "obj_inf_id", "obj_nom": "integer_17", "obj_osn_id_asu": "integer_8", "obj_osn_id_n": "integer_19", "obj_osn_infid": "integer_0", "obj_up_id": "integer_6", "okato_id_asu": "integer_13", "pasp_priz": "boolean_1", "pkt": "integer_15", "putgl_id_asu": "integer_10", "putst_id_asu": "integer_11", "putstid": "integer_3", "shortname": "short_name", "syst_obj_inf": "integer_18", "toch_saut_text": "text_0", "uksps_d": "boolean_2", "up_id_asu": "integer_12", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "upid": "integer_2", "v_obj_id_asu": "integer_9", "vidobjid": "integer_1", "vname": "string_0", }, Src2DestFieldsMapping: { "boolean_3": "conserv_priz", "string_2": "cor_tip", "created_by_id": "createdbyid", "created_time": "createdtime", "display_name": "displayname", "double_0": "expl", "boolean_0": "invert_ordinat", "is_active": "isactive", "integer_14": "km", "double_1": "latitude", "double_6": "length_obj", "double_2": "longitude", "integer_16": "m", "string_1": "name", "string_3": "obj_gid", "integer_7": "obj_id_asu", "integer_5": "obj_id_k", "integer_4": "obj_id_n", "obj_inf_id": "obj_infid", "integer_17": "obj_nom", "integer_8": "obj_osn_id_asu", "integer_19": "obj_osn_id_n", "integer_0": "obj_osn_infid", "integer_6": "obj_up_id", "integer_13": "okato_id_asu", "boolean_1": "pasp_priz", "integer_15": "pkt", "integer_10": "putgl_id_asu", "integer_11": "putst_id_asu", "integer_3": "putstid", "short_name": "shortname", "integer_18": "syst_obj_inf", "text_0": "toch_saut_text", "boolean_2": "uksps_d", "integer_12": "up_id_asu", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "integer_2": "upid", "integer_9": "v_obj_id_asu", "integer_1": "vidobjid", "string_0": "vname", }, SrcFields: ["display_name","is_active","double_1","double_2","string_1","obj_inf_id","integer_0","short_name","updated_time","string_0"], DstFields: ["displayname","isactive","latitude","longitude","name","obj_infid","obj_osn_infid","shortname","updatedtime","vname"], }, "obj_inf_b1": { ViewName: "v_obj_inf", TargetTable: "obj_inf", PrimaryKey: "obj_infid", Dest2SrcFieldsMapping: { "aps_control": "string_2", "block_of_train_routes": "string_14", "cable_lenght": "string_1", "citypeid": "integer_7", "devices": "integer_10", "duplication": "string_6", "esso_system": "string_4", "esso_system_factory": "string_3", "esso_system_install_date": "string_5", "generator": "string_11", "indicator": "string_12", "invert_pkt": "integer_1", "m_obj_k": "integer_12", "m_obj_n": "integer_11", "numbers_of_cable": "string_0", "obj_id_k_asu": "integer_5", "obj_id_n_asu": "integer_4", "obj_id_p": "integer_3", "obj_osn_id_k": "integer_0", "obj_osn_id_p": "integer_2", "obj_up_id_asu": "integer_6", "pkt_obj_k": "integer_14", "pkt_obj_n": "integer_13", "podrid": "integer_19", "power_control_kit": "string_15", "predid": "integer_18", "relay_box": "string_10", "saut_install_year": "string_9", "saut_system": "string_7", "signal_input_device": "string_13", "tdm_control_value": "string_8", "traffic_lights_a": "integer_15", "traffic_lights_b": "integer_16", "type_servicesid": "integer_17", }, Src2DestFieldsMapping: { "string_2": "aps_control", "string_14": "block_of_train_routes", "string_1": "cable_lenght", "integer_7": "citypeid", "integer_10": "devices", "string_6": "duplication", "string_4": "esso_system", "string_3": "esso_system_factory", "string_5": "esso_system_install_date", "string_11": "generator", "string_12": "indicator", "integer_1": "invert_pkt", "integer_12": "m_obj_k", "integer_11": "m_obj_n", "string_0": "numbers_of_cable", "integer_5": "obj_id_k_asu", "integer_4": "obj_id_n_asu", "integer_3": "obj_id_p", "integer_0": "obj_osn_id_k", "integer_2": "obj_osn_id_p", "integer_6": "obj_up_id_asu", "integer_14": "pkt_obj_k", "integer_13": "pkt_obj_n", "integer_19": "podrid", "string_15": "power_control_kit", "integer_18": "predid", "string_10": "relay_box", "string_9": "saut_install_year", "string_7": "saut_system", "string_13": "signal_input_device", "string_8": "tdm_control_value", "integer_15": "traffic_lights_a", "integer_16": "traffic_lights_b", "integer_17": "type_servicesid", }, SrcFields: [], DstFields: [], }, "obj_osn_inf_b0": { ViewName: "v_obj_osn_inf", TargetTable: "obj_osn_inf", PrimaryKey: "obj_osn_infid", Dest2SrcFieldsMapping: { "class_linesid": "integer_7", "cor_tip": "string_3", "createdbyid": "created_by_id", "createdtime": "created_time", "displayname": "display_name", "exdl": "double_2", "isactive": "is_active", "latitude": "double_0", "longitude": "double_1", "n_duration": "integer_6", "name": "string_0", "obj_osn_id_asu": "integer_3", "obj_osn_infid": "obj_osn_inf_id", "obj_osn_k": "integer_2", "obj_osn_k_asu": "integer_10", "obj_osn_n": "integer_1", "obj_osn_n_asu": "integer_9", "okato_id_asu": "integer_5", "poezd_gr_kol": "integer_11", "poezd_otpr_kol": "integer_19", "poezd_par_kol": "integer_14", "poezd_paspar_kol": "integer_12", "poezd_priem_kol": "integer_18", "poezd_prig_kol": "integer_13", "shortname": "short_name", "spec_linesid": "integer_8", "stanid": "integer_0", "timezone": "datetime_2", "timezoneid": "string_4", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "v_obj_id_asu": "integer_4", "v_poezd_gr": "integer_16", "v_poezd_pas": "integer_15", "v_poezd_prig": "integer_17", "vname": "string_1", "workflowid": "workflow_id", "workflowstepid": "workflowstep_id", "workflowstepname": "workflowstep_name", }, Src2DestFieldsMapping: { "integer_7": "class_linesid", "string_3": "cor_tip", "created_by_id": "createdbyid", "created_time": "createdtime", "display_name": "displayname", "double_2": "exdl", "is_active": "isactive", "double_0": "latitude", "double_1": "longitude", "integer_6": "n_duration", "string_0": "name", "integer_3": "obj_osn_id_asu", "obj_osn_inf_id": "obj_osn_infid", "integer_2": "obj_osn_k", "integer_10": "obj_osn_k_asu", "integer_1": "obj_osn_n", "integer_9": "obj_osn_n_asu", "integer_5": "okato_id_asu", "integer_11": "poezd_gr_kol", "integer_19": "poezd_otpr_kol", "integer_14": "poezd_par_kol", "integer_12": "poezd_paspar_kol", "integer_18": "poezd_priem_kol", "integer_13": "poezd_prig_kol", "short_name": "shortname", "integer_8": "spec_linesid", "integer_0": "stanid", "datetime_2": "timezone", "string_4": "timezoneid", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "integer_4": "v_obj_id_asu", "integer_16": "v_poezd_gr", "integer_15": "v_poezd_pas", "integer_17": "v_poezd_prig", "string_1": "vname", "workflow_id": "workflowid", "workflowstep_id": "workflowstepid", "workflowstep_name": "workflowstepname", }, SrcFields: ["display_name","is_active","double_0","double_1","string_0","obj_osn_inf_id","short_name","updated_time","string_1"], DstFields: ["displayname","isactive","latitude","longitude","name","obj_osn_infid","shortname","updatedtime","vname"], }, "obj_osn_inf_b1": { ViewName: "v_obj_osn_inf", TargetTable: "obj_osn_inf", PrimaryKey: "obj_osn_infid", Dest2SrcFieldsMapping: { "for_maint_class_linesid": "integer_7", "poezd_form_kol": "integer_0", "poezd_nalpar_kol": "integer_4", "poezd_potrpar_kol": "integer_5", "poezd_rasform_kol": "integer_1", "predid": "integer_8", "t_zan_otpr": "integer_3", "t_zan_pr": "integer_2", "type_servicesid": "integer_9", "vidobjid": "integer_6", }, Src2DestFieldsMapping: { "integer_7": "for_maint_class_linesid", "integer_0": "poezd_form_kol", "integer_4": "poezd_nalpar_kol", "integer_5": "poezd_potrpar_kol", "integer_1": "poezd_rasform_kol", "integer_8": "predid", "integer_3": "t_zan_otpr", "integer_2": "t_zan_pr", "integer_9": "type_servicesid", "integer_6": "vidobjid", }, SrcFields: [], DstFields: [], }, "obor_szb_b0": { ViewName: "v_obor_szb", TargetTable: "obor_szb", PrimaryKey: "obor_szbid", Dest2SrcFieldsMapping: { "ass_id_asu": "integer_5", "citypeid": "integer_8", "conserv_priz": "boolean_0", "cor_tip": "string_1", "createdbyid": "created_by_id", "createdtime": "created_time", "displayname": "display_name", "ed_obor_id_asu": "integer_1", "entitytypeid": "integer_12", "isactive": "is_active", "link_to_source_record": "text_0", "mark_id_asu": "integer_4", "nom_marid": "integer_7", "obj_id_asu": "integer_0", "obj_infid": "integer_9", "obj_osn_id_asu": "integer_2", "obj_osn_infid": "integer_10", "obor_id_asu": "integer_6", "obor_oboz": "string_0", "obor_szbid": "obor_szb_id", "obor_up_id_asu": "integer_3", "off_place": "string_3", "putstid": "integer_13", "shortname": "short_name", "up_obor_szbid": "integer_11", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", }, Src2DestFieldsMapping: { "integer_5": "ass_id_asu", "integer_8": "citypeid", "boolean_0": "conserv_priz", "string_1": "cor_tip", "created_by_id": "createdbyid", "created_time": "createdtime", "display_name": "displayname", "integer_1": "ed_obor_id_asu", "integer_12": "entitytypeid", "is_active": "isactive", "text_0": "link_to_source_record", "integer_4": "mark_id_asu", "integer_7": "nom_marid", "integer_0": "obj_id_asu", "integer_9": "obj_infid", "integer_2": "obj_osn_id_asu", "integer_10": "obj_osn_infid", "integer_6": "obor_id_asu", "string_0": "obor_oboz", "obor_szb_id": "obor_szbid", "integer_3": "obor_up_id_asu", "string_3": "off_place", "integer_13": "putstid", "short_name": "shortname", "integer_11": "up_obor_szbid", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", }, SrcFields: ["display_name","is_active","integer_9","integer_10","string_0","obor_szb_id","short_name","updated_time"], DstFields: ["displayname","isactive","obj_infid","obj_osn_infid","obor_oboz","obor_szbid","shortname","updatedtime"], }, "pa_works_b0": { ViewName: "v_pa_works", TargetTable: "pa_works", PrimaryKey: "pa_worksid", Dest2SrcFieldsMapping: { "activity_normid": "integer_3", "cancel_reason": "string_5", "category_int": "integer_2", "class_linesid": "integer_11", "color": "string_7", "createdbyid": "created_by_id", "createdtime": "created_time", "deadline": "datetime_3", "deadline_fixed": "date_0", "discription_work": "text_0", "displayname_static": "string_2", "dorid": "integer_8", "factendtime": "datetime_2", "factendtime_read_only_html": "text_2", "factlaborintensity_manual_input": "double_0", "factstarttime": "datetime_1", "factstattime_read_only_html": "text_1", "fill_stage": "integer_13", "incidentid": "integer_16", "individual_templateid": "integer_14", "inspection_category": "integer_1", "inspection_chief": "integer_19", "inspection_reason": "string_10", "inspection_reason_comment": "text_4", "inspection_schu": "integer_18", "inspection_type": "string_9", "is_autogenerated": "boolean_0", "is_input_processing": "boolean_1", "is_main_inspection": "boolean_3", "isactive": "is_active", "laborintensity_display": "double_2", "obj_osn_infid": "integer_5", "on_mrm": "boolean_2", "pa_worksid": "pa_works_id", "park_id": "integer_15", "plannedlaborintensity_manual_input": "double_1", "plannedstarttime": "datetime_0", "plannedstarttime_color": "string_8", "podrid": "integer_7", "postpone_reason": "integer_17", "predid": "integer_6", "priority": "integer_4", "related_inspection": "integer_10", "resource_status": "text_3", "resultdatastart": "datetime_5", "resultyeardata": "datetime_6", "shortname": "short_name", "templateid": "integer_9", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "userdatastart": "datetime_4", "work_category": "integer_12", "work_name": "string_0", "work_num": "integer_0", "work_postpone_info": "string_3", "work_reason": "string_4", "workflowid": "workflow_id", "workflowstepid": "workflowstep_id", "workflowstepname": "workflowstep_name", "yearplan_shortname": "string_11", }, Src2DestFieldsMapping: { "integer_3": "activity_normid", "string_5": "cancel_reason", "integer_2": "category_int", "integer_11": "class_linesid", "string_7": "color", "created_by_id": "createdbyid", "created_time": "createdtime", "datetime_3": "deadline", "date_0": "deadline_fixed", "text_0": "discription_work", "string_2": "displayname_static", "integer_8": "dorid", "datetime_2": "factendtime", "text_2": "factendtime_read_only_html", "double_0": "factlaborintensity_manual_input", "datetime_1": "factstarttime", "text_1": "factstattime_read_only_html", "integer_13": "fill_stage", "integer_16": "incidentid", "integer_14": "individual_templateid", "integer_1": "inspection_category", "integer_19": "inspection_chief", "string_10": "inspection_reason", "text_4": "inspection_reason_comment", "integer_18": "inspection_schu", "string_9": "inspection_type", "boolean_0": "is_autogenerated", "boolean_1": "is_input_processing", "boolean_3": "is_main_inspection", "is_active": "isactive", "double_2": "laborintensity_display", "integer_5": "obj_osn_infid", "boolean_2": "on_mrm", "pa_works_id": "pa_worksid", "integer_15": "park_id", "double_1": "plannedlaborintensity_manual_input", "datetime_0": "plannedstarttime", "string_8": "plannedstarttime_color", "integer_7": "podrid", "integer_17": "postpone_reason", "integer_6": "predid", "integer_4": "priority", "integer_10": "related_inspection", "text_3": "resource_status", "datetime_5": "resultdatastart", "datetime_6": "resultyeardata", "short_name": "shortname", "integer_9": "templateid", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "datetime_4": "userdatastart", "integer_12": "work_category", "string_0": "work_name", "integer_0": "work_num", "string_3": "work_postpone_info", "string_4": "work_reason", "workflow_id": "workflowid", "workflowstep_id": "workflowstepid", "workflowstep_name": "workflowstepname", "string_11": "yearplan_shortname", }, SrcFields: ["integer_3","created_by_id","created_time","datetime_3","date_0","text_0","string_2","integer_8","datetime_2","datetime_1","integer_16","is_active","integer_5","boolean_2","pa_works_id","datetime_0","integer_7","integer_6","integer_4","short_name","integer_9","updated_by_id","updated_time","workflow_id","workflowstep_id","workflowstep_name"], DstFields: ["activity_normid","createdbyid","createdtime","deadline","deadline_fixed","discription_work","displayname_static","dorid","factendtime","factstarttime","incidentid","isactive","obj_osn_infid","on_mrm","pa_worksid","plannedstarttime","podrid","predid","priority","shortname","templateid","updatedbyid","updatedtime","workflowid","workflowstepid","workflowstepname"], }, "personal_b0": { ViewName: "v_personal", TargetTable: "personal", PrimaryKey: "personalid", Dest2SrcFieldsMapping: { "birthdate": "date_0", "cor_tip": "string_8", "createdbyid": "created_by_id", "createdtime": "created_time", "date_nd": "datetime_0", "date_status_begin": "datetime_1", "date_status_expires": "datetime_2", "dol_id_asu": "integer_7", "education": "string_5", "email": "string_3", "emailstatus": "string_4", "first_name": "string_1", "full_name_str": "string_9", "isactive": "is_active", "last_name": "string_6", "name": "string_0", "personal_statusid": "integer_4", "personal_vid_specid": "integer_10", "personalid": "personal_id", "phone": "string_2", "podr_id_asu": "integer_6", "podrid": "integer_2", "pred_id_asu": "integer_5", "predid": "integer_1", "prim": "string_7", "resource_titleid": "integer_3", "schedule": "integer_11", "shortname": "short_name", "sotr_id_asu": "integer_8", "travel_time_base_station": "integer_9", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "workflowid": "workflow_id", "workflowstepid": "workflowstep_id", "workflowstepname": "workflowstep_name", "working_hours": "double_0", }, Src2DestFieldsMapping: { "date_0": "birthdate", "string_8": "cor_tip", "created_by_id": "createdbyid", "created_time": "createdtime", "datetime_0": "date_nd", "datetime_1": "date_status_begin", "datetime_2": "date_status_expires", "integer_7": "dol_id_asu", "string_5": "education", "string_3": "email", "string_4": "emailstatus", "string_1": "first_name", "string_9": "full_name_str", "is_active": "isactive", "string_6": "last_name", "string_0": "name", "integer_4": "personal_statusid", "integer_10": "personal_vid_specid", "personal_id": "personalid", "string_2": "phone", "integer_6": "podr_id_asu", "integer_2": "podrid", "integer_5": "pred_id_asu", "integer_1": "predid", "string_7": "prim", "integer_3": "resource_titleid", "integer_11": "schedule", "short_name": "shortname", "integer_8": "sotr_id_asu", "integer_9": "travel_time_base_station", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "workflow_id": "workflowid", "workflowstep_id": "workflowstepid", "workflowstep_name": "workflowstepname", "double_0": "working_hours", }, SrcFields: ["string_9","is_active","personal_id","integer_2","short_name","updated_time"], DstFields: ["full_name_str","isactive","personalid","podrid","shortname","updatedtime"], }, "plannedactivity_b0": { ViewName: "v_plannedactivity", TargetTable: "plannedactivity", PrimaryKey: "plannedactivityid", Dest2SrcFieldsMapping: { "activity_normid": "integer_16", "activity_shid": "integer_17", "appoint_date": "datetime_9", "approve_dayplan": "boolean_10", "approve_monthplan": "boolean_11", "approve_yearplan": "boolean_12", "branch": "integer_10", "calendarname": "string_1", "category": "string_0", "category_int": "integer_18", "ci_shortname": "string_6", "ci_shortname_format": "integer_5", "ciid": "integer_2", "citype": "integer_11", "citypeid": "integer_1", "class_linesid": "integer_19", "closing_code": "string_2", "closing_time": "datetime_5", "color": "string_10", "confirm_done_work": "string_9", "createdbyid": "created_by_id", "createdtime": "created_time", "deadline": "datetime_1", "deadline_fixed": "datetime_10", "deadlineoff": "boolean_5", "description": "text_0", "factduration": "double_1", "factdurtimeunits": "string_4", "factendtime": "datetime_3", "factendtime_read_only_html": "text_2", "factlaborintensity": "double_4", "factstarttime": "datetime_4", "factstattime_read_only_html": "text_1", "group_reappoint_count": "integer_8", "incidentid": "integer_20", "individual_templateid": "integer_21", "initiator": "integer_3", "is_autogenerated": "boolean_1", "is_external_upload": "boolean_13", "is_standard": "boolean_2", "isactive": "is_active", "isalertviewed": "boolean_6", "isnt_nec_for_closing": "boolean_3", "laborintensity_excel": "string_11", "laborintensity_month_excel": "string_12", "mat_approved": "boolean_9", "mat_required": "boolean_20", "mat_used": "boolean_21", "meaning_demo": "string_13", "measure_cnt": "integer_22", "number_dev": "string_14", "obj_infid": "integer_23", "obj_osn_infid": "integer_14", "obor_szbid": "integer_24", "off_approved": "boolean_14", "off_required": "boolean_15", "pa_works_shortname": "string_16", "pa_worksid": "integer_15", "parameter_demo": "string_15", "plannedactivityid": "plannedactivity_id", "plannedduration": "double_0", "planneddurtimeunits": "string_3", "plannedendoff": "boolean_4", "plannedendtime": "datetime_2", "plannedendtimeviolationcount": "integer_7", "plannedlaborintensity": "double_2", "plannedstarttime": "datetime_0", "plannedstarttime_color": "string_17", "podrid": "integer_13", "predid": "integer_12", "priority": "integer_25", "related_inc_demo": "string_18", "resolve_method": "integer_26", "resultdatastart": "datetime_11", "resultdaydata": "datetime_12", "resultyeardata": "datetime_13", "shortname": "short_name", "speedlimit_required": "boolean_16", "standard_demo": "string_19", "taskconfhash": "string_7", "tasks_plannedduration": "double_3", "tasks_planneddurtimeunits": "string_5", "tasks_plannedendtime": "datetime_7", "tasks_plannedstarttime": "datetime_6", "tasksethash": "string_8", "templateid": "integer_0", "test_string_field": "string_20", "trns_approved": "boolean_8", "trns_required": "boolean_17", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "userdatastart": "datetime_14", "wnd_approved": "boolean_7", "wnd_required": "boolean_18", "workflowid": "workflow_id", "workflowstepid": "workflowstep_id", "workflowstepname": "workflowstep_name", "workgroup": "integer_6", "workgroup_appoint_date": "datetime_8", "wrn_required": "boolean_19", "yearplan_shortname": "string_21", }, Src2DestFieldsMapping: { "integer_16": "activity_normid", "integer_17": "activity_shid", "datetime_9": "appoint_date", "boolean_10": "approve_dayplan", "boolean_11": "approve_monthplan", "boolean_12": "approve_yearplan", "integer_10": "branch", "string_1": "calendarname", "string_0": "category", "integer_18": "category_int", "string_6": "ci_shortname", "integer_5": "ci_shortname_format", "integer_2": "ciid", "integer_11": "citype", "integer_1": "citypeid", "integer_19": "class_linesid", "string_2": "closing_code", "datetime_5": "closing_time", "string_10": "color", "string_9": "confirm_done_work", "created_by_id": "createdbyid", "created_time": "createdtime", "datetime_1": "deadline", "datetime_10": "deadline_fixed", "boolean_5": "deadlineoff", "text_0": "description", "double_1": "factduration", "string_4": "factdurtimeunits", "datetime_3": "factendtime", "text_2": "factendtime_read_only_html", "double_4": "factlaborintensity", "datetime_4": "factstarttime", "text_1": "factstattime_read_only_html", "integer_8": "group_reappoint_count", "integer_20": "incidentid", "integer_21": "individual_templateid", "integer_3": "initiator", "boolean_1": "is_autogenerated", "boolean_13": "is_external_upload", "boolean_2": "is_standard", "is_active": "isactive", "boolean_6": "isalertviewed", "boolean_3": "isnt_nec_for_closing", "string_11": "laborintensity_excel", "string_12": "laborintensity_month_excel", "boolean_9": "mat_approved", "boolean_20": "mat_required", "boolean_21": "mat_used", "string_13": "meaning_demo", "integer_22": "measure_cnt", "string_14": "number_dev", "integer_23": "obj_infid", "integer_14": "obj_osn_infid", "integer_24": "obor_szbid", "boolean_14": "off_approved", "boolean_15": "off_required", "string_16": "pa_works_shortname", "integer_15": "pa_worksid", "string_15": "parameter_demo", "plannedactivity_id": "plannedactivityid", "double_0": "plannedduration", "string_3": "planneddurtimeunits", "boolean_4": "plannedendoff", "datetime_2": "plannedendtime", "integer_7": "plannedendtimeviolationcount", "double_2": "plannedlaborintensity", "datetime_0": "plannedstarttime", "string_17": "plannedstarttime_color", "integer_13": "podrid", "integer_12": "predid", "integer_25": "priority", "string_18": "related_inc_demo", "integer_26": "resolve_method", "datetime_11": "resultdatastart", "datetime_12": "resultdaydata", "datetime_13": "resultyeardata", "short_name": "shortname", "boolean_16": "speedlimit_required", "string_19": "standard_demo", "string_7": "taskconfhash", "double_3": "tasks_plannedduration", "string_5": "tasks_planneddurtimeunits", "datetime_7": "tasks_plannedendtime", "datetime_6": "tasks_plannedstarttime", "string_8": "tasksethash", "integer_0": "templateid", "string_20": "test_string_field", "boolean_8": "trns_approved", "boolean_17": "trns_required", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "datetime_14": "userdatastart", "boolean_7": "wnd_approved", "boolean_18": "wnd_required", "workflow_id": "workflowid", "workflowstep_id": "workflowstepid", "workflowstep_name": "workflowstepname", "integer_6": "workgroup", "datetime_8": "workgroup_appoint_date", "boolean_19": "wrn_required", "string_21": "yearplan_shortname", }, SrcFields: ["integer_16","integer_17","integer_2","integer_1","string_9","created_by_id","created_time","datetime_10","text_0","double_1","datetime_3","double_4","datetime_4","is_active","boolean_9","boolean_20","boolean_21","integer_23","integer_14","integer_24","boolean_14","boolean_15","integer_15","plannedactivity_id","double_0","datetime_2","double_2","datetime_0","integer_13","integer_12","integer_25","datetime_12","short_name","integer_0","boolean_8","boolean_17","updated_by_id","updated_time","datetime_14","boolean_7","boolean_18","workflow_id","workflowstep_id","workflowstep_name"], DstFields: ["activity_normid","activity_shid","ciid","citypeid","confirm_done_work","createdbyid","createdtime","deadline_fixed","description","factduration","factendtime","factlaborintensity","factstarttime","isactive","mat_approved","mat_required","mat_used","obj_infid","obj_osn_infid","obor_szbid","off_approved","off_required","pa_worksid","plannedactivityid","plannedduration","plannedendtime","plannedlaborintensity","plannedstarttime","podrid","predid","priority","resultdaydata","shortname","templateid","trns_approved","trns_required","updatedbyid","updatedtime","userdatastart","wnd_approved","wnd_required","workflowid","workflowstepid","workflowstepname"], }, "planned_activity_params_b0": { ViewName: "v_planned_activity_params", TargetTable: "planned_activity_params", PrimaryKey: "planned_activity_paramsid", Dest2SrcFieldsMapping: { "ciparamid": "integer_5", "citypeparamsid": "integer_1", "createdbyid": "created_by_id", "createdtime": "created_time", "current_type": "integer_4", "date_of_measure": "datetime_0", "display_parametr": "string_1", "displayname": "display_name", "incidentid": "integer_6", "isactive": "is_active", "maximumnorm": "double_2", "measureunitid": "integer_2", "metermethod": "integer_3", "minimumnorm": "double_1", "norm": "double_3", "param_and_obor_oboz": "string_0", "planned_activity_paramsid": "planned_activity_params_id", "plannedactivityid": "integer_0", "shortname": "short_name", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "value": "double_0", "workflowid": "workflow_id", "workflowstepid": "workflowstep_id", "workflowstepname": "workflowstep_name", }, Src2DestFieldsMapping: { "integer_5": "ciparamid", "integer_1": "citypeparamsid", "created_by_id": "createdbyid", "created_time": "createdtime", "integer_4": "current_type", "datetime_0": "date_of_measure", "string_1": "display_parametr", "display_name": "displayname", "integer_6": "incidentid", "is_active": "isactive", "double_2": "maximumnorm", "integer_2": "measureunitid", "integer_3": "metermethod", "double_1": "minimumnorm", "double_3": "norm", "string_0": "param_and_obor_oboz", "planned_activity_params_id": "planned_activity_paramsid", "integer_0": "plannedactivityid", "short_name": "shortname", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "double_0": "value", "workflow_id": "workflowid", "workflowstep_id": "workflowstepid", "workflowstep_name": "workflowstepname", }, SrcFields: ["integer_5","integer_1","created_by_id","created_time","integer_4","datetime_0","string_1","display_name","integer_6","is_active","double_2","integer_2","integer_3","double_1","double_3","string_0","planned_activity_params_id","integer_0","short_name","updated_by_id","updated_time","double_0","workflow_id","workflowstep_id","workflowstep_name"], DstFields: ["ciparamid","citypeparamsid","createdbyid","createdtime","current_type","date_of_measure","display_parametr","displayname","incidentid","isactive","maximumnorm","measureunitid","metermethod","minimumnorm","norm","param_and_obor_oboz","planned_activity_paramsid","plannedactivityid","shortname","updatedbyid","updatedtime","value","workflowid","workflowstepid","workflowstepname"], }, "plannedactivity_persons_b0": { ViewName: "v_plannedactivity_persons", TargetTable: "plannedactivity_persons", PrimaryKey: "plannedactivity_personsid", Dest2SrcFieldsMapping: { "createdbyid": "created_by_id", "createdtime": "created_time", "displayname": "display_name", "dol": "integer_3", "dopusk": "boolean_1", "fio_name": "string_0", "isactive": "is_active", "lvl": "integer_2", "norm_chel_chas": "double_1", "personalid": "integer_1", "plan_chel_chas2": "double_0", "plannedactivity_personsid": "plannedactivity_persons_id", "plannedactivityid": "integer_0", "preshift_instruction": "string_2", "responsible": "boolean_0", "shortname": "short_name", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "workflowid": "workflow_id", "workflowstepid": "workflowstep_id", "workflowstepname": "workflowstep_name", }, Src2DestFieldsMapping: { "created_by_id": "createdbyid", "created_time": "createdtime", "display_name": "displayname", "integer_3": "dol", "boolean_1": "dopusk", "string_0": "fio_name", "is_active": "isactive", "integer_2": "lvl", "double_1": "norm_chel_chas", "integer_1": "personalid", "double_0": "plan_chel_chas2", "plannedactivity_persons_id": "plannedactivity_personsid", "integer_0": "plannedactivityid", "string_2": "preshift_instruction", "boolean_0": "responsible", "short_name": "shortname", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "workflow_id": "workflowid", "workflowstep_id": "workflowstepid", "workflowstep_name": "workflowstepname", }, SrcFields: ["created_time","is_active","integer_1","plannedactivity_persons_id","integer_0","short_name","updated_time"], DstFields: ["createdtime","isactive","personalid","plannedactivity_personsid","plannedactivityid","shortname","updatedtime"], }, "rel_personal_workspace_users_b0": { ViewName: "v_rel_personal_workspace_users", TargetTable: "rel_personal_workspace_users", PrimaryKey: "workspace_userid", Dest2SrcFieldsMapping: { "createdbyid": "created_by_id", "createdtime": "created_time", "displayname": "display_name", "isactive": "is_active", "personalid": "integer_0", "rel_personal_workspace_usersid": "rel_personal_workspace_users_id", "shortname": "short_name", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "workflowid": "workflow_id", "workflowstepid": "workflowstep_id", "workflowstepname": "workflowstep_name", "workspace_userid": "integer_1", }, Src2DestFieldsMapping: { "created_by_id": "createdbyid", "created_time": "createdtime", "display_name": "displayname", "is_active": "isactive", "integer_0": "personalid", "rel_personal_workspace_users_id": "rel_personal_workspace_usersid", "short_name": "shortname", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "workflow_id": "workflowid", "workflowstep_id": "workflowstepid", "workflowstep_name": "workflowstepname", "integer_1": "workspace_userid", }, SrcFields: ["is_active","integer_0","short_name","updated_time","integer_1"], DstFields: ["isactive","personalid","shortname","updatedtime","workspace_userid"], }, "ipuser": { ViewName: "v_user", TargetTable: "ipuser", PrimaryKey: "userid", Dest2SrcFieldsMapping: { "access_expired_date": "access_expired_date", "authtype": "auth_type", "avatar_file": "avatar_file", "birthdate": "birth_date", "confirmationcode": "confirmation_code", "createdbyid": "created_by_id", "createdtime": "created_time", "email": "email", "emailstatus": "email_status", "expresshuid": "express_huid", "failedloginattempts": "failed_login_attempts", "fired_date": "fired_date", "fullname": "full_name", "grade": "grade", "isactive": "is_active", "isnamedlicense": "is_named_license", "issystem": "is_system", "lastactivity": "last_activity", "localization": "localization", "loginname": "login_name", "loginpass": "login_pass", "loginpassresetcount": "login_pass_reset_count", "loglevel": "log_level", "mobilephone": "mobile_phone", "orgunit": "orgunit", "passwordexpirationdate": "password_expiration_date", "prev_status": "prev_status", "roleid": "role_id", "shortname": "short_name", "startdate": "start_date", "status": "status", "telegramid": "telegram_id", "timezone": "time_zone", "title": "title", "unlocktime": "unlock_time", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "userid": "user_id", "workphone": "work_phone", "workspaceid": "workspace_id", }, Src2DestFieldsMapping: { "access_expired_date": "access_expired_date", "auth_type": "authtype", "avatar_file": "avatar_file", "birth_date": "birthdate", "confirmation_code": "confirmationcode", "created_by_id": "createdbyid", "created_time": "createdtime", "email": "email", "email_status": "emailstatus", "express_huid": "expresshuid", "failed_login_attempts": "failedloginattempts", "fired_date": "fired_date", "full_name": "fullname", "grade": "grade", "is_active": "isactive", "is_named_license": "isnamedlicense", "is_system": "issystem", "last_activity": "lastactivity", "localization": "localization", "login_name": "loginname", "login_pass": "loginpass", "login_pass_reset_count": "loginpassresetcount", "log_level": "loglevel", "mobile_phone": "mobilephone", "orgunit": "orgunit", "password_expiration_date": "passwordexpirationdate", "prev_status": "prev_status", "role_id": "roleid", "short_name": "shortname", "start_date": "startdate", "status": "status", "telegram_id": "telegramid", "time_zone": "timezone", "title": "title", "unlock_time": "unlocktime", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "user_id": "userid", "work_phone": "workphone", "workspace_id": "workspaceid", }, SrcFields: ["full_name","is_active","short_name","title","updated_time","user_id"], DstFields: ["fullname","isactive","shortname","title","updatedtime","userid"], }, "ipworkflowstep": { ViewName: "v_workflowstep", TargetTable: "ipworkflowstep", PrimaryKey: "workflowstepid", Dest2SrcFieldsMapping: { "createdbyid": "created_by_id", "createdtime": "created_time", "defaultouttransition": "default_out_transition", "displayname": "display_name", "internalname": "internal_name", "isabstract": "is_abstract", "isactive": "is_active", "isnotshown": "is_not_shown", "outtransitioncalculation": "out_transition_calculation", "shortname": "short_name", "sortorder": "sort_order", "steptype": "step_type", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "workflowid": "workflow_id", "workflowstepid": "workflowstep_id", "workspaceid": "workspace_id", }, Src2DestFieldsMapping: { "created_by_id": "createdbyid", "created_time": "createdtime", "default_out_transition": "defaultouttransition", "display_name": "displayname", "internal_name": "internalname", "is_abstract": "isabstract", "is_active": "isactive", "is_not_shown": "isnotshown", "out_transition_calculation": "outtransitioncalculation", "short_name": "shortname", "sort_order": "sortorder", "step_type": "steptype", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "workflow_id": "workflowid", "workflowstep_id": "workflowstepid", "workspace_id": "workspaceid", }, SrcFields: ["created_by_id","created_time","default_out_transition","display_name","internal_name","is_abstract","is_active","is_not_shown","out_transition_calculation","short_name","sort_order","step_type","updated_by_id","updated_time","workflow_id","workflowstep_id","workspace_id"], DstFields: ["createdbyid","createdtime","defaultouttransition","displayname","internalname","isabstract","isactive","isnotshown","outtransitioncalculation","shortname","sortorder","steptype","updatedbyid","updatedtime","workflowid","workflowstepid","workspaceid"], }, "workspace_user_b0": { ViewName: "v_workspace_user", TargetTable: "workspace_user", PrimaryKey: "userid", Dest2SrcFieldsMapping: { "authtype": "string_5", "avatar_file": "integer_2", "birthdate": "date_2", "createdbyid": "created_by_id", "createdtime": "created_time", "displayname": "display_name", "email": "string_3", "emailstatus": "string_7", "failedloginattempts": "integer_5", "fired_date": "date_1", "fullname": "string_2", "isactive": "is_active", "level": "integer_6", "loginname": "string_0", "loginpass": "string_1", "orgunit": "integer_1", "passwordexpirationdate": "date_3", "phone": "string_8", "roleid": "integer_0", "shortname": "short_name", "startdate": "date_0", "status": "string_6", "team_develop": "integer_4", "timezone": "string_9", "title": "string_4", "updatedbyid": "updated_by_id", "updatedtime": "updated_time", "userid": "integer_3", "workspace_userid": "workspace_user_id", }, Src2DestFieldsMapping: { "string_5": "authtype", "integer_2": "avatar_file", "date_2": "birthdate", "created_by_id": "createdbyid", "created_time": "createdtime", "display_name": "displayname", "string_3": "email", "string_7": "emailstatus", "integer_5": "failedloginattempts", "date_1": "fired_date", "string_2": "fullname", "is_active": "isactive", "integer_6": "level", "string_0": "loginname", "string_1": "loginpass", "integer_1": "orgunit", "date_3": "passwordexpirationdate", "string_8": "phone", "integer_0": "roleid", "short_name": "shortname", "date_0": "startdate", "string_6": "status", "integer_4": "team_develop", "string_9": "timezone", "string_4": "title", "updated_by_id": "updatedbyid", "updated_time": "updatedtime", "integer_3": "userid", "workspace_user_id": "workspace_userid", }, SrcFields: ["is_active","short_name","updated_time","integer_3","workspace_user_id"], DstFields: ["isactive","shortname","updatedtime","userid","workspace_userid"], }, "workspace_user_b1": { ViewName: "v_workspace_user", TargetTable: "workspace_user", PrimaryKey: "userid", Dest2SrcFieldsMapping: { "access_code": "string_0", "ipaddress": "string_1", }, Src2DestFieldsMapping: { "string_0": "access_code", "string_1": "ipaddress", }, SrcFields: [], DstFields: [], }, } module.exports = { TableFieldsMapping: TableFieldsMapping }