Mapping object relations - Foreign key associations - One-to-One.php 888 Bytes
Newer Older
doctrine's avatar
doctrine committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
<?php
class User extends Doctrine_Record {
    public function setUp() {
        $this->hasOne("Address","Address.user_id");
        $this->ownsOne("Email","User.email_id");
        $this->ownsMany("Phonenumber","Phonenumber.user_id");
    }
    public function setTableDefition() {
        $this->hasColumn("name","string",50);
        $this->hasColumn("loginname","string",20);
        $this->hasColumn("password","string",16);

        // foreign key column for email ID
        $this->hasColumn("email_id","integer");
    }
}
class Email extends Doctrine_Record {
    public function setTableDefinition() {
        $this->hasColumn("address","string",150);
    }
}
class Address extends Doctrine_Record { 
    public function setTableDefinition() {
        $this->hasColumn("street","string",50);
        $this->hasColumn("user_id","integer");
    }
} 
?>