suo_tasks
Записей: ~349
Колонки
| Колонка |
Тип |
Nullable |
Default |
Описание |
| id 🔑 |
integer(32) |
NOT NULL |
nextval('suo_tasks_id_seq':... |
|
| organization_id |
integer(32) |
NOT NULL |
|
→ suo_organizations(id) |
| assigned_user_id |
integer(32) |
NULL |
|
→ suo_users(id) |
| created_by_user_id |
integer(32) |
NULL |
|
→ suo_users(id) |
| task_type |
character varying(50) |
NOT NULL |
|
|
| status |
character varying(30) |
NOT NULL |
|
|
| priority |
character varying(30) |
NOT NULL |
|
|
| title |
character varying(500) |
NOT NULL |
|
|
| description |
text |
NULL |
|
|
| caller_phone |
character varying(20) |
NULL |
|
|
| caller_name |
character varying(300) |
NULL |
|
|
| call_id |
character varying(100) |
NULL |
|
|
| recording_url |
character varying(500) |
NULL |
|
|
| call_datetime |
timestamp with time zone |
NULL |
|
|
| call_transcription |
text |
NULL |
|
|
| call_summary |
text |
NULL |
|
|
| call_response_summary |
text |
NULL |
|
|
| error_message |
text |
NULL |
|
|
| created_at |
timestamp with time zone |
NULL |
now() |
|
| updated_at |
timestamp with time zone |
NULL |
now() |
|
| due_date |
timestamp with time zone |
NULL |
|
|
| completed_at |
timestamp with time zone |
NULL |
|
|
| appeal_id |
integer(32) |
NULL |
|
→ appeals(id) |
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя |
Определение |
| ix_suo_tasks_id |
CREATE INDEX ix_suo_tasks_id ON public.suo_tasks USING btree (id) |
| suo_tasks_pkey |
CREATE UNIQUE INDEX suo_tasks_pkey ON public.suo_tasks USING btree (id) |
Foreign Keys