DataMapper And Tables Separated By Underscores?

[eluser]Vheissu[/eluser]
Ah, thank you. That makes perfect sense. Question about the foreign key though, you mention it's the table name underscore ID. So if I have a 2 tables one called "products" and another called "product_categories" and have a join table called "products_product_categories". What foreign key name would DataMapper expect for "product_categories"? Would it expect "product_categorie" as the foreign key in the join table or could I use "product_category"?

Are there times like above where you need to tell the model what the foreign key is for each table so when you create join tables it knows? Sorry about all of the questions, just trying to learn the best way to do things with DataMapper, it's excellent.