根据编码查询业务对象表定义信息
简述：
- 根据编码查询业务对象表定义信息
请求URL：
- http://ip:port/ibps/platform/v3/bo/table/getByDefCodeVersion
- URL中的ip需要替换为自己网关ip
- URL中的port需要替换为自己网关端口
请求方式：
- 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：
- http://ip:port/ibps/platform/v3/bo/table/getByDefIdAttrCode
- URL中的ip需要替换为自己网关ip
- URL中的port需要替换为自己网关端口
请求方式：
- 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 | 业务对象属性字段关系对象 |
文档更新时间: 2020-02-06 15:05 作者：朱业成
