Database naming conventions

[eluser]garycocs[/eluser]
Hi jedd thanks for the reply, if you want a better understanding of the DB you could have a look at www.ratemypub.ie for an understanding.

Basically my tables are

county
pub
rate
pic
.....

every pub is in a county so I use (I guess a pseudo??) foreign key pub_id, not sure how to set up the hardcoded foreign key????

so on the home page etc I display counties and maybe a pub count from pubs on the pub page i display pub info ratings form rate and pics from pic etc.

when adding a rating I just insert a new row into rates etc.

This make sense?