Appearance
协同文档
| luckysheet | 协同文档sheet页配置信息 |
| Fields |
| Field | Type | Collation | Null | Key | Default | Comment | ||
| id | bigint(30) | (NULL) | NO | PRI | (NULL) | |||
| block_id | varchar(200) | utf8mb4_general_ci | NO | MUL | (NULL) | |||
| row_size | int(8) | (NULL) | YES | (NULL) | 行数 | |||
| column_size | int(8) | (NULL) | YES | (NULL) | 列数 | |||
| sheet_index | varchar(200) | utf8mb4_general_ci | NO | (NULL) | ||||
| list_id | varchar(200) | utf8mb4_general_ci | NO | (NULL) | ||||
| status | tinyint(4) | (NULL) | YES | (NULL) | ||||
| sheet_order | int(3) | (NULL) | YES | (NULL) | ||||
| sheet_name | varchar(50) | utf8mb4_general_ci | YES | (NULL) | sheet名称 | |||
| color | varchar(50) | utf8mb4_general_ci | YES | (NULL) | sheet颜色 | |||
| hide | tinyint(4) | (NULL) | YES | 0 | 是否隐藏 0不隐藏 1隐藏 | |||
| merge_info | longtext | utf8mb4_general_ci | YES | (NULL) | 单元格合并信息 | |||
| rowlen | longtext | utf8mb4_general_ci | YES | (NULL) | 行高集合 | |||
| columnlen | longtext | utf8mb4_general_ci | YES | (NULL) | 列宽集合 | |||
| rowhidden | longtext | utf8mb4_general_ci | YES | (NULL) | 隐藏行集合 | |||
| colhidden | longtext | utf8mb4_general_ci | YES | (NULL) | 隐藏列集合 | |||
| border_info | longtext | utf8mb4_general_ci | YES | (NULL) | 边框信息 | |||
| calcChain | longtext | utf8mb4_general_ci | YES | (NULL) | 公式链 | |||
| filter_select | text | utf8mb4_general_ci | YES | (NULL) | 筛选范围 | |||
| filter | text | utf8mb4_general_ci | YES | (NULL) | 筛选的具体设置 | |||
| luckysheet_alternateformat_save | text | armscii8_general_ci | YES | (NULL) | 交替颜色配置 | |||
| luckysheet_conditionformat_save | text | armscii8_general_ci | YES | (NULL) | 条件格式 | |||
| image | text | utf8mb4_general_ci | YES | (NULL) | 图片信息 | |||
| dataVerification | longtext | utf8mb4_general_ci | YES | (NULL) | 数据验证信息 | |||
| frozen | varchar(200) | utf8mb4_general_ci | YES | (NULL) | 冻结信息 | |||
| hyperlink | longtext | utf8mb4_general_ci | YES | (NULL) | 超链接信息 | |||
| del_flag | tinyint(4) | (NULL) | YES | 1 | ||||
| filterrowhidden | text | armscii8_general_ci | YES | (NULL) | 过滤隐藏行 |
| luckysheet_cell | 协同文档单元格数据表 |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| id | bigint(20) | (NULL) | NO | PRI | (NULL) | 主键 | ||
| block_id | varchar(200) | utf8mb4_general_ci | NO | MUL | (NULL) | 协同文档模板id | ||
| row_no | int(8) | (NULL) | YES | (NULL) | 横坐标 | |||
| column_no | int(8) | (NULL) | YES | (NULL) | 纵坐标 | |||
| sheet_index | varchar(200) | utf8mb4_general_ci | NO | (NULL) | sheet页唯一标识 | |||
| list_id | varchar(200) | utf8mb4_general_ci | NO | (NULL) | 文档唯一标识 | |||
| cell_data | text | utf8mb4_general_ci | YES | (NULL) | 单元格数据信息 | |||
| del_flag | tinyint(4) | (NULL) | YES | 1 |
| report_range_auth | 授权范围信息表 |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| id | bigint(20) | (NULL) | NO | PRI | (NULL) | 主键id | ||
| tpl_id | bigint(20) | (NULL) | YES | (NULL) | 模板id | |||
| sheet_id | bigint(20) | (NULL) | YES | (NULL) | sheet页id | |||
| sheet_index | varchar(100) | utf8mb4_bin | YES | (NULL) | sheet页唯一标识 | |||
| range_txt | varchar(100) | utf8_general_ci | YES | (NULL) | 范围 如A1:C1 | |||
| rows_no | varchar(100) | utf8mb4_bin | YES | (NULL) | ||||
| cols_no | varchar(100) | utf8mb4_bin | YES | (NULL) | ||||
| type | tinyint(4) | (NULL) | YES | 1 | 类型 1报表 2协同文档 | |||
| creator | bigint(20) | (NULL) | YES | (NULL) | 创建人 | |||
| create_time | datetime | (NULL) | YES | (NULL) | 创建时间 | |||
| updater | bigint(20) | (NULL) | YES | (NULL) | 更新人 | |||
| update_time | datetime | (NULL) | YES | (NULL) | 更新时间 | |||
| del_flag | tinyint(4) | (NULL) | YES | 1 | 删除标记 1未删除 2已删除 |
| report_range_auth_user | 授权用户表 |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| id | bigint(20) | (NULL) | NO | PRI | 1 | 主键id | ||
| tpl_id | bigint(20) | (NULL) | YES | (NULL) | 模板id | |||
| sheet_id | bigint(20) | (NULL) | YES | (NULL) | sheet页id | |||
| range_auth_id | bigint(20) | (NULL) | YES | (NULL) | 授权范围id | |||
| user_id | bigint(20) | (NULL) | YES | (NULL) | 用户id | |||
| type | tinyint(4) | (NULL) | YES | 1 | 类型 1报表 2协同文档 | |||
| creator | bigint(20) | (NULL) | YES | (NULL) | 创建人 | |||
| create_time | datetime | (NULL) | YES | (NULL) | 创建时间 | |||
| updater | bigint(20) | (NULL) | YES | (NULL) | 更新人 | |||
| update_time | datetime | (NULL) | YES | (NULL) | 更新时间 | |||
| del_flag | tinyint(4) | (NULL) | YES | 1 | 删除标记 1未删除 2已删除 | |||
| auth_type | tinyint(4) | (NULL) | YES | 1 | 授权类型 1编辑权限 2不允许查看 |
| luckysheet_his | 修改历史记录表 |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| id | bigint(20) | (NULL) | NO | PRI | (NULL) | 主键 | ||
| row_no | int(10) | (NULL) | YES | MUL | (NULL) | 行号 | ||
| col_no | int(10) | (NULL) | YES | (NULL) | 列号 | |||
| sheet_index | varchar(200) | armscii8_general_ci | NO | (NULL) | sheet唯一标识 | |||
| list_id | varchar(200) | armscii8_general_ci | NO | (NULL) | 文档唯一标识 | |||
| bson | text | utf8mb4_bin | YES | (NULL) | 本次修改参数 | |||
| before_json | text | utf8mb4_bin | YES | (NULL) | 上次修改参数 | |||
| change_desc | varchar(500) | utf8mb4_bin | YES | (NULL) | 修改描述 | |||
| remark | text | utf8mb4_bin | YES | (NULL) | 备注 | |||
| type | tinyint(4) | (NULL) | YES | 2 | 修改类型 1整体配置修改 2单元格内容修改 | |||
| operate_key | varchar(100) | utf8mb4_bin | YES | (NULL) | 操作key | |||
| operator | varchar(100) | utf8mb4_bin | YES | (NULL) | 操作人 | |||
| creator | bigint(20) | (NULL) | YES | (NULL) | 创建人 | |||
| create_time | datetime | (NULL) | YES | (NULL) | 创建时间 | |||
| updater | bigint(20) | (NULL) | YES | (NULL) | 更新人 | |||
| update_time | datetime | (NULL) | YES | (NULL) | 更新时间 | |||
| del_flag | tinyint(4) | (NULL) | YES | 1 | 删除标记 1未删除 2已删除 |