Table name | Old Column name | New column/table name |
|---|
| db_person |
|
|
| login_name | username |
| pwd | password_hash |
| pwd_changed_at | password_changed |
| last_access | last_accessed |
| locale_id | locale |
| time_zone_id | time_zone |
| db_project_state |
|
|
| allow_time | is_time_allowed |
| allow_client | is_client_initiable |
| db_process_type |
|
|
| allow_time | is_time_allowed |
| db_company |
|
|
| locale_id | locale |
| time_zone_id | time_zone |
| db_working_calendar |
|
|
| time_zone_id | time_zone |
| db_note |
|
|
| detail | description |
| db_message |
|
|
| detail | description |
| summary | name |
| db_baseline |
|
|
| summary | name |
| labour_cost | labor_cost |
| non_labour_cost | non_labor_cost |
| db_time_entry |
|
|
| user_comments | comments |
| hours_worked | hours |
| db_project |
|
|
| summary | name |
| detail | description |
| charging_model | billing_type |
| project_category_id | type_id |
| plan_start | planned_start |
| plan_finish | planned_finish |
| percent_complete | actual_percent_complete |
| fixed_cost | actual_fixed_cost |
| user_cost | actual_labor_cost |
| cost | actual_cost |
| c_expense | actual_costable_expense |
| nc_expense | actual_non_costable_expense |
| b_expense | actual_billable_expense |
| nb_expense | actual_non_billable_expense |
| est_work | planned_effort |
| est_labour_billing | planned_labor_revenue |
| est_labour_cost | planned_labor_cost |
| est_non_labour_cost | planned_non_labor_cost |
| est_fixed_cost | planned_fixed_cost |
| b_time_money | actual_billable_labor_amount |
| nb_time_money | actual_non_billable_labor_amount |
| b_time_hours | actual_billable_labor_hours |
| nb_time_hours | actual_non_billable_labor_hours |
| c_time_hours | actual_costable_labor_hours |
| i_expense | invoiced_expense |
| i_time_money | invoiced_labor_amount |
| i_time_hours | invoiced_labor_hours |
| db_process |
|
|
| summary | name |
| detail | description |
| assigned_to_id | assignee_id |
| my_b_time_money | my_actual_billable_labor_amount |
| my_b_time_hours | my_actual_billable_labor_hours |
| my_nb_time_money | my_actual_non_billable_labor_amount |
| my_nb_time_hours | my_actual_non_billable_labor_hours |
| my_c_time_hours | my_actual_costable_labor_hours |
| my_i_time_money | my_invoiced_labor_amount |
| my_i_time_hours | my_invoiced_labor_hours |
| my_labour_cost | my_actual_labor_cost |
| my_cost | my_actual_cost |
| requestor_name | external_requestor_name |
| requestor_email | external_requestor_email |
| db_task |
|
|
| can_fill_time | is_time_allowed |
| child_number | tree_index |
| schedule_type_value | schedule_type |
| constraint_type_value | constraint_type |
| duration_type | duration_unit |
| work_time | planned_effort |
| last_status_update | last_status_updated |
| is_dep_solved | are_predecessor_constraints_satisfied |
| my_b_time_money | my_actual_billable_labor_amount |
| my_b_time_hours | my_actual_billable_labor_hours |
| my_nb_time_money | my_actual_non_billable_labor_amount |
| my_nb_time_hours | my_actual_non_billable_labor_hours |
| my_c_time_hours | my_actual_costable_labor_hours |
| my_i_time_money | my_invoiced_labor_amount |
| my_i_time_hours | my_invoiced_labor_hours |
| my_labour_cost | my_actual_labor_cost |
| my_cost | my_actual_cost |
| ru_b_time_money | ru_actual_billable_labor_amount |
| ru_b_time_hours | ru_actual_billable_labor_hours |
| ru_nb_time_money | ru_actual_non_billable_labor_amount |
| ru_nb_time_hours | ru_actual_non_billable_labor_hours |
| ru_c_time_hours | ru_actual_costable_labor_hours |
| ru_i_time_money | ru_invoiced_labor_amount |
| ru_i_time_hours | ru_invoiced_labor_hours |
| ru_labour_cost | ru_actual_labor_cost |
| ru_cost | ru_actual_cost |
| my_b_expense | my_actual_billable_expense |
| my_nb_expense | my_actual_non_billable_expense |
| my_c_expense | my_actual_costable_expense |
| my_nc_expense | my_actual_non_costable_expense |
| my_i_expense | my_invoiced_expense |
| ru_b_expense | ru_actual_billable_expense |
| ru_nb_expense | ru_actual_non_billable_expense |
| ru_c_expense | ru_actual_costable_expense |
| ru_nc_expense | ru_actual_non_costable_expense |
| ru_i_expense | ru_invoiced_expense |
| my_est_cost | my_planned_cost |
| ru_est_cost | ru_planned_cost |
| my_est_labour_cost | my_planned_labor_cost |
| ru_est_labour_cost | ru_planned_labor_cost |
| my_est_labour_billing | my_planned_labor_revenue |
| ru_est_labour_billing | ru_planned_labor_revenue |
| plan_start | planned_start |
| plan_finish | planned_finish |
| is_manual | is_manually_scheduled |
| summary | name |
| detail | description |
| percent_complete | actual_percent_complete |
| est_non_labour_cost | planned_non_labor_cost |
| fixed_cost | planned_fixed_cost |
| local_key | sn |
| db_assignment |
|
|
| unit_type_value | allocation_unit |
| units | allocation_value |
| work_time | planned_effort |
| est_cost | planned_cost |
| est_labour_billing | planned_labor_revenue |
| labour_cost | actual_labor_cost |
| time_hours | actual_labor_hours |
| time_money | actual_billable_labor_amount |
| submitted_hours | submitted_labor_hours |
| db_expense |
|
|
| summary | name |
| approval_comments | approver_comments |
| db_calendar_event |
|
|
| summary | name |
| detail | description |
| owner_id | user_id |
| db_reminder |
|
|
| owner_id | user_id |
|
|
|
| db_project_category |
| db_project_type |
|
|
|