On 22 December 2011 19:25, bill hauck <[email protected]> wrote: > Alexander, thanks for the reply. However, I should have been more specific > in my need. > > I'd like the custom fields to be available for calculations. For instance, > custom fields for the project table might include dates for reviews or > expected and actual delivery dates from a supplier. They could be used to > calculate the difference between the promise and delivery. I'd like the > database to perform the calculations instead of the application.
Entity-Attribute-Value tables are what you need for this then : http://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model pretty simple to implement in dbix-class, add in a couple of custom relations (using functions to specify join logic) and robert's your mothers brother :) A -- Aaron J Trevena, BSc Hons http://www.aarontrevena.co.uk LAMP System Integration, Development and Consulting _______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
