I am currently thinking about using yii for a relatively big web project.
The problem is that the business logic requires to have a login for "normal" users, partner companies and administrators. As it would be necessary to access their individual data within the logins, I thought it would be best to have a base class (AbstractUser) that implements IdentityInterface and derive from it the subclasses User, Company and Administrator.
The only (good) way I know of to represent this within a relational database (we are using MySQL) would be table per type inheritance. Is it possible to use this with yii’s active record somehow? Maybe through an extension?
If not, what would be the best way do solve this issue? (I don’t know a NoSQL language right now, maybe that would be an option? How easy/reliable are those for big websites?)