operator_queue_log
История входов и выходов операторов из очередей
Записей: ~302
Колонки
| Колонка | Тип | Nullable | Default | Описание |
|---|---|---|---|---|
| id 🔑 | integer(32) | NOT NULL | nextval('operator_queue_log... | |
| operator_num | character varying(20) | NOT NULL | ||
| interface | character varying(50) | NOT NULL | ||
| queue_name | character varying(50) | NOT NULL | ||
| action | character varying(20) | NOT NULL | ||
| created_at | timestamp without time zone | NULL | CURRENT_TIMESTAMP | |
| tenant_id | integer(32) | NOT NULL | → organizations(id) |
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя | Определение |
|---|---|
| idx_operator_queue_log_created | CREATE INDEX idx_operator_queue_log_created ON public.operator_queue_log USIN... |
| idx_operator_queue_log_operator | CREATE INDEX idx_operator_queue_log_operator ON public.operator_queue_log USI... |
| idx_operator_queue_log_queue | CREATE INDEX idx_operator_queue_log_queue ON public.operator_queue_log USING ... |
| idx_operator_queue_log_tenant | CREATE INDEX idx_operator_queue_log_tenant ON public.operator_queue_log USING... |
| operator_queue_log_pkey | CREATE UNIQUE INDEX operator_queue_log_pkey ON public.operator_queue_log USIN... |
Foreign Keys
| Колонка | Ссылка на |
|---|---|
| tenant_id | organizations(id) |