EAV ( Entity-Atribute-Value data model and handling the table in Oracle Forms )
Hello,
Working on smaller business problem that involves EAV model in data model like this:
Survey( Survey# number( 7 ) not null,
Desc varchar2( 240 ) null,
DateOfOpening date not null,
DateOfClose date null );
Parameter( Parameter# varchar2( 40 ) not null,
TypeOfValue varchar2( 40 ) not null -- SMALL_INT, SMALL_CHAR, BIGGER_CHAR, BIGGER_MONEY
);
SurveyParameters( Survey#, Parameter#, Value_SMall_Int, Value_Small_Char, Values_Bigger_Char, Value Bigger_Money )
the table SurveyParameters would demand intensive generic controles in navigation and validation.
Only one type of value is relevant ( table Parameter is driving the decision ).
So wonder about the real state of the canvas and navigational and item validation logic that would handle in multi-record master-detail structure for
Working on smaller business problem that involves EAV model in data model like this:
Survey( Survey# number( 7 ) not null,
Desc varchar2( 240 ) null,
DateOfOpening date not null,
DateOfClose date null );
Parameter( Parameter# varchar2( 40 ) not null,
TypeOfValue varchar2( 40 ) not null -- SMALL_INT, SMALL_CHAR, BIGGER_CHAR, BIGGER_MONEY
);
SurveyParameters( Survey#, Parameter#, Value_SMall_Int, Value_Small_Char, Values_Bigger_Char, Value Bigger_Money )
the table SurveyParameters would demand intensive generic controles in navigation and validation.
Only one type of value is relevant ( table Parameter is driving the decision ).
So wonder about the real state of the canvas and navigational and item validation logic that would handle in multi-record master-detail structure for
0