ui-e-teammember.sql

来自「国外的一套开源CRM」· SQL 代码 · 共 403 行

-- Insert UiEntity
INSERT INTO UI_ENTITY (
  ENTITY_ID
 ,ENTITY_NAME
 ,TABLE_NAME
 ,EXT_TABLE_NAME
 ,DESCRIPTION
) VALUES (
  '10002'
 ,'TeamMember'
 ,'TEAM_MEMBER'
 ,''
 ,'Team Member'
);

-- 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 (
  '10060'
 ,'10002'
 ,'teamMemberRoleId'
 ,'Team Member Role ID'
 ,'TEAM_MEMBER_ROLE_ID'
 ,'1'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'30'
 ,'Team Member Role ID'
 ,'80'
 ,'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 (
  '10061'
 ,'10002'
 ,'teamId'
 ,'Team ID'
 ,'TEAM_ID'
 ,'10'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'N'
 ,'N'
 ,'N'
 ,'20'
 ,'Team ID'
 ,'80'
 ,'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 (
  '10062'
 ,'10002'
 ,'teamOwner'
 ,'Team Owner'
 ,'TEAM_OWNER'
 ,'21'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'40'
 ,'Team Owner'
 ,'80'
 ,'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 (
  '10063'
 ,'10002'
 ,'partyId'
 ,'Party ID'
 ,'PARTY_ID'
 ,'1'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'N'
 ,'N'
 ,'N'
 ,'50'
 ,'Party ID'
 ,'80'
 ,'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 (
  '10064'
 ,'10002'
 ,'createdDate'
 ,'Created Date'
 ,'CREATED_DATE'
 ,'17'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'N'
 ,'60'
 ,'Created Date'
 ,'80'
 ,'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 (
  '10065'
 ,'10002'
 ,'modifiedDate'
 ,'Modified Date'
 ,'MODIFIED_DATE'
 ,'17'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'N'
 ,'70'
 ,'Modified Date'
 ,'80'
 ,'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 (
  '10066'
 ,'10002'
 ,'createdBy'
 ,'Created By'
 ,'CREATED_BY'
 ,'21'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'N'
 ,'80'
 ,'Created By'
 ,'100'
 ,'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 (
  '10067'
 ,'10002'
 ,'modifiedBy'
 ,'Modified By'
 ,'MODIFIED_BY'
 ,'21'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'N'
 ,'90'
 ,'Modified By'
 ,'100'
 ,'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 (
  '400'
 ,'10002'
 ,'teamMemberId'
 ,'Team Member Id'
 ,'TEAM_MEMBER_ID'
 ,'1'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,''
 ,''
 ,'10'
 ,'Team Member Id'
 ,'0'
 ,'1'
 ,'1'
);