http://www.mattwoodward.com/blog/index.cfm?event=showEntry&entryID=0192E BB1-ADFC-93C9-4737472E34E917AD
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phillip Senn Sent: Thursday, May 17, 2007 4:02 PM To: cfcdev@cfczone.org Subject: [CFCDEV] Master/Detail I'm trying to ask this in as generic a fashion as I can. If you have 1 order with many line items, then that is known as an Order Header/Order Detail in many lines of work. Q: If you have an Order Header/Order Detail, what do you name the tables? 1. OrderHeader, OrderDetail 2. tblOrderHeader, tblOrderDetail 3. tblOrders, tblOrderDetail 4. tblOrder, tblOrderDetail 5. lcf_Order, lcf_Purchase (from www.Lynda.com Learning ColdFusion class) But here's the REAL question: Q: Let's say you decide upon #4. How do you define the components? 1. OrderDAO.cfc, OrderBean.cfc, OrderGateway.cfc, OrderDetailDAO.cfc, OrderDetailBean.cfc, OrderDetailGateway.cfc (Tables relate directly to components) 2. OrderDAO.cfc, OrderBean.cfc, OrderGateway.cfc (The OrderBean is contains everything known about the Order (Header and Detail) You are subscribed to cfcdev. To unsubscribe, please follow the instructions at http://www.cfczone.org/listserv.cfm CFCDev is supported by: Katapult Media, Inc. We are cool code geeks looking for fun projects to rock! www.katapultmedia.com An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org You are subscribed to cfcdev. To unsubscribe, please follow the instructions at http://www.cfczone.org/listserv.cfm CFCDev is supported by: Katapult Media, Inc. We are cool code geeks looking for fun projects to rock! www.katapultmedia.com An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org