Re: Db Design for my first Cake App

Thanks martin!

On Oct 30, 8:34 pm, "martin.westin...@gmail.com"
<martin.westin...@gmail.com> wrote:
> At a glance it looks pretty good.
>
> A few points and thoughts... most of them not necessary but might be
> good to have.
>
> • created_on and updated_on should loose the "_on" part to match Cakes
> conventions and be filled automatically.
> • You could add created and updated to comments and users as well.
> • You may want a boolean for the users "activated" or "blocked" or
> whatever you prefer. That way you can easily block users without
> actually deleting them and also handle email-verification (like every
> website in the world does)
> • You may want to have all user data (even those not registered) in
> the users table. Or in another central table for email and created_by
> (= name). The email might be a good unique value for such a table.
> That table would then be linked to users, pois and comments.
>
> happy baking!
> /Martin
>
> On Oct 30, 3:13 am, pgraju <prashant.g.r...@gmail.com> wrote:
>
> > Hi all,
>
> > I'm trying to create a map mashup using CakePHP for my first Web App
> > with Cake :) But I'm just afraid that I'm not structuring my database
> > correctly...
>
> > The idea: A simple mashup with google maps which allows people to
> > submit/search points of interest on a map and click on the pointers
> > for address information and to view/add comments. Users don't have to
> > register but there is an option available if they want to.
>
> > My db tables so far:
>
> > ---------------------------------
> > pois (point of interests)
> > ---------------------------------
> > id
> > name
> > address1
> > address2
> > locality
> > state
> > country
> > lng
> > lat
> > ip_address (should I log this?)
> > user_id
> > comment_id
> > created_by (this is filled out by the user if they do not want to
> > registered)
> > email_address (this is filled out by the user if they do not want to
> > registered)
> > created_on
> > updated_on
>
> > ---------------------------------
> > users
> > ---------------------------------
> > id
> > username
> > password
> > firstname
> > lastname
> > email_address
>
> > ---------------------------------
> > comments
> > ---------------------------------
> > id
> > title
> > content
> > created_by (this is filled out by the user if they do not want to
> > registered)
> > email_address (this is filled out by the user if they do not want to
> > registered)
> > ip_address (should I log this?)
> > user_id
>
> > Have I gone about the right way doing this for a CakePHP app? If not
> > do you mind shedding some light?

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---