[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
Yes it relates on ids. I don't understand why that is a question. As it says in the documentation, every table must have a primary key named id. What else would you join two tables on?

Your join table is wrong in your example. It should be:

address_users
id
address_id
user_id

This will be used to relate users to address. The id columns must all be automatically generated (autonum or serial, for example), as the existence of an id is what allows DM to determine whether to insert or update.

There really isn't two sets of documentation. I've taken the base DataMapper and added a few features. The only really important thing (regarding databases) that changed was that I allow 1-to-N relationships to use in-table relationships (In the example above, assume addresses can only have one user. Then you could include user_id on the addresses table directly.). If you don't use that or the more complex many-to-many relationships, just use DataMapper as it is.

I don't have time to update or rewrite the manual. I only offer DMZ as a benefit to the community, since many have asked for specific features (that I myself use).