user13534543 wrote:So you have a work flow.
Requirement : Some of the department values say deptno., deptname, deptManager when amended(edited) is subjected to authorisation. Only after authorisation these department values gets persisted in database table - DEPARTMENT. The DepartmentBean is the java bean.
Once authorised the status will change to 'approved', the value will be stored against its TABLE_NAME/COLUMN_NAME.What happens if it isn't authorized?
P.S : I have taken department as an entity for example there are many other entities having the same requirementWhere many = 10, 100 or 1000?
For me somehow the very idea of storing a column name (DEPARTMENT.DEPT_NO) inside a database table (INTERMEDIARY_TABLE) doesn't look right and good.It is ok but whether is it ideal depends on business needs.