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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
