Data Migration v2 - Memberships

[chicinho]

Column "Contract Name"

• use the name to select the id from the plans table
• map the id to the plan_id

Column "Type"

• can be ignored

Column "Name"

• use the name to select the id for the user from the users table
• map the id to the user_id

Column "Status"

• maps to status
  • Started -> active
  • Ended -> inactive

Column "Open Revenue"
Column "Number of Classes"
Column "Used Classes"
Column "Duration"
Column "Payment Cycle"

• can be ignored

Column "Description"

• maps to note

Column "Start Date"

• maps to starts_at
• date format must be adjusted

Column "End Date"

• maps to ends_at
• date format must be adjusted

Column "box_id"

• CF Westpack: 3

Column "created_at"
Column "updated_at"

• use the import date