queues
Записей: ~306
Колонки
| Колонка |
Тип |
Nullable |
Default |
Описание |
| name 🔑 |
character varying(128) |
NOT NULL |
|
|
| strategy |
character varying(128) |
NULL |
'ringall'::character varying |
|
| context |
character varying(128) |
NULL |
|
|
| timeout |
integer(32) |
NULL |
15 |
|
| musicclass |
character varying(128) |
NULL |
'default'::character varying |
|
| joinempty |
character varying(128) |
NULL |
'yes'::character varying |
|
| leavewhenempty |
character varying(128) |
NULL |
'no'::character varying |
|
| persistent |
character varying(5) |
NULL |
|
|
| autopause |
character varying(10) |
NULL |
'no'::character varying |
|
| autopausedelay |
integer(32) |
NULL |
0 |
|
| membermacro |
character varying(128) |
NULL |
NULL::character varying |
|
| setinterfacevar |
character varying(5) |
NULL |
'no'::character varying |
|
| tenant_id |
integer(32) |
NOT NULL |
|
→ organizations(id) |
| org_id |
integer(32) |
NOT NULL |
|
|
| display_name |
character varying(128) |
NULL |
|
|
| queue_number |
character varying(2) |
NULL |
|
|
| is_deleted |
boolean |
NULL |
false |
|
| deleted_at |
timestamp without time zone |
NULL |
|
|
| auto_remove_unavailable |
boolean |
NULL |
false |
|
| retry |
integer(32) |
NULL |
5 |
|
| wrapuptime |
integer(32) |
NULL |
0 |
|
| maxlen |
integer(32) |
NULL |
0 |
|
| servicelevel |
integer(32) |
NULL |
60 |
|
| weight |
integer(32) |
NULL |
0 |
|
| announce_position |
character varying(10) |
NULL |
'yes'::character varying |
|
| announce_holdtime |
character varying(10) |
NULL |
'yes'::character varying |
|
| periodic_announce_frequency |
integer(32) |
NULL |
30 |
|
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя |
Определение |
| idx_queues_active |
CREATE INDEX idx_queues_active ON public.queues USING btree (tenant_id, is_de... |
| idx_queues_name_tenant |
CREATE INDEX idx_queues_name_tenant ON public.queues USING btree (tenant_id, ... |
| idx_queues_tenant |
CREATE INDEX idx_queues_tenant ON public.queues USING btree (tenant_id) |
| queues_pkey |
CREATE UNIQUE INDEX queues_pkey ON public.queues USING btree (name) |
| uq_queue_number_per_tenant |
CREATE UNIQUE INDEX uq_queue_number_per_tenant ON public.queues USING btree (... |
Foreign Keys