-- Insert UiEntity
INSERT INTO UI_ENTITY (
ENTITY_ID
,ENTITY_NAME
,TABLE_NAME
,EXT_TABLE_NAME
,DESCRIPTION
) VALUES (
'10010'
,'UiUsageHistory'
,'ui_usage_history'
,''
,'UI Usage History'
);
-- 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 (
'10080'
,'10010'
,'usageHistoryId'
,'Usage History ID'
,'usage_history_id'
,'1'
,'20'
,''
,''
,'Y'
,'N'
,'N'
,'N'
,'N'
,'1'
,'Usage History ID'
,'20'
,'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 (
'10081'
,'10010'
,'partyId'
,'Party Id'
,'party_id'
,'1'
,'20'
,''
,''
,'N'
,'N'
,'Y'
,'Y'
,'N'
,'2'
,'Party Id'
,'20'
,'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 (
'10082'
,'10010'
,'description'
,'description'
,'description'
,'2'
,'40'
,''
,''
,'N'
,'N'
,'Y'
,'Y'
,'N'
,'3'
,'description'
,'40'
,'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 (
'10083'
,'10010'
,'url'
,'url'
,'url'
,'34'
,'255'
,''
,''
,'N'
,'N'
,'Y'
,'Y'
,'N'
,'4'
,'url'
,'255'
,'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 (
'10085'
,'10010'
,'timestamp'
,'timestamp'
,'timestamp'
,'17'
,'20'
,''
,''
,'N'
,'N'
,'Y'
,'Y'
,'N'
,'6'
,'timestamp'
,'20'
,'1'
,'1'
);