//todolist table definition public function setTableDefinition() { $this->setTableName('todolist'); $this->hasColumn('name', 'string', 30, array ()); $this->hasColumn('description', 'string', 100, array ()); $this->hasColumn('user_id', 'integer', 10, array ()); } public function setUp() { $this->hasMany('Task as Tasks', 'Task.todolist_id' ); $this->hasOne('User as User', 'ToDoList.user_id', array('foreign' => 'id' )); } //SQL create table output CREATE TABLE todolist (id BIGINT UNSIGNED AUTO_INCREMENT, name VARCHAR(30), description VARCHAR(100), user_id BIGINT, FOREIGN KEY (id) REFERENCES tasks(todolist_id), FOREIGN KEY (user_id) REFERENCES user(id), PRIMARY KEY(id)) ENGINE = INNODB