Analyze old data models
Analyze the tables on the old database and Normalize it if it isn't
Blueprint information
- Status:
- Complete
- Approver:
- Nhomar - Vauxoo
- Priority:
- Essential
- Drafter:
- Israel Fermin Montilla
- Direction:
- Approved
- Assignee:
- Israel Fermin Montilla
- Definition:
- Approved
- Series goal:
- None
- Implementation:
- Implemented
- Milestone target:
- None
- Started by
- Israel Fermin Montilla
- Completed by
- Israel Fermin Montilla
Related branches
Related bugs
Sprints
Whiteboard
Old database Schema was analyzed and some tables were splited into two new entities due to normalization issues and to avoid data duplication.
Some tables were migrated to OpenObject native models and extended with aditional information to support all the data on the old database
Cliente --> res.partner
Viatico --> hr.expense
Empleado --> res.users
Preventivo --> project.project
Extended models without equivalent on old database:
sale.order
account.invoice
And all the fields about Zones or Location were added to the model:
res.partner.address
The following new models were created
policy.
policy.
policy.equipment: to store all the equipment directly related data
project.
policy.
tech.team: to store data about the teams of technicians that provides the support and maintenance services
tech.team.contract: to store thata about the tech teams contracts
policy.
policy.contract: to store information about the contracts with clients (policies)
policy.vehicle: stores data about the vehicles that the company owns
Work Items
Dependency tree
* Blueprints in grey have been implemented.