REST_HEADS(
REST_HEADS_NO, /* PK */
REST_HEADS_TYPE, /* FK (TYPES_NO) */
REST_HEADS_OBJECT /* FK (OBJECTS_NO) */
)
REST_COMMODITYS(
REST_COMMODITYS_NO, /* PK */
REST_COMMODITYS_HEAD, /* FK (REST_HEADS_NO) */
REST_COMMODITYS_COMM, /* FK (COMMODITYS_NO) */
REST_COMMODITYS_REST, /* Вводится пользователем */
REST_COMMODITYS_REQUEST /* Вычислятеся ХП */
)
А для эмуляции первоначального вида
CREATE VIEW REQUEST_TABLE(
REQUEST_TABLE_TYPE,
REQUEST_TABLE_OBJECT,
REQUEST_TABLE_COMMODITY,
REQUEST_TABLE_REST,
REQUEST_TABLE_REQUEST
)
AS
SELECT
STORE_HEADS_TYPE,
STORE_HEADS_OBJECT,
STORE_COMMODITYS_COMM,
STORE_COMMODITYS_REST,
STORE_COMMODITYS_REQUEST
FROM
STORE_HEADS, STORE_COMMODITYS
WHERE
STORE_COMMODITYS_HEAD = STORE_HEADS_NO;
|