[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