operators
Записей: ~12
Колонки
| Колонка |
Тип |
Nullable |
Default |
Описание |
| id 🔑 |
integer(32) |
NOT NULL |
nextval('operators_id_seq':... |
|
| org_id |
integer(32) |
NULL |
|
→ organizations(id) |
| operator_num |
character varying(20) |
NULL |
|
|
| operator_name |
character varying(100) |
NULL |
|
|
| tenant_id |
integer(32) |
NOT NULL |
|
→ organizations(id) |
| user_id |
uuid |
NULL |
|
→ organization_users(id) |
| is_active |
boolean |
NOT NULL |
true |
|
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя |
Определение |
| idx_operators_tenant |
CREATE INDEX idx_operators_tenant ON public.operators USING btree (tenant_id,... |
| idx_operators_user_id |
CREATE INDEX idx_operators_user_id ON public.operators USING btree (user_id) |
| idx_operators_user_id_unique |
CREATE UNIQUE INDEX idx_operators_user_id_unique ON public.operators USING bt... |
| operators_pkey |
CREATE UNIQUE INDEX operators_pkey ON public.operators USING btree (id) |
Foreign Keys