Re: Database design question

2011-08-20 Thread WebbedIT
My gut instinct is screaming that you should not be creating multiple tables as that goes against database normalisation and results in duplicate tables, models, controllers and views. Why would a small add not have a value for size, location and user_id? - I would expect by the very fact you're c

Database design question

2011-08-19 Thread cronet
Hey, I've got a question concerning my database design. I would like to rewrite my website for small ads. There are two possible ways of creating my database: 1) Put all in one big table simplified example: id (1) name (2) address (3) zip (4) city (5) request_type (6) description (7) size (8)

Re: Database Design Question

2010-07-08 Thread duderion
cricket was right :D ty On Jul 8, 9:56 pm, duderion wrote: > hi guys, > > thanks alot for all your help > > i could solve the problem like > this:http://book.cakephp.org/view/851/Multiple-relations-to-the-same-model > > tx alot :D > duderion > > On 6 Jul., 19:42, bladefarm wrote: > > > > > hi p

Re: Database Design Question

2010-07-08 Thread duderion
hi guys, thanks alot for all your help i could solve the problem like this: http://book.cakephp.org/view/851/Multiple-relations-to-the-same-model tx alot :D duderion On 6 Jul., 19:42, bladefarm wrote: > hi pips! > i need ur help. > i'v got 2 models: prospects and programs. > prospects saves re

Re: Database Design Question

2010-07-07 Thread bladefarm
hi pips! i need ur help. i'v got 2 models: prospects and programs. prospects saves records of prospects for one or more programs while programs have records of the different disciplines offered. the prospects model looks like this: create table prospects( ... , ... , program_first_id int(11

Re: Database Design Question

2010-07-06 Thread cricket
On Tue, Jul 6, 2010 at 4:26 AM, dtemes wrote: > I would not use cascade delete on sender_id, once a mail is in your > box it's yours and it can contain important information that should > not be "stolen" from you even if the user that sent it is not there > any more. Good point! Check out the ne

Re: Database Design Question

2010-07-06 Thread dtemes
I would not use cascade delete on sender_id, once a mail is in your box it's yours and it can contain important information that should not be "stolen" from you even if the user that sent it is not there any more. On 5 jul, 20:52, cricket wrote: > On Mon, Jul 5, 2010 at 10:17 AM, duderion wrote:

Re: Database Design Question

2010-07-05 Thread cricket
On Mon, Jul 5, 2010 at 10:17 AM, duderion wrote: > Hi Guys > > i have a question about cake compatible database design: > > i have a table "mails" and a table "users" > > my table mail references 2 users from the users-table as Sender, > Recipient > > but then, i have 2 foreign keys in it, and i d

Database Design Question

2010-07-05 Thread duderion
Hi Guys i have a question about cake compatible database design: i have a table "mails" and a table "users" my table mail references 2 users from the users-table as Sender, Recipient but then, i have 2 foreign keys in it, and i dont know how to handle this properly (or even name it correctly)

Database design question

2008-02-14 Thread judouk
Hi group I'm sure I've asked this before but, to save time (yours and mine!), I'm going to simplify this. My company sends out engineers to work on customer sites. When they get to site, they can do one of many things. I have listed each action in a table of its own, each scheduled visit in a t