Перейти к содержанию

incoming_routes

Записей: ~38

Колонки

Колонка Тип Nullable Default Описание
id 🔑 integer(32) NOT NULL nextval('incoming_routes_id...
tenant_id integer(32) NOT NULL → organizations(id)
did character varying(50) NOT NULL
destination_type character varying(20) NOT NULL
destination_value character varying(100) NOT NULL
is_active boolean NULL true
created_at timestamp without time zone NULL CURRENT_TIMESTAMP
greeting_file character varying(200) NULL
org_name_kz character varying(500) NULL
org_name_ru character varying(500) NULL
personal_data_enabled boolean NULL false
greeting_text text NULL
recording_notice_enabled boolean NULL false
play_greeting boolean NULL false
greeting_language character varying(10) NULL 'both'::character varying
greeting_text_kz text NULL

🔑 = Primary Key, → = Foreign Key

Индексы

Имя Определение
idx_incoming_routes_did CREATE INDEX idx_incoming_routes_did ON public.incoming_routes USING btree (d...
idx_incoming_routes_tenant CREATE INDEX idx_incoming_routes_tenant ON public.incoming_routes USING btree...
incoming_routes_pkey CREATE UNIQUE INDEX incoming_routes_pkey ON public.incoming_routes USING btre...

Foreign Keys

Колонка Ссылка на
tenant_id organizations(id)

Используется в