Using POSper/Developer guide/Database-Table descriptions/posper role permission

From Wikibooks, open books for an open world
< Using POSper‎ | Developer guide‎ | Database-Table descriptions
Jump to: navigation, search


This is an associative table connecting roles to permissions.

Column Name Data Type Null Allowed? Key? Comments
Role_name VARCHAR(255) No Foreign Key This points to the role being associated with a permission.
permissions_name VARCHAR(255) No Foreign Key This is the permission being associated with the role.