DataMapper ORM v1.8.2

[eluser]Jacob F.[/eluser]
I've got a table materials with fields named publisher_id & admin_id. These fields both reference `users`.`id` (so I can't name them both user_id). DataMapper seems to be convinced there is a relational table (there isn't).

My models look like this:

Code:

class Material extends DataMapper {

var $has_one = array(
  "user" => array(
   "class" => "user",
   "join_self_as" => "admin"
  )
);

}//Material{}

Code:

class User extends DataMapper {

var $has_many = array(
  "material" => array(
   "class" => "material"
  )
);

}//User{}

I've tried every combination of join_self_as, join_field, and join_other_as and I can't get it to accept there is a 1:many relationship :/ How do I tell DataMapper that user_id is named admin_id & publisher_id and that there is a 1:many (I would have expected using $has_many and $has_one to be the end-all-be-all in dictating the relationship type).

On a related note, in the documentation, if you could provide examples of the tables to which you reference (like on the Advanced Relationships page) that would be immensely helpful so we don't have to imagine what tables looks like). Also, it gets a little confusing when 3-4 different things are named "book".

Thanks!