**Problem:** I am trying to create a foreign key on a column to a view. The view was made as a `SELECT *` from another schema with a primary key constraint on the column I am using. 

Is this possible? If this is, is this considered bad practice? If this isn't, is there an alternative? It doesn't seem to be possible through phpmyadmin, and I can't create a primary key on a view.

**Reason why:** I used two schemas for two different applications, but there is a 'user' table (not necessarily users in the mysql.user table) in one schema that I would like to reuse in the schema without granting permission to the other schema. This is why I used a view.