Fields (4)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | NULL | auto_increment |
| roleID | int(11) | NO | MUL | NULL | |
| resourceID | int(11) | YES | MUL | NULL | |
| privilegeID | int(11) | YES | MUL | NULL |
Indexes (4)
| Name | Columns | Unique |
|---|---|---|
| PRIMARY | id | Yes |
| privilegeID | privilegeID | No |
| resourceID | resourceID | No |
| roleID | roleID,resourceID,privilegeID | Yes |