I successfully created a PropertyUseTypeManage page, I also altered the existing IconManage page to route all requests through the systemCoordinator. Added remove icon/Put functions, that deactivate each icon/put respectively. Added columns in the PropertyUseType and Icon tables for boolean Active. All foreign keys to the icon or put tables are automatically added to the checklist as long as the current variable names are the same(icon_iconid, usetype_typeid).
I recommend the decommission or refactoring of table cecasestatusicon as it lists as a primary key for both columns.
Might want to think about renameing the usetype_typeid column in the property table. Please note all the contingent sql statements are in SystemIntegrator.java
I successfully created a PropertyUseTypeManage page, I also altered the existing IconManage page to route all requests through the systemCoordinator. Added remove icon/Put functions, that deactivate each icon/put respectively. Added columns in the PropertyUseType and Icon tables for boolean Active. All foreign keys to the icon or put tables are automatically added to the checklist as long as the current variable names are the same(icon_iconid, usetype_typeid).
I recommend the decommission or refactoring of table cecasestatusicon as it lists as a primary key for both columns.
Might want to think about renameing the usetype_typeid column in the property table. Please note all the contingent sql statements are in SystemIntegrator.java