工作区下的表格

字段名称 字段类型 字段说明
table_id integer 表格ID
name string 表格名称
item_name string 表格数据名称
space_id integer 工作区ID
created_by_id integer 创建人ID
created_on string 创建时间
updated_on string 更新时间
display_in_banner bool 展示在工作区表格栏标识
item_title object 数据标题,默认为第一个字段,可以通过template自定义
icon object 表格图标对应配置
allow_comment bool 允许回复标识
allow_upload_file bool 允许上传文件标识
default_view_id integer 默认视图id
display_filter_field_ids array 展示的可筛选字段列表
hidden_filter_field_ids array 隐藏的可筛选字段列表
search_field_ids array 可用于模糊搜索的字段列表
field_layout array 表格字段顺序配置,必须和fields信息对应,一般为field_id列表
list_layout array 表格字段
layout_fields array 只用作展示的分隔符装饰字段集合
rights array 当前用户的权限列表
allow_order_system_fields array 可以进行排序的系统字段列表
allow_order_fields array 可用于排序的字段列表
is_locked bool 表格被锁定标识
last_view_id integer 最近访问过的视图id
table_share object 表格的三种对外分享设置
permissions array 表格权限,权限对象
app_permissions array 当前表格被应用接管的权限,权限对象
default_app_id integer 默认应用,打开一个表格的时候默认加载的应用
table_app_status string 官方表格应用的开启状态
lock object 表格锁定信息
created_by object 创建人对应的用户对象查,参考user.short实例
fields array 表格字段,参考field实例
exceptions array 表格下操作异常信息集合
{
  "table_id": 11001,
  "name": "table_1",
  "item_name": "table_1_item",
  "space_id": 11001,
  "created_by_id": 11001,
  "created_on": "2015-05-05 16:43:26",
  "updated_on": "2015-05-11 15:10:07",
  "display_in_banner": true,
  "item_title": {
    "type": "first_field",
    "template": ""
  },
  "icon": {
    "id": 1,
    "color": "b",
    "rgb": "#66BB6A"
  },
  "allow_comment": true,
  "allow_upload_file": true,
  "default_view_id": 0,
  "display_filter_field_ids": [
    "created_by",
    "created_on",
    "11001",
    "11002",
    "11020"
  ],
  "hidden_filter_field_ids": [
    11003,
    11004,
    11005,
    11006,
    11007
  ],
  "search_field_ids": [
    11001,
    11003,
    11007
  ],
  "field_layout": [
    11001,
    11002,
    11003,
    11004,
    11005,
    11006,
    11007,
    11020
  ],
  "list_layout": [
    11001,
    11002,
    11003,
    11004,
    11005,
    11006,
    11007,
    11020
  ],
  "layout_fields": [],
  "rights": [
    "update",
    "delete",
    "import",
    "view",
    "manage",
    "item_create",
    "item_update",
    "item_delete",
    "bulk_update",
    "bulk_delete",
    "export"
  ],
  "allow_order_system_fields": [
    {
      "created_on": "创建时间"
    },
    {
      "updated_on": "修改时间"
    },
    {
      "last_activity_on": "最后活跃时间"
    }
  ],
  "allow_order_fields": [
    11001,
    11002,
    11003,
    11004,
    11005,
    11006,
    11007,
    11020,
    2008002001000000,
    11003,
    11005,
    11007
  ],
  "is_locked": false,
  "last_view_id": 0,
  "share": {
    "open": false
  },
  "table_share": {
    "open": false,
    "settings": null
  },
  "default_app_id": 0,
  "table_app_status": "enable",
  "lock": {
    "permission": 0,
    "item_delete": 0
  },
  "created_by": {
    "user_id": 11001,
    "name": "test1",
    "avatar": "https:\/\/hb-static.oss-cn-hangzhou.aliyuncs.com\/app\/assets\/images\/avatar\/no_photo_large.png"
  },
  "fields": [
    {
      "field_id": 11001,
      "table_id": 11001,
      "type": "text",
      "name": "第一个测纯文本",
      "description": "",
      "unique": false,
      "required": false,
      "default_setting": {
        "value": null
      },
      "config": {
        "type": "rich"
      },
      "range": null,
      "is_attach_field": false,
      "attach_relation_field": null,
      "include_attach_field_ids": [],
      "app_id": 0,
      "application_alias": null,
      "lock": {
        "update": 0,
        "delete": 0,
        "item_update": 0
      },
      "allow_update": true
    },
    {
      "field_id": 11002,
      "table_id": 11001,
      "type": "user",
      "name": "联系人",
      "description": "",
      "unique": false,
      "required": false,
      "default_setting": {
        "value": null
      },
      "config": {
        "type": "single"
      },
      "range": null,
      "is_attach_field": false,
      "attach_relation_field": null,
      "include_attach_field_ids": [],
      "app_id": 0,
      "application_alias": null,
      "lock": {
        "update": 0,
        "delete": 0,
        "item_update": 0
      },
      "allow_update": true
    },
    {
      "field_id": 11003,
      "table_id": 11001,
      "type": "number",
      "name": "数字",
      "description": "",
      "unique": false,
      "required": false,
      "default_setting": {
        "value": null
      },
      "config": {
        "precision": 2,
        "unit_name": "yuan",
        "unit_position": "prefix",
        "display_mode": "number"
      },
      "range": null,
      "is_attach_field": false,
      "attach_relation_field": null,
      "include_attach_field_ids": [],
      "app_id": 0,
      "application_alias": null,
      "lock": {
        "update": 0,
        "delete": 0,
        "item_update": 0
      },
      "allow_update": true
    },
    {
      "field_id": 11004,
      "table_id": 11001,
      "type": "category",
      "name": "分类",
      "description": "",
      "unique": false,
      "required": false,
      "default_setting": {
        "value": null
      },
      "config": {
        "type": "single",
        "options": [
          {
            "id": 1,
            "name": "完成",
            "color": "a",
            "status": "active"
          },
          {
            "id": 2,
            "name": "未完成",
            "color": "d",
            "status": "active"
          }
        ],
        "colorful": false,
        "display_mode": "select"
      },
      "range": null,
      "is_attach_field": false,
      "attach_relation_field": null,
      "include_attach_field_ids": [],
      "app_id": 0,
      "application_alias": null,
      "lock": {
        "update": 0,
        "delete": 0,
        "item_update": 0
      },
      "allow_update": true
    },
    {
      "field_id": 11005,
      "table_id": 11001,
      "type": "date",
      "name": "日期",
      "description": "",
      "unique": false,
      "required": false,
      "default_setting": {
        "value": null
      },
      "config": {
        "type": "date"
      },
      "range": null,
      "is_attach_field": false,
      "attach_relation_field": null,
      "include_attach_field_ids": [],
      "app_id": 0,
      "application_alias": null,
      "lock": {
        "update": 0,
        "delete": 0,
        "item_update": 0
      },
      "allow_update": true
    },
    {
      "field_id": 11006,
      "table_id": 11001,
      "type": "image",
      "name": "图片",
      "description": "",
      "unique": false,
      "required": false,
      "default_setting": {
        "value": null
      },
      "config": {
        "type": "multi"
      },
      "range": null,
      "is_attach_field": false,
      "attach_relation_field": null,
      "include_attach_field_ids": [],
      "app_id": 0,
      "application_alias": null,
      "lock": {
        "update": 0,
        "delete": 0,
        "item_update": 0
      },
      "allow_update": true
    },
    {
      "field_id": 11007,
      "table_id": 11001,
      "type": "calculation",
      "name": "计算",
      "description": "",
      "unique": false,
      "required": false,
      "default_setting": {
        "value": null
      },
      "config": {
        "formula": "1+1",
        "item_field": "cal0",
        "precision": 2,
        "unit_name": "yuan",
        "values": [],
        "display_mode": "number",
        "unit_position": "prefix"
      },
      "range": null,
      "is_attach_field": false,
      "attach_relation_field": null,
      "include_attach_field_ids": [],
      "app_id": 0,
      "application_alias": null,
      "lock": {
        "update": 0,
        "delete": 0,
        "item_update": 0
      },
      "allow_update": false
    },
    {
      "field_id": 11020,
      "table_id": 11001,
      "type": "relation",
      "name": "关联",
      "description": "",
      "unique": false,
      "required": false,
      "default_setting": {
        "value": null
      },
      "config": {
        "type": "single",
        "table_id": 11002,
        "filter": [],
        "attachable": true,
        "display_attach_field_ids": [
          2001000000000000
        ],
        "column_name": "relation_id1",
        "table": {
          "table_id": 11002,
          "name": "app_2",
          "item_name": "app_2_item",
          "space_id": 11001,
          "created_by_id": 11001,
          "created_on": "2015-05-05 16:43:26",
          "updated_on": "0000-00-00 00:00:00",
          "display_in_banner": true,
          "item_title": {
            "type": "first_field",
            "template": ""
          },
          "icon": {
            "id": 1,
            "color": "b",
            "rgb": "#66BB6A"
          },
          "allow_comment": true,
          "allow_upload_file": true,
          "default_view_id": 0,
          "display_filter_field_ids": [
            "created_by",
            "created_on",
            "11008",
            "11009"
          ],
          "hidden_filter_field_ids": [],
          "search_field_ids": [
            11008
          ],
          "field_layout": [
            11008,
            11009
          ],
          "list_layout": [
            11008,
            11009
          ],
          "layout_fields": [],
          "rights": [
            "update",
            "delete",
            "import",
            "view",
            "manage",
            "item_create",
            "item_update",
            "item_delete",
            "bulk_update",
            "bulk_delete",
            "export"
          ],
          "allow_order_system_fields": [
            {
              "created_on": "创建时间"
            },
            {
              "updated_on": "修改时间"
            },
            {
              "last_activity_on": "最后活跃时间"
            }
          ],
          "allow_order_fields": [
            11008,
            11009
          ],
          "is_locked": false,
          "last_view_id": 0,
          "share": {
            "open": false
          },
          "table_share": {
            "open": false,
            "settings": null
          },
          "default_app_id": 0,
          "table_app_status": "enable",
          "lock": {
            "permission": 0,
            "item_delete": 0
          },
          "created_by": {
            "user_id": 11001,
            "name": "test1",
            "avatar": "https:\/\/hb-static.oss-cn-hangzhou.aliyuncs.com\/app\/assets\/images\/avatar\/no_photo_large.png"
          },
          "fields": [
            {
              "field_id": 11018,
              "table_id": 11002,
              "type": "text",
              "name": "文本",
              "description": "",
              "unique": false,
              "required": false,
              "default_setting": {
                "value": null
              },
              "range": null,
              "is_attach_field": false,
              "attach_relation_field": null,
              "include_attach_field_ids": [],
              "app_id": 0,
              "application_alias": null,
              "lock": {
                "update": 0,
                "delete": 0,
                "item_update": 0
              },
              "allow_update": true
            },
            {
              "field_id": 11009,
              "table_id": 11002,
              "type": "relation",
              "name": "关联",
              "description": "",
              "unique": false,
              "required": false,
              "default_setting": {
                "value": null
              },
              "range": null,
              "is_attach_field": false,
              "attach_relation_field": null,
              "include_attach_field_ids": [],
              "app_id": 0,
              "application_alias": null,
              "lock": {
                "update": 0,
                "delete": 0,
                "item_update": 0
              },
              "allow_update": true
            }
          ]
        },
        "inner_filter": []
      },
      "range": null,
      "is_attach_field": false,
      "attach_relation_field": null,
      "include_attach_field_ids": [
        2008002001000000
      ],
      "app_id": 0,
      "application_alias": null,
      "lock": {
        "update": 0,
        "delete": 0,
        "item_update": 0
      },
      "allow_update": true
    },
    {
      "field_id": 2008002001000000,
      "table_id": 11001,
      "type": "text",
      "name": "文本",
      "description": "",
      "unique": false,
      "required": false,
      "default_setting": {
        "value": null
      },
      "config": {
        "type": "input"
      },
      "range": null,
      "is_attach_field": true,
      "attach_relation_field": {
        "field_id": 11020,
        "name": "关联",
        "relation_table": {
          "table_id": 11002,
          "name": "app_2",
          "icon": {
            "id": 1,
            "color": "b"
          }
        },
        "attach_relation_field": null
      },
      "include_attach_field_ids": [],
      "app_id": null,
      "application_alias": null,
      "lock": {
        "update": 0,
        "delete": 0,
        "item_update": 0
      },
      "allow_update": false
    }
  ],
  "exceptions": {
    "item_create": "因为异常工作流无法创建数据",
    "item_update": "因为异常工作流无法更新数据",
    "item_delete": "因为异常工作流无法删除数据"
  }
}