Well, I'll be using CFC's to create the components (i'm attempting to create the class structures, i'm just not sure how to store the data they represent). Also, There will be additional items related to content... Things such as images, events etc., all which should inherit the generic properties of content.
Does that help? Thanks! -----Original Message----- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 12:57 PM To: CF-Talk Subject: Re: I'm not sure if you are you trying to create an Object Oriented class structure, or a database design, so I'm a bit confused all around. But, based on my understanding... You have two tables: a content table and a document table. The content table contains a lot of generic information that relates to many different types of data. The document table is a specialized version of 'content'. I would put the ContentID in the Document table. If your content table doesn't relate to anything other than than document, then there may not be a need for two tables. At 12:00 PM 6/26/2002 -0400, you wrote: >Hello everyone, I'm wondering how I would represent the following case >in >a database. > >I have a general content class that contains generic information about >a >piece of content. I then have more specific classes such as document >(which will inherit the content class). How would I go about relating the >two in the physical database? So far classes look like so: > >-------------- >| content | >-------------- >| -contentID | >| -title >| -dateAdded | >| -etc... | >|------------| >| +add(s) | >| +etc... | >| | >-------------- > >-------------- >| document | >-------------- >| -documentID| >| -fileName | >| -fileSize | >| -etc... | >|------------| >| +upload(s) | >| +etc... | >| | >-------------- > >How do I represent the 'document' is a 'content' relationship in the >DB? >Would the content class contain the ID of the more specific class (ID of >the document)? > >And please excuse me if my ASCII art isn't up to par :) > >Thanks, > >Phillip >FAQ: http://www.thenetprofits.co.uk/coldfusion/faq >Archives: http://www.mail-archive.com/[email protected]/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Fax / Phone: 1-203-379-0773 -- My CFMX Book: <http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20> My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
