suo_user_roles
Записей: ~4
Колонки
| Колонка |
Тип |
Nullable |
Default |
Описание |
| id 🔑 |
integer(32) |
NOT NULL |
nextval('suo_user_roles_id_... |
|
| user_id |
integer(32) |
NOT NULL |
|
→ suo_users(id) |
| role |
character varying(30) |
NOT NULL |
|
|
| operator_id |
integer(32) |
NULL |
|
|
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя |
Определение |
| ix_suo_user_roles_id |
CREATE INDEX ix_suo_user_roles_id ON public.suo_user_roles USING btree (id) |
| suo_user_roles_pkey |
CREATE UNIQUE INDEX suo_user_roles_pkey ON public.suo_user_roles USING btree ... |
| uq_user_role |
CREATE UNIQUE INDEX uq_user_role ON public.suo_user_roles USING btree (user_i... |
Foreign Keys