ps_auths
Записей: ~169
Колонки
| Колонка |
Тип |
Nullable |
Default |
Описание |
| id 🔑 |
character varying(40) |
NOT NULL |
|
|
| auth_type |
USER-DEFINED |
NULL |
'userpass'::auth_type_values |
|
| password |
character varying(80) |
NULL |
|
|
| username |
character varying(80) |
NULL |
|
|
| type |
character varying(20) |
NULL |
'auth'::character varying |
|
| tenant_id |
integer(32) |
NOT NULL |
|
→ organizations(id) |
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя |
Определение |
| idx_ps_auths_tenant |
CREATE INDEX idx_ps_auths_tenant ON public.ps_auths USING btree (tenant_id, id) |
| ps_auths_pkey |
CREATE UNIQUE INDEX ps_auths_pkey ON public.ps_auths USING btree (id) |
Foreign Keys