phpcms模型字段关联

-- users 表
CREATE TABLE users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(50) NOT NULL
);

-- articles 表
CREATE TABLE articles (
    id INT PRIMARY KEY AUTO_INCREMENT,
    title VARCHAR(100) NOT NULL,
    content TEXT,
    user_id INT,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

// User 模型
class UserModel extends Model {
    public $tableName = 'users';

    public function getArticles() {
        return $this->hasMany(ArticleModel::class, 'user_id', 'id');
    }
}

// Article 模型
class ArticleModel extends Model {
    public $tableName = 'articles';

    public function getUser() {
        return $this->hasOne(UserModel::class, 'id', 'user_id');
    }
}

try {
    $this->db->beginTransaction();
    // 更新用户信息
    $user = UserModel::find($userId);
    $user->username = 'new_username';
    $user->save();

    // 更新文章信息
    $article = ArticleModel::find($articleId);
    $article->title = 'new_title';
    $article->save();

    $this->db->commit();
} catch (Exception $e) {
    $this->db->rollBack();
    throw $e;
}

-- 在 user_id 字段上创建索引
CREATE INDEX idx_user_id ON articles(user_id);