Re: MYSQL Table Columns HELP..
Posted: Wed Oct 15, 2008 2:09 pm
thnq..
yep i got an idea,,
so i decided to use as many columns as i need for my table.(columns<25)
if i do like this, i will not be maintaining relationship wid the rest of tables..is this okay?
only users and their UNIQUE ID's table will be related..
will it create any new problems in maintaining 25 columns and 150 tables around?
yes u r rite, there is no use of splitting up the columns..this will create problem during data entry for administrator
.as he has to enter ID some 30-40 times.,looks awkward..
thnx mate for ur valuable suggestions..
so i'm now clear with wht u've suggested me..
my last query:
i.will it create any new problems in maintaining 25 columns and 150 tables around?
ii. will it be a good database practise if only fewer tables of my DB contain 1-1 or many-many relations?
Many Thanx mate,
pavan.p
yep i got an idea,,
so i decided to use as many columns as i need for my table.(columns<25)
if i do like this, i will not be maintaining relationship wid the rest of tables..is this okay?
only users and their UNIQUE ID's table will be related..
will it create any new problems in maintaining 25 columns and 150 tables around?
yes u r rite, there is no use of splitting up the columns..this will create problem during data entry for administrator
thnx mate for ur valuable suggestions..
so i'm now clear with wht u've suggested me..
my last query:
i.will it create any new problems in maintaining 25 columns and 150 tables around?
ii. will it be a good database practise if only fewer tables of my DB contain 1-1 or many-many relations?
Many Thanx mate,
pavan.p