Индекс "str.str$orders_idx"
Столбец | Тип | Определение
-------------------+--------------------------------+-------------------
task_num | character varying(50) | task_num
contractor_id_ord | bigint | contractor_id_ord
operator_id | bigint | operator_id
order_type_code | bigint | order_type_code
task_date | timestamp(0) without time zone | task_date
contract_id | bigint | contract_id
date_deleted | timestamp(0) without time zone | date_deleted
уникальный, btree, для таблицы "str.str$orders"
Таблица "str.str$orders"
Столбец | Тип | Правило сортировки | Допустимость NULL | По умолчанию
---------------------------+--------------------------------+--------------------+-------------------+--------------
order_id | bigint | | not null |
order_num | character varying(40) | | not null |
order_date | timestamp(6) without time zone | | not null |
contractor_id_ord | bigint | | not null |
contractor_id_sel | bigint | | |
selection_reason_code | bigint | | |
user_changed | character varying(40) | | |
date_changed | timestamp(0) without time zone | | |
user_created | character varying(40) | | not null |
date_created | timestamp(0) without time zone | | not null |
user_deleted | character varying(40) | | |
date_deleted | timestamp(0) without time zone | | |
deleted | boolean | | not null | false
operator_id | bigint | | not null |
input_num | character varying(50) | | |
task_num | character varying(50) | | |
order_status_code | bigint | | |
order_type_code | bigint | | not null | 1
order_control_method_code | bigint | | |
task_date | timestamp(0) without time zone | | |
input_date | timestamp(0) without time zone | | |
check_order_num | character varying(240) | | |
check_order_date | timestamp(0) without time zone | | |
notes | character varying(4000) | | |
contractor_id_own | bigint | | |
selection_base_id | bigint | | |
contract_id | bigint | | |
Индексы:
"str$orders_pkey" PRIMARY KEY, btree (order_id)
"str$orders_idx" UNIQUE CONSTRAINT, btree (task_num, contractor_id_ord, operator_id, order_type_code, task_date, contract_id, date_deleted)
"order_ selection_base_fk_i" btree (selection_base_id)
"order_contractor_ord_fk_i" btree (contractor_id_ord)
"order_contractor_sel_fk_i" btree (contractor_id_sel)
"order_order_type_fk_i" btree (order_type_code)
"order_selection_reason_fk_i" btree (selection_reason_code)
"order_status_fk_i" btree (order_status_code)
"orders_UK" btree (order_num)
"orders_control_method_fk_i" btree (order_control_method_code)
"orders_own_fk_i" btree (contractor_id_own)
"str$orders_contract_fk_i" btree (contract_id)
Ограничения внешнего ключа:
"order_ selection_base_fk" FOREIGN KEY (selection_base_id) REFERENCES "str$selection_bases"(selection_base_id)
"order_contractor_ord_fk" FOREIGN KEY (contractor_id_ord) REFERENCES "com$contractors"(contractor_id)
"order_contractor_sel_fk" FOREIGN KEY (contractor_id_sel) REFERENCES "com$contractors"(contractor_id)
"order_order_type_fk" FOREIGN KEY (order_type_code) REFERENCES "str$order_types"(order_type_code)
"order_selection_reason_fk" FOREIGN KEY (selection_reason_code) REFERENCES "str$selection_reasons"(selection_reason_code)
"order_status_fk" FOREIGN KEY (order_status_code) REFERENCES "str$order_statuses"(order_status_code)
"orders_control_method_fk" FOREIGN KEY (order_control_method_code) REFERENCES "str$order_control_methods"(order_control_method_code)
"orders_own_fk" FOREIGN KEY (contractor_id_own) REFERENCES "com$contractors"(contractor_id)
"str$orders_contract_fk" FOREIGN KEY (contract_id) REFERENCES "com$contracts"(contract_id)
Ссылки извне:
TABLE ""str$documents"" CONSTRAINT "documents_order_fk" FOREIGN KEY (order_id) REFERENCES "str$orders"(order_id)
TABLE ""str$scr_documents"" CONSTRAINT "scr_document_order_fk" FOREIGN KEY (order_id) REFERENCES "str$orders"(order_id)
TABLE ""str$order_positions"" CONSTRAINT "str$order_positions_order_fk" FOREIGN KEY (order_id) REFERENCES "str$orders"(order_id)
Триггеры:
"str$orders_biu" BEFORE INSERT OR UPDATE ON "str$orders" FOR EACH ROW EXECUTE PROCEDURE log_auth_trigger()
"str$orders_log" BEFORE INSERT OR DELETE OR UPDATE ON "str$orders" FOR EACH ROW EXECUTE PROCEDURE log_trigger()
"str$orders_oper_bi" BEFORE INSERT ON "str$orders" FOR EACH ROW EXECUTE PROCEDURE insert_operator_id()