to add the following functions to Redmine, to track and administer equipment issues:
1. Add a new field in the standard "Issue" form for "Equipment ID".
2. The Equipment ID will be queried from "Equipment" table (new table in Redmine) to display the Description of the eqipment.
3. An Equipment Administration form/page to list/edit/add/delete Equipment information, show equipment "History"/audit trail, define drop down values for each equipment type.
4. Equipments are assigned to Projects(Customers) and equipment to Customeris one-to-one relationship, so "Equipment ID" field should be validated as such during an issue update.
5. Equipments can be transferred between Customers and transfers should not invalidate/affect older issues' "Equipment ID" field value.