准备数据库
执行Oracle SQL,或使用MySQL的SQL代码创建库后,使用DBeaver或navicat等工具转换为Oracle库(官方最新)
修改数据库链接字符串
url: jdbc:oracle:thin:@192.168.1.1:1521:ORCL
username: root
password: root
driver-class-name: oracle.jdbc.OracleDriver
数据库脚本
CREATE TABLE jimu_dict (
id varchar2(32) NOT NULL,
dict_name nvarchar2(100) NULL,
dict_code varchar2(100) NULL,
description nvarchar2(255) NULL,
del_flag number(1) NULL,
create_by varchar2(32) NULL ,
create_time DATE NULL ,
update_by varchar2(32) NULL ,
update_time DATE NULL ,
type number(1) NULL ,
PRIMARY KEY (ID)
);
COMMENT ON COLUMN jimu_dict.dict_name IS '字典名称';
COMMENT ON COLUMN jimu_dict.dict_code IS '字典编码';
COMMENT ON COLUMN jimu_dict.description IS '描述';
COMMENT ON COLUMN jimu_dict.del_flag IS '删除状态';
COMMENT ON COLUMN jimu_dict.type IS '字典类型0为string,1为number';
CREATE TABLE JIMU_DICT_ITEM(
ID VARCHAR(32) NOT NULL,
DICT_ID VARCHAR(32),
ITEM_TEXT NVARCHAR2(100) NOT NULL,
ITEM_VALUE NVARCHAR2(100) NOT NULL,
DESCRIPTION NVARCHAR2(255),
SORT_ORDER DECIMAL,
STATUS DECIMAL,
CREATE_BY VARCHAR(32),
CREATE_TIME DATE,
UPDATE_BY VARCHAR(32),
UPDATE_TIME DATE,
PRIMARY KEY (ID)
);
CREATE TABLE "JIMU_REPORT"
( "ID" VARCHAR2(32),
"CODE" VARCHAR2(50),
"NAME" VARCHAR2(50),
"NOTE" VARCHAR2(255),
"STATUS" VARCHAR2(10),
"TYPE" VARCHAR2(10),
"JSON_STR" CLOB,
"API_URL" VARCHAR2(255),
"THUMB" VARCHAR2(4000),
"CREATE_BY" VARCHAR2(50),
"CREATE_TIME" TIMESTAMP (6),
"UPDATE_BY" VARCHAR2(50),
"UPDATE_TIME" TIMESTAMP (6),
"DEL_FLAG" NUMBER(3,0),
"API_METHOD" VARCHAR2(255),
"API_CODE" VARCHAR2(255),
"TEMPLATE" NUMBER(3,0),
"VIEW_COUNT" NUMBER(19,0)
) ;
ALTER TABLE JIMU_REPORT ADD (css_str nclob);
COMMENT ON COLUMN JIMU_REPORT.css_str IS 'css增强';
ALTER TABLE JIMU_REPORT ADD (js_str nclob);
COMMENT ON COLUMN JIMU_REPORT.js_str IS 'js增强';
CREATE TABLE "JIMU_REPORT_DATA_SOURCE"
( "ID" VARCHAR2(36),
"NAME" VARCHAR2(100),
"REPORT_ID" VARCHAR2(100),
"CODE" VARCHAR2(100),
"REMARK" VARCHAR2(200),
"DB_TYPE" VARCHAR2(10),
"DB_DRIVER" VARCHAR2(100),
"DB_URL" VARCHAR2(500),
"DB_USERNAME" VARCHAR2(100),
"DB_PASSWORD" VARCHAR2(100),
"CREATE_BY" VARCHAR2(50),
"CREATE_TIME" TIMESTAMP (6),
"UPDATE_BY" VARCHAR2(50),
"UPDATE_TIME" TIMESTAMP (6)
) ;
ALTER TABLE jimu_report_data_source ADD (connect_times integer);
COMMENT ON COLUMN jimu_report_data_source.connect_times IS '连接失败次数';
CREATE TABLE "JIMU_REPORT_DB"
( "ID" VARCHAR2(36),
"JIMU_REPORT_ID" VARCHAR2(32),
"CREATE_BY" VARCHAR2(50),
"UPDATE_BY" VARCHAR2(50),
"CREATE_TIME" TIMESTAMP (6),
"UPDATE_TIME" TIMESTAMP (6),
"DB_CODE" VARCHAR2(32),
"DB_CH_NAME" VARCHAR2(50),
"DB_TYPE" VARCHAR2(32),
"DB_TABLE_NAME" VARCHAR2(32),
"DB_DYN_SQL" VARCHAR2(4000),
"DB_KEY" VARCHAR2(32),
"TB_DB_KEY" VARCHAR2(32),
"TB_DB_TABLE_NAME" VARCHAR2(32),
"JAVA_TYPE" VARCHAR2(32),
"JAVA_VALUE" VARCHAR2(255),
"API_URL" VARCHAR2(255),
"API_METHOD" VARCHAR2(255),
"IS_LIST" NUMBER(10,0),
"IS_PAGE" VARCHAR2(10),
"DB_SOURCE" VARCHAR2(255),
"DB_SOURCE_TYPE" VARCHAR2(50)
) ;
ALTER TABLE jimu_report_db ADD (api_convert varchar2(255));
COMMENT ON COLUMN jimu_report_db.api_convert IS 'api转换器';
CREATE TABLE "JIMU_REPORT_DB_FIELD"
( "ID" VARCHAR2(36),
"CREATE_BY" VARCHAR2(50),
"CREATE_TIME" TIMESTAMP (6),
"UPDATE_BY" VARCHAR2(50),
"UPDATE_TIME" TIMESTAMP (6),
"JIMU_REPORT_DB_ID" VARCHAR2(32),
"FIELD_NAME" VARCHAR2(80),
"FIELD_TEXT" VARCHAR2(50),
"WIDGET_TYPE" VARCHAR2(50),
"WIDGET_WIDTH" NUMBER(10,0),
"ORDER_NUM" NUMBER(10,0),
"SEARCH_FLAG" NUMBER(10,0),
"SEARCH_MODE" NUMBER(10,0),
"DICT_CODE" VARCHAR2(255)
) ;
ALTER TABLE jimu_report_db_field ADD (search_format varchar2(50));
COMMENT ON COLUMN jimu_report_db_field.search_format IS '查询时间格式化表达式';
ALTER TABLE jimu_report_db_field ADD (ext_json nclob);
COMMENT ON COLUMN jimu_report_db_field.ext_json IS '参数配置';
CREATE TABLE "JIMU_REPORT_DB_PARAM"
( "ID" VARCHAR2(36),
"JIMU_REPORT_HEAD_ID" VARCHAR2(36),
"PARAM_NAME" VARCHAR2(32),
"PARAM_TXT" VARCHAR2(32),
"PARAM_VALUE" VARCHAR2(32),
"ORDER_NUM" NUMBER(10,0),
"CREATE_BY" VARCHAR2(50),
"CREATE_TIME" TIMESTAMP (6),
"UPDATE_BY" VARCHAR2(50),
"UPDATE_TIME" TIMESTAMP (6)
) ;
ALTER TABLE jimu_report_db_param ADD (search_flag NUMBER(1));
COMMENT ON COLUMN jimu_report_db_param.search_flag IS '查询标识0否1是 默认0';
ALTER TABLE jimu_report_db_param ADD (widget_type varchar2(50));
COMMENT ON COLUMN jimu_report_db_param.widget_type IS '查询控件类型';
ALTER TABLE jimu_report_db_param ADD (search_mode NUMBER(1));
COMMENT ON COLUMN jimu_report_db_param.search_mode IS '查询模式1简单2范围';
ALTER TABLE jimu_report_db_param ADD (dict_code varchar2(255));
COMMENT ON COLUMN jimu_report_db_param.dict_code IS '字典';
ALTER TABLE jimu_report_db_param ADD (search_format varchar2(50));
COMMENT ON COLUMN jimu_report_db_param.search_format IS '查询时间格式化表达式';
ALTER TABLE jimu_report_db_param ADD (ext_json nclob);
COMMENT ON COLUMN jimu_report_db_param.ext_json IS '参数配置';
ALTER TABLE jimu_report_link ADD (link_chart_id varchar2(50));
COMMENT ON COLUMN jimu_report_link.link_chart_id IS '联动图表的ID';
ALTER TABLE jimu_report_link ADD (expression varchar2(255));
COMMENT ON COLUMN jimu_report_link.expression IS '表达式';
ALTER TABLE jimu_report_link ADD (requirement varchar2(255));
COMMENT ON COLUMN jimu_report_link.requirement IS '条件';
CREATE TABLE "JIMU_REPORT_MAP"
( "ID" VARCHAR2(64),
"LABEL" VARCHAR2(125),
"NAME" VARCHAR2(125),
"data" CLOB,
"CREATE_BY" VARCHAR2(32),
"CREATE_TIME" TIMESTAMP (6),
"UPDATE_BY" VARCHAR2(32),
"UPDATE_TIME" TIMESTAMP (6),
"DEL_FLAG" VARCHAR2(1),
"SYS_ORG_CODE" VARCHAR2(64)
) ;
CREATE TABLE JIMU_REPORT_SHARE (
ID VARCHAR2(32),
REPORT_ID VARCHAR2(32),
PREVIEW_URL VARCHAR2(1000),
PREVIEW_LOCK VARCHAR2(4),
LAST_UPDATE_TIME DATE,
TERM_OF_VALIDITY VARCHAR2(1),
STATUS VARCHAR2(1)
);
COMMENT ON COLUMN JIMU_REPORT_SHARE.report_id IS '在线excel设计器id';
COMMENT ON COLUMN JIMU_REPORT_SHARE.preview_url IS '预览地址';
COMMENT ON COLUMN JIMU_REPORT_SHARE.preview_lock IS '密码锁';
COMMENT ON COLUMN JIMU_REPORT_SHARE.last_update_time IS '最后更新时间';
COMMENT ON COLUMN JIMU_REPORT_SHARE.term_of_validity IS '有效期(0:永久有效,1:1天,2:7天)';
COMMENT ON COLUMN JIMU_REPORT_SHARE.status IS '是否过期(0未过期,1已过期)';
相关推荐
积木报表官方提供了mysql的数据库表结构,根据官方的表结构创建了oracle对应的结构,记录一下,方便之后查找使用
jimureport-oracle积木报表Oracle数据库脚本
一款免费的数据可视化报表,含报表和大屏设计,像搭建积木一样在线设计报表!功能涵盖,数据报表、打印设计、图表报表、大屏设计等! Web 版报表设计器,类似于excel操作风格,通过拖拽完成报表设计。 秉承“简单、...
像搭建积木—样在线设计报表,类似于excel操作风格,通过拖拽完成报表设计l功能涵盖打印设计、报表设计、图形设计、大屏设计等,完全免费!
基于echart的图表生成工具
Springboot集成JimuReport示例代码,mybatis-plus、springboot
积木报表oracle脚本,如果有问题可以给我留言
积木报表的 mysql 文件
积木报表换行bug修复的资源、适用于积木报表调用后端API、解决换行BUG、换页BUG的问题
积木报表官方初始化sql
积木报表ORACLE脚本
ruoyi-vue-pro yudao 项目报表设计器 积木报表模块启用及相关SQL脚本, 模块开启可以参考博文
JimuReport 积木报表 v1.6.6.zip
EECG BOOT, 高质量的低代码开发平台 以天为单位的实施周期 通过简易配置搭建应用 搭建积木一样设计表单和流程 在线表单设计 在线拖拽设计,简单易用 在线流程设计 灵活稳定高性能 权限设置,多维度,颗粒化权限控制...
首先需要选择一款适合的报表工具,这里采用积木报表进行设计,具体步骤如下: 1. 数据准备 数据库中新建两张表,一张表名为“zhiwu”,用来存储部门信息;一张表名为“user”,用来存储客户信息数据。 两个表的关系...
吉木报告v1.3.0-beta | 20210319功能涵盖,数据报表,打印设计,图表报表,大屏设计等! Web版报表设计器,可以使用excel操作风格,通过拖拽完成报表设计。秉承“简单,易用,专业”的产品理念,极大地降低报表开发...
积木报表封装版,不用安装数据库,自带H2进行数据存储,下载即可使用,方便快捷
瀚高数据库适配积木报表sql脚本,由积木报表1.7.0版本的MySQL脚本迁移获得。
积木报表sql、MySQL数据库
数据可视化报表系统源码,一款数据可视化报表系统,含报表和大屏设计,像搭建积木一样在线设计报表!功能涵盖,数据报表、打印设计、图表报表、大屏设计等! Web 版报表设计器,类似于excel操作风格,通过拖拽完成...