Hi Guys,
Let's suppose I have the following table:
create table companies
(
id int(11) not null auto_increment primary key,
# user's login and password
email varchar(100),
password varchar(100),
# basic information
company_name varchar(100),
contact_name varchar(100),
street varchar(100),
city varchar(100),
state varchar(7),
zip varchar(13),
phone varchar(25),
# user's company description
description text,
category_other text,
# localization
desired_zip varchar(7),
latitude dec(10,7),
longitude dec(10,7),
# user's personalized options
url varchar(200) not null unique,
logo_md5 varchar(32),
linked_url varchar(200),
color_bgrd varchar(16),
# content moderation (null if nothing, 1 for new, 2 for updates)
updates smallint,
banned boolean
);
Would you keep this as one table or would you split it into multiple
tables such as users, company localizations, personalized options and
moderation which would hold each the fields under each comment
together with a company_id? The first way of doing it is easier to
update because I would not have to update all the other linked tables.
But the other way of doing seems cleaner.
To summarize one table vs. many tables with one to one relations?
Thank you,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
