queue_members
Записей: ~8
Колонки
| Колонка |
Тип |
Nullable |
Default |
Описание |
| queue_name |
character varying(128) |
NOT NULL |
|
|
| interface |
character varying(128) |
NOT NULL |
|
|
| membername |
character varying(128) |
NULL |
|
|
| state_interface |
character varying(128) |
NULL |
|
|
| penalty |
integer(32) |
NULL |
0 |
|
| paused |
integer(32) |
NULL |
0 |
|
| uniqueid |
text |
NOT NULL |
|
|
| wrapuptime |
integer(32) |
NULL |
0 |
|
| ringinuse |
integer(32) |
NULL |
0 |
|
| reason_id |
integer(32) |
NULL |
0 |
|
| id 🔑 |
integer(32) |
NOT NULL |
nextval('queue_members_id_s... |
|
| operator_num |
character varying(20) |
NULL |
|
|
| pause_reason |
character varying(50) |
NULL |
NULL::character varying |
|
| paused_at |
timestamp without time zone |
NULL |
|
|
| tenant_id |
integer(32) |
NOT NULL |
|
→ organizations(id) |
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя |
Определение |
| idx_queue_members_tenant |
CREATE INDEX idx_queue_members_tenant ON public.queue_members USING btree (te... |
| queue_interface_unique |
CREATE UNIQUE INDEX queue_interface_unique ON public.queue_members USING btre... |
| queue_members_pkey |
CREATE UNIQUE INDEX queue_members_pkey ON public.queue_members USING btree (id) |
| queue_operator_unique |
CREATE UNIQUE INDEX queue_operator_unique ON public.queue_members USING btree... |
Foreign Keys