Wednesday, October 29, 2008

Db Design for my first Cake App

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
-~----------~----~----~----~------~----~------~--~---

No comments: