Карта связи заказа и позиций: почему важен порядок колонок ключа

Данные получены настоящими запросами через native-расширение cubrid. После наблюдений собственные учебные объекты удалены.

Результат выполнения
НаблюдениеРезультат
Первичный ключwarehouse + order_no
Связьwarehouse → warehouse; order_no → order_no
ЗаказСклад 1 / 700
ПокупательМастерская
Позиция 1Кабель — 3 шт.
Позиция 2Клемма — 6 шт.
Чужой филиал не смешанда
Полученные строки и дополнительные наблюдения
{
    "primary_key": [
        {
            "CLASS_NAME": "dba.c169_orders_0dbe61e56a",
            "ATTR_NAME": "warehouse",
            "KEY_SEQ": "1",
            "KEY_NAME": "pk_c169_orders_0dbe61e56a_warehouse_order_no"
        },
        {
            "CLASS_NAME": "dba.c169_orders_0dbe61e56a",
            "ATTR_NAME": "order_no",
            "KEY_SEQ": "2",
            "KEY_NAME": "pk_c169_orders_0dbe61e56a_warehouse_order_no"
        }
    ],
    "imported": [
        {
            "PKTABLE_NAME": "dba.c169_orders_0dbe61e56a",
            "PKCOLUMN_NAME": "warehouse",
            "FKTABLE_NAME": "c169_lines_053b563372",
            "FKCOLUMN_NAME": "warehouse",
            "KEY_SEQ": "1",
            "UPDATE_RULE": "1",
            "DELETE_RULE": "1",
            "FK_NAME": "fk_c169_lines_053b563372_warehouse_order_no",
            "PK_NAME": "pk_c169_orders_0dbe61e56a_warehouse_order_no"
        },
        {
            "PKTABLE_NAME": "dba.c169_orders_0dbe61e56a",
            "PKCOLUMN_NAME": "order_no",
            "FKTABLE_NAME": "c169_lines_053b563372",
            "FKCOLUMN_NAME": "order_no",
            "KEY_SEQ": "2",
            "UPDATE_RULE": "1",
            "DELETE_RULE": "1",
            "FK_NAME": "fk_c169_lines_053b563372_warehouse_order_no",
            "PK_NAME": "pk_c169_orders_0dbe61e56a_warehouse_order_no"
        }
    ],
    "exported": [
        {
            "PKTABLE_NAME": "c169_orders_0dbe61e56a",
            "PKCOLUMN_NAME": "warehouse",
            "FKTABLE_NAME": "dba.c169_lines_053b563372",
            "FKCOLUMN_NAME": "warehouse",
            "KEY_SEQ": "1",
            "UPDATE_RULE": "1",
            "DELETE_RULE": "1",
            "FK_NAME": "fk_c169_lines_053b563372_warehouse_order_no",
            "PK_NAME": "pk_c169_orders_0dbe61e56a_warehouse_order_no"
        },
        {
            "PKTABLE_NAME": "c169_orders_0dbe61e56a",
            "PKCOLUMN_NAME": "order_no",
            "FKTABLE_NAME": "dba.c169_lines_053b563372",
            "FKCOLUMN_NAME": "order_no",
            "KEY_SEQ": "2",
            "UPDATE_RULE": "1",
            "DELETE_RULE": "1",
            "FK_NAME": "fk_c169_lines_053b563372_warehouse_order_no",
            "PK_NAME": "pk_c169_orders_0dbe61e56a_warehouse_order_no"
        }
    ],
    "cross_reference": [
        {
            "PKTABLE_NAME": "c169_orders_0dbe61e56a",
            "PKCOLUMN_NAME": "warehouse",
            "FKTABLE_NAME": "c169_lines_053b563372",
            "FKCOLUMN_NAME": "warehouse",
            "KEY_SEQ": "1",
            "UPDATE_RULE": "1",
            "DELETE_RULE": "1",
            "FK_NAME": "fk_c169_lines_053b563372_warehouse_order_no",
            "PK_NAME": "pk_c169_orders_0dbe61e56a_warehouse_order_no"
        },
        {
            "PKTABLE_NAME": "c169_orders_0dbe61e56a",
            "PKCOLUMN_NAME": "order_no",
            "FKTABLE_NAME": "c169_lines_053b563372",
            "FKCOLUMN_NAME": "order_no",
            "KEY_SEQ": "2",
            "UPDATE_RULE": "1",
            "DELETE_RULE": "1",
            "FK_NAME": "fk_c169_lines_053b563372_warehouse_order_no",
            "PK_NAME": "pk_c169_orders_0dbe61e56a_warehouse_order_no"
        }
    ],
    "order_items": [
        {
            "customer": "Мастерская",
            "title": "Кабель",
            "qty": "3"
        },
        {
            "customer": "Мастерская",
            "title": "Клемма",
            "qty": "6"
        }
    ],
    "sql_limit": 10
}

result.json содержит те же данные; metrics.json — проверки. Реквизиты входа в эти файлы не записываются.