odbtools/odbctest/mql/uino/094.classfield.mql

-- 反复创建和删除相同的类，产生类的字段映射错误

create class if not exists mingdao : / ( )with autosearch=true , version=false , key=manu, alias='mingdao' , namespace='mingdao' ;
create class if not exists /mingdao/project ( 
		attr0				varchar	"项目ID",
		attr1				varchar	"合同编号",
		attr10			varchar	"产品信息（合同）",
		attr100			double	"实施人员成本",
		attr101			double	"开发人员工时",
		attr102			double	"开发人员成本",
		attr103			double	"项目经理工时",
		attr104			double	"项目经理成本",
		attr105			double	"设计人员工时",
		attr106			double	"设计人员成本",
		attr107			double	"模型人员工时",
		attr108			double	"模型人员成本",
		attr109			double	"实习人员工时",
		attr11			varchar	"采纳的技术平台",
		attr110			double	"实习人员成本",
		attr111			double	"其他人员工时（需修改）",
		attr112			double	"其他人员成本（需修改）",
		attr113			double	"总部定制开发总工时",
		attr114			double	"总部定制开发总工时成本",
		attr115			double	"总部建模工时",
		attr116			double	"总部建模成本",
		attr117			double	"总部开发-北京工时",
		attr118			double	"总部开发-北京成本",
		attr119			double	"总部开发-南京武汉工时",
		attr12			varchar	"产品版本",
		attr120			double	"总部开发-南京武汉成本",
		attr121			double	"总部开发-EA工时",
		attr122			double	"总部开发-EA成本",
		attr123			double	"总部开发-设计工时",
		attr124			double	"总部开发-设计成本",
		attr125			double	"总部开发-森学院工时",
		attr126			double	"总部开发-森学院成本",
		attr127			double	"总部开发-U产品研发部开发工时",
		attr128			double	"总部开发-U产品研发部开发工时成本",
		attr129			double	"总部开发-实习人员工时",
		attr13			date	"授权到期日期-1",
		attr130			double	"总部开发-实习人员成本",
		attr131			varchar	"格式调整-2",
		attr132			double	"差旅成本-手工记录(元)",
		attr133			double	"提货成本",
		attr134			double	"外包成本（不含税）",
		attr135			double	"项目总工时",
		attr136			double	"项目总工时成本",
		attr137			double	"其中：项目售后工时",
		attr138			double	"售后工时占比",
		attr139			double	"项目总成本（包含：总工时成本+差旅成本+提货成本）",
		attr14			date	"授权到期日期-2",
		attr140			double	"项目实际公司毛利率",
		attr141			double	"预审事业部毛利率",
		attr142			double	"预审公司毛利率",
		attr143			double	"实际工时VS.预审工时",
		attr144			double	"超额工时占比",
		attr145			double	"实际毛利率VS.预审毛利率",
		attr146			double	"实际毛利率VS.预审毛利率【数值】(%)",
		attr147			varchar	"毛利率说明",
		attr148			date	"毛利差首次低于0%",
		attr149			varchar	"记录rowId",
		attr15			date	"授权到期日期-3",
		attr150			varchar	"里程碑",
		attr151			timestamp	"创建时间",
		attr152			timestamp	"最近修改时间",
		attr16			date	"授权到期日期-4",
		attr17			varchar	"项目整体需求概况",
		attr18			varchar	"干系人管理",
		attr19			varchar	"项目机会名称",
		attr2				varchar	"签约客户名称",
		attr20			varchar	"阶段名称",
		attr21			double	"机会总额",
		attr22			varchar	"责任销售（售前）",
		attr23			varchar	"部门（售前）",
		attr24			varchar	"事业部（售前）",
		attr25			varchar	"项目经理（售前）",
		attr26			date	"申请提前入场时间",
		attr27			date	"预计签约时间",
		attr28			varchar	"售前项目是否可在今年验收",
		attr29			varchar	"售前项目可在今年验收状态",
		attr3				varchar	"项目名称",
		attr30			varchar	"项目经理*",
		attr31			varchar	"非我司交付类型",
		attr32			varchar	"支持售前",
		attr33			varchar	"所属事业部",
		attr34			varchar	"所属部门（销售）",
		attr35			varchar	"销售所在部门",
		attr36			varchar	"TAPD链接（应用交付项目敏捷研发协作地址）",
		attr37			varchar	"是否为大项目",
		attr38			date	"周报更新日期",
		attr39			varchar	"项目活跃度",
		attr4				date	"签约日期",
		attr40			varchar	"项目状态",
		attr41			date	"项目启动时间",
		attr42			date	"项目承诺完成时间",
		attr43			int	"项目完成百分比(%)",
		attr44			date	"项目计划完成时间",
		attr45			date	"项目实际完成时间",
		attr46			date	"进场时间（入场通知书）",
		attr47			int	"延期天数(天)",
		attr48			varchar	"是否延期",
		attr49			int	"checklist提交情况",
		attr5				varchar	"行业",
		attr50			varchar	"计划延期情况说明",
		attr51			int	"提前启动至今天数(天)",
		attr52			int	"提前启动至签约天数(天)",
		attr53			varchar	"验收报告提醒",
		attr54			date	"【PM】预计验收报告签回时间",
		attr55			varchar	"（PM）收入承诺状态",
		attr56			date	"【销售】预计签回验收报告日期",
		attr57			varchar	"（销售）收入承诺状态",
		attr58			date	"项目验收报告时间",
		attr59			varchar	"是否跨期调整",
		attr6				varchar	"合同归档状态",
		attr60			date	"项目完工报告时间",
		attr61			date	"发送预计完成时间",
		attr62			date	"内部启动评审时间",
		attr63			date	"内部结项评审时间",
		attr64			date	"取消/终止时间",
		attr65			varchar	"合同终止/取消原因",
		attr66			double	"合同总金额",
		attr67			double	"不含税总金额",
		attr68			double	"外包实际金额",
		attr69			double	"净合同额",
		attr7				varchar	"原售前项目编号",
		attr70			double	"回款金额",
		attr71			double	"回款比例",
		attr72			int	"剩余未回款金额（元）",
		attr73			varchar	"收入认列依据",
		attr74			date	"收入确认年月",
		attr75			varchar	"已完成里程碑",
		attr76			varchar	"财务回款目标",
		attr77			varchar	"已完成财务目标",
		attr78			double	"预估工时汇总",
		attr79			double	"预估人天汇总",
		attr8				varchar	"项目密级",
		attr80			double	"预估成本汇总",
		attr81			double	"PM-预计工时",
		attr82			double	"实施-预计工时",
		attr83			double	"区域开发-预计工时",
		attr84			double	"设计-预计工时",
		attr85			double	"其他-预计工时",
		attr86			double	"模型-预计工时",
		attr87			double	"总部开发-预计工时",
		attr88			double	"实习-预计工时",
		attr89			int	"PM-预计人天",
		attr9				varchar	"省份",
		attr90			int	"实施-预计人天",
		attr91			int	"区域开发-预计人天",
		attr92			int	"设计-预计人天",
		attr93			int	"其他-预计人天",
		attr94			int	"模型-预计人天",
		attr95			int	"总部开发-预计人天",
		attr96			int	"实习-预计人天",
		attr97			double	"BU交付总工时",
		attr98			double	"BU交付总工时成本",
		attr99			double	"实施人员工时"

		)with  autosearch=true , version=false , key=manu, alias='项目信息' , nickname='mingdao_project' ;
create class if not exists /mingdao/staff ( 
		attr0				varchar	"工号",
		attr1				varchar	"员工姓名",
		attr10			varchar	"职位",
		attr11			varchar	"部门主管",
		attr13			date	"入职日期",
		attr19			varchar	"岗位名称",
		attr2				varchar	"系统账号ID",
		attr20			varchar	"职能侧",
		attr22			varchar	"工时填报类型",
		attr23			varchar	"事业部",
		attr24			varchar	"部门（三级）",
		attr25			varchar	"归属小组（四级）",
		attr3				varchar	"base地",
		attr5				varchar	"二级部门",
		attr6				varchar	"三级部门",
		attr7				varchar	"四级部门",
		attr8				varchar	"五级部门",
		attr9				varchar	"成本中心",
		attr12			double	"手机号码",
		attr14			varchar	"在职状态",
		attr15			varchar	"HR接口人",
		attr16			varchar	"辅助HR接口人",
		attr17			date	"转正日期",
		attr18			date	"离职日期",
		attr21			int	"人天成本(元)",
		attr26			varchar	"城市",
		attr27			varchar	"邮箱",
		attr4				varchar	"一级部门"

		)with autosearch=true , version=false , key=manu, alias='员工信息' , nickname='mingdao_staff' ;
create class if not exists /mingdao/case ( 
		attr0				varchar	"Case编号",
		attr1				varchar	"Case类型",
		attr10			varchar	"Case标签（必填，方案提供人填写）",
		attr11			varchar	"Case解决方式（必填，方案提供人填写）",
		attr12			varchar	"修复状态（漏洞类问题修复完成必填）",
		attr17			varchar	"Case关闭总结（故障问题需填写排查步骤和解决方案）（必填，方案提供人填写）",
		attr19			varchar	"提交时间",
		attr2				varchar	"Case来源",
		attr20			varchar	"最新处理时间",
		attr22			varchar	"初次响应时间",
		attr24			varchar	"初次提交方案时间",
		attr3				varchar	"Case状态",
		attr30			varchar	"关闭时间",
		attr32			varchar	"流转到下一团队",
		attr33			varchar	"内部小组",
		attr34			varchar	"问题初次处理小组",
		attr6				varchar	"故障现象（查看已发生的故障现象，查看现象发生原因及排查步骤解决方法）",
		attr7				varchar	"级别（更新频率）",
		attr8				varchar	"Case主题",
		attr13			varchar	"修复版本/补丁路径（漏洞类问题修复完成必填）",
		attr14			varchar	"问题现象描述",
		attr15			varchar	"Case发生根本原因（必填，方案提供人填写）",
		attr16			varchar	"选择故障原因（可多选）",
		attr18			int	"Case总结对排查手册价值",
		attr21			int	"已经历时长(小时)",
		attr23			int	"初次响应经历时长(分钟)",
		attr25			int	"初次提交方案时长(分钟)",
		attr26			int	"提交方案累积时长（分钟）",
		attr27			int	"响应次数",
		attr28			int	"提交方案次数",
		attr29			int	"打回次数",
		attr31			int	"关闭时长(小时)",
		attr4				varchar	"Case技术分类",
		attr5				date	"期望解决时间",
		attr9				text	"Case/漏洞的详细描述（复现问题操作+解决什么问题）（有的Case描述需要有前后对比判断哪个正常哪个不正常）（信息的完整、清楚、正确有助于排查解决）"

		)with autosearch=true , version=false , key=manu, alias='CASE信息' , nickname='mingdao_case' ;
create class if not exists /mingdao/contract ( 
		attr0				varchar	"合同总表-优-id",
		attr1				varchar	"合同总表-优",
		attr10			varchar	"校企合作项目",
		attr11			varchar	"主题场景",
		attr12			varchar	"项目成本",
		attr19			varchar	"地区",
		attr2				varchar	"合同编号-优",
		attr20			varchar	"事业部",
		attr22			varchar	"部门",
		attr23			varchar	"销售小组",
		attr24			varchar	"组别",
		attr25			varchar	"项目需求描述",
		attr3				varchar	"所属行业",
		attr30			varchar	"合同归档状态-优",
		attr5				varchar	"渠道全称",
		attr6				varchar	"城市",
		attr7				varchar	"集成总包项目金额(元)",
		attr8				varchar	"合同类别",
		attr9				varchar	"是否重点关注",
		attr13			varchar	"行业",
		attr14			varchar	"所在省份",
		attr15			double	"机会总额",
		attr16			double	"不含税额",
		attr17			double	"外包金额(元)",
		attr18			double	"净合同额",
		attr21			varchar	"销售类别",
		attr26			double	"总成本（POC+售前+售后+差旅+总部）不含提货",
		attr27			double	"不含税总金额",
		attr28			double	"项目毛利率：(不含税总额-总成本-外包不含税额)/(不含税-外包/1.06)",
		attr29			double	"赚钱（利润）",
		attr31			double	"回款完成比例-U",
		attr4				varchar	"客户全称"

		)with autosearch=true , version=false , key=manu, alias='合同信息' , nickname='mingdao_contract' ;