EAV tables and column attributes migrated to the EAV table with name, type of value, value, does For
Hello,
We're working on the upgrade of some application where we found the need also to make some changes and upgrading to data model.
Some of the entitites in the data model would be candidates to transform into the form where previous attributes/columns would become
separate entity list of the parameters with values.
According to perception to some theory articles this is called EAV model: Entity-attribute-value model.
For example:
Table1( PK_ID, attr1 number(14,2 ) , attr2 varchar2( 80 ), ...........attr100 date ) would
become.
Table1( Pk_Id number,
...list of common mandatory attributes for each instance of entity )
Table2( Pk_Id number,
Id_of_Parameter the varchar2( 40 ),
We're working on the upgrade of some application where we found the need also to make some changes and upgrading to data model.
Some of the entitites in the data model would be candidates to transform into the form where previous attributes/columns would become
separate entity list of the parameters with values.
According to perception to some theory articles this is called EAV model: Entity-attribute-value model.
For example:
Table1( PK_ID, attr1 number(14,2 ) , attr2 varchar2( 80 ), ...........attr100 date ) would
become.
Table1( Pk_Id number,
...list of common mandatory attributes for each instance of entity )
Table2( Pk_Id number,
Id_of_Parameter the varchar2( 40 ),
0