var $has_one = array('country', 'theme', 'style', 'creator' => array( 'class' => 'user', 'other_field' => 'created_account'), 'editor' => array( 'class' => 'user', 'other_field' => 'edited_account'), ); var $has_many = array('user', 'image', 'client', 'page');
var $has_many = array('account', 'edited_account' => array( 'class' => 'account', 'other_field' => 'editor' ), 'created_account' => array( 'class' => 'account', 'other_field' => 'creator' ) ); var $has_one = array();
CREATE TABLE `accounts_users` ( `id` INTEGER unsigned AUTO_INCREMENT, `user_id` INTEGER unsigned, `account_id` INTEGER unsigned, `creator_id` INTEGER unsigned, `created_account_id` INTEGER unsigned, `editor_id` INTEGER unsigned, `edited_account_id` INTEGER unsigned, PRIMARY KEY (`id`) ) ENGINE=MyISAM;