staff_permissions
Individual permissions for staff users
Колонки
| Колонка |
Тип |
Nullable |
Default |
Описание |
| id 🔑 |
uuid |
NOT NULL |
uuid_generate_v4() |
|
| staff_user_id |
uuid |
NOT NULL |
|
→ staff_users(id) |
| permission |
character varying(100) |
NOT NULL |
|
Permission in format "entity:action" (e.g., organizations:create) |
| created_at |
timestamp without time zone |
NULL |
CURRENT_TIMESTAMP |
|
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя |
Определение |
| idx_staff_permissions_permission |
CREATE INDEX idx_staff_permissions_permission ON public.staff_permissions USI... |
| idx_staff_permissions_staff_user_id |
CREATE INDEX idx_staff_permissions_staff_user_id ON public.staff_permissions ... |
| staff_permissions_pkey |
CREATE UNIQUE INDEX staff_permissions_pkey ON public.staff_permissions USING ... |
| staff_permissions_staff_user_id_permission_key |
CREATE UNIQUE INDEX staff_permissions_staff_user_id_permission_key ON public.... |
Foreign Keys