Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Table name

Old Column name

New column/table name

db_person


login_nameusername

pwdpassword_hash

pwd_changed_atpassword_changed

last_accesslast_accessed

locale_idlocale

time_zone_idtime_zone
db_project_state


allow_timeis_time_allowed

allow_clientis_client_initiable
db_process_type


allow_timeis_time_allowed
db_company


locale_idlocale

time_zone_idtime_zone
db_working_calendar


time_zone_idtime_zone
db_note


detaildescription
db_message


detaildescription

summaryname
db_baseline


summaryname

labour_costlabor_cost

non_labour_costnon_labor_cost
db_time_entry


user_commentscomments

hours_workedhours
db_project


summaryname

detaildescription

charging_modelbilling_type

project_category_idtype_id

plan_startplanned_start

plan_finishplanned_finish

percent_completeactual_percent_complete

fixed_costactual_fixed_cost

user_costactual_labor_cost

costactual_cost

c_expenseactual_costable_expense

nc_expenseactual_non_costable_expense

b_expenseactual_billable_expense

nb_expenseactual_non_billable_expense

est_workplanned_effort

est_labour_billingplanned_labor_revenue

est_labour_costplanned_labor_cost

est_non_labour_costplanned_non_labor_cost

est_fixed_costplanned_fixed_cost

b_time_moneyactual_billable_labor_amount

nb_time_moneyactual_non_billable_labor_amount

b_time_hoursactual_billable_labor_hours

nb_time_hoursactual_non_billable_labor_hours

c_time_hoursactual_costable_labor_hours

i_expenseinvoiced_expense

i_time_moneyinvoiced_labor_amount

i_time_hoursinvoiced_labor_hours
db_process


summaryname

detaildescription

assigned_to_idassignee_id

my_b_time_moneymy_actual_billable_labor_amount

my_b_time_hoursmy_actual_billable_labor_hours

my_nb_time_moneymy_actual_non_billable_labor_amount

my_nb_time_hoursmy_actual_non_billable_labor_hours

my_c_time_hoursmy_actual_costable_labor_hours

my_i_time_moneymy_invoiced_labor_amount

my_i_time_hoursmy_invoiced_labor_hours

my_labour_costmy_actual_labor_cost

my_costmy_actual_cost

requestor_nameexternal_requestor_name

requestor_emailexternal_requestor_email
db_task


can_fill_timeis_time_allowed

child_numbertree_index

schedule_type_valueschedule_type

constraint_type_valueconstraint_type

duration_typeduration_unit

work_timeplanned_effort

last_status_updatelast_status_updated

is_dep_solvedare_predecessor_constraints_satisfied

my_b_time_moneymy_actual_billable_labor_amount

my_b_time_hoursmy_actual_billable_labor_hours

my_nb_time_moneymy_actual_non_billable_labor_amount

my_nb_time_hoursmy_actual_non_billable_labor_hours

my_c_time_hoursmy_actual_costable_labor_hours

my_i_time_moneymy_invoiced_labor_amount

my_i_time_hoursmy_invoiced_labor_hours

my_labour_costmy_actual_labor_cost

my_costmy_actual_cost

ru_b_time_moneyru_actual_billable_labor_amount

ru_b_time_hoursru_actual_billable_labor_hours

ru_nb_time_moneyru_actual_non_billable_labor_amount

ru_nb_time_hoursru_actual_non_billable_labor_hours

ru_c_time_hoursru_actual_costable_labor_hours

ru_i_time_moneyru_invoiced_labor_amount

ru_i_time_hoursru_invoiced_labor_hours

ru_labour_costru_actual_labor_cost

ru_costru_actual_cost

my_b_expensemy_actual_billable_expense

my_nb_expensemy_actual_non_billable_expense

my_c_expensemy_actual_costable_expense

my_nc_expensemy_actual_non_costable_expense

my_i_expensemy_invoiced_expense

ru_b_expenseru_actual_billable_expense

ru_nb_expenseru_actual_non_billable_expense

ru_c_expenseru_actual_costable_expense

ru_nc_expenseru_actual_non_costable_expense

ru_i_expenseru_invoiced_expense

my_est_costmy_planned_cost

ru_est_costru_planned_cost

my_est_labour_costmy_planned_labor_cost

ru_est_labour_costru_planned_labor_cost

my_est_labour_billingmy_planned_labor_revenue

ru_est_labour_billingru_planned_labor_revenue

plan_startplanned_start

plan_finishplanned_finish

is_manualis_manually_scheduled

summaryname

detaildescription

percent_completeactual_percent_complete

est_non_labour_costplanned_non_labor_cost

fixed_costplanned_fixed_cost

local_keysn
db_assignment


unit_type_valueallocation_unit

unitsallocation_value

work_timeplanned_effort

est_costplanned_cost

est_labour_billingplanned_labor_revenue

labour_costactual_labor_cost

time_hoursactual_labor_hours

time_moneyactual_billable_labor_amount

submitted_hourssubmitted_labor_hours
db_expense


summaryname

approval_commentsapprover_comments
db_calendar_event


summaryname

detaildescription

owner_iduser_id
db_reminder


owner_iduser_id



db_project_category
db_project_type