Chris Kavanagh wrote: > Dear List, > > So tasks in my task management system include these fields: > > deadline (date - MySQL "date") > leadtime (number - MySQL "tinyint") > leadtime_type (minutes, hours, days, weeks - MySQL "varchar")
Slight aside: if you're using MySQL, why not use an ENUM column for leadtime_type? It'd take up less space, be just as readable, constrain the data that can be put in that column (a good thing), and, if all the other columns in the row are fixed width, allow the DBMS to search the table faster by letting it use fixed size tuples. K. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192524 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
