📄 ui-e-contact.sql

📁 国外的一套开源CRM
💻 SQL
📖 第 1 页 / 共 2 页
字号:
12 下一页
-- Insert UiEntity
INSERT INTO UI_ENTITY (
  ENTITY_ID
 ,ENTITY_NAME
 ,TABLE_NAME
 ,EXT_TABLE_NAME
 ,DESCRIPTION
) VALUES (
  '11'
 ,'Contact'
 ,'CONTACT'
 ,''
 ,'Contact'
);

-- 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 (
  '100'
 ,'11'
 ,'assistantName'
 ,'Assistant Name'
 ,'ASSISTANT_NAME'
 ,'2'
 ,'255'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'100'
 ,'Assistant 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 (
  '10000'
 ,'11'
 ,'assistantEmail'
 ,'Assistant E-Mail'
 ,'assistant_email'
 ,'2'
 ,'40'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'280'
 ,'Asst. Email'
 ,'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 (
  '101'
 ,'11'
 ,'assistantPhone'
 ,'Assistant Phone'
 ,'ASSISTANT_PHONE'
 ,'2'
 ,'255'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'110'
 ,'Assistant Phone'
 ,'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 (
  '102'
 ,'11'
 ,'spouseName'
 ,'Spouse Name'
 ,'SPOUSE_NAME'
 ,'2'
 ,'255'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'120'
 ,'Spouse 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 (
  '103'
 ,'11'
 ,'reportsTo'
 ,'Reports To'
 ,'REPORTS_TO'
 ,'2'
 ,'255'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'130'
 ,'Reports To'
 ,'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 (
  '104'
 ,'11'
 ,'painsProfessional'
 ,'Pains Professional'
 ,'PAINS_PROFESSIONAL'
 ,'2'
 ,'255'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'140'
 ,'Professional Pains'
 ,'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 (
  '105'
 ,'11'
 ,'painsPersonal'
 ,'Pains Personal'
 ,'PAINS_PERSONAL'
 ,'2'
 ,'255'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'150'
 ,'Personal Pains'
 ,'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 (
  '106'
 ,'11'
 ,'birthDate'
 ,'Birth Date'
 ,'BIRTH_DATE'
 ,'18'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'250'
 ,'Birth Date'
 ,'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 (
  '107'
 ,'11'
 ,'leadSourceId'
 ,'Lead Source ID (Contact)'
 ,'LEAD_SOURCE_ID'
 ,'1'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'230'
 ,'Lead Source 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 (
  '108'
 ,'11'
 ,'geoId'
 ,'Geo ID'
 ,'GEO_ID'
 ,'1'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'240'
 ,'Geo 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 (
  '109'
 ,'11'
 ,'hireDate'
 ,'Hire Date'
 ,'HIRE_DATE'
 ,'18'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'260'
 ,'Hire Date'
 ,'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 (
  '110'
 ,'11'
 ,'activeFlag'
 ,'Contact Active Flag'
 ,'ACTIVE_FLAG'
 ,'41'
 ,'10'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'270'
 ,'Active'
 ,'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 (
  '111'
 ,'11'
 ,'createdBy'
 ,'Created By (Contact)'
 ,'CREATED_BY'
 ,'1'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'320'
 ,'Created By'
 ,'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 (
  '112'
 ,'11'
 ,'createdDate'
 ,'Created Date (Contact)'
 ,'CREATED_DATE'
 ,'1'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'300'
 ,'Created Date'
 ,'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 (
  '113'
 ,'11'
 ,'modifiedBy'
 ,'Modified By (Contact)'
 ,'MODIFIED_BY'
 ,'1'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'310'
 ,'Modified By'
 ,'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 (
  '114'
 ,'11'
 ,'modifiedDate'
 ,'Modified Date (Contact)'
 ,'MODIFIED_DATE'
 ,'1'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'330'
 ,'Modified Date'
 ,'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
12 下一页
⌨️ 快捷键说明

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