Project: Okul Database · Hub: Okul Database — Reference
Reference: Roles & Permissions
Spatie RBAC package. Tables: roles, permissions, model_has_roles, model_has_permissions, role_has_permissions.
System Roles
| Role Slug | Display Name | Description |
|---|
super-admin | Süper Admin | Full system access |
it | IT | Technical staff |
editor | Editör | Content management |
sales | Satış | Sales team |
data | Data | Data/analytics team |
finance | Finans | Finance team |
py | Portföy | Portfolio management |
intern | Stajyer | Intern |
agent | Çağrı | Call center agent |
sales-support | Satış Destek | Sales support |
Permissions by Category
School Management
| Permission | Description |
|---|
view-school | View school records |
add-school | Create schools |
edit-school | Edit school data |
delete-school | Delete schools |
view-school-product | View school’s product/subscription |
view-school-interactions | View CRM interactions |
add-school-interactions | Log new interactions |
edit-school-interactions | Edit interactions |
delete-school-interactions | Delete interactions |
Lead Management
| Permission | Description |
|---|
view-lead | View leads |
edit-lead | Edit lead data |
add-lead | Create leads |
delete-lead | Delete leads |
view-lead-pool-form | View lead pool forms |
add-lead-pool-form | Add lead pool forms |
edit-lead-pool-form | Edit lead pool forms |
show-lead-pool-form | Show lead pool form detail |
Customer & Agreement Management
| Permission | Description |
|---|
view-customer-agreement | View agreements |
add-customer-agreement | Create agreements |
edit-customer-agreement | Edit agreements |
delete-customer-agreement | Delete agreements |
change-status-customer-agreement | Change agreement status |
Payment & Finance
| Permission | Description |
|---|
view-payment | View payments |
add-payment | Create payments |
edit-payment | Edit payments |
delete-payment | Delete payments |
repeat-payment | Re-trigger payment |
view-sale-statistic | View sales statistics |
User Management
| Permission | Description |
|---|
view-user | View users |
add-user | Create users |
edit-user | Edit users |
delete-user | Delete users |
Content Management
| Permission | Description |
|---|
view-article, add-article, edit-article, delete-article | Article CRUD |
view-gallery, add-gallery, edit-gallery, delete-gallery | Gallery CRUD |
view-announcement, add-announcement, edit-announcement | Announcement CRUD |
Communication & Consent
| Permission | Description |
|---|
send-mail | Send emails |
send-iys | Submit to IYS (consent registry) |
add-iys, view-iys | IYS management |
okulcomtr-mail | okul.com.tr branded email |
product-mail | Product update emails |
System Administration
| Permission | Description |
|---|
view-role, add-role, edit-role, delete-role | Role management |
view-permission, add-permission, edit-permission, delete-permission | Permission management |
view-sale-support | Sales support access |
view-appointment-calendar | Appointment calendar |
Customer User Roles (B2B Portal)
These are NOT Spatie roles — they live in the configs table:
type = 'customer_user_role'
| item_id | item_value | Description |
|---|
| 1 | Panel Yöneticisi | B2B panel admin — full access |
| 2 | Panel Kullanıcısı | B2B panel user — limited access |
Customer User Titles
type = 'customer_user_title' — 37 entries total, sample:
| item_id | item_value | English |
|---|
| 1 | Firma Sahibi | Business Owner |
| 2 | Satış Müdürü | Sales Manager |
| 3 | İşletme Müdürü | Operations Manager |
| 6 | Genel Müdür | General Manager |
| 12 | Yönetici | Manager |
| 22 | Finans Müdürü | Finance Manager |
| 37 | Diğer | Other |