📄 ui-s-codes.sql
字号:
-- Insert UiScreen
INSERT INTO UI_SCREEN (
SCREEN_ID
,APPLICATION_ID
,SCREEN_NAME
,SCREEN_DESCRIPTION
) VALUES (
'10011'
,'1'
,'CODES'
,'Screens for manipulation of code types and codes.'
);
-- Insert UiScreenSection
INSERT INTO UI_SCREEN_SECTION (
SECTION_ID
,SCREEN_ID
,SECTION_NAME
,SECTION_DESCRIPTION
,LAYOUT_TYPE_ID
,DISPLAY_ORDER
,COLUMN_COUNT
,ROW_COUNT
,BUTTON_KEYS
,TITLE_DEF
,BUTTON_ACTION
,BUTTON_TARGET
,DETAIL_BUTTON_ACTION
,DETAIL_BUTTON_TARGET
,POPUP_ACTION
,POPUP_TARGET
,EDIT_BUTTON_ACTION
,EDIT_BUTTON_TARGET
,NEW_BUTTON_ACTION
,NEW_BUTTON_TARGET
,SEARCH_ACTION
,SEARCH_TARGET
,SEARCH_ATTRIBUTE_ID
,SEND_QUERY_PARAMETER_LIST
,USE_QUERY_PARAMETER_LIST
,SORT_DEF
,HIDE_BUTTONS
,SELECT_NAME_DEF
,ROWS_PER_PAGE
) VALUES (
'10033'
,'10011'
,'CodeTypeHeader'
,'Header for manipulation of code types.'
,'1'
,'2'
,'2'
,'0'
,'codeTypeId:codeTypeId'
,'"CODE TYPE: ";codeTypeName'
,'/sfa/control/codeTypeHeader'
,'headerFrame'
,'/sfa/control/codeTypeTabs'
,'contentFrame'
,''
,''
,'/sfa/control/codeTypeHeader'
,'headerFrame'
,'/sfa/control/codeTypeHeader'
,'headerFrame'
,'/sfa/control/codeTypeList'
,'contentFrame'
,''
,'codeTypeId:codeTypeId;parentCodeTypeId:codeTypeId'
,''
,''
,''
,''
,''
);
-- Insert UiScreenSection
INSERT INTO UI_SCREEN_SECTION (
SECTION_ID
,SCREEN_ID
,SECTION_NAME
,SECTION_DESCRIPTION
,LAYOUT_TYPE_ID
,DISPLAY_ORDER
,COLUMN_COUNT
,ROW_COUNT
,BUTTON_KEYS
,TITLE_DEF
,BUTTON_ACTION
,BUTTON_TARGET
,DETAIL_BUTTON_ACTION
,DETAIL_BUTTON_TARGET
,POPUP_ACTION
,POPUP_TARGET
,EDIT_BUTTON_ACTION
,EDIT_BUTTON_TARGET
,NEW_BUTTON_ACTION
,NEW_BUTTON_TARGET
,SEARCH_ACTION
,SEARCH_TARGET
,SEARCH_ATTRIBUTE_ID
,SEND_QUERY_PARAMETER_LIST
,USE_QUERY_PARAMETER_LIST
,SORT_DEF
,HIDE_BUTTONS
,SELECT_NAME_DEF
,ROWS_PER_PAGE
) VALUES (
'10046'
,'10011'
,'CodeTypeList'
,'List of Code Types'
,'2'
,'3'
,'1'
,'0'
,'codeTypeId:codeTypeId'
,'"CODE TYPE LIST"'
,''
,''
,'/sfa/control/codeTypeHeader'
,'headerFrame'
,''
,''
,''
,''
,'/sfa/control/codeTypeHeader'
,'headerFrame'
,'/sfa/control/codeTypeList'
,'contentFrame'
,'10008'
,''
,''
,'codeTypeName'
,''
,''
,''
);
-- Insert UiScreenSection
INSERT INTO UI_SCREEN_SECTION (
SECTION_ID
,SCREEN_ID
,SECTION_NAME
,SECTION_DESCRIPTION
,LAYOUT_TYPE_ID
,DISPLAY_ORDER
,COLUMN_COUNT
,ROW_COUNT
,BUTTON_KEYS
,TITLE_DEF
,BUTTON_ACTION
,BUTTON_TARGET
,DETAIL_BUTTON_ACTION
,DETAIL_BUTTON_TARGET
,POPUP_ACTION
,POPUP_TARGET
,EDIT_BUTTON_ACTION
,EDIT_BUTTON_TARGET
,NEW_BUTTON_ACTION
,NEW_BUTTON_TARGET
,SEARCH_ACTION
,SEARCH_TARGET
,SEARCH_ATTRIBUTE_ID
,SEND_QUERY_PARAMETER_LIST
,USE_QUERY_PARAMETER_LIST
,SORT_DEF
,HIDE_BUTTONS
,SELECT_NAME_DEF
,ROWS_PER_PAGE
) VALUES (
'10047'
,'10011'
,'CodeHeader'
,'Code Header'
,'1'
,'1'
,'2'
,'0'
,'codeTypeId:codeTypeId;codeId:codeId'
,'"CODE: ";codeValue'
,'/sfa/control/codeHeader'
,'headerFrame'
,'/sfa/control/codeChildCodeList'
,'contentFrame'
,''
,''
,'/sfa/control/codeHeader'
,'headerFrame'
,'/sfa/control/codeHeader'
,'headerFrame'
,'/sfa/control/codeChildCodeList'
,'contentFrame'
,'10005'
,'parentCodeId:codeId'
,''
,'codeValue'
,'Query;Detail'
,''
,''
);
-- Insert UiScreenSection
INSERT INTO UI_SCREEN_SECTION (
SECTION_ID
,SCREEN_ID
,SECTION_NAME
,SECTION_DESCRIPTION
,LAYOUT_TYPE_ID
,DISPLAY_ORDER
,COLUMN_COUNT
,ROW_COUNT
,BUTTON_KEYS
,TITLE_DEF
,BUTTON_ACTION
,BUTTON_TARGET
,DETAIL_BUTTON_ACTION
,DETAIL_BUTTON_TARGET
,POPUP_ACTION
,POPUP_TARGET
,EDIT_BUTTON_ACTION
,EDIT_BUTTON_TARGET
,NEW_BUTTON_ACTION
,NEW_BUTTON_TARGET
,SEARCH_ACTION
,SEARCH_TARGET
,SEARCH_ATTRIBUTE_ID
,SEND_QUERY_PARAMETER_LIST
,USE_QUERY_PARAMETER_LIST
,SORT_DEF
,HIDE_BUTTONS
,SELECT_NAME_DEF
,ROWS_PER_PAGE
) VALUES (
'10048'
,'10011'
,'CodeTypeCodeList'
,'List of Codes for a Given Code Type'
,'2'
,'4'
,'7'
,'0'
,'codeTypeId:codeTypeId;codeId:codeId'
,'"CODES for Code Type: ";codeTypeId'
,''
,''
,'/sfa/control/codeHeader'
,'headerFrame'
,''
,''
,'/sfa/control/codeTypeCodeList'
,'contentFrame'
,'/sfa/control/codeHeader'
,'headerFrame'
,''
,''
,''
,'codeTypeId:codeTypeId'
,'codeTypeId:codeTypeId'
,''
,'QueryPicker'
,''
,''
);
-- Insert UiScreenSection
INSERT INTO UI_SCREEN_SECTION (
SECTION_ID
,SCREEN_ID
,SECTION_NAME
,SECTION_DESCRIPTION
,LAYOUT_TYPE_ID
,DISPLAY_ORDER
,COLUMN_COUNT
,ROW_COUNT
,BUTTON_KEYS
,TITLE_DEF
,BUTTON_ACTION
,BUTTON_TARGET
,DETAIL_BUTTON_ACTION
,DETAIL_BUTTON_TARGET
,POPUP_ACTION
,POPUP_TARGET
,EDIT_BUTTON_ACTION
,EDIT_BUTTON_TARGET
,NEW_BUTTON_ACTION
,NEW_BUTTON_TARGET
,SEARCH_ACTION
,SEARCH_TARGET
,SEARCH_ATTRIBUTE_ID
,SEND_QUERY_PARAMETER_LIST
,USE_QUERY_PARAMETER_LIST
,SORT_DEF
,HIDE_BUTTONS
,SELECT_NAME_DEF
,ROWS_PER_PAGE
) VALUES (
'10049'
,'10011'
,'CodeChildCodeList'
,'List of Child Codes for a Given Code'
,'2'
,'6'
,'1'
,'0'
,'codeId:codeId;codeTypeId:codeTypeId'
,'"CHILD CODES for Code: ";parentCodeId'
,'/sfa/control/codeHeader'
,'headerFrame'
,'/sfa/control/codeHeader'
,'headerFrame'
,''
,''
,''
,''
,'/sfa/control/codeHeader'
,'headerFrame'
,'/sfa/control/codeChildCodeList'
,'contentFrame'
,''
,'parentCodeId:parentCodeId'
,'parentCodeId:parentCodeId'
,'codeValue'
,'QueryPicker; Edit'
,''
,''
);
-- Insert UiScreenSection
INSERT INTO UI_SCREEN_SECTION (
SECTION_ID
,SCREEN_ID
,SECTION_NAME
,SECTION_DESCRIPTION
,LAYOUT_TYPE_ID
,DISPLAY_ORDER
,COLUMN_COUNT
,ROW_COUNT
,BUTTON_KEYS
,TITLE_DEF
,BUTTON_ACTION
,BUTTON_TARGET
,DETAIL_BUTTON_ACTION
,DETAIL_BUTTON_TARGET
,POPUP_ACTION
,POPUP_TARGET
,EDIT_BUTTON_ACTION
,EDIT_BUTTON_TARGET
,NEW_BUTTON_ACTION
,NEW_BUTTON_TARGET
,SEARCH_ACTION
,SEARCH_TARGET
,SEARCH_ATTRIBUTE_ID
,SEND_QUERY_PARAMETER_LIST
,USE_QUERY_PARAMETER_LIST
,SORT_DEF
,HIDE_BUTTONS
,SELECT_NAME_DEF
,ROWS_PER_PAGE
) VALUES (
'10053'
,'10011'
,'CodeChildCodeTypeList'
,''
,'2'
,'5'
,'1'
,'0'
,'codeTypeId:codeTypeId'
,'"CHILD CODE TYPES for Code Type: ";parentCodeTypeId'
,''
,''
,'/sfa/control/codeTypeHeader'
,'headerFrame'
,''
,''
,''
,''
,'/sfa/control/codeTypeHeader'
,'headerFrame'
,''
,''
,''
,'parentCodeTypeId:parentCodeTypeId'
,'parentCodeTypeId:parentCodeTypeId'
,''
,'QueryPicker;Edit'
,''
,''
);
-- Insert UiScreenSectionEntity
INSERT INTO UI_SCREEN_SECTION_ENTITY (
SECTION_ID
,ENTITY_ID
,IS_UPDATEABLE
,RELATION_TITLE
,RELATION_BY_AND_FIELDS
,RELATION_ORDER_BY_FIELDS
,RETRIEVE_ORDER
,INSERT_ORDER
,UPDATE_ORDER
,DELETE_ORDER
,IS_OUTER_JOINED
,HAS_SEQUENCE_KEY
) VALUES (
'10033'
,'10005'
,'Y'
,''
,''
,''
,'1'
,'0'
,'0'
,'0'
,'N'
,'N'
);
-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
SECTION_ID
,PARTY_ID
,ATTRIBUTE_ID
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'10033'
,'-1'
,'10007'
,'2'
,'20'
,'Y'
,'N'
,'Y'
,'Y'
,'10'
,'Code Type ID'
,'0'
,'1'
,'1'
);
-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
SECTION_ID
,PARTY_ID
,ATTRIBUTE_ID
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'10033'
,'-1'
,'10008'
,'2'
,'60'
,'Y'
,'N'
,'Y'
,'Y'
,'20'
,'Code Type Name'
,'60'
,'1'
,'1'
);
-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
SECTION_ID
,PARTY_ID
,ATTRIBUTE_ID
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'10033'
,'-1'
,'10009'
,'55'
,'255'
,'N'
,'N'
,'Y'
,'Y'
,'30'
,'Code Type Description'
,'0'
,'1'
,'1'
);
-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
SECTION_ID
,PARTY_ID
,ATTRIBUTE_ID
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'10033'
,'-1'
,'10011'
,'10000'
,'40'
,'N'
,'N'
,'Y'
,'Y'
,'40'
,'Parent Code Type'
,'40'
,'1'
,'1'
);
-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
SECTION_ID
,PARTY_ID
,ATTRIBUTE_ID
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'10033'
,'-1'
,'10047'
,'41'
,'0'
,'N'
,'N'
,'Y'
,'Y'
,'50'
,'Visible'
,'0'
,'1'
,'1'
);
-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
SECTION_ID
,PARTY_ID
,ATTRIBUTE_ID
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'10033'
,'-1'
,'10048'
,'17'
,'20'
,'N'
,'Y'
,'Y'
,'Y'
,'15'
,'Created Date'
,'0'
,'1'
,'1'
);
-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
SECTION_ID
,PARTY_ID
,ATTRIBUTE_ID
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'10033'
,'-1'
,'10049'
,'17'
,'20'
,'N'
,'Y'
,'Y'
,'Y'
,'35'
,'Modified Date'
,'0'
,'1'
,'1'
);
-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
SECTION_ID
,PARTY_ID
,ATTRIBUTE_ID
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'10033'
,'-1'
,'10050'
,'21'
,'20'
,'N'
,'Y'
,'Y'
,'Y'
,'25'
,'Created By'
,'0'
,'1'
,'1'
);
-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
SECTION_ID
,PARTY_ID
,ATTRIBUTE_ID
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'10033'
,'-1'
,'10051'
,'21'
,'20'
,'N'
,'Y'
,'Y'
,'Y'
,'45'
,'Modified By'
,'0'
,'1'
,'1'
);
-- Insert UiScreenSectionEntity
INSERT INTO UI_SCREEN_SECTION_ENTITY (
SECTION_ID
,ENTITY_ID
,IS_UPDATEABLE
,RELATION_TITLE
,RELATION_BY_AND_FIELDS
,RELATION_ORDER_BY_FIELDS
,RETRIEVE_ORDER
,INSERT_ORDER
,UPDATE_ORDER
,DELETE_ORDER
,IS_OUTER_JOINED
,HAS_SEQUENCE_KEY
) VALUES (
'10046'
,'10005'
,'N'
,''
,''
,''
,'2'
,'0'
,'0'
,'0'
,'N'
,'N'
);
-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
SECTION_ID
,PARTY_ID
,ATTRIBUTE_ID
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'10046'
,'-1'
,'10007'
,'10010'
,'20'
,'N'
,'Y'
,'Y'
,'Y'
,'1'
,'Code Type ID'
,'150'
,'1'
,'1'
);
-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
SECTION_ID
,PARTY_ID
,ATTRIBUTE_ID
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'10046'
,'-1'
,'10008'
,'10010'
,'40'
,'N'
,'N'
,'Y'
,'Y'
,'2'
,'Code Type Name'
,'200'
,'1'
,'1'
);
-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
SECTION_ID
,PARTY_ID
,ATTRIBUTE_ID
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'10046'
,'-1'
,'10009'
,'10004'
,'30'
,'N'
,'N'
,'Y'
,'Y'
,'4'
,'Code Type Filename'
,'200'
,'1'
,'1'
);
-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
SECTION_ID
,PARTY_ID
,ATTRIBUTE_ID
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'10046'
,'-1'
,'10011'
,'10000'
,'40'
,'N'
,'N'
,'Y'
,'Y'
,'3'
,'Parent Code Type'
,'150'
,'1'
,'1'
);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -