support_bot_sessions
Колонки
| Колонка |
Тип |
Nullable |
Default |
Описание |
| id 🔑 |
integer(32) |
NOT NULL |
nextval('support_bot_sessio... |
|
| line |
character varying(5) |
NOT NULL |
'L1'::character varying |
|
| status |
character varying(20) |
NULL |
'active'::character varying |
|
| created_by |
integer(32) |
NOT NULL |
|
|
| organization_id |
integer(32) |
NULL |
|
→ organizations(id) |
| summary |
text |
NULL |
|
|
| created_at |
timestamp without time zone |
NULL |
CURRENT_TIMESTAMP |
|
| updated_at |
timestamp without time zone |
NULL |
CURRENT_TIMESTAMP |
|
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя |
Определение |
| idx_sbot_sessions_created_by |
CREATE INDEX idx_sbot_sessions_created_by ON public.support_bot_sessions USIN... |
| idx_sbot_sessions_org |
CREATE INDEX idx_sbot_sessions_org ON public.support_bot_sessions USING btree... |
| idx_sbot_sessions_status |
CREATE INDEX idx_sbot_sessions_status ON public.support_bot_sessions USING bt... |
| support_bot_sessions_pkey |
CREATE UNIQUE INDEX support_bot_sessions_pkey ON public.support_bot_sessions ... |
Foreign Keys