module_roles
Роли пользователей в модулях (callbox, suo)
Колонки
| Колонка | Тип | Nullable | Default | Описание |
|---|---|---|---|---|
| id 🔑 | integer(32) | NOT NULL | nextval('module_roles_id_se... | |
| user_email | character varying(255) | NOT NULL | ||
| organization_id | integer(32) | NOT NULL | ||
| module | character varying(50) | NOT NULL | ||
| role | character varying(50) | NOT NULL | ||
| is_active | boolean | NOT NULL | true | |
| created_at | timestamp with time zone | NOT NULL | now() | |
| created_by | character varying(255) | NULL |
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя | Определение |
|---|---|
| ix_module_roles_module | CREATE INDEX ix_module_roles_module ON public.module_roles USING btree (module) |
| ix_module_roles_organization_id | CREATE INDEX ix_module_roles_organization_id ON public.module_roles USING btr... |
| ix_module_roles_user_email | CREATE INDEX ix_module_roles_user_email ON public.module_roles USING btree (u... |
| module_roles_pkey | CREATE UNIQUE INDEX module_roles_pkey ON public.module_roles USING btree (id) |
| uq_module_roles_email_org_module | CREATE UNIQUE INDEX uq_module_roles_email_org_module ON public.module_roles U... |