📄 ui-e-itworkorder.sql

📁 国外的一套开源CRM
💻 SQL
字号:
-- Insert UiEntity
INSERT INTO UI_ENTITY (
  ENTITY_ID
 ,ENTITY_NAME
 ,TABLE_NAME
 ,EXT_TABLE_NAME
 ,DESCRIPTION
) VALUES (
  '10010.10011'
 ,'ItWorkOrder'
 ,'IT_WORK_ORDER'
 ,''
 ,'Work Order'
);

-- 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 (
  '10010.10003'
 ,'10010.10011'
 ,'statusId'
 ,'Work Order Status'
 ,'STATUS_ID'
 ,'7700'
 ,'20'
 ,''
 ,''
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'40'
 ,'Status'
 ,'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 (
  '10010.10019'
 ,'10010.10011'
 ,'workOrderId'
 ,'Work Order ID'
 ,'WORK_ORDER_ID'
 ,'1'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'N'
 ,'10'
 ,'Work Order 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 (
  '10010.10020'
 ,'10010.10011'
 ,'workOrderTypeId'
 ,'Work Order Type ID'
 ,'WORK_ORDER_TYPE_ID'
 ,'1'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'20'
 ,'Work Order Type 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 (
  '10010.10021'
 ,'10010.10011'
 ,'issueItemId'
 ,'Issue Item ID'
 ,'ISSUE_ITEM_ID'
 ,'1'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'30'
 ,'Issue Item 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 (
  '10010.10022'
 ,'10010.10011'
 ,'priorityId'
 ,'Issue Item Priority Id'
 ,'PRIORITY_ID'
 ,'7720'
 ,'20'
 ,''
 ,''
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'60'
 ,'Priority'
 ,'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 (
  '10010.10023'
 ,'10010.10011'
 ,'assignedTo'
 ,'Assigned To'
 ,'ASSIGNED_TO'
 ,'21'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'70'
 ,'Issue Item Assigned To'
 ,'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 (
  '10010.10024'
 ,'10010.10011'
 ,'shortName'
 ,'Short Name'
 ,'SHORT_NAME'
 ,'5'
 ,'255'
 ,''
 ,''
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'80'
 ,'Short Name'
 ,'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 (
  '10010.10025'
 ,'10010.10011'
 ,'dueDate'
 ,'Due Date'
 ,'DUE_DATE'
 ,'18'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'90'
 ,'Due 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 (
  '10010.10026'
 ,'10010.10011'
 ,'completedDate'
 ,'Completed Date'
 ,'COMPLETED_DATE'
 ,'18'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'100'
 ,'Completed 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 (
  '10010.10027'
 ,'10010.10011'
 ,'cancelledDate'
 ,'Canceled Date'
 ,'CANCELLED_DATE'
 ,'18'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'110'
 ,'Canceled 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 (
  '10010.10028'
 ,'10010.10011'
 ,'verified'
 ,'Verified'
 ,'VERIFIED'
 ,'41'
 ,'1'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'120'
 ,'Verified'
 ,'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 (
  '10010.10029'
 ,'10010.10011'
 ,'entryPermission'
 ,'Entry Permission'
 ,'ENTRY_PERMISSION'
 ,'41'
 ,'1'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'130'
 ,'Entry Permission'
 ,'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 (
  '10010.10030'
 ,'10010.10011'
 ,'estimatedHours'
 ,'Estimated Hours'
 ,'ESTIMATED_HOURS'
 ,'26'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'140'
 ,'Estimated Hours'
 ,'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 (
  '10010.10031'
 ,'10010.10011'
 ,'actualHours'
 ,'Actual Hours'
 ,'ACTUAL_HOURS'
 ,'26'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'150'
 ,'Actual Hours'
 ,'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 (
  '10010.10032'
 ,'10010.10011'
 ,'createdBy'
 ,'Created By (Work Order)'
 ,'CREATED_BY'
 ,'17'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'N'
 ,'200'
 ,'Created By'
 ,'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 (
  '10010.10033'
 ,'10010.10011'
 ,'modifiedBy'
 ,'Modified By (Work Order)'
 ,'MODIFIED_BY'
 ,'21'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'N'
 ,'220'
 ,'Modified By'
 ,'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 (
  '10010.10034'
 ,'10010.10011'
 ,'modifiedDate'
 ,'Modified Date (Work Order)'
 ,'MODIFIED_DATE'
 ,'17'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'N'
 ,'230'
 ,'Modified Date'
 ,'120'
 ,'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 (
  '10010.10035'
 ,'10010.10011'
 ,'createdDate'
 ,'Created Date (Work Order)'
 ,'CREATED_DATE'
 ,'10'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'N'
 ,'210'
 ,'Created Date'
 ,'120'
 ,'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 (
  '10010.10036'
 ,'10010.10011'
 ,'repairVendorId'
 ,'Repair Vendor ID'
 ,'REPAIR_VENDOR_ID'
 ,'42'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'170'
 ,'Repair Vendor 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 (
  '10010.10037'
 ,'10010.10011'
 ,'causeVendorId'
 ,'Cause Vendor ID'
 ,'CAUSE_VENDOR_ID'
 ,'42'
 ,'20'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'160'
 ,'Cause Vendor ID'
 ,'80'
 ,'1'
 ,'1'
);
⌨️ 快捷键说明

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