Not sure how someone can intelligently comment on your table structure
when you haven't given any details of the data you are storing. In my
experience, the fact that you have 75 fields in your table is a strong
indicator that your data is not normalized. If that is the case you
tables are
Subject: Re: Help with Table structure
Not sure how someone can intelligently comment on your table structure
when you haven't given any details of the data you are storing. In my
experience, the fact that you have 75 fields in your table is a strong
indicator that your data is not normalized
Hi,
I have a table containing 75 fields with a primary index and index set on 5
other fields. Everything is working fine so far as the table contains only
about 80,000 records. I expect these records to reach 500,000 by end of
september.
I would like to know:
- if the number of records will
What you have so far looks good, but what I learned from doing my ecomm
project was that it is beneficial to make a separate table for anything
and everything that you might have more than one of... Addresses, phone
numbers, and email addresses are all great candidates for breaking out
into
Justin Smith mailto:[EMAIL PROTECTED]
on Tuesday, October 12, 2004 8:48 AM said:
What you have so far looks good, but what I learned from doing my
ecomm project was that it is beneficial to make a separate table for
anything and everything that you might have more than one of...
Chris W. Parker wrote:
interesting you say that because i was going to do this same thing
except not as completely as i probably should (which i think is what you
are suggesting). what i mean is, my extra table of addresses was going
to be merely shipping addresses for the customer and nothing
You were wondering about a separate phone number table?
Most phone numbers (esp. cell phones and home phones) belong to only one
person. If that were your only data, then creating a new table may not
make sense. However, dozens of people can share a common number (like in a
large office. Each
Also International Numbers
Have you seen any address books accomodating 3 digit Country Code??
Martin-
- Original Message -
From: [EMAIL PROTECTED]
To: Chris W. Parker [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 12, 2004 1:20 PM
Subject: RE: help with table structure
hello,
i'm just looking for some examples of a customer table that some of you
are using for your ecomm sites (or any site that would need a customer
table).
here is mine so far:
(horrible wrapping to follow...)
mysql describe customers;