Re: table structure problem

2010-07-12 Thread Miguel Vaz
Hi, Shawn, Thanks for replying. What i meant is that i would also like to create a table with "site types", where i would have a listing of possible sites, like arqueology, natural, etc. and maybe use it to redirect the queries instead of having to hardcode the table name when i need to list a spe

Re: table structure problem

2010-07-12 Thread Shawn Green (MySQL)
On 7/8/2010 11:29 PM, Miguel Vaz wrote: Hi, I am having some uncertainty while designing the following structure: I have two sets of data: * arqueology sites (can be natural): id name description id_category id_period x y * natural sites (can be arqueological also - bear with me -, so there