Topic: The partial update of reference manuals
Good afternoon. Prompt, please, as is better to organize the partial update of hierarchical reference manuals.
That is for example, there is a reference manual of the organizations.
CREATE TABLE ORGANISATIONS
Uniqueness PERIOD_KEY and ORG_ID.
When the data with new structure comes, it is necessary to update only changed elements. It turns out that for new elements PERIOD_KEY changes, and for "parents" PERIOD_KEY remains without changes. How, it is possible to set FC c PARENT_ORG_ID on ORG_ID? That is it turns out that ORG_ID is not unique, and communication PARENT_ORG_ID, PERIOD_KEY and ORG_ID, PERIOD_KEY too is incorrect, since for "parents" PERIOD_KEY can not change. How, is better to organize the partial update of reference manuals?