⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 ui-s-account.sql

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

-- 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
) VALUES (
  '1'
 ,'1'
 ,'AccountHeader'
 ,'Account Header'
 ,'1'
 ,'1'
 ,'3'
 ,'0'
 ,'accountId:accountId'
 ,'"ACCOUNT: ";accountName'
 ,'/sfa/control/accountHeader'
 ,'headerFrame'
 ,'/sfa/control/accountTabs'
 ,'contentFrame'
 ,''
 ,''
 ,'/sfa/control/accountHeader'
 ,'headerFrame'
 ,'/sfa/control/accountHeader'
 ,'headerFrame'
 ,'/sfa/control/accountList'
 ,'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
) VALUES (
  '10030'
 ,'1'
 ,'AccountOpportunityList'
 ,'Account Opportunity List'
 ,'2'
 ,'4'
 ,'0'
 ,'0'
 ,'dealId:dealId'
 ,'"OPPORTUNITIES for Account: ";Account.accountName'
 ,''
 ,''
 ,'/sfa/control/dealHeader'
 ,'headerFrame'
 ,''
 ,''
 ,'/sfa/control/dealHeader'
 ,'headerFrame'
 ,'/sfa/control/dealHeader'
 ,'headerFrame'
 ,'/sfa/control/accountDealList'
 ,'oMIframe'
 ,''
 ,'accountId:accountId'
 ,'accountId:accountId'
 ,'dealName'
 ,'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
) VALUES (
  '10043'
 ,'1'
 ,'AccountActivityList'
 ,'Account Activity List'
 ,'2'
 ,'5'
 ,'0'
 ,'0'
 ,'activityId:activityId'
 ,'"ACTIVITIES for Account: ";Account.accountName'
 ,''
 ,''
 ,'/sfa/control/activityHeader'
 ,'headerFrame'
 ,''
 ,''
 ,'/sfa/control/activityHeader'
 ,'headerFrame'
 ,'/sfa/control/activityHeader'
 ,'headerFrame'
 ,'/sfa/control/accountActivityList'
 ,'oMIframe'
 ,''
 ,'accountId:accountId'
 ,'accountId:accountId'
 ,'openDate;openStartTime;activityName'
 ,'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
) VALUES (
  '10060'
 ,'1'
 ,'AccountContactList'
 ,'Account Contact List'
 ,'2'
 ,'3'
 ,'0'
 ,'0'
 ,'contactId:contactId'
 ,'"CONTACTS for Account: ";Account.accountName'
 ,''
 ,''
 ,'/sfa/control/contactHeader'
 ,'headerFrame'
 ,''
 ,''
 ,'/sfa/control/contactHeader'
 ,'headerFrame'
 ,'/sfa/control/contactHeader'
 ,'headerFrame'
 ,'/sfa/control/accountContactList'
 ,'oMIframe'
 ,''
 ,'accountId:accountId'
 ,'accountId:accountId'
 ,'lastName;firstName'
 ,'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
) VALUES (
  '10071'
 ,'1'
 ,'accountUrlList'
 ,''
 ,'2'
 ,'8'
 ,'1'
 ,'0'
 ,'urlId:urlId'
 ,'"URL Listing"'
 ,'/sfa/control/accountUrlList'
 ,'contentFrame'
 ,'/sfa/control/accountUrlHeader'
 ,'headerFrame'
 ,''
 ,''
 ,''
 ,''
 ,'/sfa/control/accountUrlHeader'
 ,'headerFrame'
 ,''
 ,''
 ,''
 ,'accountId:accountId;contactId:contactId'
 ,'accountId:accountId;contactId:contactId'
 ,''
 ,'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
) VALUES (
  '10072'
 ,'1'
 ,'accountUrlHeader'
 ,''
 ,'1'
 ,'7'
 ,'1'
 ,'0'
 ,'urlId:urlId'
 ,'"URL"'
 ,'/sfa/control/accountUrlHeader'
 ,'headerFrame'
 ,'/sfa/control/accountUrlList'
 ,'contentFrame'
 ,''
 ,''
 ,'/sfa/control/accountUrlHeader'
 ,'headerFrame'
 ,'/sfa/control/accountUrlHeader'
 ,'headerFrame'
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
);

-- 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
) VALUES (
  '10140'
 ,'1'
 ,'AccountOther'
 ,'Account Other Information'
 ,'1'
 ,'6'
 ,'2'
 ,'0'
 ,'accountId:accountId'
 ,'"OTHER INFO for Account: ";Account.accountName'
 ,'/sfa/control/accountOther'
 ,'oMIframe'
 ,''
 ,''
 ,''
 ,''
 ,'/sfa/control/accountOther'
 ,'oMIframe'
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,'Query;New;Copy;Delete;Detail;Cancel'
 ,''
);

-- 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
) VALUES (
  '2'
 ,'1'
 ,'AccountList'
 ,'Account List'
 ,'2'
 ,'2'
 ,'4'
 ,'0'
 ,'accountId:accountId'
 ,'"ACCOUNTS"'
 ,''
 ,''
 ,'/sfa/control/accountHeader'
 ,'headerFrame'
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,'/sfa/control/accountList'
 ,'contentFrame'
 ,'2'
 ,''
 ,''
 ,'accountName'
 ,''
 ,''
);

-- 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 (
  '1'
 ,'1'
 ,'Y'
 ,''
 ,''
 ,''
 ,'1'
 ,'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 (
  '1'
 ,'12'
 ,'Y'
 ,''
 ,''
 ,''
 ,'3'
 ,'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 (
  '1'
 ,'5'
 ,'Y'
 ,''
 ,''
 ,''
 ,'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 (
  '1'
 ,'-1'
 ,'1'
 ,'1'
 ,'60'
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'1'
 ,'Account 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 (
  '1'
 ,'-1'
 ,'11'
 ,'42'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'0'
 ,'Parent Account'
 ,'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 (
  '1'
 ,'-1'
 ,'116'
 ,'10'
 ,'20'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'999'
 ,'Party ID'
 ,'0'
 ,'0'
 ,'0'
);

-- 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 (
  '1'
 ,'-1'
 ,'12'
 ,'1'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'140'
 ,'Phone'
 ,'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 (
  '1'
 ,'-1'
 ,'16'
 ,'29'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'100'
 ,'Stock Symbol'
 ,'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 (
  '1'
 ,'-1'
 ,'17'
 ,'28'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'260'
 ,'URL'
 ,'0'
 ,'2'
 ,'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 (
  '1'
 ,'-1'
 ,'18'
 ,'17'
 ,'60'
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'250'
 ,'Created'
 ,'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 (
  '1'
 ,'-1'
 ,'19'
 ,'21'
 ,'60'
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'999'
 ,'Modified 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 (
  '1'
 ,'-1'
 ,'2'
 ,'2'
 ,'60'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'150'
 ,'Name'
 ,'0'
 ,'2'
 ,'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 (
  '1'
 ,'-1'
 ,'20'
 ,'21'
 ,'60'
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'999'
 ,'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 (
  '1'
 ,'-1'
 ,'201'
 ,'62'
 ,'0'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'410'
 ,'Status'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiScreenSectionInfo

⌨️ 快捷键说明

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