organizations
Записей: ~230
Колонки
| Колонка | Тип | Nullable | Default | Описание |
|---|---|---|---|---|
| id 🔑 | integer(32) | NOT NULL | nextval('organizations_id_s... | |
| org_name | character varying(256) | NOT NULL | ||
| org_prefix | character varying(20) | NOT NULL | ||
| created_at | timestamp without time zone | NULL | CURRENT_TIMESTAMP | |
| is_active | boolean | NULL | true | |
| max_queues | integer(32) | NULL | 30 | |
| max_operators | integer(32) | NULL | 100 | |
| phone_city_code | character varying(5) | NULL | Полный телефонный код города (7212, 727, 72137...) | |
| phone_zone_code | character varying(3) | NULL | Код зоны 3 цифры (721, 727...) | |
| phone_local_digits | integer(32) | NULL | Длина местного номера (5, 6 или 7) |
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя | Определение |
|---|---|
| idx_organizations_prefix_active | CREATE UNIQUE INDEX idx_organizations_prefix_active ON public.organizations U... |
| organizations_pkey | CREATE UNIQUE INDEX organizations_pkey ON public.organizations USING btree (id) |
Используется в
- call_billing — через organization_id
- call_detail_records — через tenant_id
- incoming_routes — через tenant_id
- operator_pause_log — через tenant_id
- operator_queue_log — через tenant_id
- operators — через org_id
- operators — через tenant_id
- ps_aors — через tenant_id
- ps_auths — через tenant_id
- ps_endpoints — через tenant_id
- queue_members — через tenant_id
- queues — через tenant_id
- working_hours — через tenant_id
- organization_notifications — через organization_id
- organization_users — через organization_id
- sms_billing — через organization_id
- support_bot_sessions — через organization_id