Analyze old data models

Registered by Israel Fermin Montilla

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

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.equipment.type: to store the distinct equipment types
policy.equipment.service.type: to store the distinct types of services that an A/C Equipment can provide
policy.equipment: to store all the equipment directly related data
project.project.type: to store the distinct types of preventive maintenance projects that the company provides
policy.contract.coverage: to store de distinct coverages that the policy covers
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.payment.type: to store the distinct allowed payment types
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.

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.