-- Insert UiEntity
INSERT INTO UI_ENTITY (
ENTITY_ID
,ENTITY_NAME
,TABLE_NAME
,EXT_TABLE_NAME
,DESCRIPTION
) VALUES (
'100'
,'UiScreen'
,'UI_SCREEN'
,''
,'UI Screen'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'1000'
,'100'
,'screenId'
,'Screen ID (UI Screen)'
,'SCREEN_ID'
,'1'
,'20'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'1'
,'Screen ID'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'1001'
,'100'
,'applicationId'
,'Application ID (UI Screen)'
,'APPLICATION_ID'
,'30'
,'20'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'2'
,'Application'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'1002'
,'100'
,'screenName'
,'Screen Name'
,'SCREEN_NAME'
,'2'
,'60'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'3'
,'Screen Name'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'1003'
,'100'
,'screenDescription'
,'Screen Description'
,'SCREEN_DESCRIPTION'
,'5'
,'0'
,''
,''
,'N'
,'N'
,'Y'
,''
,''
,'4'
,'Screen Description'
,'0'
,'1'
,'1'
);
