[thelist] Tricky Database Question

Sam Richardson sam.richardson at outwide.co.nz
Thu Jul 17 18:56:48 CDT 2003


Hmm, that's what I figured, but what data type is the DataEntered table?

----- Original Message ----- 
From: "Anthony Baratta" <Anthony at Baratta.com>
To: "Sam Richardson" <sam.richardson at outwide.co.nz>;
<thelist at lists.evolt.org>
Sent: Friday, July 18, 2003 10:39 AM
Subject: Re: [thelist] Tricky Database Question


> At 03:11 PM 7/17/2003, Sam Richardson wrote:
>
> >My question is: How do I store the data from the attributes?
>
> Here's my whack at that:
>
> Table: Breed_Attributes_Main
>          AttributeID
>          BreedID
>          Name/Label
>          Short Description
>          Long Description
>          DisplayTypeID
>
> Table: Breed_Attributes_Detail
>          DetailID
>          AttributeID
>          Name/Label
>
> Table: HTML_Display_Type
>          DisplayTypeID
>          Name/Label
>
> Another option would be to drop the BreedID from the Breed_Attributes
table
> and have a Cross Walk table that can do a Many to Many relationship
between
> the Breeds and the Breed_Attributes. This way if there are attributes that
> should be applied to multiple breeds you can do that with out having to
> enter the same attributes more than once.
>
> Then to store the data entered for each breed attribute you could just
have
> a table like this:
>
> Table: Selected_Breed_Attributues
>          AnimalID
>          DetailID
>          DataEntered
>
> Or something like that. ;-)
>
> -- 
> Anthony Baratta
> President
> Keyboard Jockeys
>
> "Conformity is the refuge of the unimaginative."
>
> -- 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> Evolt.org conference in London, July 25-27 2003.  Register today at
http://evolt.org.uk
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>



More information about the thelist mailing list