Appearance
数据源管理
| report_datasource | 报表数据源 |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| id | bigint(20) | (NULL) | NO | PRI | (NULL) | 主键id | ||
| merchant_no | varchar(20) | utf8_general_ci | YES | (NULL) | 商户号 | |||
| code | varchar(50) | utf8_general_ci | YES | (NULL) | 编码 | |||
| name | varchar(40) | utf8_general_ci | YES | (NULL) | 数据库名称 | |||
| type | tinyint(4) | (NULL) | YES | (NULL) | 数据库类型 1mysql 2oracle 3 sqlserver 4api | |||
| driver_class | varchar(100) | utf8_general_ci | YES | 驱动 | ||||
| jdbc_url | varchar(500) | utf8_general_ci | YES | (NULL) | 数据库链接url | |||
| user_name | varchar(40) | utf8_general_ci | YES | (NULL) | 登录名 | |||
| password | varchar(50) | utf8_general_ci | YES | (NULL) | 密码 | |||
| api_columns_prefix | varchar(200) | utf8_general_ci | YES | (NULL) | 属性前缀 | |||
| api_columns | text | utf8_general_ci | YES | (NULL) | api返回列 | |||
| api_result_type | varchar(20) | utf8_general_ci | YES | (NULL) | api返回类型 String Array ObjectArray Object | |||
| api_request_type | varchar(10) | utf8_general_ci | YES | post | 请求方式 post get | |||
| api_request_header | text | utf8_general_ci | 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已删除 |
| report_datasource_dict_type | 数据源数据字典类型表 |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| id | bigint(20) | (NULL) | NO | PRI | (NULL) | 主键 | ||
| datasource_id | bigint(20) | (NULL) | YES | (NULL) | 数据源id | |||
| dict_name | varchar(100) | utf8mb4_general_ci | YES | (NULL) | 字典类型名称 | |||
| dict_type | varchar(100) | utf8mb4_general_ci | YES | 字典类型 | ||||
| remark | varchar(200) | utf8mb4_general_ci | 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已删除 | |||
| merchant_no | varchar(20) | utf8_general_ci | YES | (NULL) | 商户号 |
| report_datasource_dict_data | 数据源字典值表 |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| id | bigint(20) | (NULL) | NO | PRI | (NULL) | 主键 | ||
| datasource_id | bigint(20) | (NULL) | YES | (NULL) | 数据源id | |||
| dict_label | varchar(100) | utf8mb4_general_ci | YES | 字典标签 | ||||
| dict_value | varchar(100) | utf8mb4_general_ci | YES | 字典键值 | ||||
| dict_type | varchar(100) | utf8mb4_general_ci | YES | 字典类型 | ||||
| remark | varchar(500) | utf8mb4_general_ci | YES | (NULL) | 备注 | |||
| sort | int(6) | (NULL) | 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已删除 | |||
| merchant_no | varchar(20) | utf8_general_ci | YES | (NULL) | 商户号 |