n my old project I used long id for table primary key, like ‘shop_id’ or ‘order_id’, but now I want to use just ‘id’ as alias for ‘shop_id’. How to add this to the model class only, not changing tables. After that I’d like to have something like this
I don’t think it’s possible to use aliases for column names in Yii. In PostgreSQL you could use a view with some rules defined so you could perform insert/update/delete statements on it that would update some other table. I don’t know if it’s possible in MySQL.
So check out the docs on how to create rules so the view can be updated. From version 9.3, PostgreSQL will allow simple views (selecting from one table) to be automatically updateable.