-- Table structure for SYS_SMS
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_SMS";
CREATE TABLE "JEECGBOOTOS"."SYS_SMS" (
  "ID" NVARCHAR2(32) NOT NULL,
  "ES_TITLE" NVARCHAR2(100),
  "ES_TYPE" NVARCHAR2(50),
  "ES_RECEIVER" NVARCHAR2(50),
  "ES_PARAM" NVARCHAR2(1000),
  "ES_CONTENT" NCLOB,
  "ES_SEND_TIME" DATE,
  "ES_SEND_STATUS" NVARCHAR2(1),
  "ES_SEND_NUM" NUMBER(11,0),
  "ES_RESULT" NVARCHAR2(255),
  "REMARK" NVARCHAR2(500),
  "CREATE_BY" NVARCHAR2(32),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(32),
  "UPDATE_TIME" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."ID" IS 'ID';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."ES_TITLE" IS '消息标题';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."ES_TYPE" IS '发送方式：参考枚举MessageTypeEnum';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."ES_RECEIVER" IS '接收人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."ES_PARAM" IS '发送所需参数Json格式';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."ES_CONTENT" IS '推送内容';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."ES_SEND_TIME" IS '推送时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."ES_SEND_STATUS" IS '推送状态 0未推送 1推送成功 2推送失败 -1失败不再发送';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."ES_SEND_NUM" IS '发送次数 超过5次不再发送';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."ES_RESULT" IS '推送失败原因';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."REMARK" IS '备注';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."CREATE_BY" IS '创建人登录名称';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."CREATE_TIME" IS '创建日期';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."UPDATE_BY" IS '更新人登录名称';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS"."UPDATE_TIME" IS '更新日期';

-- ----------------------------
-- Records of SYS_SMS
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."SYS_SMS" VALUES ('402880e74dc2f361014dc2f8411e0001', '消息推送测试333', '2', '411944058@qq.com', NULL, '张三你好，你的订单4028d881436d514601436d521ae80165已付款!', TO_DATE('2015-06-05 17:06:01', 'SYYYY-MM-DD HH24:MI:SS'), '3', NULL, NULL, '认证失败错误的用户名或者密码', 'admin', TO_DATE('2015-06-05 17:05:59', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2015-11-19 22:30:39', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "JEECGBOOTOS"."SYS_SMS" VALUES ('402880ea533647b00153364e74770001', '发个问候', '3', 'admin', NULL, '你好', TO_DATE('2016-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '2', NULL, NULL, NULL, 'admin', TO_DATE('2016-03-02 15:50:24', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2018-07-05 19:53:01', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "JEECGBOOTOS"."SYS_SMS" VALUES ('402880ee5a17e711015a17f3188e013f', '消息推送测试333', '2', '411944058@qq.com', NULL, '张三你好，你的订单4028d881436d514601436d521ae80165已付款!', NULL, '2', NULL, NULL, NULL, 'admin', TO_DATE('2017-02-07 17:41:31', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2017-03-10 11:37:05', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "JEECGBOOTOS"."SYS_SMS" VALUES ('402880f05ab649b4015ab64b9cd80012', '消息推送测试333', '2', '411944058@qq.com', NULL, '张三你好，你的订单4028d881436d514601436d521ae80165已付款!', TO_DATE('2017-11-16 15:58:15', 'SYYYY-MM-DD HH24:MI:SS'), '3', NULL, NULL, NULL, 'admin', TO_DATE('2017-03-10 11:38:13', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2017-07-31 17:24:54', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "JEECGBOOTOS"."SYS_SMS" VALUES ('402880f05ab7b035015ab7c4462c0004', '消息推送测试333', '2', '411944058@qq.com', NULL, '张三你好，你的订单4028d881436d514601436d521ae80165已付款!', TO_DATE('2017-11-16 15:58:15', 'SYYYY-MM-DD HH24:MI:SS'), '3', NULL, NULL, NULL, 'admin', TO_DATE('2017-03-10 18:29:37', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_SMS" VALUES ('402881f3646a472b01646a4a5af00001', '催办：HR审批', '3', 'admin', NULL, 'admin，您好！
请前待办任务办理事项！HR审批


===========================
此消息由系统发出', TO_DATE('2018-07-05 19:53:35', 'SYYYY-MM-DD HH24:MI:SS'), '2', NULL, NULL, NULL, 'admin', TO_DATE('2018-07-05 19:53:35', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2018-07-07 13:45:24', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "JEECGBOOTOS"."SYS_SMS" VALUES ('402881f3647da06c01647da43a940014', '催办：HR审批', '3', 'admin', NULL, 'admin，您好！
请前待办任务办理事项！HR审批


===========================
此消息由系统发出', TO_DATE('2018-07-09 14:04:32', 'SYYYY-MM-DD HH24:MI:SS'), '2', NULL, NULL, NULL, 'admin', TO_DATE('2018-07-09 14:04:32', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2018-07-09 18:51:30', 'SYYYY-MM-DD HH24:MI:SS'));

-- ----------------------------
-- Table structure for SYS_SMS_TEMPLATE
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_SMS_TEMPLATE";
CREATE TABLE "JEECGBOOTOS"."SYS_SMS_TEMPLATE" (
  "ID" NVARCHAR2(32) NOT NULL,
  "TEMPLATE_NAME" NVARCHAR2(50),
  "TEMPLATE_CODE" NVARCHAR2(32) NOT NULL,
  "TEMPLATE_TYPE" NVARCHAR2(1) NOT NULL,
  "TEMPLATE_CATEGORY" NVARCHAR2(10),
  "TEMPLATE_CONTENT" NVARCHAR2(1000) NOT NULL,
  "TEMPLATE_TEST_JSON" NVARCHAR2(1000),
  "CREATE_TIME" DATE,
  "CREATE_BY" NVARCHAR2(32),
  "UPDATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(32),
  "USE_STATUS" NVARCHAR2(1)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS_TEMPLATE"."ID" IS '主键';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS_TEMPLATE"."TEMPLATE_NAME" IS '模板标题';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS_TEMPLATE"."TEMPLATE_CODE" IS '模板CODE';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS_TEMPLATE"."TEMPLATE_TYPE" IS '模板类型：1短信 2邮件 3微信';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS_TEMPLATE"."TEMPLATE_CATEGORY" IS '模版分类：notice通知公告 other其他';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS_TEMPLATE"."TEMPLATE_CONTENT" IS '模板内容';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS_TEMPLATE"."TEMPLATE_TEST_JSON" IS '模板测试json';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS_TEMPLATE"."CREATE_TIME" IS '创建日期';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS_TEMPLATE"."CREATE_BY" IS '创建人登录名称';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS_TEMPLATE"."UPDATE_TIME" IS '更新日期';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS_TEMPLATE"."UPDATE_BY" IS '更新人登录名称';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_SMS_TEMPLATE"."USE_STATUS" IS '是否使用中 1是0否';

-- ----------------------------
-- Records of SYS_SMS_TEMPLATE
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."SYS_SMS_TEMPLATE" VALUES ('1199606397416775681', '系统消息通知', 'sys_ts_note', '2', NULL, '<h1>&nbsp; &nbsp; 系统通知</h1>
<ul>
<li>通知时间：&nbsp; ${ts_date}</li>
<li>通知内容：&nbsp; ${ts_content}</li>
</ul>', NULL, TO_DATE('2019-11-27 16:30:27', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2019-11-27 19:36:50', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', NULL);
INSERT INTO "JEECGBOOTOS"."SYS_SMS_TEMPLATE" VALUES ('1199615897335095298', '流程催办', 'bpm_cuiban', '2', NULL, '<h1>&nbsp; &nbsp;流程催办提醒</h1>
<ul>
<li>流程名称：&nbsp; ${bpm_name}</li>
<li>催办任务：&nbsp; ${bpm_task}</li>
<li>催办时间 :&nbsp; &nbsp; ${datetime}</li>
<li>催办内容 :&nbsp; &nbsp; ${remark}</li>
</ul>', NULL, TO_DATE('2019-11-27 17:08:12', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2019-11-27 19:36:45', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', NULL);
INSERT INTO "JEECGBOOTOS"."SYS_SMS_TEMPLATE" VALUES ('1199648914107625473', '流程办理超时提醒', 'bpm_chaoshi_tip', '2', NULL, '<h1>&nbsp; &nbsp;流程办理超时提醒</h1>
<ul>
<li>&nbsp; &nbsp;超时提醒信息：&nbsp; &nbsp; 您有待处理的超时任务，请尽快处理！</li>
<li>&nbsp; &nbsp;超时任务标题：&nbsp; &nbsp; ${title}</li>
<li>&nbsp; &nbsp;超时任务节点：&nbsp; &nbsp; ${task}</li>
<li>&nbsp; &nbsp;任务处理人：&nbsp; &nbsp; &nbsp; &nbsp;${user}</li>
<li>&nbsp; &nbsp;任务开始时间：&nbsp; &nbsp; ${time}</li>
</ul>', NULL, TO_DATE('2019-11-27 19:19:24', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2019-11-27 19:36:37', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', NULL);
INSERT INTO "JEECGBOOTOS"."SYS_SMS_TEMPLATE" VALUES ('4028608164691b000164693108140003', '催办：${taskName}', 'SYS001', '1', NULL, '${userName}，您好！
请前待办任务办理事项！${taskName}


===========================
此消息由系统发出', '{
"taskName":"HR审批",
"userName":"admin"
}', TO_DATE('2018-07-05 14:46:18', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2018-07-05 18:31:34', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', NULL);

-- ----------------------------
-- Table structure for SYS_TABLE_WHITE_LIST
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST";
CREATE TABLE "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" (
  "ID" NVARCHAR2(32) NOT NULL,
  "TABLE_NAME" NVARCHAR2(100),
  "FIELD_NAME" NVARCHAR2(200),
  "STATUS" NVARCHAR2(10),
  "CREATE_BY" NVARCHAR2(32),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(32),
  "UPDATE_TIME" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST"."ID" IS '主键id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST"."TABLE_NAME" IS '允许的表名';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST"."FIELD_NAME" IS '允许的字段名，多个用逗号分割';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST"."STATUS" IS '状态，1=启用，0=禁用';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST"."UPDATE_BY" IS '更新人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST"."UPDATE_TIME" IS '更新时间';
COMMENT ON TABLE "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" IS '系统表白名单';

-- ----------------------------
-- Records of SYS_TABLE_WHITE_LIST
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1701578033271521282', 'sys_user', 'phone,work_no,id,email,realname,username', '1', 'admin', TO_DATE('2023-09-12 10:46:32', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2023-12-31 16:55:30', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1701581935488385025', 'oa_officialdoc_organcode', 'id,organ_name', '1', 'admin', TO_DATE('2023-09-12 11:02:02', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1701581977733414913', 'demo', 'id,name', '1', 'admin', TO_DATE('2023-09-12 11:02:12', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1701582035472203777', 'sys_permission', 'id,name', '1', 'admin', TO_DATE('2023-09-12 11:02:26', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1701582087619985409', 'onl_drag_comp', 'id,comp_name', '1', 'admin', TO_DATE('2023-09-12 11:02:38', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1701582136420712450', 'sys_depart', 'id,org_code,depart_name', '1', 'admin', TO_DATE('2023-09-12 11:02:50', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2023-10-18 09:36:40', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1701582163599802370', 'design_form', 'id,desform_name,desform_code', '1', 'admin', TO_DATE('2023-09-12 11:02:56', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1701582190187495426', 'onl_cgform_head', 'table_txt,table_name', '1', 'admin', TO_DATE('2023-09-12 11:03:03', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1701582254301626370', 'oa_wps_file', 'id,name', '1', 'admin', TO_DATE('2023-09-12 11:03:18', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1714453996678926338', 'onl_cgreport_head', 'code', '1', 'admin', TO_DATE('2023-10-18 09:31:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1714455418728337410', 'sys_category', 'id,name', '1', 'admin', TO_DATE('2023-10-18 09:36:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1714471625900564482', 'sys_position', 'name,id', '1', 'ceshi', TO_DATE('2023-10-18 10:41:04', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1769610154632491009', 'sys_dict', 'dict_code', '1', 'admin', TO_DATE('2024-03-18 14:21:53', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1778692300030484482', 'test_shoptype_tree', 'type_name,id', '1', 'admin', TO_DATE('2024-04-12 15:51:05', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1782650226206269441', 'sys_tenant', 'name,id', '1', 'admin', TO_DATE('2024-04-23 13:58:29', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1800712552062898178', 'tj_user_report', 'name,username', '1', 'admin', TO_DATE('2024-06-12 10:11:43', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1801076145102925826', 'sys_data_source', 'code,name', '1', 'admin', TO_DATE('2024-06-13 10:16:30', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1801097090085564420', 'sys_role', 'role_name,role_code', '1', 'jeecg', TO_DATE('2024-06-13 11:39:44', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2024-09-10 11:47:35', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1805416360756006913', 'wu_liao', 'wul_name,id', '1', 'admin', TO_DATE('2024-06-25 09:42:58', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1897919397122269185', 'ces_shop_type', 'name,pid,id,has_child', '1', 'admin', TO_DATE('2025-03-07 15:57:01', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1907407400953659394', 'airag_flow', 'name,id', '1', 'admin', TO_DATE('2025-04-02 20:18:57', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1907407401083682817', 'airag_model', 'name,id', '1', 'admin', TO_DATE('2025-04-02 20:18:57', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" VALUES ('1950438522834546690', 'sys_sms_template', 'template_code', '1', 'admin', TO_DATE('2025-07-30 14:09:16', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);

-- ----------------------------
-- Table structure for SYS_TENANT
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_TENANT";
CREATE TABLE "JEECGBOOTOS"."SYS_TENANT" (
  "ID" NUMBER(11,0) NOT NULL,
  "NAME" NVARCHAR2(100),
  "CREATE_TIME" DATE,
  "CREATE_BY" NVARCHAR2(100),
  "BEGIN_DATE" DATE,
  "END_DATE" DATE,
  "STATUS" NUMBER(11,0),
  "TRADE" NVARCHAR2(10),
  "COMPANY_SIZE" NVARCHAR2(10),
  "COMPANY_ADDRESS" NVARCHAR2(100),
  "COMPANY_LOGO" NVARCHAR2(200),
  "HOUSE_NUMBER" NVARCHAR2(10),
  "WORK_PLACE" NVARCHAR2(100),
  "SECONDARY_DOMAIN" NVARCHAR2(50),
  "LOGIN_BKGD_IMG" NVARCHAR2(200),
  "POSITION" NVARCHAR2(10),
  "DEPARTMENT" NVARCHAR2(10),
  "DEL_FLAG" NUMBER(4,0),
  "UPDATE_BY" NVARCHAR2(32),
  "UPDATE_TIME" DATE,
  "APPLY_STATUS" NUMBER(11,0)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."ID" IS '租户编码';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."NAME" IS '租户名称';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."BEGIN_DATE" IS '开始时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."END_DATE" IS '结束时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."STATUS" IS '状态 1正常 0冻结';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."TRADE" IS '所属行业';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."COMPANY_SIZE" IS '公司规模';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."COMPANY_ADDRESS" IS '公司地址';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."COMPANY_LOGO" IS '公司logo';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."HOUSE_NUMBER" IS '门牌号';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."WORK_PLACE" IS '工作地点';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."SECONDARY_DOMAIN" IS '二级域名';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."LOGIN_BKGD_IMG" IS '登录背景图片';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."POSITION" IS '职级';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."DEPARTMENT" IS '部门';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."DEL_FLAG" IS '删除状态(0-正常,1-已删除)';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."UPDATE_BY" IS '更新人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT"."APPLY_STATUS" IS '允许申请管理员 1允许 0不允许';
COMMENT ON TABLE "JEECGBOOTOS"."SYS_TENANT" IS '多租户信息表';

-- ----------------------------
-- Records of SYS_TENANT
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."SYS_TENANT" VALUES ('1000', '北京国炬信息技术有限公司', TO_DATE('2023-03-09 19:55:11', 'SYYYY-MM-DD HH24:MI:SS'), 'jeecg', NULL, NULL, '1', NULL, NULL, NULL, NULL, '2PI3U6', NULL, NULL, NULL, NULL, NULL, '0', 'admin', TO_DATE('2023-11-05 10:35:15', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TENANT" VALUES ('1001', '北京敲敲云科技有限公司', TO_DATE('2023-10-18 13:37:19', 'SYYYY-MM-DD HH24:MI:SS'), 'ceshi', NULL, NULL, '1', NULL, NULL, NULL, NULL, 'EX33W8', NULL, NULL, NULL, NULL, NULL, '0', 'admin', TO_DATE('2024-03-18 11:19:28', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TENANT" VALUES ('1002', '111', TO_DATE('2025-02-07 16:22:57', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', NULL, NULL, '1', NULL, NULL, NULL, NULL, '8UDKXJ', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL);

-- ----------------------------
-- Table structure for SYS_TENANT_PACK
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_TENANT_PACK";
CREATE TABLE "JEECGBOOTOS"."SYS_TENANT_PACK" (
  "ID" NVARCHAR2(32) NOT NULL,
  "TENANT_ID" NUMBER(11,0),
  "PACK_NAME" NVARCHAR2(20),
  "STATUS" NVARCHAR2(1),
  "REMARKS" NVARCHAR2(100),
  "CREATE_BY" NVARCHAR2(32),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(32),
  "UPDATE_TIME" DATE,
  "PACK_CODE" NVARCHAR2(50),
  "PACK_TYPE" NVARCHAR2(10)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK"."ID" IS '主键id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK"."TENANT_ID" IS '租户id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK"."PACK_NAME" IS '产品包名';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK"."STATUS" IS '开启状态(0 未开启 1开启)';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK"."REMARKS" IS '备注';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK"."UPDATE_BY" IS '更新人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK"."PACK_CODE" IS '编码,默认添加的三个管理员需要设置编码';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK"."PACK_TYPE" IS '产品包类型(default 默认产品包 custom 自定义产品包)';
COMMENT ON TABLE "JEECGBOOTOS"."SYS_TENANT_PACK" IS '租户产品包';

-- ----------------------------
-- Records of SYS_TENANT_PACK
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK" VALUES ('1714517098074152962', '0', '默认套餐', '1', NULL, 'ceshi', TO_DATE('2023-10-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2023-12-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, 'default');
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK" VALUES ('1887779048513064962', '1001', '默认套餐', '1', NULL, 'ceshi', TO_DATE('2023-10-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2023-12-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, 'custom');
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK" VALUES ('1887779067148357633', '1002', '默认套餐', '1', NULL, 'ceshi', TO_DATE('2023-10-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2023-12-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, 'custom');

-- ----------------------------
-- Table structure for SYS_TENANT_PACK_PERMS
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS";
CREATE TABLE "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" (
  "ID" NVARCHAR2(32) NOT NULL,
  "PACK_ID" NVARCHAR2(32),
  "PERMISSION_ID" NVARCHAR2(32),
  "CREATE_BY" NVARCHAR2(32),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(32),
  "UPDATE_TIME" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS"."ID" IS '主键编号';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS"."PACK_ID" IS '租户产品包名称';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS"."PERMISSION_ID" IS '菜单id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS"."UPDATE_BY" IS '更新人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS"."UPDATE_TIME" IS '更新时间';
COMMENT ON TABLE "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" IS '租户产品包和菜单关系表';

-- ----------------------------
-- Records of SYS_TENANT_PACK_PERMS
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" VALUES ('1714517098137067522', '1714517098074152962', '1473927410093187073', 'ceshi', TO_DATE('2023-10-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" VALUES ('1714517098199982082', '1714517098074152962', '1473955758466981890', 'ceshi', TO_DATE('2023-10-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" VALUES ('1714517098199982083', '1714517098074152962', '1542385335362383873', 'ceshi', TO_DATE('2023-10-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" VALUES ('1714517098199982084', '1714517098074152962', '1554384900763729922', 'ceshi', TO_DATE('2023-10-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" VALUES ('1887779048638894082', '1887779048513064962', '1473927410093187073', 'admin', TO_DATE('2025-02-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" VALUES ('1887779048697614338', '1887779048513064962', '1473955758466981890', 'admin', TO_DATE('2025-02-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" VALUES ('1887779048697614339', '1887779048513064962', '1542385335362383873', 'admin', TO_DATE('2025-02-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" VALUES ('1887779048697614340', '1887779048513064962', '1554384900763729922', 'admin', TO_DATE('2025-02-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" VALUES ('1887779067148357634', '1887779067148357633', '1473927410093187073', 'admin', TO_DATE('2025-02-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" VALUES ('1887779067148357635', '1887779067148357633', '1473955758466981890', 'admin', TO_DATE('2025-02-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" VALUES ('1887779067211272194', '1887779067148357633', '1542385335362383873', 'admin', TO_DATE('2025-02-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" VALUES ('1887779067211272195', '1887779067148357633', '1554384900763729922', 'admin', TO_DATE('2025-02-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);

-- ----------------------------
-- Table structure for SYS_TENANT_PACK_USER
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_TENANT_PACK_USER";
CREATE TABLE "JEECGBOOTOS"."SYS_TENANT_PACK_USER" (
  "ID" NVARCHAR2(32) NOT NULL,
  "PACK_ID" NVARCHAR2(32),
  "USER_ID" NVARCHAR2(32),
  "TENANT_ID" NUMBER(11,0),
  "CREATE_BY" NVARCHAR2(50),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(50),
  "UPDATE_TIME" DATE,
  "STATUS" NUMBER(11,0)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_USER"."PACK_ID" IS '租户产品包ID';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_USER"."USER_ID" IS '用户ID';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_USER"."TENANT_ID" IS '租户ID';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_USER"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_USER"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_USER"."UPDATE_BY" IS '更新人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_USER"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_TENANT_PACK_USER"."STATUS" IS '状态 正常状态1 申请状态0';
COMMENT ON TABLE "JEECGBOOTOS"."SYS_TENANT_PACK_USER" IS '租户套餐人员表';

-- ----------------------------
-- Records of SYS_TENANT_PACK_USER
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."SYS_TENANT_PACK_USER" VALUES ('1633795234318729217', '1633795213938606082', 'a75d45a015c44384a04449ee80dc3503', '1', 'admin', TO_DATE('2023-03-09 19:41:53', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '1');

-- ----------------------------
-- Table structure for SYS_THIRD_ACCOUNT
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_THIRD_ACCOUNT";
CREATE TABLE "JEECGBOOTOS"."SYS_THIRD_ACCOUNT" (
  "ID" NVARCHAR2(32) NOT NULL,
  "SYS_USER_ID" NVARCHAR2(32),
  "AVATAR" NVARCHAR2(255),
  "STATUS" NUMBER(4,0),
  "DEL_FLAG" NUMBER(4,0),
  "REALNAME" NVARCHAR2(100),
  "TENANT_ID" NUMBER(11,0),
  "THIRD_USER_UUID" NVARCHAR2(100),
  "THIRD_USER_ID" NVARCHAR2(100),
  "CREATE_BY" NVARCHAR2(32),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(32),
  "UPDATE_TIME" DATE,
  "THIRD_TYPE" NVARCHAR2(50)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_ACCOUNT"."ID" IS '编号';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_ACCOUNT"."SYS_USER_ID" IS '第三方登录id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_ACCOUNT"."AVATAR" IS '头像';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_ACCOUNT"."STATUS" IS '状态(1-正常,2-冻结)';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_ACCOUNT"."DEL_FLAG" IS '删除状态(0-正常,1-已删除)';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_ACCOUNT"."REALNAME" IS '真实姓名';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_ACCOUNT"."TENANT_ID" IS '租户id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_ACCOUNT"."THIRD_USER_UUID" IS '第三方账号';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_ACCOUNT"."THIRD_USER_ID" IS '第三方app用户账号';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_ACCOUNT"."CREATE_BY" IS '创建人登录名称';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_ACCOUNT"."CREATE_TIME" IS '创建日期';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_ACCOUNT"."UPDATE_BY" IS '更新人登录名称';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_ACCOUNT"."UPDATE_TIME" IS '更新日期';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_ACCOUNT"."THIRD_TYPE" IS '登录来源';

-- ----------------------------
-- Records of SYS_THIRD_ACCOUNT
-- ----------------------------

-- ----------------------------
-- Table structure for SYS_THIRD_APP_CONFIG
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG";
CREATE TABLE "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG" (
  "ID" NVARCHAR2(32) NOT NULL,
  "TENANT_ID" NUMBER(11,0) NOT NULL,
  "AGENT_ID" NVARCHAR2(20),
  "CLIENT_ID" NVARCHAR2(50),
  "CLIENT_SECRET" NVARCHAR2(100),
  "CORP_ID" NVARCHAR2(100),
  "THIRD_TYPE" NVARCHAR2(20),
  "STATUS" NUMBER(11,0),
  "CREATE_TIME" DATE,
  "UPDATE_TIME" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG"."TENANT_ID" IS '租户id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG"."AGENT_ID" IS '钉钉/企业微信应用id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG"."CLIENT_ID" IS '钉钉/企业微信 应用id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG"."CLIENT_SECRET" IS '钉钉/企业微信应用id对应的秘钥';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG"."CORP_ID" IS '钉钉企业id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG"."THIRD_TYPE" IS '第三方类别(dingtalk 钉钉 wechat_enterprise 企业微信)';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG"."STATUS" IS '是否启用(0-否,1-是)';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG"."UPDATE_TIME" IS '更新时间';
COMMENT ON TABLE "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG" IS '租户第三方配置表';

-- ----------------------------
-- Records of SYS_THIRD_APP_CONFIG
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG" VALUES ('1714477134884085762', '0', '1', '1', '1', NULL, 'dingtalk', '1', TO_DATE('2023-10-18 11:02:57', 'SYYYY-MM-DD HH24:MI:SS'), NULL);

-- ----------------------------
-- Table structure for SYS_USER
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_USER";
CREATE TABLE "JEECGBOOTOS"."SYS_USER" (
  "ID" NVARCHAR2(32) NOT NULL,
  "USERNAME" NVARCHAR2(100),
  "REALNAME" NVARCHAR2(100),
  "PASSWORD" NVARCHAR2(255),
  "SALT" NVARCHAR2(45),
  "AVATAR" NVARCHAR2(255),
  "BIRTHDAY" DATE,
  "SEX" NUMBER(4,0),
  "EMAIL" NVARCHAR2(45),
  "PHONE" NVARCHAR2(45),
  "ORG_CODE" NVARCHAR2(64),
  "STATUS" NUMBER(4,0),
  "DEL_FLAG" NUMBER(4,0),
  "THIRD_ID" NVARCHAR2(100),
  "THIRD_TYPE" NVARCHAR2(100),
  "ACTIVITI_SYNC" NUMBER(4,0),
  "WORK_NO" NVARCHAR2(100),
  "TELEPHONE" NVARCHAR2(45),
  "CREATE_BY" NVARCHAR2(32),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(32),
  "UPDATE_TIME" DATE,
  "USER_IDENTITY" NUMBER(4,0),
  "DEPART_IDS" NVARCHAR2(1000),
  "CLIENT_ID" NVARCHAR2(64),
  "LOGIN_TENANT_ID" NUMBER(11,0),
  "BPM_STATUS" NVARCHAR2(2)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."ID" IS '主键id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."USERNAME" IS '登录账号';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."REALNAME" IS '真实姓名';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."PASSWORD" IS '密码';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."SALT" IS 'md5密码盐';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."AVATAR" IS '头像';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."BIRTHDAY" IS '生日';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."SEX" IS '性别(0-默认未知,1-男,2-女)';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."EMAIL" IS '电子邮件';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."PHONE" IS '电话';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."ORG_CODE" IS '登录会话的机构编码';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."STATUS" IS '性别(1-正常,2-冻结)';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."DEL_FLAG" IS '删除状态(0-正常,1-已删除)';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."THIRD_ID" IS '第三方登录的唯一标识';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."THIRD_TYPE" IS '第三方类型';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."ACTIVITI_SYNC" IS '同步工作流引擎(1-同步,0-不同步)';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."WORK_NO" IS '工号，唯一键';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."TELEPHONE" IS '座机号';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."UPDATE_BY" IS '更新人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."USER_IDENTITY" IS '身份（1普通成员 2上级）';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."DEPART_IDS" IS '负责部门';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."CLIENT_ID" IS '设备ID';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."LOGIN_TENANT_ID" IS '上次登录选择租户ID';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER"."BPM_STATUS" IS '流程入职离职状态';
COMMENT ON TABLE "JEECGBOOTOS"."SYS_USER" IS '用户表';

-- ----------------------------
-- Records of SYS_USER
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."SYS_USER" VALUES ('1714471285016895490', 'ceshi', '测试用户', 'a9932bb12d2cbc5a', 'AF4vhXUz', NULL, TO_DATE('2024-04-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, 'winter@jeecg.org', '15201111112', NULL, '1', '0', NULL, NULL, '1', '123', NULL, 'admin', TO_DATE('2023-10-18 10:39:42', 'SYYYY-MM-DD HH24:MI:SS'), 'ceshi', TO_DATE('2025-05-08 16:11:05', 'SYYYY-MM-DD HH24:MI:SS'), '1', NULL, NULL, '0', NULL);
INSERT INTO "JEECGBOOTOS"."SYS_USER" VALUES ('3d464b4ea0d2491aab8a7bde74c57e95', 'zhangsan', '张三', '02ea098224c7d0d2077c14b9a3a1ed16', 'x5xRdeKB', 'https://static.jeecg.com/temp/jmlogo_1606575041993.png', TO_DATE('2024-04-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, '111@1.com', '13426411111', '财务部', '1', '0', NULL, NULL, '1', '0005', NULL, 'admin', TO_DATE('2020-05-14 21:26:24', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2024-04-26 13:25:37', 'SYYYY-MM-DD HH24:MI:SS'), '1', NULL, NULL, NULL, NULL);
INSERT INTO "JEECGBOOTOS"."SYS_USER" VALUES ('a75d45a015c44384a04449ee80dc3503', 'jeecg', 'jeecg', 'eee378a1258530cb', 'mIgiYJow', 'https://static.jeecg.com/temp/国炬软件logo_1606575029126.png', NULL, '1', '418799587@qq.com', '18611788525', 'A02A01', '1', '0', NULL, NULL, '1', '00002', NULL, 'admin', TO_DATE('2019-02-13 16:02:36', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2023-10-18 13:51:36', 'SYYYY-MM-DD HH24:MI:SS'), '1', NULL, NULL, '1001', NULL);
INSERT INTO "JEECGBOOTOS"."SYS_USER" VALUES ('e9ca23d68d884d4ebb19d07889727dae', 'admin', '管理员', 'cb362cfeefbf3d8d', 'RCGTeGiH', 'https://static.jeecg.com/temp/国炬软件logo_1606575029126.png', TO_DATE('1986-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '1', 'jeecg@163.com', '18611111111', 'A01', '1', '0', NULL, NULL, '1', '00001', NULL, NULL, TO_DATE('2019-06-21 17:54:10', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2025-07-30 15:22:42', 'SYYYY-MM-DD HH24:MI:SS'), '2', NULL, NULL, '0', NULL);

-- ----------------------------
-- Table structure for SYS_USER_AGENT
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_USER_AGENT";
CREATE TABLE "JEECGBOOTOS"."SYS_USER_AGENT" (
  "ID" NVARCHAR2(32) NOT NULL,
  "USER_NAME" NVARCHAR2(100),
  "AGENT_USER_NAME" NVARCHAR2(100),
  "START_TIME" DATE,
  "END_TIME" DATE,
  "PROCESS_IDS" NVARCHAR2(255),
  "STATUS" NVARCHAR2(2),
  "CREATE_NAME" NVARCHAR2(50),
  "CREATE_BY" NVARCHAR2(50),
  "CREATE_TIME" DATE,
  "UPDATE_NAME" NVARCHAR2(50),
  "UPDATE_BY" NVARCHAR2(50),
  "UPDATE_TIME" DATE,
  "SYS_ORG_CODE" NVARCHAR2(50),
  "SYS_COMPANY_CODE" NVARCHAR2(50)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."ID" IS '序号';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."USER_NAME" IS '用户名';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."AGENT_USER_NAME" IS '代理人用户名';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."START_TIME" IS '代理开始时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."END_TIME" IS '代理结束时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."PROCESS_IDS" IS '代理流程ID';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."STATUS" IS '状态0无效1有效';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."CREATE_NAME" IS '创建人名称';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."CREATE_BY" IS '创建人登录名称';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."CREATE_TIME" IS '创建日期';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."UPDATE_NAME" IS '更新人名称';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."UPDATE_BY" IS '更新人登录名称';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."UPDATE_TIME" IS '更新日期';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."SYS_ORG_CODE" IS '所属部门';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_AGENT"."SYS_COMPANY_CODE" IS '所属公司';
COMMENT ON TABLE "JEECGBOOTOS"."SYS_USER_AGENT" IS '用户代理人设置';

-- ----------------------------
-- Records of SYS_USER_AGENT
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."SYS_USER_AGENT" VALUES ('1632029640019922945', 'zhagnxiao', 'jeecg', TO_DATE('2023-03-04 22:45:50', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2023-03-04 05:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, '1', NULL, 'admin', TO_DATE('2023-03-04 22:46:02', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, 'A01', NULL);
INSERT INTO "JEECGBOOTOS"."SYS_USER_AGENT" VALUES ('1803245960282488834', '18611566565', NULL, TO_DATE('2024-06-19 09:58:32', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2054-06-19 09:58:32', 'SYYYY-MM-DD HH24:MI:SS'), NULL, '1', NULL, 'jeecg', TO_DATE('2024-06-19 09:58:34', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, 'A02A01', NULL);

-- ----------------------------
-- Table structure for SYS_USER_DEPART
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_USER_DEPART";
CREATE TABLE "JEECGBOOTOS"."SYS_USER_DEPART" (
  "ID" NVARCHAR2(32) NOT NULL,
  "USER_ID" NVARCHAR2(32),
  "DEP_ID" NVARCHAR2(32)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_DEPART"."ID" IS 'id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_DEPART"."USER_ID" IS '用户id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_DEPART"."DEP_ID" IS '部门id';

-- ----------------------------
-- Records of SYS_USER_DEPART
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."SYS_USER_DEPART" VALUES ('1783729121915510785', '3d464b4ea0d2491aab8a7bde74c57e95', 'a7d7e77e06c84325a40932163adcdaa6');
INSERT INTO "JEECGBOOTOS"."SYS_USER_DEPART" VALUES ('1714519577067200514', 'a75d45a015c44384a04449ee80dc3503', 'a7d7e77e06c84325a40932163adcdaa6');
INSERT INTO "JEECGBOOTOS"."SYS_USER_DEPART" VALUES ('1f3a0267811327b9eca86b0cc2b956f3', 'bcbe1290783a469a83ae3bd8effe15d4', '5159cde220114246b045e574adceafe9');

-- ----------------------------
-- Table structure for SYS_USER_POSITION
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_USER_POSITION";
CREATE TABLE "JEECGBOOTOS"."SYS_USER_POSITION" (
  "ID" NVARCHAR2(32) NOT NULL,
  "USER_ID" NVARCHAR2(32),
  "POSITION_ID" NVARCHAR2(32),
  "CREATE_BY" NVARCHAR2(50),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(50),
  "UPDATE_TIME" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_POSITION"."ID" IS '主键';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_POSITION"."USER_ID" IS '用户id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_POSITION"."POSITION_ID" IS '职位id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_POSITION"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_POSITION"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_POSITION"."UPDATE_BY" IS '修改人';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_POSITION"."UPDATE_TIME" IS '修改时间';

-- ----------------------------
-- Records of SYS_USER_POSITION
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."SYS_USER_POSITION" VALUES ('1920390985293144065', '1714471285016895490', '1185040064792571906', 'ceshi', TO_DATE('2025-05-08 16:11:05', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);

-- ----------------------------
-- Table structure for SYS_USER_ROLE
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_USER_ROLE";
CREATE TABLE "JEECGBOOTOS"."SYS_USER_ROLE" (
  "ID" NVARCHAR2(32) NOT NULL,
  "USER_ID" NVARCHAR2(32),
  "ROLE_ID" NVARCHAR2(32),
  "TENANT_ID" NUMBER(11,0)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_ROLE"."ID" IS '主键id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_ROLE"."USER_ID" IS '用户id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_ROLE"."ROLE_ID" IS '角色id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_ROLE"."TENANT_ID" IS '租户ID';
COMMENT ON TABLE "JEECGBOOTOS"."SYS_USER_ROLE" IS '用户角色表';

-- ----------------------------
-- Records of SYS_USER_ROLE
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('0ede6d23d53bc7dc990346ff14faabee', '3db4cf42353f4e868b7ccfeef90505d2', 'ee8626f80f7c2619917b6236f3a7f02b', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('1714519577000091650', 'a75d45a015c44384a04449ee80dc3503', 'ee8626f80f7c2619917b6236f3a7f02b', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('1714519577000091651', 'a75d45a015c44384a04449ee80dc3503', '1501570619841810433', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('1783729121881956354', '3d464b4ea0d2491aab8a7bde74c57e95', 'ee8626f80f7c2619917b6236f3a7f02b', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('1794912584001581058', 'a75d45a015c44384a04449ee80dc3503', '1169504891467464706', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('1794912584001581059', 'a75d45a015c44384a04449ee80dc3503', '1169504891467464707', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('1920390985230229505', '1714471285016895490', 'ee8626f80f7c2619917b6236f3a7f02b', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('1950457002841501698', 'e9ca23d68d884d4ebb19d07889727dae', '1501570619841810433', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('1950457002841501699', 'e9ca23d68d884d4ebb19d07889727dae', 'f6817f48af4fb3af11b9e8bf182f618b', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('79d66ef7aa137cfa9957081a1483009d', '9a668858c4c74cf5a2b25ad9608ba095', 'ee8626f80f7c2619917b6236f3a7f02b', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('b3ffd9311a1ca296c44e2409b547384f', '01b802058ea94b978a2c96f4807f6b48', '1', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('be2639167ede09379937daca7fc3bb73', '526f300ab35e44faaed54a9fb0742845', 'ee8626f80f7c2619917b6236f3a7f02b', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('e78d210d24aaff48e0a736e2ddff4cdc', '3e177fede453430387a8279ced685679', 'ee8626f80f7c2619917b6236f3a7f02b', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('ee45d0343ecec894b6886effc92cb0b7', '4d8fef4667574b24a9ccfedaf257810c', 'f6817f48af4fb3af11b9e8bf182f618b', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('f2922a38ba24fb53749e45a0c459adb3', '439ae3e9bcf7418583fcd429cadb1d72', '1', '0');
INSERT INTO "JEECGBOOTOS"."SYS_USER_ROLE" VALUES ('f72c6190b0722e798147e73c776c6ac9', '439ae3e9bcf7418583fcd429cadb1d72', 'ee8626f80f7c2619917b6236f3a7f02b', '0');

-- ----------------------------
-- Table structure for SYS_USER_TENANT
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."SYS_USER_TENANT";
CREATE TABLE "JEECGBOOTOS"."SYS_USER_TENANT" (
  "ID" NVARCHAR2(32) NOT NULL,
  "USER_ID" NVARCHAR2(32),
  "TENANT_ID" NUMBER(11,0),
  "STATUS" NVARCHAR2(1),
  "CREATE_BY" NVARCHAR2(32),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(32),
  "UPDATE_TIME" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_TENANT"."ID" IS '主键id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_TENANT"."USER_ID" IS '用户id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_TENANT"."TENANT_ID" IS '租户id';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_TENANT"."STATUS" IS '状态(1 正常 2 离职 3 待审核 4 拒绝 5 邀请加入)';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_TENANT"."CREATE_BY" IS '创建人登录名称';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_TENANT"."CREATE_TIME" IS '创建日期';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_TENANT"."UPDATE_BY" IS '更新人登录名称';
COMMENT ON COLUMN "JEECGBOOTOS"."SYS_USER_TENANT"."UPDATE_TIME" IS '更新日期';
COMMENT ON TABLE "JEECGBOOTOS"."SYS_USER_TENANT" IS '用户租户关系表';

-- ----------------------------
-- Records of SYS_USER_TENANT
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."SYS_USER_TENANT" VALUES ('1714517525209489409', 'a75d45a015c44384a04449ee80dc3503', '1001', '1', 'ceshi', TO_DATE('2023-10-18 13:43:27', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);

-- ----------------------------
-- Table structure for TEST_DEMO
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."TEST_DEMO";
CREATE TABLE "JEECGBOOTOS"."TEST_DEMO" (
  "ID" NVARCHAR2(36) NOT NULL,
  "CREATE_BY" NVARCHAR2(50),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(50),
  "UPDATE_TIME" DATE,
  "NAME" NVARCHAR2(200),
  "SEX" NVARCHAR2(32),
  "AGE" NUMBER(11,0),
  "DESCC" NVARCHAR2(500),
  "BIRTHDAY" DATE,
  "USER_CODE" NVARCHAR2(32),
  "FILE_KK" NVARCHAR2(500),
  "TOP_PIC" NVARCHAR2(500),
  "CHEGNSHI" NVARCHAR2(300),
  "CECK" NVARCHAR2(32),
  "XIAMUTI" NVARCHAR2(100),
  "SEARCH_SEL" NVARCHAR2(100),
  "POP" NVARCHAR2(32),
  "SEL_TABLE" NVARCHAR2(32)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."ID" IS '主键';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."CREATE_BY" IS '创建人登录名称';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."CREATE_TIME" IS '创建日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."UPDATE_BY" IS '更新人登录名称';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."UPDATE_TIME" IS '更新日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."NAME" IS '用户名';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."SEX" IS '性别';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."AGE" IS '年龄';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."DESCC" IS '描述';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."BIRTHDAY" IS '生日';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."USER_CODE" IS '用户编码';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."FILE_KK" IS '附件';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."TOP_PIC" IS '头像';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."CHEGNSHI" IS '城市';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."CECK" IS 'checkbox';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."XIAMUTI" IS '下拉多选';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."SEARCH_SEL" IS '搜索下拉';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."POP" IS '弹窗';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_DEMO"."SEL_TABLE" IS '下拉字典表';

-- ----------------------------
-- Records of TEST_DEMO
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."TEST_DEMO" VALUES ('11', 'admin', TO_DATE('2024-06-23 16:51:45', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '111', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO "JEECGBOOTOS"."TEST_DEMO" VALUES ('1331884149004910593', 'admin', TO_DATE('2020-11-26 16:55:01', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '张三', '1', NULL, NULL, NULL, NULL, NULL, NULL, '130304', NULL, NULL, NULL, NULL, NULL);
INSERT INTO "JEECGBOOTOS"."TEST_DEMO" VALUES ('1331901553776869377', 'admin', TO_DATE('2020-11-26 18:04:10', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-11-26 18:04:24', 'SYYYY-MM-DD HH24:MI:SS'), '张三', '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1,2', 'hr', NULL, NULL);
INSERT INTO "JEECGBOOTOS"."TEST_DEMO" VALUES ('1533107308342210561', 'admin', TO_DATE('2022-06-04 23:24:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '11', '1', '111', '<p>111</p>', TO_DATE('2022-06-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, 'temp/11_1654356225072.jpg', 'temp/11_1654356229294.jpg', '210603', '2', '2,1', 'hr', NULL, 'admin');
INSERT INTO "JEECGBOOTOS"."TEST_DEMO" VALUES ('1899062356047814658', 'admin', TO_DATE('2025-03-10 19:38:43', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '哈喽', '1', NULL, NULL, TO_DATE('2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO "JEECGBOOTOS"."TEST_DEMO" VALUES ('4028810c6aed99e1016aed9b31b40002', NULL, NULL, 'admin', TO_DATE('2019-10-19 15:37:27', 'SYYYY-MM-DD HH24:MI:SS'), 'jeecg', '2', '55', '5', TO_DATE('2019-05-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO "JEECGBOOTOS"."TEST_DEMO" VALUES ('4028810c6b02cba2016b02cba21f0000', 'admin', TO_DATE('2019-05-29 16:53:48', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2022-11-07 22:09:46', 'SYYYY-MM-DD HH24:MI:SS'), '张小红', '1', '8222', '8', TO_DATE('2019-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '120101', '2', NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for TEST_ENHANCE_SELECT
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."TEST_ENHANCE_SELECT";
CREATE TABLE "JEECGBOOTOS"."TEST_ENHANCE_SELECT" (
  "ID" NVARCHAR2(36) NOT NULL,
  "PROVINCE" NVARCHAR2(100),
  "CITY" NVARCHAR2(100),
  "AREA" NVARCHAR2(100),
  "CREATE_TIME" DATE,
  "CREATE_BY" NVARCHAR2(50)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ENHANCE_SELECT"."PROVINCE" IS '省份';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ENHANCE_SELECT"."CITY" IS '市';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ENHANCE_SELECT"."AREA" IS '区';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ENHANCE_SELECT"."CREATE_TIME" IS '创建日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ENHANCE_SELECT"."CREATE_BY" IS '创建人';

-- ----------------------------
-- Records of TEST_ENHANCE_SELECT
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."TEST_ENHANCE_SELECT" VALUES ('1256614575282958338', '1230769290609725441', '1230769470889299970', '1230769620021972993', TO_DATE('2020-05-03 00:00:36', 'SYYYY-MM-DD HH24:MI:SS'), 'admin');
INSERT INTO "JEECGBOOTOS"."TEST_ENHANCE_SELECT" VALUES ('1427183594647195649', '1230769253267836929', '1230769769930592257', '1230769855347593217', TO_DATE('2021-08-16 16:20:59', 'SYYYY-MM-DD HH24:MI:SS'), 'admin');
INSERT INTO "JEECGBOOTOS"."TEST_ENHANCE_SELECT" VALUES ('1427184250225299457', '1230769290609725441', '1230769470889299970', '1230769620021972993', TO_DATE('2021-08-16 16:23:35', 'SYYYY-MM-DD HH24:MI:SS'), 'admin');
INSERT INTO "JEECGBOOTOS"."TEST_ENHANCE_SELECT" VALUES ('1427900912506630146', '1230769253267836929', '1230769769930592257', '1230769855347593217', TO_DATE('2021-08-18 15:51:21', 'SYYYY-MM-DD HH24:MI:SS'), 'admin');
INSERT INTO "JEECGBOOTOS"."TEST_ENHANCE_SELECT" VALUES ('402880e570801ffe01708053743c002e', '1230769253267836929', '1230769769930592257', '1230769855347593217', TO_DATE('2020-02-26 15:08:37', 'SYYYY-MM-DD HH24:MI:SS'), 'admin');
INSERT INTO "JEECGBOOTOS"."TEST_ENHANCE_SELECT" VALUES ('402880e570801ffe017080538b24002f', '1230769253267836929', '1230769769930592257', '1230769855347593217', TO_DATE('2020-02-26 15:08:43', 'SYYYY-MM-DD HH24:MI:SS'), 'admin');
INSERT INTO "JEECGBOOTOS"."TEST_ENHANCE_SELECT" VALUES ('402880e570801ffe01708053b2b10030', '1230769290609725441', '1230769470889299970', '1230769620021972993', TO_DATE('2020-02-26 15:08:53', 'SYYYY-MM-DD HH24:MI:SS'), 'admin');

-- ----------------------------
-- Table structure for TEST_NOTE
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."TEST_NOTE";
CREATE TABLE "JEECGBOOTOS"."TEST_NOTE" (
  "ID" NVARCHAR2(36) NOT NULL,
  "CREATE_BY" NVARCHAR2(50),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(50),
  "UPDATE_TIME" DATE,
  "SYS_ORG_CODE" NVARCHAR2(64),
  "NAME" NVARCHAR2(32),
  "AGE" NUMBER(11,0),
  "SEX" NVARCHAR2(32),
  "BIRTHDAY" DATE,
  "CONTENTS" NVARCHAR2(500),
  "YEAR" DATE,
  "SHENG" NVARCHAR2(32),
  "MONTH" DATE,
  "BEGIN_TIME" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."ID" IS '主键';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."CREATE_TIME" IS '创建日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."UPDATE_BY" IS '更新人';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."UPDATE_TIME" IS '更新日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."SYS_ORG_CODE" IS '所属部门';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."NAME" IS '用户名';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."AGE" IS '年龄';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."SEX" IS '性别';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."BIRTHDAY" IS '生日';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."CONTENTS" IS '请假原因';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."YEAR" IS '年';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."SHENG" IS '地区';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."MONTH" IS '月';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_NOTE"."BEGIN_TIME" IS '开始时间';

-- ----------------------------
-- Records of TEST_NOTE
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."TEST_NOTE" VALUES ('1257876639515222017', 'admin', TO_DATE('2020-05-06 11:35:35', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'A01', '不同意', '20', '1', TO_DATE('2020-05-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '999', NULL, NULL, NULL, NULL);
INSERT INTO "JEECGBOOTOS"."TEST_NOTE" VALUES ('1304309860578455553', 'admin', TO_DATE('2020-09-11 14:44:38', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2025-06-25 17:51:19', 'SYYYY-MM-DD HH24:MI:SS'), 'A01', 'zhangsan', '18', '1', TO_DATE('2020-09-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '<p>2223333</p>', NULL, NULL, NULL, NULL);
INSERT INTO "JEECGBOOTOS"."TEST_NOTE" VALUES ('1923203898831777793', 'admin', TO_DATE('2025-05-16 10:28:35', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2025-07-31 14:12:28', 'SYYYY-MM-DD HH24:MI:SS'), 'A01', 'jeecg', '10', '2', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO "JEECGBOOTOS"."TEST_NOTE" VALUES ('1943500714139598850', 'admin', TO_DATE('2025-07-11 10:40:53', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2025-07-31 14:12:20', 'SYYYY-MM-DD HH24:MI:SS'), 'A01', 'admin', '1212', '1', TO_DATE('2025-07-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '<p>经过上述讨论, 我们不得不面对一个非常尴尬的事实, 那就是, 这样看来, 一般来讲, 我们都必须务必慎重的考虑考虑. 就我个人来说, 随机一段废话对我的意义, 不能不说非常重大.&nbsp;<br>每个人都不得不面对这些问题. 在面对这种问题时, 随机一段废话, 发生了会如何, 不发生又会如何. 总结的来说,&nbsp;<br>这种事实对本人来说意义重大, 相信对这个世界也是有一定意义的.所谓随机一段废话, 关键是x需要</p>', NULL, '140311', NULL, NULL);

-- ----------------------------
-- Table structure for TEST_ONLINE_LINK
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."TEST_ONLINE_LINK";
CREATE TABLE "JEECGBOOTOS"."TEST_ONLINE_LINK" (
  "ID" NVARCHAR2(32) NOT NULL,
  "PID" NVARCHAR2(32),
  "NAME" NVARCHAR2(255)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ONLINE_LINK"."PID" IS 'pid';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ONLINE_LINK"."NAME" IS 'name';

-- ----------------------------
-- Records of TEST_ONLINE_LINK
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."TEST_ONLINE_LINK" VALUES ('1', NULL, '中国');
INSERT INTO "JEECGBOOTOS"."TEST_ONLINE_LINK" VALUES ('10', '8', '庐阳区');
INSERT INTO "JEECGBOOTOS"."TEST_ONLINE_LINK" VALUES ('11', '7', '黄山市');
INSERT INTO "JEECGBOOTOS"."TEST_ONLINE_LINK" VALUES ('2', '1', '山东省');
INSERT INTO "JEECGBOOTOS"."TEST_ONLINE_LINK" VALUES ('3', '2', '济南市');
INSERT INTO "JEECGBOOTOS"."TEST_ONLINE_LINK" VALUES ('4', '3', '历城区');
INSERT INTO "JEECGBOOTOS"."TEST_ONLINE_LINK" VALUES ('5', '3', '长青区');
INSERT INTO "JEECGBOOTOS"."TEST_ONLINE_LINK" VALUES ('6', '2', '青岛市');
INSERT INTO "JEECGBOOTOS"."TEST_ONLINE_LINK" VALUES ('7', '1', '安徽省');
INSERT INTO "JEECGBOOTOS"."TEST_ONLINE_LINK" VALUES ('8', '7', '合肥市');
INSERT INTO "JEECGBOOTOS"."TEST_ONLINE_LINK" VALUES ('9', '8', '包河区');

-- ----------------------------
-- Table structure for TEST_ORDER_CUSTOMER
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."TEST_ORDER_CUSTOMER";
CREATE TABLE "JEECGBOOTOS"."TEST_ORDER_CUSTOMER" (
  "ID" NVARCHAR2(36) NOT NULL,
  "CREATE_BY" NVARCHAR2(50),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(50),
  "UPDATE_TIME" DATE,
  "SYS_ORG_CODE" NVARCHAR2(64),
  "NAME" NVARCHAR2(32),
  "SEX" NVARCHAR2(32),
  "AGE" NUMBER(11,0),
  "BIRTHDAY" DATE,
  "ORDER_ID" NVARCHAR2(32),
  "ADDRESS" NVARCHAR2(300)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_CUSTOMER"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_CUSTOMER"."CREATE_TIME" IS '创建日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_CUSTOMER"."UPDATE_BY" IS '更新人';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_CUSTOMER"."UPDATE_TIME" IS '更新日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_CUSTOMER"."SYS_ORG_CODE" IS '所属部门';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_CUSTOMER"."NAME" IS '客户名字';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_CUSTOMER"."SEX" IS '性别';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_CUSTOMER"."AGE" IS '年龄';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_CUSTOMER"."BIRTHDAY" IS '生日';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_CUSTOMER"."ORDER_ID" IS '订单id';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_CUSTOMER"."ADDRESS" IS '地址';

-- ----------------------------
-- Records of TEST_ORDER_CUSTOMER
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_CUSTOMER" VALUES ('1586285823409205250', 'admin', TO_DATE('2022-10-29 17:16:26', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'A01', '90', '1', '90', TO_DATE('2022-09-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '1551943088862896130', NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_CUSTOMER" VALUES ('1586557969578553345', 'admin', TO_DATE('2022-10-30 11:20:31', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'A01', '小王', '1', '33', TO_DATE('2022-09-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '1586557968995545089', NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_CUSTOMER" VALUES ('1586557969578553346', 'admin', TO_DATE('2022-10-30 11:17:51', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'A01', '效力', '2', '333', TO_DATE('2022-10-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '1586557968995545089', NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_CUSTOMER" VALUES ('1589514956528386050', 'admin', TO_DATE('2022-11-07 15:07:52', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'A01', '1111', '1', '22', TO_DATE('2022-11-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '1589514956490637313', NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_CUSTOMER" VALUES ('1589516804559699970', 'admin', TO_DATE('2022-11-07 15:15:13', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'A01', '33', NULL, NULL, NULL, '1589516804530339842', '120101');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_CUSTOMER" VALUES ('1589516832699285506', 'admin', TO_DATE('2022-11-07 15:15:19', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'A01', '4434', NULL, NULL, NULL, '1589516804530339842', NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_CUSTOMER" VALUES ('1597149156416937985', 'admin', TO_DATE('2022-11-28 16:43:27', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'A01', '33', '1', '33', TO_DATE('2022-11-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '1597149156089782273', NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_CUSTOMER" VALUES ('1683074969947033601', 'admin', TO_DATE('2024-09-10 19:47:29', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'A01', '于美欣', '1', '22', TO_DATE('2023-07-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '1683074969561157634', NULL);

-- ----------------------------
-- Table structure for TEST_ORDER_MAIN
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."TEST_ORDER_MAIN";
CREATE TABLE "JEECGBOOTOS"."TEST_ORDER_MAIN" (
  "ID" NVARCHAR2(36) NOT NULL,
  "CREATE_BY" NVARCHAR2(50),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(50),
  "UPDATE_TIME" DATE,
  "ORDER_CODE" NVARCHAR2(32),
  "ORDER_DATE" DATE,
  "DESCC" NVARCHAR2(100),
  "XIALA" NVARCHAR2(32)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_MAIN"."ID" IS '主键';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_MAIN"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_MAIN"."CREATE_TIME" IS '创建日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_MAIN"."UPDATE_BY" IS '更新人';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_MAIN"."UPDATE_TIME" IS '更新日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_MAIN"."ORDER_CODE" IS '订单编码';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_MAIN"."ORDER_DATE" IS '下单时间';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_MAIN"."DESCC" IS '描述';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_MAIN"."XIALA" IS '下拉多选';

-- ----------------------------
-- Records of TEST_ORDER_MAIN
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_MAIN" VALUES ('1256629667445714946', 'admin', TO_DATE('2020-05-03 01:00:34', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2020-11-26 15:22:35', 'SYYYY-MM-DD HH24:MI:SS'), '鼠标', TO_DATE('2020-05-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '15', NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_MAIN" VALUES ('1551943088862896130', 'admin', TO_DATE('2022-07-26 22:50:40', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2022-10-29 17:16:26', 'SYYYY-MM-DD HH24:MI:SS'), 'CN2022', NULL, NULL, NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_MAIN" VALUES ('1586557968995545089', 'admin', TO_DATE('2022-10-30 11:17:51', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2022-11-07 15:07:24', 'SYYYY-MM-DD HH24:MI:SS'), 'CN2022103011170844', NULL, '111', NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_MAIN" VALUES ('1589514956490637313', 'admin', TO_DATE('2022-11-07 15:07:52', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2022-11-07 15:14:50', 'SYYYY-MM-DD HH24:MI:SS'), '顾平', TO_DATE('2022-11-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, '1,2');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_MAIN" VALUES ('1589516804530339842', 'admin', TO_DATE('2022-11-07 15:15:13', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2022-11-23 17:20:56', 'SYYYY-MM-DD HH24:MI:SS'), '顾平2', TO_DATE('2022-11-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '222', '1,2');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_MAIN" VALUES ('1597149156089782273', 'admin', TO_DATE('2022-11-28 16:43:27', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'CN2022112816431596', NULL, NULL, NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_MAIN" VALUES ('1683074969561157634', 'admin', TO_DATE('2023-07-23 19:21:57', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2024-09-10 19:47:29', 'SYYYY-MM-DD HH24:MI:SS'), 'CN2023072319214115', NULL, '111', '1,2');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_MAIN" VALUES ('1833472350097121281', 'admin', TO_DATE('2024-09-10 19:47:27', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2025-07-07 14:49:52', 'SYYYY-MM-DD HH24:MI:SS'), 'CN2024091019472568', NULL, NULL, NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_MAIN" VALUES ('1907441973318082561', 'admin', TO_DATE('2025-04-02 22:36:19', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'CN2025040222361836', NULL, NULL, NULL);

-- ----------------------------
-- Table structure for TEST_ORDER_PRODUCT
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."TEST_ORDER_PRODUCT";
CREATE TABLE "JEECGBOOTOS"."TEST_ORDER_PRODUCT" (
  "ID" NVARCHAR2(36) NOT NULL,
  "CREATE_BY" NVARCHAR2(50),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(50),
  "UPDATE_TIME" DATE,
  "PRODUCT_NAME" NVARCHAR2(32),
  "PRICE" NUMBER(32,0),
  "NUM" NUMBER(11,0),
  "DESCC" NVARCHAR2(32),
  "ORDER_FK_ID" NVARCHAR2(32) NOT NULL,
  "PRO_TYPE" NVARCHAR2(32)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_PRODUCT"."ID" IS '主键';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_PRODUCT"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_PRODUCT"."CREATE_TIME" IS '创建日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_PRODUCT"."UPDATE_BY" IS '更新人';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_PRODUCT"."UPDATE_TIME" IS '更新日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_PRODUCT"."PRODUCT_NAME" IS '产品名字';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_PRODUCT"."PRICE" IS '价格';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_PRODUCT"."NUM" IS '数量';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_PRODUCT"."DESCC" IS '描述';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_PRODUCT"."ORDER_FK_ID" IS '订单外键ID';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_ORDER_PRODUCT"."PRO_TYPE" IS '产品类型';

-- ----------------------------
-- Records of TEST_ORDER_PRODUCT
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1331860890813284353', 'admin', TO_DATE('2020-11-26 15:22:35', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '44', '44', '44', NULL, '1256629667445714946', '1');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1551943088930004994', 'admin', TO_DATE('2022-10-29 17:16:26', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '11', '11', '11', '11', '1551943088862896130', '1');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1551943088930004995', 'admin', TO_DATE('2022-07-26 22:50:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '2', '2', '2', '2', '1551943088862896130', '2');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('15665749948861', 'admin', TO_DATE('2020-02-24 02:05:38', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '333', '33', NULL, NULL, '402831816a38e7fd016a38e825c90003', NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1586557969318506498', 'admin', TO_DATE('2022-10-30 11:20:31', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '小米手机3', '20003', '33', '3', '1586557968995545089', '2');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1586557969381421058', 'admin', TO_DATE('2022-10-30 11:17:51', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '华为手机1', '80001', '31', '11', '1586557968995545089', '2');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('15884388229280883233', 'admin', TO_DATE('2020-11-26 15:22:35', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '华为手机', '25', '35', '345', '1256629667445714946', '1');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('15884388231401967996', 'admin', TO_DATE('2020-07-11 11:36:36', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '低代码平台', '25', '35', '445', '1256629667445714946', '1');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('15884388463052345317', 'admin', TO_DATE('2020-07-11 11:36:36', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '表单设计器', '55', '55', '55', '1256629667445714946', '2');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1589514837779251202', 'admin', TO_DATE('2022-11-07 15:07:24', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '2323', '2323', '2323', NULL, '1586557968995545089', '1');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1589514956499025921', 'admin', TO_DATE('2022-11-07 15:07:52', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '111', '222', '222', '222', '1589514956490637313', '1');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1589514956515803137', 'admin', TO_DATE('2022-11-07 15:07:52', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '333', NULL, NULL, NULL, '1589514956490637313', NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1589516804542922753', 'admin', TO_DATE('2022-11-23 17:20:56', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '1133', NULL, NULL, NULL, '1589516804530339842', NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1589516804551311361', 'admin', TO_DATE('2022-11-07 15:15:13', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '222', NULL, NULL, NULL, '1589516804530339842', NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1597149156278525953', 'admin', TO_DATE('2022-11-28 16:43:27', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '22', '2', '2', '22', '1597149156089782273', '1');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1683074969716346881', 'admin', TO_DATE('2024-09-10 19:47:29', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '电脑', '5000', '21', '121', '1683074969561157634', '1');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1714472725034704898', 'admin', TO_DATE('2024-09-10 19:47:29', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '办公椅子', '50', '100', NULL, '1683074969561157634', '1');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1732300515406647298', 'admin', TO_DATE('2024-09-10 19:47:29', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2025-07-30 10:00:02', 'SYYYY-MM-DD HH24:MI:SS'), '苹果手机', '3000', '10', NULL, '1683074969561157634', '1');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('1907442008848031746', 'admin', TO_DATE('2025-04-02 22:36:28', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2025-04-02 22:36:32', 'SYYYY-MM-DD HH24:MI:SS'), '1', '1', '22', NULL, '1833472350097121281', '1');
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('402831816a38e7fd016a38e7fdeb0001', 'admin', TO_DATE('2019-04-20 12:01:29', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '笔记本', '100', '10', NULL, '402831816a38e7fd016a38e7fddf0000', NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('402831816a38e7fd016a38e7fdf10002', 'admin', TO_DATE('2019-04-20 12:01:29', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '显示器', '300', '1', NULL, '402831816a38e7fd016a38e7fddf0000', NULL);
INSERT INTO "JEECGBOOTOS"."TEST_ORDER_PRODUCT" VALUES ('4028810c6b40244b016b406884080005', 'admin', TO_DATE('2020-02-24 02:05:38', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '333', NULL, '33', NULL, '402831816a38e7fd016a38e825c90003', NULL);

-- ----------------------------
-- Table structure for TEST_PERSON
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."TEST_PERSON";
CREATE TABLE "JEECGBOOTOS"."TEST_PERSON" (
  "ID" NVARCHAR2(36) NOT NULL,
  "CREATE_BY" NVARCHAR2(50),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(50),
  "UPDATE_TIME" DATE,
  "SEX" NVARCHAR2(32),
  "NAME" NVARCHAR2(200),
  "CONTENT" NCLOB,
  "BE_DATE" DATE,
  "QJ_DAYS" NUMBER(11,0)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_PERSON"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_PERSON"."CREATE_TIME" IS '创建日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_PERSON"."UPDATE_BY" IS '更新人';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_PERSON"."UPDATE_TIME" IS '更新日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_PERSON"."SEX" IS '性别';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_PERSON"."NAME" IS '用户名';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_PERSON"."CONTENT" IS '请假原因';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_PERSON"."BE_DATE" IS '请假时间';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_PERSON"."QJ_DAYS" IS '请假天数';

-- ----------------------------
-- Records of TEST_PERSON
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."TEST_PERSON" VALUES ('8ca668defdae47df8649a5477ae08b05', 'admin', TO_DATE('2019-04-12 09:51:37', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '1', 'zhangdaiscott', 'dsdsd', TO_DATE('2019-04-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '2');

-- ----------------------------
-- Table structure for TEST_SHOPTYPE_TREE
-- ----------------------------
DROP TABLE "JEECGBOOTOS"."TEST_SHOPTYPE_TREE";
CREATE TABLE "JEECGBOOTOS"."TEST_SHOPTYPE_TREE" (
  "ID" NVARCHAR2(36) NOT NULL,
  "CREATE_BY" NVARCHAR2(50),
  "CREATE_TIME" DATE,
  "UPDATE_BY" NVARCHAR2(50),
  "UPDATE_TIME" DATE,
  "SYS_ORG_CODE" NVARCHAR2(64),
  "TYPE_NAME" NVARCHAR2(32),
  "PIC" NVARCHAR2(500),
  "PID" NVARCHAR2(32),
  "HAS_CHILD" NVARCHAR2(3)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_SHOPTYPE_TREE"."ID" IS '主键';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_SHOPTYPE_TREE"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_SHOPTYPE_TREE"."CREATE_TIME" IS '创建日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_SHOPTYPE_TREE"."UPDATE_BY" IS '更新人';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_SHOPTYPE_TREE"."UPDATE_TIME" IS '更新日期';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_SHOPTYPE_TREE"."SYS_ORG_CODE" IS '所属部门';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_SHOPTYPE_TREE"."TYPE_NAME" IS '商品分类';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_SHOPTYPE_TREE"."PIC" IS '分类图片';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_SHOPTYPE_TREE"."PID" IS '父级节点';
COMMENT ON COLUMN "JEECGBOOTOS"."TEST_SHOPTYPE_TREE"."HAS_CHILD" IS '是否有子节点';

-- ----------------------------
-- Records of TEST_SHOPTYPE_TREE
-- ----------------------------
INSERT INTO "JEECGBOOTOS"."TEST_SHOPTYPE_TREE" VALUES ('1256629035921944577', 'admin', TO_DATE('2020-05-03 00:58:03', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'A01', '三星显示器', 'gh_f28e66390fc9_344 (shop)_1588438682583.jpg', '1256628864848867329', '0');
INSERT INTO "JEECGBOOTOS"."TEST_SHOPTYPE_TREE" VALUES ('1833472226709086209', 'admin', TO_DATE('2024-09-10 19:46:57', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'A01', '笔记本', NULL, '0', '0');
INSERT INTO "JEECGBOOTOS"."TEST_SHOPTYPE_TREE" VALUES ('1923190583678107649', 'admin', TO_DATE('2025-05-16 09:35:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'A01', '水果', NULL, '0', '1');
INSERT INTO "JEECGBOOTOS"."TEST_SHOPTYPE_TREE" VALUES ('1923190611448594433', 'admin', TO_DATE('2025-05-16 09:35:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'A01', '苹果', NULL, '1923190583678107649', '0');

-- ----------------------------
-- Primary Key structure for table AIRAG_APP
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."AIRAG_APP" ADD CONSTRAINT "SYS_C0029164" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table AIRAG_APP
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."AIRAG_APP" ADD CONSTRAINT "SYS_C0028910" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table AIRAG_FLOW
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."AIRAG_FLOW" ADD CONSTRAINT "SYS_C0029165" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table AIRAG_FLOW
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."AIRAG_FLOW" ADD CONSTRAINT "SYS_C0028909" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table AIRAG_KNOWLEDGE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."AIRAG_KNOWLEDGE" ADD CONSTRAINT "SYS_C0029162" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table AIRAG_KNOWLEDGE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."AIRAG_KNOWLEDGE" ADD CONSTRAINT "SYS_C0028907" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table AIRAG_KNOWLEDGE_DOC
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."AIRAG_KNOWLEDGE_DOC" ADD CONSTRAINT "SYS_C0029163" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table AIRAG_KNOWLEDGE_DOC
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."AIRAG_KNOWLEDGE_DOC" ADD CONSTRAINT "SYS_C0028908" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table AIRAG_MODEL
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."AIRAG_MODEL" ADD CONSTRAINT "SYS_C0029166" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table AIRAG_MODEL
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."AIRAG_MODEL" ADD CONSTRAINT "SYS_C0028911" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table DEMO
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."DEMO" ADD CONSTRAINT "SYS_C0029167" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table DEMO
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."DEMO" ADD CONSTRAINT "SYS_C0028912" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table FLYWAY_SCHEMA_HISTORY
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY" ADD CONSTRAINT "SYS_C0029168" PRIMARY KEY ("INSTALLED_RANK");

-- ----------------------------
-- Checks structure for table FLYWAY_SCHEMA_HISTORY
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY" ADD CONSTRAINT "SYS_C0028916" CHECK ("INSTALLED_RANK" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY" ADD CONSTRAINT "SYS_C0028918" CHECK ("DESCRIPTION" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY" ADD CONSTRAINT "SYS_C0028920" CHECK ("TYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY" ADD CONSTRAINT "SYS_C0028922" CHECK ("SCRIPT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY" ADD CONSTRAINT "SYS_C0028924" CHECK ("INSTALLED_BY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY" ADD CONSTRAINT "SYS_C0028926" CHECK ("INSTALLED_ON" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY" ADD CONSTRAINT "SYS_C0028928" CHECK ("EXECUTION_TIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY" ADD CONSTRAINT "SYS_C0028930" CHECK ("SUCCESS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table FLYWAY_SCHEMA_HISTORY
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY_S_IDX"
  ON "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY" ("SUCCESS" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table FLYWAY_SCHEMA_HISTORY_1
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY_1" ADD CONSTRAINT "SYS_C0029169" PRIMARY KEY ("INSTALLED_RANK");

-- ----------------------------
-- Checks structure for table FLYWAY_SCHEMA_HISTORY_1
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY_1" ADD CONSTRAINT "SYS_C0028917" CHECK ("INSTALLED_RANK" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY_1" ADD CONSTRAINT "SYS_C0028919" CHECK ("DESCRIPTION" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY_1" ADD CONSTRAINT "SYS_C0028921" CHECK ("TYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY_1" ADD CONSTRAINT "SYS_C0028923" CHECK ("SCRIPT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY_1" ADD CONSTRAINT "SYS_C0028925" CHECK ("INSTALLED_BY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY_1" ADD CONSTRAINT "SYS_C0028927" CHECK ("INSTALLED_ON" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY_1" ADD CONSTRAINT "SYS_C0028929" CHECK ("EXECUTION_TIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."FLYWAY_SCHEMA_HISTORY_1" ADD CONSTRAINT "SYS_C0028931" CHECK ("SUCCESS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table JEECG_ORDER_CUSTOMER
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JEECG_ORDER_CUSTOMER" ADD CONSTRAINT "SYS_C0029170" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JEECG_ORDER_CUSTOMER
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JEECG_ORDER_CUSTOMER" ADD CONSTRAINT "SYS_C0028913" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."JEECG_ORDER_CUSTOMER" ADD CONSTRAINT "SYS_C0028914" CHECK ("NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."JEECG_ORDER_CUSTOMER" ADD CONSTRAINT "SYS_C0028915" CHECK ("ORDER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table JEECG_ORDER_MAIN
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JEECG_ORDER_MAIN" ADD CONSTRAINT "SYS_C0029171" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JEECG_ORDER_MAIN
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JEECG_ORDER_MAIN" ADD CONSTRAINT "SYS_C0028932" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table JEECG_ORDER_TICKET
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JEECG_ORDER_TICKET" ADD CONSTRAINT "SYS_C0029173" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JEECG_ORDER_TICKET
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JEECG_ORDER_TICKET" ADD CONSTRAINT "SYS_C0028935" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."JEECG_ORDER_TICKET" ADD CONSTRAINT "SYS_C0028938" CHECK ("TICKET_CODE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."JEECG_ORDER_TICKET" ADD CONSTRAINT "SYS_C0028941" CHECK ("ORDER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table JIMU_DICT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_DICT" ADD CONSTRAINT "SYS_C0029172" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JIMU_DICT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_DICT" ADD CONSTRAINT "SYS_C0028934" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."JIMU_DICT" ADD CONSTRAINT "SYS_C0028937" CHECK ("DICT_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."JIMU_DICT" ADD CONSTRAINT "SYS_C0028940" CHECK ("DICT_CODE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table JIMU_DICT
-- ----------------------------
CREATE UNIQUE INDEX "JEECGBOOTOS"."UK_SD_DICT_CODE"
  ON "JEECGBOOTOS"."JIMU_DICT" ("DICT_CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table JIMU_DICT_ITEM
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_DICT_ITEM" ADD CONSTRAINT "SYS_C0029174" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JIMU_DICT_ITEM
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_DICT_ITEM" ADD CONSTRAINT "SYS_C0028933" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."JIMU_DICT_ITEM" ADD CONSTRAINT "SYS_C0028936" CHECK ("ITEM_TEXT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."JIMU_DICT_ITEM" ADD CONSTRAINT "SYS_C0028939" CHECK ("ITEM_VALUE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table JIMU_DICT_ITEM
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SDI_DICT_VAL"
  ON "JEECGBOOTOS"."JIMU_DICT_ITEM" ("DICT_ID" ASC, "ITEM_VALUE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SDI_ROLE_DICT_ID"
  ON "JEECGBOOTOS"."JIMU_DICT_ITEM" ("DICT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SDI_ROLE_SORT_ORDER"
  ON "JEECGBOOTOS"."JIMU_DICT_ITEM" ("SORT_ORDER" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SDI_STATUS"
  ON "JEECGBOOTOS"."JIMU_DICT_ITEM" ("STATUS" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table JIMU_REPORT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT" ADD CONSTRAINT "SYS_C0029175" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JIMU_REPORT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT" ADD CONSTRAINT "SYS_C0028942" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table JIMU_REPORT
-- ----------------------------
CREATE UNIQUE INDEX "JEECGBOOTOS"."UNIQ_JMREPORT_CODE"
  ON "JEECGBOOTOS"."JIMU_REPORT" ("CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."UNIQ_JMREPORT_CREATEBY"
  ON "JEECGBOOTOS"."JIMU_REPORT" ("CREATE_BY" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."UNIQ_JMREPORT_DELFLAG"
  ON "JEECGBOOTOS"."JIMU_REPORT" ("DEL_FLAG" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table JIMU_REPORT_CATEGORY
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_CATEGORY" ADD CONSTRAINT "SYS_C0029280" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JIMU_REPORT_CATEGORY
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_CATEGORY" ADD CONSTRAINT "SYS_C0029160" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_CATEGORY" ADD CONSTRAINT "SYS_C0029161" CHECK ("NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table JIMU_REPORT_DATA_SOURCE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_DATA_SOURCE" ADD CONSTRAINT "SYS_C0029176" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JIMU_REPORT_DATA_SOURCE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_DATA_SOURCE" ADD CONSTRAINT "SYS_C0028943" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table JIMU_REPORT_DATA_SOURCE
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_JMDATASOURCE_CODE"
  ON "JEECGBOOTOS"."JIMU_REPORT_DATA_SOURCE" ("CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_JMDATASOURCE_REPORT_ID"
  ON "JEECGBOOTOS"."JIMU_REPORT_DATA_SOURCE" ("REPORT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table JIMU_REPORT_DB
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_DB" ADD CONSTRAINT "SYS_C0029177" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JIMU_REPORT_DB
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_DB" ADD CONSTRAINT "SYS_C0028944" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table JIMU_REPORT_DB
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_DB_SOURCE_ID"
  ON "JEECGBOOTOS"."JIMU_REPORT_DB" ("DB_SOURCE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_JIMU_REPORT_ID"
  ON "JEECGBOOTOS"."JIMU_REPORT_DB" ("JIMU_REPORT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_JMREPORTDB_DB_KEY"
  ON "JEECGBOOTOS"."JIMU_REPORT_DB" ("DB_KEY" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table JIMU_REPORT_DB_FIELD
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_DB_FIELD" ADD CONSTRAINT "SYS_C0029178" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JIMU_REPORT_DB_FIELD
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_DB_FIELD" ADD CONSTRAINT "SYS_C0028945" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table JIMU_REPORT_DB_FIELD
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_DBFIELD_ORDER_NUM"
  ON "JEECGBOOTOS"."JIMU_REPORT_DB_FIELD" ("ORDER_NUM" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_JRDF_JIMU_REPORT_DB_ID"
  ON "JEECGBOOTOS"."JIMU_REPORT_DB_FIELD" ("JIMU_REPORT_DB_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table JIMU_REPORT_DB_PARAM
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_DB_PARAM" ADD CONSTRAINT "SYS_C0029179" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JIMU_REPORT_DB_PARAM
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_DB_PARAM" ADD CONSTRAINT "SYS_C0028946" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_DB_PARAM" ADD CONSTRAINT "SYS_C0028947" CHECK ("JIMU_REPORT_HEAD_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_DB_PARAM" ADD CONSTRAINT "SYS_C0028948" CHECK ("PARAM_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table JIMU_REPORT_DB_PARAM
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_JRDP_JIMU_REPORT_HEAD_ID"
  ON "JEECGBOOTOS"."JIMU_REPORT_DB_PARAM" ("JIMU_REPORT_HEAD_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table JIMU_REPORT_EXPORT_JOB
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_EXPORT_JOB" ADD CONSTRAINT "SYS_C0029180" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JIMU_REPORT_EXPORT_JOB
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_EXPORT_JOB" ADD CONSTRAINT "SYS_C0028949" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table JIMU_REPORT_EXPORT_LOG
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_EXPORT_LOG" ADD CONSTRAINT "SYS_C0029181" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JIMU_REPORT_EXPORT_LOG
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_EXPORT_LOG" ADD CONSTRAINT "SYS_C0028950" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table JIMU_REPORT_ICON_LIB
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_ICON_LIB" ADD CONSTRAINT "SYS_C0029182" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JIMU_REPORT_ICON_LIB
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_ICON_LIB" ADD CONSTRAINT "SYS_C0028951" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table JIMU_REPORT_LINK
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_LINK" ADD CONSTRAINT "SYS_C0029183" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JIMU_REPORT_LINK
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_LINK" ADD CONSTRAINT "SYS_C0028952" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table JIMU_REPORT_LINK
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."UNIQ_LINK_REPORTID"
  ON "JEECGBOOTOS"."JIMU_REPORT_LINK" ("REPORT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table JIMU_REPORT_MAP
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_MAP" ADD CONSTRAINT "SYS_C0029184" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JIMU_REPORT_MAP
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_MAP" ADD CONSTRAINT "SYS_C0028953" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table JIMU_REPORT_MAP
-- ----------------------------
CREATE UNIQUE INDEX "JEECGBOOTOS"."UNIQ_JMREPORT_MAP_NAME"
  ON "JEECGBOOTOS"."JIMU_REPORT_MAP" ("NAME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table JIMU_REPORT_SHARE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_SHARE" ADD CONSTRAINT "SYS_C0029185" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table JIMU_REPORT_SHARE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."JIMU_REPORT_SHARE" ADD CONSTRAINT "SYS_C0028954" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table JIMU_REPORT_SHARE
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_JRS_SHARE_TOKEN"
  ON "JEECGBOOTOS"."JIMU_REPORT_SHARE" ("SHARE_TOKEN" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE UNIQUE INDEX "JEECGBOOTOS"."UNIQ_REPORT_ID"
  ON "JEECGBOOTOS"."JIMU_REPORT_SHARE" ("REPORT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table OAUTH2_REGISTERED_CLIENT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."OAUTH2_REGISTERED_CLIENT" ADD CONSTRAINT "SYS_C0029186" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table OAUTH2_REGISTERED_CLIENT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."OAUTH2_REGISTERED_CLIENT" ADD CONSTRAINT "SYS_C0028955" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."OAUTH2_REGISTERED_CLIENT" ADD CONSTRAINT "SYS_C0028956" CHECK ("CLIENT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."OAUTH2_REGISTERED_CLIENT" ADD CONSTRAINT "SYS_C0028957" CHECK ("CLIENT_ID_ISSUED_AT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."OAUTH2_REGISTERED_CLIENT" ADD CONSTRAINT "SYS_C0028958" CHECK ("CLIENT_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."OAUTH2_REGISTERED_CLIENT" ADD CONSTRAINT "SYS_C0028959" CHECK ("CLIENT_AUTHENTICATION_METHODS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."OAUTH2_REGISTERED_CLIENT" ADD CONSTRAINT "SYS_C0028960" CHECK ("AUTHORIZATION_GRANT_TYPES" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."OAUTH2_REGISTERED_CLIENT" ADD CONSTRAINT "SYS_C0028961" CHECK ("SCOPES" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."OAUTH2_REGISTERED_CLIENT" ADD CONSTRAINT "SYS_C0028962" CHECK ("CLIENT_SETTINGS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."OAUTH2_REGISTERED_CLIENT" ADD CONSTRAINT "SYS_C0028963" CHECK ("TOKEN_SETTINGS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table ONL_AUTH_DATA
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_AUTH_DATA" ADD CONSTRAINT "SYS_C0029187" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_AUTH_DATA
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_AUTH_DATA" ADD CONSTRAINT "SYS_C0028964" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table ONL_AUTH_PAGE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_AUTH_PAGE" ADD CONSTRAINT "SYS_C0029188" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_AUTH_PAGE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_AUTH_PAGE" ADD CONSTRAINT "SYS_C0028965" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_AUTH_PAGE
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_ONL_AUTH_PAGE_CGFORM_ID"
  ON "JEECGBOOTOS"."ONL_AUTH_PAGE" ("CGFORM_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_ONL_AUTH_PAGE_CODE"
  ON "JEECGBOOTOS"."ONL_AUTH_PAGE" ("CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table ONL_AUTH_RELATION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_AUTH_RELATION" ADD CONSTRAINT "SYS_C0029189" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_AUTH_RELATION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_AUTH_RELATION" ADD CONSTRAINT "SYS_C0028966" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table ONL_CGFORM_BUTTON
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_BUTTON" ADD CONSTRAINT "SYS_C0029190" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_CGFORM_BUTTON
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_BUTTON" ADD CONSTRAINT "SYS_C0028967" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_CGFORM_BUTTON
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_OCB_BUTTON_CODE"
  ON "JEECGBOOTOS"."ONL_CGFORM_BUTTON" ("BUTTON_CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_OCB_BUTTON_STATUS"
  ON "JEECGBOOTOS"."ONL_CGFORM_BUTTON" ("BUTTON_STATUS" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_OCB_CGFORM_HEAD_ID"
  ON "JEECGBOOTOS"."ONL_CGFORM_BUTTON" ("CGFORM_HEAD_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_OCB_ORDER_NUM"
  ON "JEECGBOOTOS"."ONL_CGFORM_BUTTON" ("ORDER_NUM" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table ONL_CGFORM_ENHANCE_JAVA
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_JAVA" ADD CONSTRAINT "SYS_C0029191" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_CGFORM_ENHANCE_JAVA
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_JAVA" ADD CONSTRAINT "SYS_C0028968" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_JAVA" ADD CONSTRAINT "SYS_C0028969" CHECK ("CG_JAVA_TYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_JAVA" ADD CONSTRAINT "SYS_C0028970" CHECK ("CG_JAVA_VALUE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_JAVA" ADD CONSTRAINT "SYS_C0028971" CHECK ("CGFORM_HEAD_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_JAVA" ADD CONSTRAINT "SYS_C0028972" CHECK ("EVENT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_CGFORM_ENHANCE_JAVA
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_EJAVA_CGFORM_HEAD_ID"
  ON "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_JAVA" ("CGFORM_HEAD_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_OCEJ_ACTIVE_STATUS"
  ON "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_JAVA" ("ACTIVE_STATUS" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_OCEJ_BUTTON_CODE"
  ON "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_JAVA" ("BUTTON_CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table ONL_CGFORM_ENHANCE_JS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_JS" ADD CONSTRAINT "SYS_C0029192" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_CGFORM_ENHANCE_JS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_JS" ADD CONSTRAINT "SYS_C0028973" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_CGFORM_ENHANCE_JS
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_EJS_CGFORM_HEAD_ID"
  ON "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_JS" ("CGFORM_HEAD_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_EJS_CG_JS_TYPE"
  ON "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_JS" ("CG_JS_TYPE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table ONL_CGFORM_ENHANCE_SQL
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_SQL" ADD CONSTRAINT "SYS_C0029193" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_CGFORM_ENHANCE_SQL
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_SQL" ADD CONSTRAINT "SYS_C0028974" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_CGFORM_ENHANCE_SQL
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_OCES_CGFORM_HEAD_ID"
  ON "JEECGBOOTOS"."ONL_CGFORM_ENHANCE_SQL" ("CGFORM_HEAD_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table ONL_CGFORM_FIELD
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_FIELD" ADD CONSTRAINT "SYS_C0029194" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_CGFORM_FIELD
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_FIELD" ADD CONSTRAINT "SYS_C0028975" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_FIELD" ADD CONSTRAINT "SYS_C0028976" CHECK ("CGFORM_HEAD_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_FIELD" ADD CONSTRAINT "SYS_C0028977" CHECK ("DB_FIELD_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_FIELD" ADD CONSTRAINT "SYS_C0028978" CHECK ("DB_TYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_FIELD" ADD CONSTRAINT "SYS_C0028979" CHECK ("DB_LENGTH" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_CGFORM_FIELD
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_OCF_CGFORM_HEAD_ID"
  ON "JEECGBOOTOS"."ONL_CGFORM_FIELD" ("CGFORM_HEAD_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table ONL_CGFORM_HEAD
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_HEAD" ADD CONSTRAINT "SYS_C0029195" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_CGFORM_HEAD
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_HEAD" ADD CONSTRAINT "SYS_C0028980" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_HEAD" ADD CONSTRAINT "SYS_C0028981" CHECK ("TABLE_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_HEAD" ADD CONSTRAINT "SYS_C0028982" CHECK ("TABLE_TYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_HEAD" ADD CONSTRAINT "SYS_C0028983" CHECK ("TABLE_TXT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_HEAD" ADD CONSTRAINT "SYS_C0028984" CHECK ("IS_CHECKBOX" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_HEAD" ADD CONSTRAINT "SYS_C0028985" CHECK ("IS_DB_SYNCH" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_HEAD" ADD CONSTRAINT "SYS_C0028986" CHECK ("IS_PAGE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_HEAD" ADD CONSTRAINT "SYS_C0028987" CHECK ("IS_TREE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_HEAD" ADD CONSTRAINT "SYS_C0028988" CHECK ("FORM_CATEGORY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_CGFORM_HEAD
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_OCH_CGFORM_HEAD_ID"
  ON "JEECGBOOTOS"."ONL_CGFORM_HEAD" ("TABLE_NAME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_OCH_FORM_TEMPLATE_MOBILE"
  ON "JEECGBOOTOS"."ONL_CGFORM_HEAD" ("FORM_TEMPLATE_MOBILE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_OCH_TABLE_NAME"
  ON "JEECGBOOTOS"."ONL_CGFORM_HEAD" ("FORM_TEMPLATE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_OCH_TABLE_VERSION"
  ON "JEECGBOOTOS"."ONL_CGFORM_HEAD" ("TABLE_VERSION" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table ONL_CGFORM_INDEX
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_INDEX" ADD CONSTRAINT "SYS_C0029196" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_CGFORM_INDEX
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGFORM_INDEX" ADD CONSTRAINT "SYS_C0028989" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_CGFORM_INDEX
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_OCI_CGFORM_HEAD_ID"
  ON "JEECGBOOTOS"."ONL_CGFORM_INDEX" ("CGFORM_HEAD_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table ONL_CGREPORT_HEAD
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGREPORT_HEAD" ADD CONSTRAINT "SYS_C0029197" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_CGREPORT_HEAD
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGREPORT_HEAD" ADD CONSTRAINT "SYS_C0028990" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGREPORT_HEAD" ADD CONSTRAINT "SYS_C0028991" CHECK ("CODE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGREPORT_HEAD" ADD CONSTRAINT "SYS_C0028992" CHECK ("NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGREPORT_HEAD" ADD CONSTRAINT "SYS_C0028993" CHECK ("CGR_SQL" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_CGREPORT_HEAD
-- ----------------------------
CREATE UNIQUE INDEX "JEECGBOOTOS"."INDEX_ONLINEREPORT_CODE"
  ON "JEECGBOOTOS"."ONL_CGREPORT_HEAD" ("CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table ONL_CGREPORT_ITEM
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGREPORT_ITEM" ADD CONSTRAINT "SYS_C0029198" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_CGREPORT_ITEM
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGREPORT_ITEM" ADD CONSTRAINT "SYS_C0028994" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGREPORT_ITEM" ADD CONSTRAINT "SYS_C0028995" CHECK ("CGRHEAD_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGREPORT_ITEM" ADD CONSTRAINT "SYS_C0028996" CHECK ("FIELD_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_CGREPORT_ITEM
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_OCI_CGRHEAD_ID"
  ON "JEECGBOOTOS"."ONL_CGREPORT_ITEM" ("CGRHEAD_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_OCI_IS_SHOW"
  ON "JEECGBOOTOS"."ONL_CGREPORT_ITEM" ("IS_SHOW" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_OCI_ORDER_NUM"
  ON "JEECGBOOTOS"."ONL_CGREPORT_ITEM" ("ORDER_NUM" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table ONL_CGREPORT_PARAM
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGREPORT_PARAM" ADD CONSTRAINT "SYS_C0029199" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_CGREPORT_PARAM
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_CGREPORT_PARAM" ADD CONSTRAINT "SYS_C0028997" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGREPORT_PARAM" ADD CONSTRAINT "SYS_C0028998" CHECK ("CGRHEAD_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_CGREPORT_PARAM" ADD CONSTRAINT "SYS_C0028999" CHECK ("PARAM_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_CGREPORT_PARAM
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_OCP_CGRHEAD_ID"
  ON "JEECGBOOTOS"."ONL_CGREPORT_PARAM" ("CGRHEAD_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table ONL_DRAG_COMP
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_COMP" ADD CONSTRAINT "SYS_C0029200" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_DRAG_COMP
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_COMP" ADD CONSTRAINT "SYS_C0029000" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table ONL_DRAG_DATASET_HEAD
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_DATASET_HEAD" ADD CONSTRAINT "SYS_C0029201" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_DRAG_DATASET_HEAD
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_DATASET_HEAD" ADD CONSTRAINT "SYS_C0029001" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_DATASET_HEAD" ADD CONSTRAINT "SYS_C0029002" CHECK ("NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table ONL_DRAG_DATASET_ITEM
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_DATASET_ITEM" ADD CONSTRAINT "SYS_C0029202" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_DRAG_DATASET_ITEM
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_DATASET_ITEM" ADD CONSTRAINT "SYS_C0029003" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_DATASET_ITEM" ADD CONSTRAINT "SYS_C0029004" CHECK ("HEAD_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_DRAG_DATASET_ITEM
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_ODDI_HEAD_ID"
  ON "JEECGBOOTOS"."ONL_DRAG_DATASET_ITEM" ("HEAD_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table ONL_DRAG_DATASET_PARAM
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_DATASET_PARAM" ADD CONSTRAINT "SYS_C0029203" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_DRAG_DATASET_PARAM
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_DATASET_PARAM" ADD CONSTRAINT "SYS_C0029005" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_DATASET_PARAM" ADD CONSTRAINT "SYS_C0029006" CHECK ("HEAD_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_DATASET_PARAM" ADD CONSTRAINT "SYS_C0029007" CHECK ("PARAM_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_DRAG_DATASET_PARAM
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_ODDP_HEAD_ID"
  ON "JEECGBOOTOS"."ONL_DRAG_DATASET_PARAM" ("HEAD_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table ONL_DRAG_PAGE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_PAGE" ADD CONSTRAINT "SYS_C0029204" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_DRAG_PAGE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_PAGE" ADD CONSTRAINT "SYS_C0029008" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table ONL_DRAG_PAGE_COMP
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_PAGE_COMP" ADD CONSTRAINT "SYS_C0029205" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_DRAG_PAGE_COMP
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_PAGE_COMP" ADD CONSTRAINT "SYS_C0029009" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table ONL_DRAG_SHARE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_SHARE" ADD CONSTRAINT "SYS_C0029206" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_DRAG_SHARE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_SHARE" ADD CONSTRAINT "SYS_C0029010" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_DRAG_SHARE
-- ----------------------------
CREATE UNIQUE INDEX "JEECGBOOTOS"."UNIQ_ODS_DRAG_ID"
  ON "JEECGBOOTOS"."ONL_DRAG_SHARE" ("DRAG_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table ONL_DRAG_TABLE_RELATION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_TABLE_RELATION" ADD CONSTRAINT "SYS_C0029207" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table ONL_DRAG_TABLE_RELATION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."ONL_DRAG_TABLE_RELATION" ADD CONSTRAINT "SYS_C0029011" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table ONL_DRAG_TABLE_RELATION
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_AGGREGATION_NAME"
  ON "JEECGBOOTOS"."ONL_DRAG_TABLE_RELATION" ("AGGREGATION_NAME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_CREATE_BY"
  ON "JEECGBOOTOS"."ONL_DRAG_TABLE_RELATION" ("CREATE_BY" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_DEL_FLAG"
  ON "JEECGBOOTOS"."ONL_DRAG_TABLE_RELATION" ("DEL_FLAG" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_TENANT_ID"
  ON "JEECGBOOTOS"."ONL_DRAG_TABLE_RELATION" ("TENANT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table OPEN_API
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."OPEN_API" ADD CONSTRAINT "SYS_C0029208" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table OPEN_API
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."OPEN_API" ADD CONSTRAINT "SYS_C0029012" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table OPEN_API_AUTH
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."OPEN_API_AUTH" ADD CONSTRAINT "SYS_C0029209" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table OPEN_API_AUTH
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."OPEN_API_AUTH" ADD CONSTRAINT "SYS_C0029013" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table OPEN_API_LOG
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."OPEN_API_LOG" ADD CONSTRAINT "SYS_C0029210" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table OPEN_API_LOG
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."OPEN_API_LOG" ADD CONSTRAINT "SYS_C0029014" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table OPEN_API_PERMISSION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."OPEN_API_PERMISSION" ADD CONSTRAINT "SYS_C0029211" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table OPEN_API_PERMISSION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."OPEN_API_PERMISSION" ADD CONSTRAINT "SYS_C0029015" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table OSS_FILE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."OSS_FILE" ADD CONSTRAINT "SYS_C0029212" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table OSS_FILE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."OSS_FILE" ADD CONSTRAINT "SYS_C0029016" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table QRTZ_BLOB_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_BLOB_TRIGGERS" ADD CONSTRAINT "QRTZ_BLOB_TRIG_PK" PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Checks structure for table QRTZ_BLOB_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_BLOB_TRIGGERS" ADD CONSTRAINT "SYS_C0029319" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_BLOB_TRIGGERS" ADD CONSTRAINT "SYS_C0029320" CHECK ("TRIGGER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_BLOB_TRIGGERS" ADD CONSTRAINT "SYS_C0029321" CHECK ("TRIGGER_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table QRTZ_CALENDARS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_CALENDARS" ADD CONSTRAINT "QRTZ_CALENDARS_PK" PRIMARY KEY ("SCHED_NAME", "CALENDAR_NAME");

-- ----------------------------
-- Checks structure for table QRTZ_CALENDARS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_CALENDARS" ADD CONSTRAINT "SYS_C0029324" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_CALENDARS" ADD CONSTRAINT "SYS_C0029325" CHECK ("CALENDAR_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_CALENDARS" ADD CONSTRAINT "SYS_C0029326" CHECK ("CALENDAR" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table QRTZ_CRON_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_CRON_TRIGGERS" ADD CONSTRAINT "QRTZ_CRON_TRIG_PK" PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Checks structure for table QRTZ_CRON_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_CRON_TRIGGERS" ADD CONSTRAINT "SYS_C0029308" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_CRON_TRIGGERS" ADD CONSTRAINT "SYS_C0029309" CHECK ("TRIGGER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_CRON_TRIGGERS" ADD CONSTRAINT "SYS_C0029310" CHECK ("TRIGGER_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_CRON_TRIGGERS" ADD CONSTRAINT "SYS_C0029311" CHECK ("CRON_EXPRESSION" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table QRTZ_FIRED_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "QRTZ_FIRED_TRIGGER_PK" PRIMARY KEY ("SCHED_NAME", "ENTRY_ID");

-- ----------------------------
-- Checks structure for table QRTZ_FIRED_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0029331" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0029332" CHECK ("ENTRY_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0029333" CHECK ("TRIGGER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0029334" CHECK ("TRIGGER_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0029335" CHECK ("INSTANCE_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0029336" CHECK ("FIRED_TIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0029337" CHECK ("SCHED_TIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0029338" CHECK ("PRIORITY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT "SYS_C0029339" CHECK ("STATE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table QRTZ_FIRED_TRIGGERS
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_FT_INST_JOB_REQ_RCVRY"
  ON "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ("SCHED_NAME" ASC, "INSTANCE_NAME" ASC, "REQUESTS_RECOVERY" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_FT_JG"
  ON "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ("SCHED_NAME" ASC, "JOB_GROUP" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_FT_J_G"
  ON "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ("SCHED_NAME" ASC, "JOB_NAME" ASC, "JOB_GROUP" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_FT_TG"
  ON "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ("SCHED_NAME" ASC, "TRIGGER_GROUP" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_FT_TRIG_INST_NAME"
  ON "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ("SCHED_NAME" ASC, "INSTANCE_NAME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_FT_T_G"
  ON "JEECGBOOTOS"."QRTZ_FIRED_TRIGGERS" ("SCHED_NAME" ASC, "TRIGGER_NAME" ASC, "TRIGGER_GROUP" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table QRTZ_JOB_DETAILS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_JOB_DETAILS" ADD CONSTRAINT "QRTZ_JOB_DETAILS_PK" PRIMARY KEY ("SCHED_NAME", "JOB_NAME", "JOB_GROUP");

-- ----------------------------
-- Checks structure for table QRTZ_JOB_DETAILS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0029281" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0029282" CHECK ("JOB_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0029283" CHECK ("JOB_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0029284" CHECK ("JOB_CLASS_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0029285" CHECK ("IS_DURABLE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0029286" CHECK ("IS_NONCONCURRENT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0029287" CHECK ("IS_UPDATE_DATA" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_JOB_DETAILS" ADD CONSTRAINT "SYS_C0029288" CHECK ("REQUESTS_RECOVERY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table QRTZ_JOB_DETAILS
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_J_GRP"
  ON "JEECGBOOTOS"."QRTZ_JOB_DETAILS" ("SCHED_NAME" ASC, "JOB_GROUP" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_J_REQ_RECOVERY"
  ON "JEECGBOOTOS"."QRTZ_JOB_DETAILS" ("SCHED_NAME" ASC, "REQUESTS_RECOVERY" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table QRTZ_LOCKS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_LOCKS" ADD CONSTRAINT "QRTZ_LOCKS_PK" PRIMARY KEY ("SCHED_NAME", "LOCK_NAME");

-- ----------------------------
-- Checks structure for table QRTZ_LOCKS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_LOCKS" ADD CONSTRAINT "SYS_C0029346" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_LOCKS" ADD CONSTRAINT "SYS_C0029347" CHECK ("LOCK_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_PAUSED_TRIGGER_GRPS" ADD CONSTRAINT "QRTZ_PAUSED_TRIG_GRPS_PK" PRIMARY KEY ("SCHED_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Checks structure for table QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_PAUSED_TRIGGER_GRPS" ADD CONSTRAINT "SYS_C0029328" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_PAUSED_TRIGGER_GRPS" ADD CONSTRAINT "SYS_C0029329" CHECK ("TRIGGER_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table QRTZ_SCHEDULER_STATE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_SCHEDULER_STATE" ADD CONSTRAINT "QRTZ_SCHEDULER_STATE_PK" PRIMARY KEY ("SCHED_NAME", "INSTANCE_NAME");

-- ----------------------------
-- Checks structure for table QRTZ_SCHEDULER_STATE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_SCHEDULER_STATE" ADD CONSTRAINT "SYS_C0029341" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_SCHEDULER_STATE" ADD CONSTRAINT "SYS_C0029342" CHECK ("INSTANCE_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_SCHEDULER_STATE" ADD CONSTRAINT "SYS_C0029343" CHECK ("LAST_CHECKIN_TIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_SCHEDULER_STATE" ADD CONSTRAINT "SYS_C0029344" CHECK ("CHECKIN_INTERVAL" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "QRTZ_SIMPLE_TRIG_PK" PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Checks structure for table QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "SYS_C0029300" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "SYS_C0029301" CHECK ("TRIGGER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "SYS_C0029302" CHECK ("TRIGGER_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "SYS_C0029303" CHECK ("REPEAT_COUNT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "SYS_C0029304" CHECK ("REPEAT_INTERVAL" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "SYS_C0029305" CHECK ("TIMES_TRIGGERED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_SIMPROP_TRIGGERS" ADD CONSTRAINT "QRTZ_SIMPROP_TRIG_PK" PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Checks structure for table QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_SIMPROP_TRIGGERS" ADD CONSTRAINT "SYS_C0029314" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_SIMPROP_TRIGGERS" ADD CONSTRAINT "SYS_C0029315" CHECK ("TRIGGER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_SIMPROP_TRIGGERS" ADD CONSTRAINT "SYS_C0029316" CHECK ("TRIGGER_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table QRTZ_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_TRIGGERS" ADD CONSTRAINT "QRTZ_TRIGGERS_PK" PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Checks structure for table QRTZ_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0029290" CHECK ("SCHED_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0029291" CHECK ("TRIGGER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0029292" CHECK ("TRIGGER_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0029293" CHECK ("JOB_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0029294" CHECK ("JOB_GROUP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0029295" CHECK ("TRIGGER_STATE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0029296" CHECK ("TRIGGER_TYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."QRTZ_TRIGGERS" ADD CONSTRAINT "SYS_C0029297" CHECK ("START_TIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table QRTZ_TRIGGERS
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_T_C"
  ON "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "CALENDAR_NAME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_T_G"
  ON "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "TRIGGER_GROUP" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_T_J"
  ON "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "JOB_NAME" ASC, "JOB_GROUP" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_T_JG"
  ON "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "JOB_GROUP" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_T_NEXT_FIRE_TIME"
  ON "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "NEXT_FIRE_TIME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_T_NFT_MISFIRE"
  ON "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "MISFIRE_INSTR" ASC, "NEXT_FIRE_TIME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_T_NFT_ST"
  ON "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "TRIGGER_STATE" ASC, "NEXT_FIRE_TIME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_T_NFT_ST_MISFIRE"
  ON "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "MISFIRE_INSTR" ASC, "NEXT_FIRE_TIME" ASC, "TRIGGER_STATE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_T_NFT_ST_MISFIRE_GRP"
  ON "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "MISFIRE_INSTR" ASC, "NEXT_FIRE_TIME" ASC, "TRIGGER_GROUP" ASC, "TRIGGER_STATE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_T_N_G_STATE"
  ON "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "TRIGGER_GROUP" ASC, "TRIGGER_STATE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_T_N_STATE"
  ON "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "TRIGGER_NAME" ASC, "TRIGGER_GROUP" ASC, "TRIGGER_STATE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_QRTZ_T_STATE"
  ON "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "TRIGGER_STATE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table REP_DEMO_DXTJ
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_DXTJ" ADD CONSTRAINT "SYS_C0029224" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table REP_DEMO_DXTJ
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_DXTJ" ADD CONSTRAINT "SYS_C0029069" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table REP_DEMO_EMPLOYEE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_EMPLOYEE" ADD CONSTRAINT "SYS_C0029225" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table REP_DEMO_EMPLOYEE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_EMPLOYEE" ADD CONSTRAINT "SYS_C0029070" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table REP_DEMO_GONGSI
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_GONGSI" ADD CONSTRAINT "SYS_C0029226" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table REP_DEMO_GONGSI
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_GONGSI" ADD CONSTRAINT "SYS_C0029071" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_GONGSI" ADD CONSTRAINT "SYS_C0029072" CHECK ("GNAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_GONGSI" ADD CONSTRAINT "SYS_C0029073" CHECK ("GDATA" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_GONGSI" ADD CONSTRAINT "SYS_C0029074" CHECK ("TDATA" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_GONGSI" ADD CONSTRAINT "SYS_C0029075" CHECK ("DIDIAN" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_GONGSI" ADD CONSTRAINT "SYS_C0029076" CHECK ("ZHAIYAO" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_GONGSI" ADD CONSTRAINT "SYS_C0029077" CHECK ("NUM" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table REP_DEMO_JIANPIAO
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_JIANPIAO" ADD CONSTRAINT "SYS_C0029227" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table REP_DEMO_JIANPIAO
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_JIANPIAO" ADD CONSTRAINT "SYS_C0029078" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_JIANPIAO" ADD CONSTRAINT "SYS_C0029079" CHECK ("BNUM" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_JIANPIAO" ADD CONSTRAINT "SYS_C0029080" CHECK ("FTIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_JIANPIAO" ADD CONSTRAINT "SYS_C0029081" CHECK ("SFKONG" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_JIANPIAO" ADD CONSTRAINT "SYS_C0029082" CHECK ("KAISHI" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_JIANPIAO" ADD CONSTRAINT "SYS_C0029083" CHECK ("JIESHU" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_JIANPIAO" ADD CONSTRAINT "SYS_C0029084" CHECK ("HEZAIREN" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_JIANPIAO" ADD CONSTRAINT "SYS_C0029085" CHECK ("JPNUM" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_JIANPIAO" ADD CONSTRAINT "SYS_C0029086" CHECK ("SHIHELV" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_JIANPIAO" ADD CONSTRAINT "SYS_C0029087" CHECK ("S_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table REP_DEMO_ORDER_MAIN
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_ORDER_MAIN" ADD CONSTRAINT "SYS_C0029228" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table REP_DEMO_ORDER_MAIN
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_ORDER_MAIN" ADD CONSTRAINT "SYS_C0029088" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table REP_DEMO_ORDER_PRODUCT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_ORDER_PRODUCT" ADD CONSTRAINT "SYS_C0029229" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table REP_DEMO_ORDER_PRODUCT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_ORDER_PRODUCT" ADD CONSTRAINT "SYS_C0029089" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."REP_DEMO_ORDER_PRODUCT" ADD CONSTRAINT "SYS_C0029090" CHECK ("ORDER_FK_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table SYS_ANNOUNCEMENT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_ANNOUNCEMENT" ADD CONSTRAINT "SYS_C0029230" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_ANNOUNCEMENT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_ANNOUNCEMENT" ADD CONSTRAINT "SYS_C0029091" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_ANNOUNCEMENT" ADD CONSTRAINT "SYS_C0029092" CHECK ("MSG_CATEGORY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_ANNOUNCEMENT
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SANNO_CREATE_TIME"
  ON "JEECGBOOTOS"."SYS_ANNOUNCEMENT" ("CREATE_TIME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SANNO_DEL_FLAG"
  ON "JEECGBOOTOS"."SYS_ANNOUNCEMENT" ("DEL_FLAG" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SANNO_ENDTIME"
  ON "JEECGBOOTOS"."SYS_ANNOUNCEMENT" ("END_TIME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SANNO_MSG_TYPE"
  ON "JEECGBOOTOS"."SYS_ANNOUNCEMENT" ("MSG_TYPE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SANNO_SENDER"
  ON "JEECGBOOTOS"."SYS_ANNOUNCEMENT" ("SENDER" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SANNO_SEND_STATUS"
  ON "JEECGBOOTOS"."SYS_ANNOUNCEMENT" ("SEND_STATUS" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SANNO_START_TIME"
  ON "JEECGBOOTOS"."SYS_ANNOUNCEMENT" ("START_TIME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SANNO_TENANT_ID"
  ON "JEECGBOOTOS"."SYS_ANNOUNCEMENT" ("TENANT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_ANNOUNCEMENT_SEND
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_ANNOUNCEMENT_SEND" ADD CONSTRAINT "SYS_C0029231" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_ANNOUNCEMENT_SEND
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_ANNOUNCEMENT_SEND" ADD CONSTRAINT "SYS_C0029093" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_ANNOUNCEMENT_SEND
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SACM_ANNT_ID"
  ON "JEECGBOOTOS"."SYS_ANNOUNCEMENT_SEND" ("ANNT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SACM_READ_FLAG"
  ON "JEECGBOOTOS"."SYS_ANNOUNCEMENT_SEND" ("READ_FLAG" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SACM_STAR_FLAG"
  ON "JEECGBOOTOS"."SYS_ANNOUNCEMENT_SEND" ("STAR_FLAG" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SACM_USER_ID"
  ON "JEECGBOOTOS"."SYS_ANNOUNCEMENT_SEND" ("USER_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_CATEGORY
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_CATEGORY" ADD CONSTRAINT "SYS_C0029232" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_CATEGORY
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_CATEGORY" ADD CONSTRAINT "SYS_C0029094" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_CATEGORY
-- ----------------------------
CREATE UNIQUE INDEX "JEECGBOOTOS"."INDEX_SCG_CODE"
  ON "JEECGBOOTOS"."SYS_CATEGORY" ("CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_CHECK_RULE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_CHECK_RULE" ADD CONSTRAINT "SYS_C0029233" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_CHECK_RULE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_CHECK_RULE" ADD CONSTRAINT "SYS_C0029095" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_CHECK_RULE
-- ----------------------------
CREATE UNIQUE INDEX "JEECGBOOTOS"."UK_SCR_RULE_CODE"
  ON "JEECGBOOTOS"."SYS_CHECK_RULE" ("RULE_CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_COMMENT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_COMMENT" ADD CONSTRAINT "SYS_C0029234" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_COMMENT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_COMMENT" ADD CONSTRAINT "SYS_C0029096" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_COMMENT" ADD CONSTRAINT "SYS_C0029097" CHECK ("TABLE_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_COMMENT" ADD CONSTRAINT "SYS_C0029098" CHECK ("TABLE_DATA_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_COMMENT" ADD CONSTRAINT "SYS_C0029099" CHECK ("FROM_USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_COMMENT
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_TABLE_DATA_ID"
  ON "JEECGBOOTOS"."SYS_COMMENT" ("TABLE_NAME" ASC, "TABLE_DATA_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_DATA_LOG
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DATA_LOG" ADD CONSTRAINT "SYS_C0029235" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_DATA_LOG
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DATA_LOG" ADD CONSTRAINT "SYS_C0029100" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_DATA_LOG
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SDL_DATA_TABLE_ID"
  ON "JEECGBOOTOS"."SYS_DATA_LOG" ("DATA_TABLE" ASC, "DATA_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_DATA_SOURCE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DATA_SOURCE" ADD CONSTRAINT "SYS_C0029236" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_DATA_SOURCE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DATA_SOURCE" ADD CONSTRAINT "SYS_C0029101" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_DATA_SOURCE
-- ----------------------------
CREATE UNIQUE INDEX "JEECGBOOTOS"."UK_SDC_RULE_CODE"
  ON "JEECGBOOTOS"."SYS_DATA_SOURCE" ("CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_DEPART
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DEPART" ADD CONSTRAINT "SYS_C0029237" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_DEPART
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DEPART" ADD CONSTRAINT "SYS_C0029102" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_DEPART" ADD CONSTRAINT "SYS_C0029103" CHECK ("DEPART_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_DEPART" ADD CONSTRAINT "SYS_C0029104" CHECK ("ORG_CATEGORY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_DEPART" ADD CONSTRAINT "SYS_C0029105" CHECK ("ORG_CODE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_DEPART
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SD_DEPART_ORDER"
  ON "JEECGBOOTOS"."SYS_DEPART" ("DEPART_ORDER" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SD_PARENT_ID"
  ON "JEECGBOOTOS"."SYS_DEPART" ("PARENT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE UNIQUE INDEX "JEECGBOOTOS"."UNIQ_DEPART_ORG_CODE"
  ON "JEECGBOOTOS"."SYS_DEPART" ("ORG_CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_DEPART_PERMISSION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DEPART_PERMISSION" ADD CONSTRAINT "SYS_C0029238" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_DEPART_PERMISSION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DEPART_PERMISSION" ADD CONSTRAINT "SYS_C0029106" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table SYS_DEPART_ROLE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DEPART_ROLE" ADD CONSTRAINT "SYS_C0029239" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_DEPART_ROLE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DEPART_ROLE" ADD CONSTRAINT "SYS_C0029107" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table SYS_DEPART_ROLE_PERMISSION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DEPART_ROLE_PERMISSION" ADD CONSTRAINT "SYS_C0029240" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_DEPART_ROLE_PERMISSION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DEPART_ROLE_PERMISSION" ADD CONSTRAINT "SYS_C0029108" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_DEPART_ROLE_PERMISSION
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SDRP_PER_ID"
  ON "JEECGBOOTOS"."SYS_DEPART_ROLE_PERMISSION" ("PERMISSION_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SDRP_ROLE_ID"
  ON "JEECGBOOTOS"."SYS_DEPART_ROLE_PERMISSION" ("ROLE_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SDRP_ROLE_PER_ID"
  ON "JEECGBOOTOS"."SYS_DEPART_ROLE_PERMISSION" ("ROLE_ID" ASC, "PERMISSION_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_DEPART_ROLE_USER
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DEPART_ROLE_USER" ADD CONSTRAINT "SYS_C0029241" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_DEPART_ROLE_USER
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DEPART_ROLE_USER" ADD CONSTRAINT "SYS_C0029109" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_DEPART_ROLE_USER
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SDR_ROLE_ID"
  ON "JEECGBOOTOS"."SYS_DEPART_ROLE_USER" ("DROLE_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SDR_USER_ID"
  ON "JEECGBOOTOS"."SYS_DEPART_ROLE_USER" ("USER_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_DICT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DICT" ADD CONSTRAINT "SYS_C0029242" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_DICT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DICT" ADD CONSTRAINT "SYS_C0029110" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_DICT" ADD CONSTRAINT "SYS_C0029111" CHECK ("DICT_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_DICT" ADD CONSTRAINT "SYS_C0029112" CHECK ("DICT_CODE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_DICT
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."UK_SD_TENANT_ID"
  ON "JEECGBOOTOS"."SYS_DICT" ("TENANT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_DICT_ITEM
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DICT_ITEM" ADD CONSTRAINT "SYS_C0029243" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_DICT_ITEM
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_DICT_ITEM" ADD CONSTRAINT "SYS_C0029113" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_DICT_ITEM" ADD CONSTRAINT "SYS_C0029114" CHECK ("ITEM_TEXT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_DICT_ITEM" ADD CONSTRAINT "SYS_C0029115" CHECK ("ITEM_VALUE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_DICT_ITEM
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SDITEM_DICT_VAL"
  ON "JEECGBOOTOS"."SYS_DICT_ITEM" ("DICT_ID" ASC, "ITEM_VALUE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SDITEM_ROLE_DICT_ID"
  ON "JEECGBOOTOS"."SYS_DICT_ITEM" ("DICT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SDITEM_ROLE_SORT_ORDER"
  ON "JEECGBOOTOS"."SYS_DICT_ITEM" ("SORT_ORDER" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SDITEM_STATUS"
  ON "JEECGBOOTOS"."SYS_DICT_ITEM" ("STATUS" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_FILES
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_FILES" ADD CONSTRAINT "SYS_C0029244" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_FILES
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_FILES" ADD CONSTRAINT "SYS_C0029116" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_FILES
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."INDEX_DEL_FLAG"
  ON "JEECGBOOTOS"."SYS_FILES" ("DEL_FLAG" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."INDEX_TENANT_ID"
  ON "JEECGBOOTOS"."SYS_FILES" ("TENANT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_FILL_RULE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_FILL_RULE" ADD CONSTRAINT "SYS_C0029245" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_FILL_RULE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_FILL_RULE" ADD CONSTRAINT "SYS_C0029117" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_FILL_RULE
-- ----------------------------
CREATE UNIQUE INDEX "JEECGBOOTOS"."UK_SFR_RULE_CODE"
  ON "JEECGBOOTOS"."SYS_FILL_RULE" ("RULE_CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_FORM_FILE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_FORM_FILE" ADD CONSTRAINT "SYS_C0029246" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_FORM_FILE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_FORM_FILE" ADD CONSTRAINT "SYS_C0029118" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_FORM_FILE" ADD CONSTRAINT "SYS_C0029119" CHECK ("TABLE_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_FORM_FILE" ADD CONSTRAINT "SYS_C0029120" CHECK ("TABLE_DATA_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_FORM_FILE
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_TABLE_FORM"
  ON "JEECGBOOTOS"."SYS_FORM_FILE" ("TABLE_NAME" ASC, "TABLE_DATA_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."INDEX_FILE_ID"
  ON "JEECGBOOTOS"."SYS_FORM_FILE" ("FILE_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_GATEWAY_ROUTE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_GATEWAY_ROUTE" ADD CONSTRAINT "SYS_C0029247" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_GATEWAY_ROUTE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_GATEWAY_ROUTE" ADD CONSTRAINT "SYS_C0029121" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table SYS_LOG
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_LOG" ADD CONSTRAINT "SYS_C0029248" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_LOG
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_LOG" ADD CONSTRAINT "SYS_C0029122" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_LOG
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SL_CREATE_TIME"
  ON "JEECGBOOTOS"."SYS_LOG" ("CREATE_TIME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SL_LOG_TYPE"
  ON "JEECGBOOTOS"."SYS_LOG" ("LOG_TYPE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SL_OPERATE_TYPE"
  ON "JEECGBOOTOS"."SYS_LOG" ("OPERATE_TYPE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SL_USERID"
  ON "JEECGBOOTOS"."SYS_LOG" ("USERID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_PERMISSION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_PERMISSION" ADD CONSTRAINT "SYS_C0029249" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_PERMISSION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_PERMISSION" ADD CONSTRAINT "SYS_C0029123" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_PERMISSION
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."INDEX_MENU_DEL_FLAG"
  ON "JEECGBOOTOS"."SYS_PERMISSION" ("DEL_FLAG" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."INDEX_MENU_HIDDEN"
  ON "JEECGBOOTOS"."SYS_PERMISSION" ("HIDDEN" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."INDEX_MENU_SORT_NO"
  ON "JEECGBOOTOS"."SYS_PERMISSION" ("SORT_NO" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."INDEX_MENU_STATUS"
  ON "JEECGBOOTOS"."SYS_PERMISSION" ("STATUS" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."INDEX_MENU_TYPE"
  ON "JEECGBOOTOS"."SYS_PERMISSION" ("MENU_TYPE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."INDEX_MENU_URL"
  ON "JEECGBOOTOS"."SYS_PERMISSION" ("URL" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_PERMISSION_DATA_RULE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_PERMISSION_DATA_RULE" ADD CONSTRAINT "SYS_C0029250" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_PERMISSION_DATA_RULE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_PERMISSION_DATA_RULE" ADD CONSTRAINT "SYS_C0029124" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_PERMISSION_DATA_RULE
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SPDR_PERMISSION_ID"
  ON "JEECGBOOTOS"."SYS_PERMISSION_DATA_RULE" ("PERMISSION_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_POSITION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_POSITION" ADD CONSTRAINT "SYS_C0029251" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_POSITION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_POSITION" ADD CONSTRAINT "SYS_C0029125" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_POSITION
-- ----------------------------
CREATE UNIQUE INDEX "JEECGBOOTOS"."UNIQ_CODE"
  ON "JEECGBOOTOS"."SYS_POSITION" ("CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_QUARTZ_JOB
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_QUARTZ_JOB" ADD CONSTRAINT "SYS_C0029252" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_QUARTZ_JOB
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_QUARTZ_JOB" ADD CONSTRAINT "SYS_C0029126" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table SYS_ROLE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_ROLE" ADD CONSTRAINT "SYS_C0029253" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_ROLE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_ROLE" ADD CONSTRAINT "SYS_C0029127" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_ROLE" ADD CONSTRAINT "SYS_C0029128" CHECK ("ROLE_CODE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_ROLE
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SYSROLE_TENANT_ID"
  ON "JEECGBOOTOS"."SYS_ROLE" ("TENANT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE UNIQUE INDEX "JEECGBOOTOS"."UNIQ_SYS_ROLE_ROLE_CODE"
  ON "JEECGBOOTOS"."SYS_ROLE" ("ROLE_CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_ROLE_INDEX
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_ROLE_INDEX" ADD CONSTRAINT "SYS_C0029254" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_ROLE_INDEX
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_ROLE_INDEX" ADD CONSTRAINT "SYS_C0029129" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_ROLE_INDEX
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SRI_PRIORITY"
  ON "JEECGBOOTOS"."SYS_ROLE_INDEX" ("PRIORITY" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SRI_ROLE_CODE"
  ON "JEECGBOOTOS"."SYS_ROLE_INDEX" ("ROLE_CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SRI_STATUS"
  ON "JEECGBOOTOS"."SYS_ROLE_INDEX" ("STATUS" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_ROLE_PERMISSION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_ROLE_PERMISSION" ADD CONSTRAINT "SYS_C0029255" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_ROLE_PERMISSION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_ROLE_PERMISSION" ADD CONSTRAINT "SYS_C0029130" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_ROLE_PERMISSION
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SRP_PERMISSION_ID"
  ON "JEECGBOOTOS"."SYS_ROLE_PERMISSION" ("PERMISSION_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SRP_ROLE_ID"
  ON "JEECGBOOTOS"."SYS_ROLE_PERMISSION" ("ROLE_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SRP_ROLE_PER_ID"
  ON "JEECGBOOTOS"."SYS_ROLE_PERMISSION" ("ROLE_ID" ASC, "PERMISSION_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_SMS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_SMS" ADD CONSTRAINT "SYS_C0029256" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_SMS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_SMS" ADD CONSTRAINT "SYS_C0029131" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_SMS
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SS_ES_RECEIVER"
  ON "JEECGBOOTOS"."SYS_SMS" ("ES_RECEIVER" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SS_ES_SEND_STATUS"
  ON "JEECGBOOTOS"."SYS_SMS" ("ES_SEND_STATUS" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SS_ES_SEND_TIME"
  ON "JEECGBOOTOS"."SYS_SMS" ("ES_SEND_TIME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SS_ES_TYPE"
  ON "JEECGBOOTOS"."SYS_SMS" ("ES_TYPE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_SMS_TEMPLATE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_SMS_TEMPLATE" ADD CONSTRAINT "SYS_C0029257" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_SMS_TEMPLATE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_SMS_TEMPLATE" ADD CONSTRAINT "SYS_C0029132" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_SMS_TEMPLATE" ADD CONSTRAINT "SYS_C0029133" CHECK ("TEMPLATE_CODE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_SMS_TEMPLATE" ADD CONSTRAINT "SYS_C0029134" CHECK ("TEMPLATE_TYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_SMS_TEMPLATE" ADD CONSTRAINT "SYS_C0029135" CHECK ("TEMPLATE_CONTENT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_SMS_TEMPLATE
-- ----------------------------
CREATE UNIQUE INDEX "JEECGBOOTOS"."UK_SST_TEMPLATE_CODE"
  ON "JEECGBOOTOS"."SYS_SMS_TEMPLATE" ("TEMPLATE_CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_TABLE_WHITE_LIST
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" ADD CONSTRAINT "SYS_C0029258" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_TABLE_WHITE_LIST
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_TABLE_WHITE_LIST" ADD CONSTRAINT "SYS_C0029136" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table SYS_TENANT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_TENANT" ADD CONSTRAINT "SYS_C0029259" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_TENANT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_TENANT" ADD CONSTRAINT "SYS_C0029137" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table SYS_TENANT_PACK
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_TENANT_PACK" ADD CONSTRAINT "SYS_C0029260" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_TENANT_PACK
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_TENANT_PACK" ADD CONSTRAINT "SYS_C0029138" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_TENANT_PACK
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX__STP_TENANT_ID_PACK_CODE"
  ON "JEECGBOOTOS"."SYS_TENANT_PACK" ("TENANT_ID" ASC, "PACK_CODE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_TENANT_PACK_PERMS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" ADD CONSTRAINT "SYS_C0029261" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_TENANT_PACK_PERMS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" ADD CONSTRAINT "SYS_C0029139" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_TENANT_PACK_PERMS
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_STPP_PACK_ID"
  ON "JEECGBOOTOS"."SYS_TENANT_PACK_PERMS" ("PACK_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_TENANT_PACK_USER
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_TENANT_PACK_USER" ADD CONSTRAINT "SYS_C0029262" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_TENANT_PACK_USER
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_TENANT_PACK_USER" ADD CONSTRAINT "SYS_C0029140" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_TENANT_PACK_USER
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_TPU_PACK_ID"
  ON "JEECGBOOTOS"."SYS_TENANT_PACK_USER" ("PACK_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_TPU_STATUS"
  ON "JEECGBOOTOS"."SYS_TENANT_PACK_USER" ("STATUS" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_TPU_TENANT_ID"
  ON "JEECGBOOTOS"."SYS_TENANT_PACK_USER" ("TENANT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_TPU_USER_ID"
  ON "JEECGBOOTOS"."SYS_TENANT_PACK_USER" ("USER_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_THIRD_ACCOUNT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_THIRD_ACCOUNT" ADD CONSTRAINT "SYS_C0029263" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_THIRD_ACCOUNT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_THIRD_ACCOUNT" ADD CONSTRAINT "SYS_C0029141" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_THIRD_ACCOUNT
-- ----------------------------
CREATE UNIQUE INDEX "JEECGBOOTOS"."UNIQ_STAT_THIRD_TYPE_USER_ID"
  ON "JEECGBOOTOS"."SYS_THIRD_ACCOUNT" ("THIRD_TYPE" ASC, "THIRD_USER_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_THIRD_APP_CONFIG
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG" ADD CONSTRAINT "SYS_C0029264" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_THIRD_APP_CONFIG
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG" ADD CONSTRAINT "SYS_C0029142" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG" ADD CONSTRAINT "SYS_C0029143" CHECK ("TENANT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_THIRD_APP_CONFIG
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_STAC_TENANT_ID"
  ON "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG" ("TENANT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_STAC_THIRD_TYPE"
  ON "JEECGBOOTOS"."SYS_THIRD_APP_CONFIG" ("THIRD_TYPE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_USER
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_USER" ADD CONSTRAINT "SYS_C0029265" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_USER
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_USER" ADD CONSTRAINT "SYS_C0029144" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_USER
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SU_DEL_FLAG"
  ON "JEECGBOOTOS"."SYS_USER" ("DEL_FLAG" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SU_DEL_USERNAME"
  ON "JEECGBOOTOS"."SYS_USER" ("USERNAME" ASC, "DEL_FLAG" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SU_STATUS"
  ON "JEECGBOOTOS"."SYS_USER" ("STATUS" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE UNIQUE INDEX "JEECGBOOTOS"."UNIQ_SYS_USER_EMAIL"
  ON "JEECGBOOTOS"."SYS_USER" ("EMAIL" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE UNIQUE INDEX "JEECGBOOTOS"."UNIQ_SYS_USER_PHONE"
  ON "JEECGBOOTOS"."SYS_USER" ("PHONE" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE UNIQUE INDEX "JEECGBOOTOS"."UNIQ_SYS_USER_USERNAME"
  ON "JEECGBOOTOS"."SYS_USER" ("USERNAME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE UNIQUE INDEX "JEECGBOOTOS"."UNIQ_SYS_USER_WORK_NO"
  ON "JEECGBOOTOS"."SYS_USER" ("WORK_NO" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_USER_AGENT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_USER_AGENT" ADD CONSTRAINT "SYS_C0029266" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_USER_AGENT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_USER_AGENT" ADD CONSTRAINT "SYS_C0029145" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_USER_AGENT
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SUG_END_TIME"
  ON "JEECGBOOTOS"."SYS_USER_AGENT" ("END_TIME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SUG_START_TIME"
  ON "JEECGBOOTOS"."SYS_USER_AGENT" ("START_TIME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SUG_STATUS"
  ON "JEECGBOOTOS"."SYS_USER_AGENT" ("STATUS" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE UNIQUE INDEX "JEECGBOOTOS"."UK_SUG_USER_NAME"
  ON "JEECGBOOTOS"."SYS_USER_AGENT" ("USER_NAME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_USER_DEPART
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_USER_DEPART" ADD CONSTRAINT "SYS_C0029267" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_USER_DEPART
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_USER_DEPART" ADD CONSTRAINT "SYS_C0029146" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_USER_DEPART
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SUD_DEP_ID"
  ON "JEECGBOOTOS"."SYS_USER_DEPART" ("DEP_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE UNIQUE INDEX "JEECGBOOTOS"."IDX_SUD_USER_DEP_ID"
  ON "JEECGBOOTOS"."SYS_USER_DEPART" ("USER_ID" ASC, "DEP_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SUD_USER_ID"
  ON "JEECGBOOTOS"."SYS_USER_DEPART" ("USER_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_USER_POSITION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_USER_POSITION" ADD CONSTRAINT "SYS_C0029268" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_USER_POSITION
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_USER_POSITION" ADD CONSTRAINT "SYS_C0029147" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_USER_POSITION
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SUP_POSITION_ID"
  ON "JEECGBOOTOS"."SYS_USER_POSITION" ("POSITION_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SUP_USER_ID"
  ON "JEECGBOOTOS"."SYS_USER_POSITION" ("USER_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SUP_USER_POSITION_ID"
  ON "JEECGBOOTOS"."SYS_USER_POSITION" ("USER_ID" ASC, "POSITION_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_USER_ROLE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_USER_ROLE" ADD CONSTRAINT "SYS_C0029269" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_USER_ROLE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_USER_ROLE" ADD CONSTRAINT "SYS_C0029148" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_USER_ROLE
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SUR_ROLE_ID"
  ON "JEECGBOOTOS"."SYS_USER_ROLE" ("ROLE_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SUR_USER_ID"
  ON "JEECGBOOTOS"."SYS_USER_ROLE" ("USER_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SUR_USER_ROLE_ID"
  ON "JEECGBOOTOS"."SYS_USER_ROLE" ("USER_ID" ASC, "ROLE_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table SYS_USER_TENANT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_USER_TENANT" ADD CONSTRAINT "SYS_C0029270" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table SYS_USER_TENANT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."SYS_USER_TENANT" ADD CONSTRAINT "SYS_C0029149" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table SYS_USER_TENANT
-- ----------------------------
CREATE INDEX "JEECGBOOTOS"."IDX_SUT_STATUS"
  ON "JEECGBOOTOS"."SYS_USER_TENANT" ("STATUS" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SUT_TENANT_ID"
  ON "JEECGBOOTOS"."SYS_USER_TENANT" ("TENANT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SUT_USERID_STATUS"
  ON "JEECGBOOTOS"."SYS_USER_TENANT" ("USER_ID" ASC, "STATUS" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SUT_USER_ID"
  ON "JEECGBOOTOS"."SYS_USER_TENANT" ("USER_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);
CREATE INDEX "JEECGBOOTOS"."IDX_SUT_USER_REL_TENANT"
  ON "JEECGBOOTOS"."SYS_USER_TENANT" ("USER_ID" ASC, "TENANT_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table TEST_DEMO
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_DEMO" ADD CONSTRAINT "SYS_C0029271" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table TEST_DEMO
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_DEMO" ADD CONSTRAINT "SYS_C0029150" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TEST_ENHANCE_SELECT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_ENHANCE_SELECT" ADD CONSTRAINT "SYS_C0029272" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table TEST_ENHANCE_SELECT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_ENHANCE_SELECT" ADD CONSTRAINT "SYS_C0029151" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TEST_NOTE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_NOTE" ADD CONSTRAINT "SYS_C0029273" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table TEST_NOTE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_NOTE" ADD CONSTRAINT "SYS_C0029152" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TEST_ONLINE_LINK
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_ONLINE_LINK" ADD CONSTRAINT "SYS_C0029274" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table TEST_ONLINE_LINK
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_ONLINE_LINK" ADD CONSTRAINT "SYS_C0029153" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TEST_ORDER_CUSTOMER
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_ORDER_CUSTOMER" ADD CONSTRAINT "SYS_C0029275" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table TEST_ORDER_CUSTOMER
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_ORDER_CUSTOMER" ADD CONSTRAINT "SYS_C0029154" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TEST_ORDER_MAIN
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_ORDER_MAIN" ADD CONSTRAINT "SYS_C0029276" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table TEST_ORDER_MAIN
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_ORDER_MAIN" ADD CONSTRAINT "SYS_C0029155" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TEST_ORDER_PRODUCT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_ORDER_PRODUCT" ADD CONSTRAINT "SYS_C0029277" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table TEST_ORDER_PRODUCT
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_ORDER_PRODUCT" ADD CONSTRAINT "SYS_C0029156" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JEECGBOOTOS"."TEST_ORDER_PRODUCT" ADD CONSTRAINT "SYS_C0029157" CHECK ("ORDER_FK_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TEST_PERSON
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_PERSON" ADD CONSTRAINT "SYS_C0029278" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table TEST_PERSON
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_PERSON" ADD CONSTRAINT "SYS_C0029158" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TEST_SHOPTYPE_TREE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_SHOPTYPE_TREE" ADD CONSTRAINT "SYS_C0029279" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table TEST_SHOPTYPE_TREE
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."TEST_SHOPTYPE_TREE" ADD CONSTRAINT "SYS_C0029159" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table QRTZ_BLOB_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_BLOB_TRIGGERS" ADD CONSTRAINT "QRTZ_BLOB_TRIG_TO_TRIG_FK" FOREIGN KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") REFERENCES "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table QRTZ_CRON_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_CRON_TRIGGERS" ADD CONSTRAINT "QRTZ_CRON_TRIG_TO_TRIG_FK" FOREIGN KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") REFERENCES "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "QRTZ_SIMPLE_TRIG_TO_TRIG_FK" FOREIGN KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") REFERENCES "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
ALTER TABLE "JEECGBOOTOS"."QRTZ_SIMPROP_TRIGGERS" ADD CONSTRAINT "QRTZ_SIMPROP_TRIG_TO_TRIG_FK" FOREIGN KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") REFERENCES "JEECGBOOTOS"."QRTZ_TRIGGERS" ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table QRTZ_TRIGGERS
-- ----------------------------
