appeals

Колонки

Колонка	Тип	Nullable	Default	Описание
id 🔑	integer(32)	NOT NULL	nextval('appeals_id_seq'::r...
created_at	timestamp with time zone	NULL	now()
source_id	integer(32)	NOT NULL		→ sources(id)
transcription	text	NULL
content	text	NOT NULL
appeal_type_id	integer(32)	NOT NULL		→ cls_appeal_types(id)
category_id	integer(32)	NOT NULL		→ cls_categories(id)
subcategory_id	integer(32)	NULL		→ cls_subcategories(id)
priority	character varying(50)	NULL
operator_region_id	integer(32)	NOT NULL
operator_organization_id	integer(32)	NOT NULL
region_id	integer(32)	NOT NULL
organization_id	integer(32)	NOT NULL
applicant_id	integer(32)	NOT NULL		→ persons(id)
applicant_is_patient	boolean	NULL
patient_id	integer(32)	NULL		→ persons(id)
short_description	text	NULL
response_method_id	integer(32)	NULL		→ response_methods(id)

🔑 = Primary Key, → = Foreign Key

Индексы

Имя	Определение
appeals_pkey	CREATE UNIQUE INDEX appeals_pkey ON public.appeals USING btree (id)
ix_appeals_id	CREATE INDEX ix_appeals_id ON public.appeals USING btree (id)

Foreign Keys

Колонка	Ссылка на
appeal_type_id	cls_appeal_types(id)
applicant_id	persons(id)
category_id	cls_categories(id)
patient_id	persons(id)
response_method_id	response_methods(id)
source_id	sources(id)
subcategory_id	cls_subcategories(id)

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

• appeal_files — через appeal_id
• suo_tasks — через appeal_id