Sample Header Ad - 728x90

Design database table for property listing

0 votes
1 answer
194 views
I want to design a database for a listing website, this is the first time I design the database, so I am not sure if I in the correct path. Here is the fields that needed in a listing, 1. title - Character 2. pub_date -Timestamp 3. modi_date -Timestamp 4. ex_date - Timestamp 5. desc - Character 6. thumb - Character 7. office_no - Integer 8. mobile_no - Integer 9. email - Character 10. web - Character 11. status - Character 12. state - Character 13. city - Character 14. address - Character 15. postcode - Character 16. lat - float 17. lng - float The lat (latitude) and lng (longitude) are used for searching, eg, searching nearby listing by comparing the lat and lng. So these fields will be queried often. My question is should I separate the *lat* and *lng* into another table (normalization) since these fields will be query a lot. Or I just leave it in one table.
Asked by dev-jim (101 rep)
Sep 16, 2015, 06:28 PM
Last activity: Jun 21, 2025, 11:04 AM