I was looking for an opinion on the actual table structure. :-) How should i build the data set? Is my second example ok? The first is the long version but i wanted to put together all the common fields to both types of "sites" and then (maybe) build tables to accomodate the specific fields so there are no empty columns on the table if i put everything in the same table.
> But i seem to be missing something. How can i have this in a way that its > easy to list only "arqueology sites" for example. I feel the solution is > simple enough, even for me, but its eluding me. Any help in the right > direction would be very appreciated.
You mean archaeological sites that are not also natural sites?
| SELECT * FROM site_arqeuology | WHERE id_site NOT IN | (SELECT id_site FROM site_natural);
There are numerous other ways to do this, i. e., with "LEFT JOIN", "EXCEPT", etc.