| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166 |
- migration:
- type: FILE
- sourceDatabase:
- type: sqlserver
- host: 192.168.100.25
- port: 1433
- name: cpcimb
- username: sa
- password: D4tacom!
- properties: encrypt=true;trustServerCertificate=true;
- target: null
- schema:
- - target: pbx
- table: pbxlist
- history: null
- group: null
- unique: code
- attribute:
- code: pbx_code
- name: description
- ipPbx: ip_pbx
- pbxSupporter: pbx_supporter
- sharePath: share_path
- appliedDate: ext_start
- expiredDate: ext_end
- - target: corcos
- table: womastercorcos
- history: null
- group: null
- attribute:
- command: command
- name: short_desc
- description: description
- - target: provider
- table: provider
- history: null
- group: null
- attribute:
- code: provider_prefix
- name: description
- description: description
- - target: account
- table: account
- history: accounthistory
- group: null
- attribute:
- id: history.account_id
- code: account_code
- name: history.account_number
- description: description
- appliedDate: history.app_datetime
- expiredDate: history.exp_datetime
- - target: trunk
- table: trunk
- history: trunkhistory
- group: null
- unique: code;pbx_uid
- attribute:
- id: history.trunk_id
- code: trunk_code
- name: description
- pbx_id: location_code
- direction: cap_direction
- appliedDate: history.app_datetime
- expiredDate: history.exp_datetime
- subscribedNo: history.trunk_number
- - target: costCenter
- table: costcenter
- history: costcenterhistory
- group: null
- unique: code
- attribute:
- id: history.costcenter_id
- code: costcenter_code
- name: costcenter_name
- description: description
- email: costcenter_email
- parent_id: history.parent_costcenter_id
- structure: history.costcenter_id_structure
- appliedDate: history.app_datetime
- expiredDate: history.exp_datetime
- - target: organization
- table: organization
- history: organizationhistory
- group: null
- unique: code
- attribute:
- id: history.organization_id
- code: organization_code
- name: organization_name
- description: description
- email: organization_email
- emailOnOverBudget: sendemail_overbudget
- parent_id: history.parent_organization_id
- structure: history.organization_id_structure
- appliedDate: history.app_datetime
- expiredDate: history.exp_datetime
- cpid: history.organization_id
- - target: phoneUser
- table: phoneuser
- history: phoneuserhistory
- group: phoneuserextlist
- unique: code
- attribute:
- id: history.phoneuser_id
- code: phoneuser_code
- name: phoneuser_name
- email: phoneuser_email
- whatsapp: phoneuser_mobile
- position: position
- emailOnOverBudget: sendemail_overbudget
- pin: history.phoneuser_pin
- extension: history.default_extension
- organization_id: history.organization_code
- costCenter_id: history.costcenter_code
- appliedDate: history.app_datetime
- expiredDate: history.exp_datetime
- budget__maxCost: history.max_cost
- budget__warnCost: history.warn_cost
- pbx_id: history.pbx_code
- pbx__list: group.pbx_list
- # corcosNormal_id: history.pbx_0_day
- # corcosReducing_id: history.pbx_1_day
- # corcosBlock_id: history.pbx_1_day
- # pbx__default: "01"
- - target: callTransaction
- table: calltransaction_20260127
- history: null
- group: null
- unique: raw_data
- attribute:
- direction: direction
- startOfCall: start_of_call
- duration: duration
- extension: ext_used
- pin: pin
- phoneUser_id: phoneuser_code
- extTransferFrom: ext_transfer_from
- extTransferTo: ext_transfer_to
- number: dialed_number
- callerNumber: caller_number
- accessNumber: access_number
- organization_id: organization_code
- costCenter_id: costcenter_code
- cost: cost_1
- service: cost_service
- tax: cost_tax1
- discount: cost_adjustment
- currency: currency
- pbx_id: pbx_code
- terminationCode: call_termination
- redirectReason: redirect_reason
- account_id: account_code
- trunk_id: trunk_code
- - target: webUser
- table: usersetup
- history: null
- group: null
- attribute:
- username: login_id
- password: login_password
- name: description
- phoneUser_id: phoneuser_code
- loginPin: used_pin
- lastTarget: pbx;corcos;provider;account;trunk;costCenter;organization;phoneUser;callTransaction;webUser
- lastAction: '2026-03-02 16:31:09'
|
