工作区下的表格
| 字段名称 | 字段类型 | 字段说明 |
|---|---|---|
| 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": "因为异常工作流无法删除数据"
}
}