One to Many Database field uniqueness rule in YII

Asked May 15 '12 at 15:31

Active May 15 '12 at 15:31

Viewed 299 times

I have a table. Lets say we have a userid of 23, which corresponds to various roles that the user might hold: scientist, researcher and developer. ID's respectively: 2,8,9.

enter image description here

So, userid can be duplicated but roleid as it relates to userid is unique. Note that if there are more then 1 users I want it so that roles can be duplicated (unique to the user, duplicated across different users) such as: enter image description here

In Yii, under rules of the model you can create a rule to do uniqueness. I want the RoleID field to be unique for that user. So if user x has role y, it won't add role y again (creating duplicates).

here's the schema:

enter image description here

asked May 15 '12 at 15:31

Snow_Mac

5,727
17
54
80

1

i think [this answer](http://stackoverflow.com/a/10435307/720508) will help you – bool.dev May 15 '12 at 15:42
It did. Should we mark for deletion? – Snow_Mac May 15 '12 at 16:26
1

possible duplicate of [Yii validation rule - unique](http://stackoverflow.com/questions/10432591/yii-validation-rule-unique) – Snow_Mac May 15 '12 at 16:38

One to Many Database field uniqueness rule in YII

0 Answers0