route_greeting_blocks
Колонки
| Колонка |
Тип |
Nullable |
Default |
Описание |
| id 🔑 |
integer(32) |
NOT NULL |
nextval('route_greeting_blo... |
|
| route_id |
integer(32) |
NOT NULL |
|
→ incoming_routes(id) |
| order_num |
integer(32) |
NOT NULL |
|
|
| block_type |
character varying(20) |
NOT NULL |
|
|
| template_id |
integer(32) |
NULL |
|
→ greeting_templates(id) |
| custom_text |
text |
NULL |
|
|
| custom_language |
character varying(10) |
NULL |
|
|
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя |
Определение |
| ix_route_greeting_blocks_id |
CREATE INDEX ix_route_greeting_blocks_id ON public.route_greeting_blocks USIN... |
| ix_route_greeting_blocks_route_id |
CREATE INDEX ix_route_greeting_blocks_route_id ON public.route_greeting_block... |
| route_greeting_blocks_pkey |
CREATE UNIQUE INDEX route_greeting_blocks_pkey ON public.route_greeting_block... |
| uq_route_greeting_block_order |
CREATE UNIQUE INDEX uq_route_greeting_block_order ON public.route_greeting_bl... |
Foreign Keys