作者:管理员  历史版本:1  最后编辑:龚清  更新时间:2024-09-20 15:13

根据编码查询业务对象表定义信息

简述:

  • 根据编码查询业务对象表定义信息

请求URL:

请求方式:

  • GET

请求参数:

  • Headers:
名称 类型 是否必须 默认值 备注 其他信息
X-Authorization-access_token String 系统令牌
  • Query:
名称 类型 是否必须 默认值 备注 其他信息
boCode String 业务对象定义编码
boVersion integer 业务对象定义版本
  • Body:

暂无

请求参数示例:

http://192.168.3.230:15100/ibps/business/v3/bo/table/getByDefCodeVersion?boCode=qjsqbd&boVersion=1

返回示例:

{
    "state": 200,
    "request": null,
    "message": "",
    "cause": "",
    "variables": {},
    "data": {
        "pk": "",
        "name": "qjsqbd",
        "ip": null,
        "createBy": "1",
        "createTime": 1580780345000,
        "updateBy": null,
        "updateTime": null,
        "tenantId": null,
        "dataStatus": null,
        "dbtype": null,
        "id": "674187160672272384",
        "defCode": "qjsqbd",
        "defVersion": 1,
        "comment": "请假申请表单",
        "desc": "请假申请表单",
        "isExternal": "N",
        "dsAlias": "",
        "pkColumn": "id_",
        "tableType": "object",
        "dsName": null,
        "parentId": null,
        "fkColumn": null,
        "fkRelColumn": null,
        "fromColumn": null,
        "relation": null,
        "path": null,
        "bizId": null,
        "columnList": [
            {
                "pk": "",
                "name": "id_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187160915542016",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "主键",
                "desc": "主键",
                "isPk": "Y",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": null,
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 0,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "id",
                "updateNull": false,
                "format": null
            },
            {
                "pk": "",
                "name": "tenant_id_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161003622400",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "租户ID",
                "desc": "租户ID",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 1,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "tenantId",
                "updateNull": false,
                "format": ""
            },
            {
                "pk": "",
                "name": "ip_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161066536960",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "IP地址",
                "desc": "IP地址",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 15,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 3,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "ip",
                "updateNull": false,
                "format": ""
            },
            {
                "pk": "",
                "name": "create_by_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161133645824",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "创建人",
                "desc": "创建人",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 5,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "createBy",
                "updateNull": false,
                "format": ""
            },
            {
                "pk": "",
                "name": "create_time_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161200754688",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "创建时间",
                "desc": "创建时间",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 7,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "createTime",
                "updateNull": false,
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            {
                "pk": "",
                "name": "update_by_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161272057856",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "更新人",
                "desc": "更新人",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 9,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "updateBy",
                "updateNull": false,
                "format": ""
            },
            {
                "pk": "",
                "name": "update_time_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161343361024",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "更新时间",
                "desc": "更新时间",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 11,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "updateTime",
                "updateNull": false,
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            {
                "pk": "",
                "name": "xing_ming_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161410469888",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "姓名",
                "desc": "姓名",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 13,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "xingMing",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "bu_men_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161477578752",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "部门",
                "desc": "部门",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 15,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "buMen",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "lei_bie_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161553076224",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "类别",
                "desc": "类别",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 17,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "leiBie",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "shi_you_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161632768000",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "事由",
                "desc": "事由",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "clob",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 19,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "shiYou",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "qi_shi_shi_jian_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161699876864",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "起始时间",
                "desc": "起始时间",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 21,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "qiShiShiJian",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "jie_shu_ri_qi_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161766985728",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "结束日期",
                "desc": "结束日期",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 23,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "jieShuRiQi",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "tian_shu_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161834094592",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "天数",
                "desc": "天数",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "number",
                "charLen": 0,
                "intLen": 20,
                "decimalLen": 0,
                "label": null,
                "index": 25,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "tianShu",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "dai_li_ren_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161901203456",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "职务代理人",
                "desc": "职务代理人",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 27,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "zhiWuDaiLiRen",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "zhi_shu_zhu_guan_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161968312320",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "直属主管",
                "desc": "直属主管",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 29,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "zhiShuZhuGuan",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "bu_men_jing_li_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187162039615488",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "部门经理",
                "desc": "部门经理",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 31,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "buMenJingLi",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "zong_jing_li_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187162102530048",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "总经理",
                "desc": "总经理",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 33,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "zongJingLi",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            }
        ],
        "boColumnLists": [],
        "boColumnList": [
            {
                "pk": "",
                "name": "id_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187160915542016",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "主键",
                "desc": "主键",
                "isPk": "Y",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": null,
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 0,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "id",
                "updateNull": false,
                "format": null
            },
            {
                "pk": "",
                "name": "tenant_id_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161003622400",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "租户ID",
                "desc": "租户ID",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 1,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "tenantId",
                "updateNull": false,
                "format": ""
            },
            {
                "pk": "",
                "name": "ip_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161066536960",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "IP地址",
                "desc": "IP地址",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 15,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 3,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "ip",
                "updateNull": false,
                "format": ""
            },
            {
                "pk": "",
                "name": "create_by_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161133645824",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "创建人",
                "desc": "创建人",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 5,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "createBy",
                "updateNull": false,
                "format": ""
            },
            {
                "pk": "",
                "name": "create_time_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161200754688",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "创建时间",
                "desc": "创建时间",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 7,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "createTime",
                "updateNull": false,
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            {
                "pk": "",
                "name": "update_by_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161272057856",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "更新人",
                "desc": "更新人",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 9,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "updateBy",
                "updateNull": false,
                "format": ""
            },
            {
                "pk": "",
                "name": "update_time_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161343361024",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "更新时间",
                "desc": "更新时间",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 11,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "updateTime",
                "updateNull": false,
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            {
                "pk": "",
                "name": "xing_ming_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161410469888",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "姓名",
                "desc": "姓名",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 13,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "xingMing",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "bu_men_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161477578752",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "部门",
                "desc": "部门",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 15,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "buMen",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "lei_bie_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161553076224",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "类别",
                "desc": "类别",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 17,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "leiBie",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "shi_you_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161632768000",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "事由",
                "desc": "事由",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "clob",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 19,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "shiYou",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "qi_shi_shi_jian_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161699876864",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "起始时间",
                "desc": "起始时间",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 21,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "qiShiShiJian",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "jie_shu_ri_qi_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161766985728",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "结束日期",
                "desc": "结束日期",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 23,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "jieShuRiQi",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "tian_shu_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161834094592",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "天数",
                "desc": "天数",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "number",
                "charLen": 0,
                "intLen": 20,
                "decimalLen": 0,
                "label": null,
                "index": 25,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "tianShu",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "dai_li_ren_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161901203456",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "职务代理人",
                "desc": "职务代理人",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 27,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "zhiWuDaiLiRen",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "zhi_shu_zhu_guan_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161968312320",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "直属主管",
                "desc": "直属主管",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 29,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "zhiShuZhuGuan",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "bu_men_jing_li_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187162039615488",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "部门经理",
                "desc": "部门经理",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 31,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "buMenJingLi",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            {
                "pk": "",
                "name": "zong_jing_li_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187162102530048",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "总经理",
                "desc": "总经理",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 33,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "zongJingLi",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            }
        ],
        "subTableList": [],
        "add": true,
        "primayKey": [
            {
                "pk": "",
                "name": "id_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187160915542016",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "主键",
                "desc": "主键",
                "isPk": "Y",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": null,
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 0,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "id",
                "updateNull": false,
                "format": null
            }
        ],
        "foreignKey": [],
        "columnMap": {
            "buMenJingLi": {
                "pk": "",
                "name": "bu_men_jing_li_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187162039615488",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "部门经理",
                "desc": "部门经理",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 31,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "buMenJingLi",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "bu_men_": {
                "pk": "",
                "name": "bu_men_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161477578752",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "部门",
                "desc": "部门",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 15,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "buMen",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "create_by_": {
                "pk": "",
                "name": "create_by_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161133645824",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "创建人",
                "desc": "创建人",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 5,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "createBy",
                "updateNull": false,
                "format": ""
            },
            "shi_you_": {
                "pk": "",
                "name": "shi_you_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161632768000",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "事由",
                "desc": "事由",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "clob",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 19,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "shiYou",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "leiBie": {
                "pk": "",
                "name": "lei_bie_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161553076224",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "类别",
                "desc": "类别",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 17,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "leiBie",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "tenant_id_": {
                "pk": "",
                "name": "tenant_id_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161003622400",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "租户ID",
                "desc": "租户ID",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 1,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "tenantId",
                "updateNull": false,
                "format": ""
            },
            "zong_jing_li_": {
                "pk": "",
                "name": "zong_jing_li_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187162102530048",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "总经理",
                "desc": "总经理",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 33,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "zongJingLi",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "update_by_": {
                "pk": "",
                "name": "update_by_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161272057856",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "更新人",
                "desc": "更新人",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 9,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "updateBy",
                "updateNull": false,
                "format": ""
            },
            "qiShiShiJian": {
                "pk": "",
                "name": "qi_shi_shi_jian_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161699876864",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "起始时间",
                "desc": "起始时间",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 21,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "qiShiShiJian",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "updateBy": {
                "pk": "",
                "name": "update_by_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161272057856",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "更新人",
                "desc": "更新人",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 9,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "updateBy",
                "updateNull": false,
                "format": ""
            },
            "zhiShuZhuGuan": {
                "pk": "",
                "name": "zhi_shu_zhu_guan_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161968312320",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "直属主管",
                "desc": "直属主管",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 29,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "zhiShuZhuGuan",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "update_time_": {
                "pk": "",
                "name": "update_time_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161343361024",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "更新时间",
                "desc": "更新时间",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 11,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "updateTime",
                "updateNull": false,
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            "buMen": {
                "pk": "",
                "name": "bu_men_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161477578752",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "部门",
                "desc": "部门",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 15,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "buMen",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "ip_": {
                "pk": "",
                "name": "ip_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161066536960",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "IP地址",
                "desc": "IP地址",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 15,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 3,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "ip",
                "updateNull": false,
                "format": ""
            },
            "lei_bie_": {
                "pk": "",
                "name": "lei_bie_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161553076224",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "类别",
                "desc": "类别",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 17,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "leiBie",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "id": {
                "pk": "",
                "name": "id_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187160915542016",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "主键",
                "desc": "主键",
                "isPk": "Y",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": null,
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 0,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "id",
                "updateNull": false,
                "format": null
            },
            "jie_shu_ri_qi_": {
                "pk": "",
                "name": "jie_shu_ri_qi_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161766985728",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "结束日期",
                "desc": "结束日期",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 23,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "jieShuRiQi",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "xingMing": {
                "pk": "",
                "name": "xing_ming_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161410469888",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "姓名",
                "desc": "姓名",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 13,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "xingMing",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "tian_shu_": {
                "pk": "",
                "name": "tian_shu_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161834094592",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "天数",
                "desc": "天数",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "number",
                "charLen": 0,
                "intLen": 20,
                "decimalLen": 0,
                "label": null,
                "index": 25,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "tianShu",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "id_": {
                "pk": "",
                "name": "id_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187160915542016",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "主键",
                "desc": "主键",
                "isPk": "Y",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": null,
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 0,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "id",
                "updateNull": false,
                "format": null
            },
            "ip": {
                "pk": "",
                "name": "ip_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161066536960",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "IP地址",
                "desc": "IP地址",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 15,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 3,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "ip",
                "updateNull": false,
                "format": ""
            },
            "updateTime": {
                "pk": "",
                "name": "update_time_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161343361024",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "更新时间",
                "desc": "更新时间",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 11,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "updateTime",
                "updateNull": false,
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            "shiYou": {
                "pk": "",
                "name": "shi_you_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161632768000",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "事由",
                "desc": "事由",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "clob",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 19,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "shiYou",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "jieShuRiQi": {
                "pk": "",
                "name": "jie_shu_ri_qi_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161766985728",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "结束日期",
                "desc": "结束日期",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 23,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "jieShuRiQi",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "create_time_": {
                "pk": "",
                "name": "create_time_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161200754688",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "创建时间",
                "desc": "创建时间",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 7,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "createTime",
                "updateNull": false,
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            "createBy": {
                "pk": "",
                "name": "create_by_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161133645824",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "创建人",
                "desc": "创建人",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 5,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "createBy",
                "updateNull": false,
                "format": ""
            },
            "zongJingLi": {
                "pk": "",
                "name": "zong_jing_li_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187162102530048",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "总经理",
                "desc": "总经理",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 33,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "zongJingLi",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "createTime": {
                "pk": "",
                "name": "create_time_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161200754688",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "创建时间",
                "desc": "创建时间",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 7,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "createTime",
                "updateNull": false,
                "format": "yyyy-MM-dd HH:mm:ss"
            },
            "zhiWuDaiLiRen": {
                "pk": "",
                "name": "dai_li_ren_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161901203456",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "职务代理人",
                "desc": "职务代理人",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 27,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "zhiWuDaiLiRen",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "bu_men_jing_li_": {
                "pk": "",
                "name": "bu_men_jing_li_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187162039615488",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "部门经理",
                "desc": "部门经理",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 31,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "buMenJingLi",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "tianShu": {
                "pk": "",
                "name": "tian_shu_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161834094592",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "天数",
                "desc": "天数",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "number",
                "charLen": 0,
                "intLen": 20,
                "decimalLen": 0,
                "label": null,
                "index": 25,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "tianShu",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "zhi_shu_zhu_guan_": {
                "pk": "",
                "name": "zhi_shu_zhu_guan_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161968312320",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "直属主管",
                "desc": "直属主管",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 29,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "zhiShuZhuGuan",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "tenantId": {
                "pk": "",
                "name": "tenant_id_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161003622400",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "租户ID",
                "desc": "租户ID",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 64,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 1,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "tenantId",
                "updateNull": false,
                "format": ""
            },
            "qi_shi_shi_jian_": {
                "pk": "",
                "name": "qi_shi_shi_jian_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161699876864",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "起始时间",
                "desc": "起始时间",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "date",
                "charLen": 0,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 21,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "qiShiShiJian",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "xing_ming_": {
                "pk": "",
                "name": "xing_ming_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161410469888",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "姓名",
                "desc": "姓名",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 13,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "xingMing",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            },
            "dai_li_ren_": {
                "pk": "",
                "name": "dai_li_ren_",
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "674187161901203456",
                "tableId": "674187160672272384",
                "tableName": "qjsqbd",
                "comment": "职务代理人",
                "desc": "职务代理人",
                "isPk": "N",
                "isFk": "N",
                "isNull": "Y",
                "defaultValue": "",
                "columnType": "varchar",
                "charLen": 200,
                "intLen": 0,
                "decimalLen": 0,
                "label": null,
                "index": 27,
                "fkRefTable": null,
                "fkRefColumn": null,
                "status": null,
                "skip": false,
                "defId": "674187133874864128",
                "attrCode": "zhiWuDaiLiRen",
                "updateNull": false,
                "format": "yyyy-MM-dd"
            }
        }
    }
}

返回参数说明:

名称 类型 备注
data BoTablePo 物理表对象

根据业务对象定义字段名查询关联信息

简述:

  • 根据业务对象定义字段名查询关联信息

请求URL:

请求方式:

  • GET

请求参数:

  • Headers:
名称 类型 是否必须 默认值 备注 其他信息
X-Authorization-access_token String 系统令牌
  • Query:
名称 类型 是否必须 默认值 备注 其他信息
attrCode String 字段名
defId String 业务对象定义ID
  • Body:

暂无

请求参数示例:

http://192.168.3.230:15100/ibps/business/v3/bo/table/getByDefIdAttrCode?attrCode=id&defId=674187133874864128

返回示例:

{
    "state": 200,
    "request": null,
    "message": "",
    "cause": "",
    "variables": {},
    "data": {
        "pk": "",
        "name": null,
        "ip": null,
        "createBy": null,
        "createTime": null,
        "updateBy": null,
        "updateTime": null,
        "tenantId": null,
        "dataStatus": null,
        "dbtype": null,
        "id": "674187135472893952",
        "defId": "674187133874864128",
        "attrCode": "id",
        "tableId": "674187160672272384",
        "fieldName": "id_"
    }
}

返回参数说明:

名称 类型 备注
data BoAttrColumnPo 业务对象属性字段关系对象