i do organization schema for my company. i make a simple design of org. sch.
organization_schema=> org_job_ıd ,bigger_org_job_id,job_id(for example more than one department have computer enginner)
job=>job_id,job_name and also employees have relation with organization_schema
than my problem is i need to history of organization_schema
for it i add a table like;
and also add column to organization_schema which name org_id
can u look and advice for better way