Thanks martin! On Oct 30, 8:34 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
