📄 ui-e-contact.sql

📁 国外的一套开源CRM
💻 SQL
📖 第 1 页 / 共 2 页
字号:
上一页 12
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '115'
 ,'11'
 ,'statusId'
 ,'Contact Status ID'
 ,'STATUS_ID'
 ,'61'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'35'
 ,'Status'
 ,'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 (
  '84'
 ,'11'
 ,'contactId'
 ,'Contact ID (Contact)'
 ,'CONTACT_ID'
 ,'1'
 ,'20'
 ,''
 ,''
 ,'Y'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'10'
 ,'Contact 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 (
  '85'
 ,'11'
 ,'accountId'
 ,'Contact Account ID'
 ,'ACCOUNT_ID'
 ,'42'
 ,'20'
 ,''
 ,''
 ,'Y'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'20'
 ,'Account 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 (
  '86'
 ,'11'
 ,'contactTypeId'
 ,'Contact Type ID (Contact)'
 ,'CONTACT_TYPE_ID'
 ,'14'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'30'
 ,'Contact Type'
 ,'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 (
  '87'
 ,'11'
 ,'contactAttitudeTypeId'
 ,'Contact Attitude Type ID'
 ,'CONTACT_ATTITUDE_TYPE_ID'
 ,'15'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'40'
 ,'Attitude Type'
 ,'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 (
  '88'
 ,'11'
 ,'contactOwnerId'
 ,'Contact Owner ID'
 ,'CONTACT_OWNER_ID'
 ,'21'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'N'
 ,'90'
 ,'Contact Owner'
 ,'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 (
  '89'
 ,'11'
 ,'roleId'
 ,'Contact Role ID'
 ,'ROLE_ID'
 ,'16'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'50'
 ,'Role'
 ,'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 (
  '90'
 ,'11'
 ,'firstName'
 ,'First Name'
 ,'FIRST_NAME'
 ,'2'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'60'
 ,'First 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 (
  '91'
 ,'11'
 ,'lastName'
 ,'Last Name'
 ,'LAST_NAME'
 ,'2'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'70'
 ,'Last 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 (
  '92'
 ,'11'
 ,'title'
 ,'Title'
 ,'TITLE'
 ,'2'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'80'
 ,'Title'
 ,'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 (
  '93'
 ,'11'
 ,'businessPhone'
 ,'Business Phone'
 ,'BUSINESS_PHONE'
 ,'1'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'160'
 ,'Business 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 (
  '94'
 ,'11'
 ,'businessPhoneExtension'
 ,'Business Phone Extension'
 ,'BUSINESS_PHONE_EXTENSION'
 ,'20'
 ,'5'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'170'
 ,'Business Phone Extension'
 ,'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 (
  '95'
 ,'11'
 ,'mobilePhone'
 ,'Mobile Phone'
 ,'MOBILE_PHONE'
 ,'1'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'180'
 ,'Mobile 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 (
  '96'
 ,'11'
 ,'faxPhone'
 ,'Fax (Contact)'
 ,'FAX_PHONE'
 ,'1'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'190'
 ,'Fax'
 ,'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 (
  '97'
 ,'11'
 ,'pager'
 ,'Pager'
 ,'PAGER'
 ,'1'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'200'
 ,'Pager'
 ,'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 (
  '98'
 ,'11'
 ,'homePhone'
 ,'Home Phone'
 ,'HOME_PHONE'
 ,'1'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'210'
 ,'Home 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 (
  '99'
 ,'11'
 ,'email'
 ,'Email'
 ,'EMAIL'
 ,'2'
 ,'255'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'220'
 ,'Email Address'
 ,'0'
 ,'1'
 ,'1'
);
上一页 12
⌨️ 快捷键说明

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