致远OA自定义表单，字段信息描述

表名：FORM_DEFINITION

字段信息在field_info列中，保存格式为xml

 

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [ID]
      ,[NAME]
      ,[CREATE_ID]
      ,[CREATE_TIME]
      ,[FORM_TYPE]
      ,[CATEGORY_ID]
      ,[USE_FLAG]
      ,[STATE]
      ,[DELETE_FLAG]
      ,[FIELD_INFO]
      ,[VIEW_INFO]
      ,[QUERY_INFO]
      ,[REPORT_INFO]
      ,[TRIGGER_INFO]
      ,[APPBIND_INFO]
      ,[EXTENSIONS_INFO]
      ,[MODIFY_TIME]
      ,[FORM_STYLE]
      ,[PREPARE_FLAG]
      ,[SOURCE_TYPE]
      ,[FORM_CODE]
      ,[LOG_FIELD_LIST]
      ,[UPGRADE_VERSION]
  FROM [OA].[dbo].[FORM_DEFINITION]

FIELD_INFO
<TableList>    <Table id="6281316996684401518" name="formmain_0001" display="formmain_0001" tabletype="master" onwertable="" onwerfield="">        <FieldList>            <Field id="7834247481623595267" name="id" display="id" fieldtype="long" fieldlength="20" is_null="true" is_primary="true" classname=""/>            <Field id="-250838190161509285" name="state" display="审核状态" fieldtype="int" fieldlength="10" is_null="true" is_primary="false" classname=""/>             <Field id="-2028729455988617895" name="start_member_id" display="发起人" fieldtype="long" fieldlength="20" is_null="true" is_primary="false" classname=""/>            <Field id="1920729986784052617" name="start_date" display="发起时间" fieldtype="DATETIME" fieldlength="" is_null="true" is_primary="false" classname=""/>            <Field id="-3509506703567468381" name="approve_member_id" display="审核人" fieldtype="long" fieldlength="20" is_null="true" is_primary="false" classname=""/>            <Field id="-905095442502369069" name="approve_date" display="审核时间" fieldtype="DATETIME" fieldlength="" is_null="true" is_primary="false" classname=""/>            <Field id="-6661946971681698433" name="finishedflag" display="流程状态" fieldtype="int" fieldlength="10" is_null="true" is_primary="false" classname=""/>            <Field id="4871011523724920827" name="ratifyflag" display="核定状态" fieldtype="int" fieldlength="10" is_null="true" is_primary="false" classname=""/>            <Field id="-1478473161173155808" name="ratify_member_id" display="核定人" fieldtype="long" fieldlength="20" is_null="true" is_primary="false" classname=""/>            <Field id="5299793709067289432" name="ratify_date" display="核定时间" fieldtype="DATETIME" fieldlength="" is_null="true" is_primary="false" classname=""/>                                    <Field id="-4208382467952260799" name="field0001" display="编号" fieldtype="VARCHAR" fieldlength="30,0" is_null="false" is_primary="false" classname=""/>            <Field id="-5533009939779533504" name="field0002" display="填写日期" fieldtype="TIMESTAMP" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="-2032196562016645859" name="field0003" display="基础-姓名" fieldtype="VARCHAR" fieldlength="30,0" is_null="false" is_primary="false" classname=""/>            <Field id="-967535757771583541" name="field0004" display="基础-性别" fieldtype="VARCHAR" fieldlength="30,0" is_null="false" is_primary="false" classname=""/>            <Field id="3816733325281608673" name="field0005" display="基础-民族" fieldtype="VARCHAR" fieldlength="30,0" is_null="false" is_primary="false" classname=""/>            <Field id="-7530103588444026559" name="field0006" display="基础-照片" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="2688798875126874755" name="field0007" display="基础-状态" fieldtype="VARCHAR" fieldlength="30,0" is_null="false" is_primary="false" classname=""/>            <Field id="-3059850052762188427" name="field0008" display="基础-出生日期" fieldtype="TIMESTAMP" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="3466916439142908075" name="field0009" display="基础-年龄" fieldtype="DECIMAL" fieldlength="2,0" is_null="false" is_primary="false" classname=""/>            <Field id="-3918619716235280212" name="field0010" display="基础-政治面貌" fieldtype="VARCHAR" fieldlength="30,0" is_null="false" is_primary="false" classname=""/>            <Field id="-8434239216001923224" name="field0011" display="基础-婚姻状况" fieldtype="VARCHAR" fieldlength="30,0" is_null="false" is_primary="false" classname=""/>            <Field id="1554736576973587272" name="field0012" display="基础-身份证号" fieldtype="VARCHAR" fieldlength="18,0" is_null="false" is_primary="false" classname=""/>            <Field id="4732134798621951595" name="field0013" display="基础-学历" fieldtype="VARCHAR" fieldlength="30,0" is_null="false" is_primary="false" classname=""/>            <Field id="-6559669608608937895" name="field0014" display="基础-毕业院校" fieldtype="VARCHAR" fieldlength="60,0" is_null="false" is_primary="false" classname=""/>            <Field id="-5850198959053586376" name="field0015" display="基础-所学专业" fieldtype="VARCHAR" fieldlength="60,0" is_null="false" is_primary="false" classname=""/>            <Field id="8646043189581138354" name="field0016" display="基础-户籍" fieldtype="VARCHAR" fieldlength="120,0" is_null="false" is_primary="false" classname=""/>            <Field id="6105316737413825756" name="field0017" display="基础-身高" fieldtype="DECIMAL" fieldlength="3,2" is_null="false" is_primary="false" classname=""/>            <Field id="2444046435632041203" name="field0018" display="基础-体重" fieldtype="DECIMAL" fieldlength="3,2" is_null="false" is_primary="false" classname=""/>            <Field id="-3245534315489704203" name="field0019" display="基础-职称资格" fieldtype="VARCHAR" fieldlength="120,0" is_null="false" is_primary="false" classname=""/>            <Field id="-451087883045617512" name="field0020" display="基础-个人简历" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="-9192495040267730210" name="field0021" display="基础-联系电话" fieldtype="VARCHAR" fieldlength="30,0" is_null="false" is_primary="false" classname=""/>            <Field id="6245476184298898637" name="field0022" display="基础-电子邮箱" fieldtype="VARCHAR" fieldlength="90,0" is_null="false" is_primary="false" classname=""/>            <Field id="-2675553703865660838" name="field0023" display="基础-邮政编码" fieldtype="DECIMAL" fieldlength="6,0" is_null="false" is_primary="false" classname=""/>            <Field id="2462013405410378351" name="field0024" display="基础-通讯住址" fieldtype="VARCHAR" fieldlength="120,0" is_null="false" is_primary="false" classname=""/>            <Field id="4520483574102769918" name="field0025" display="基础-其他信息" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="773893282650672248" name="field0026" display="职位-供职部门" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="8380769062256398314" name="field0027" display="职位-岗位职务" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="-457504956327047242" name="field0028" display="职位-兼任部门" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="4295728769604403382" name="field0029" display="职位-兼任职务" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="-2343663930101707079" name="field0030" display="职位-直接上级部门" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="-3996341546138910705" name="field0031" display="职位-直接上级岗位" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="-4670432655284089797" name="field0032" display="职位-职务层级" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="-4347371736110511906" name="field0033" display="职位-入职日期" fieldtype="TIMESTAMP" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="-4913826720189497116" name="field0034" display="职位-试用开始日期" fieldtype="TIMESTAMP" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="-1309464364129697515" name="field0035" display="职位-试用结束日期" fieldtype="TIMESTAMP" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="439457063822313053" name="field0036" display="职位-试用月数" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="3186031235227733619" name="field0037" display="协同帐号-用户" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="6280432891546913560" name="field0038" display="协同帐号-登录名" fieldtype="VARCHAR" fieldlength="15,0" is_null="false" is_primary="false" classname=""/>            <Field id="9113609182794763206" name="field0039" display="协同帐号-密码" fieldtype="VARCHAR" fieldlength="10,0" is_null="false" is_primary="false" classname=""/>            <Field id="7881997540468542219" name="field0040" display="薪资-工资标准" fieldtype="DECIMAL" fieldlength="7,2" is_null="false" is_primary="false" classname=""/>            <Field id="-8247309411663656467" name="field0041" display="薪资-试用期月工资" fieldtype="DECIMAL" fieldlength="7,2" is_null="false" is_primary="false" classname=""/>            <Field id="-2556288976490577269" name="field0042" display="薪资-试用期发放比例" fieldtype="DECIMAL" fieldlength="3,0" is_null="false" is_primary="false" classname=""/>            <Field id="-6058038419977190830" name="field0043" display="薪资-绩效基数" fieldtype="DECIMAL" fieldlength="7,2" is_null="false" is_primary="false" classname=""/>            <Field id="-8287310885697597820" name="field0044" display="薪资-年奖基数" fieldtype="DECIMAL" fieldlength="7,2" is_null="false" is_primary="false" classname=""/>            <Field id="9058690301224504889" name="field0045" display="薪资-交通补贴" fieldtype="DECIMAL" fieldlength="4,0" is_null="false" is_primary="false" classname=""/>            <Field id="-5004684180158133668" name="field0046" display="薪资-通讯补贴" fieldtype="DECIMAL" fieldlength="4,0" is_null="false" is_primary="false" classname=""/>            <Field id="131755481851775981" name="field0047" display="薪资-餐费补贴" fieldtype="DECIMAL" fieldlength="4,0" is_null="false" is_primary="false" classname=""/>            <Field id="4468137471287510291" name="field0048" display="薪资-社保基数" fieldtype="DECIMAL" fieldlength="7,2" is_null="false" is_primary="false" classname=""/>            <Field id="-2086578768261200614" name="field0049" display="薪资-住房公积金基数" fieldtype="DECIMAL" fieldlength="7,2" is_null="false" is_primary="false" classname=""/>            <Field id="-3573495591144700381" name="field0050" display="薪资-住房公积金缴交比例" fieldtype="DECIMAL" fieldlength="3,0" is_null="false" is_primary="false" classname=""/>            <Field id="-2617040610226779681" name="field0051" display="薪资-其他福利" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="7091801089179077604" name="field0052" display="部门负责人意见" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="-5127874104845841818" name="field0053" display="人事部门意见" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="3230663491472018352" name="field0054" display="部门分管领导意见" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="8309764148632175517" name="field0055" display="总经理意见" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="2665598775391110213" name="field0056" display="劳动合同-编号" fieldtype="VARCHAR" fieldlength="90,0" is_null="false" is_primary="false" classname=""/>            <Field id="-1067289625916060964" name="field0057" display="劳动合同-签订日期" fieldtype="TIMESTAMP" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="6799843990616490243" name="field0058" display="劳动合同-期限" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="1046453109113047467" name="field0059" display="劳动合同-开始日期" fieldtype="TIMESTAMP" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="-6261698460866818252" name="field0060" display="劳动合同-结束日期" fieldtype="TIMESTAMP" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>            <Field id="4319276585410315490" name="field0061" display="劳动合同-说明" fieldtype="VARCHAR" fieldlength="255,0" is_null="false" is_primary="false" classname=""/>        </FieldList>        <IndexList>        </IndexList>    </Table>  </TableList>