📄 ui-s-ui_screen.sql

📁 国外的一套开源CRM
💻 SQL
📖 第 1 页 / 共 4 页
字号:
12 3 4 下一页
-- Insert UiScreen
INSERT INTO UI_SCREEN (
  SCREEN_ID
 ,APPLICATION_ID
 ,SCREEN_NAME
 ,SCREEN_DESCRIPTION
) VALUES (
  '10024'
 ,'1'
 ,'UI_SCREEN'
 ,'Screen'
);

-- 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 (
  '10050'
 ,'10024'
 ,'UiScreenHeader'
 ,'Screen Header'
 ,'1'
 ,'1'
 ,'1'
 ,'0'
 ,'screenId:screenId'
 ,'"SCREEN: ";screenName'
 ,'/sfa/control/uiScreenHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenTabs'
 ,'contentFrame'
 ,''
 ,''
 ,'/sfa/control/uiScreenHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenList'
 ,'contentFrame'
 ,''
 ,'screenId:screenId'
 ,'screenId:screenId'
 ,''
 ,''
 ,''
 ,''
);

-- 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 (
  '10051'
 ,'10024'
 ,'UiScreenList'
 ,'Screen List'
 ,'2'
 ,'2'
 ,'0'
 ,'0'
 ,'screenId:screenId'
 ,'"SCREENS"'
 ,''
 ,''
 ,'/sfa/control/uiScreenHeader'
 ,'headerFrame'
 ,''
 ,''
 ,'/sfa/control/uiScreenHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenList'
 ,'contentFrame'
 ,'1002'
 ,''
 ,''
 ,'screenName'
 ,''
 ,''
 ,''
);

-- 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 (
  '10052'
 ,'10024'
 ,'UiScreenSectionList'
 ,'Screen Section List'
 ,'2'
 ,'3'
 ,'0'
 ,'0'
 ,'sectionId:sectionId'
 ,'"SCREEN SECTIONS: Screen ";UiScreen.screenName'
 ,'/sfa/control/uiScreenSectionList'
 ,'contentFrame'
 ,'/sfa/control/uiScreenSectionHeader'
 ,'headerFrame'
 ,''
 ,''
 ,'/sfa/control/uiScreenSectionList'
 ,'contentFrame'
 ,'/sfa/control/uiScreenSectionHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenSectionList'
 ,'contentFrame'
 ,'1012'
 ,'screenId:screenId'
 ,'screenId:screenId'
 ,'sectionName'
 ,'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 (
  '10110'
 ,'10024'
 ,'UiScreenSectionHeader'
 ,'UI Screen Section Header'
 ,'1'
 ,'4'
 ,'2'
 ,'0'
 ,'sectionId:sectionId'
 ,'"SCREEN SECTION: ";sectionName'
 ,'/sfa/control/uiScreenSectionHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenSectionTabs'
 ,'contentFrame'
 ,''
 ,''
 ,'/sfa/control/uiScreenSectionHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenSectionHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenSectionList'
 ,'contentFrame'
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
);

-- 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 (
  '10111'
 ,'10024'
 ,'UiScreenSectionEntityList'
 ,'UI Screen Section Header'
 ,'2'
 ,'5'
 ,'0'
 ,'0'
 ,'sectionId:sectionId;entityId:entityId'
 ,'"ENTITIES: Screen Section ";UiScreenSection.sectionName'
 ,'/sfa/control/uiScreenSectionEntityList'
 ,'oMIframe'
 ,'/sfa/control/uiScreenSectionEntityHeader'
 ,'headerFrame'
 ,''
 ,''
 ,'/sfa/control/uiScreenSectionEntityList'
 ,'oMIframe'
 ,'/sfa/control/uiScreenSectionEntityHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenSectionEntityList'
 ,'contentFrame'
 ,''
 ,'sectionId:sectionId'
 ,'sectionId:sectionId'
 ,'retrieveOrder'
 ,'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 (
  '10121'
 ,'10024'
 ,'UiScreenSectionInfoList'
 ,'UI Screen Section Info List'
 ,'2'
 ,'6'
 ,'0'
 ,'0'
 ,'sectionId:sectionId;partyId:partyId;attributeId:attributeId'
 ,'"FIELDS: Section ";UiScreenSection.sectionName'
 ,'/sfa/control/uiScreenSectionInfoList'
 ,'oMIframe'
 ,'/sfa/control/uiScreenSectionInfoHeader'
 ,'headerFrame'
 ,''
 ,''
 ,'/sfa/control/uiScreenSectionInfoList'
 ,'oMIframe'
 ,'/sfa/control/uiScreenSectionInfoHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenSectionInfoList'
 ,'contentFrame'
 ,''
 ,'sectionId:sectionId'
 ,'sectionId:sectionId'
 ,'partyId;displayOrder'
 ,'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 (
  '10130'
 ,'10024'
 ,'UiScreenSectionEntityHeader'
 ,'UI Screen Section Entity Header'
 ,'1'
 ,'7'
 ,'2'
 ,'0'
 ,'sectionId:sectionId;entityId:entityId'
 ,'"SCREEN SECTION ENTITY: ";UiScreenSection.sectionName;" / ";UiEntity.entityName'
 ,'/sfa/control/uiScreenSectionEntityHeader'
 ,'headerFrame'
 ,''
 ,''
 ,''
 ,''
 ,'/sfa/control/uiScreenSectionEntityHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenSectionEntityHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenSectionEntityList'
 ,'contentSection'
 ,''
 ,''
 ,''
 ,''
 ,'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 (
  '10131'
 ,'10024'
 ,'UiScreenSectionInfoHeader'
 ,'UI Screen Section InfoHeader'
 ,'1'
 ,'8'
 ,'2'
 ,'0'
 ,'sectionId:sectionId;partyId:partyId;attributeId:attributeId'
 ,'"FIELD: ";UiScreenSection.sectionName;" / ";UiAttribute.attributeName;" / ";partyId'
 ,'/sfa/control/uiScreenSectionInfoHeader'
 ,'headerFrame'
 ,''
 ,''
 ,''
 ,''
 ,'/sfa/control/uiScreenSectionInfoHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenSectionInfoHeader'
 ,'headerFrame'
 ,'/sfa/control/uiScreenSectionInfoList'
 ,'contentSection'
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
);

-- 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 (
  '10050'
 ,'100'
 ,'Y'
 ,''
 ,''
 ,''
 ,'1'
 ,'1'
 ,'1'
 ,'1'
 ,'N'
 ,'Y'
);

-- 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 (
  '10050'
 ,'-1'
 ,'1000'
 ,'1'
 ,'20'
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'1'
 ,'Screen ID'
 ,'100'
 ,'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 (
  '10050'
 ,'-1'
 ,'1001'
 ,'30'
 ,'20'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'2'
 ,'Application'
 ,'100'
 ,'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 (
  '10050'
 ,'-1'
 ,'1002'
 ,'2'
 ,'60'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'3'
 ,'Screen Name'
 ,'100'
 ,'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 (
  '10050'
 ,'-1'
 ,'1003'
 ,'5'
 ,'0'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'4'
 ,'Screen Description'
 ,'100'
 ,'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 (
  '10051'
 ,'100'
 ,'N'
 ,''
 ,''
 ,''
 ,'0'
 ,'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 (
  '10051'
 ,'-1'
 ,'1000'
 ,'46'
 ,'20'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'N'
 ,'20'
 ,'Screen ID'
 ,'70'
 ,'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 (
  '10051'
 ,'-1'
 ,'1001'
 ,'30'
 ,'20'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'N'
 ,'10'
 ,'Application'
 ,'100'
 ,'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 (
  '10051'
 ,'-1'
 ,'1002'
 ,'46'
 ,'60'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'N'
 ,'30'
 ,'Screen 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 (
  '10051'
 ,'-1'
 ,'1003'
 ,'65'
 ,'0'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'40'
 ,'SQL File Name'
 ,'200'
 ,'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 (
  '10052'
 ,'100'
 ,'N'
 ,''
 ,''
 ,''
 ,'2'
 ,'0'
 ,'0'
 ,'0'
 ,'N'
 ,'N'
);

-- 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 (
  '10052'
 ,'101'
 ,'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 (
  '10052'
 ,'-1'
 ,'1010'
 ,'47'
 ,'20'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'N'
 ,'20'
 ,'Section ID'
 ,'70'
 ,'1'
 ,'1'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
12 3 4 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -