|
|
Posted by Frankly on 10/03/23 11:50
"J.O. Aho" <user@example.net> wrote in message
news:4fglcpF1i90ndU2@individual.net...
> J.O. Aho wrote:
>
>> Your RelationPictureApartmentBuilding table is lacking completely a
>> relation to the image, it's quite useless, the only relations it has is
>> building-apartment, the same relation is hold in the picture table I done
>> and data about the images.
>
> I hope you don't take offense of the strong wording here, but your ImageID
> don't relate anywhere.
>
>
>
> //Aho
no offense taken but i do feel bad. this is my first time building a
database. Before this i did build a flat file of about 8 columns. i know
that has nothing to do with my putting varchars where I should have known
and do know to put INT - i have no excuse and can understand your thinking
HTH. i think i put varchar when i thought it was going to be Yes or No, but
also be to honest I am a bit confused because i thought as long as you wont
be using numbers for calculations varchar can be used. not questioning you
at all, I will make them INT.
i wish i didnt bother looking into all that MS and Coldfusion stuff. I
should have just jumped in and did this when that tutorial was fresh in my
head. Still is no excuse for some of the mistakes I have been making.
Frank
Navigation:
[Reply to this message]
|