admin_access
Purpose: Used to grant school-level access permissions to staff with 'Admin' rights.
Joins: users and schools tables.
Field | Type | Purpose |
---|---|---|
adminID | int(11) | Primary Key – auto increment. |
userID | int(10) unsigned | ID of the member of staff granting 'Admin' access to. |
schools_id | int(11) | The School ID that you want to grant access to. |