iailab-plat.git

Merge remote-tracking branch 'origin/master'

潘志宝

2 天以前 af7bd200a95b9fc6b8b3f3fc603d612221e21fc7

提交 \| 用户 \| 时间
6a5cf8	1	create table t_dm_module
f154f0	2	(
4eb113	3	id varchar(36) not null,
潘	4	modulename varchar(50),
	5	moduletype varchar(30),
	6	cycle decimal(5, 0),
	7	modulenavconfig varchar(3072),
	8	predicttime datetime,
	9	collecttime datetime,
	10	create_time datetime default current_timestamp,
	11	update_time datetime default current_timestamp,
	12	traintime datetime,
	13	primary key (id),
	14	UNIQUE INDEX uk_modulename (modulename),
	15	INDEX idx_moduletype (moduletype)
6a5cf8	16	) engine = innodb default character set utf8mb4 COMMENT = '管网表';
f154f0	17
潘	18
6a5cf8	19	create table t_dm_module_item
f154f0	20	(
4eb113	21	id varchar(36) not null,
潘	22	moduleid varchar(36),
	23	itemid varchar(36),
	24	itemorder bigint,
	25	status bigint,
	26	categoryid varchar(64),
	27	primary key (id),
	28	key idx_moduleid (moduleid)
6a5cf8	29	) engine = innodb default character set utf8mb4 COMMENT = '管网预测项关系表';
f154f0	30
潘	31	create table t_mm_item_output
	32	(
4eb113	33	id varchar(36) not null,
潘	34	itemid varchar(36),
	35	pointid varchar(36),
	36	resulttableid varchar(36),
	37	tagname varchar(50),
	38	outputorder decimal(5, 0),
	39	primary key (id),
	40	INDEX idx_itemid (itemid)
6a5cf8	41	) engine = innodb default character set utf8mb4 COMMENT = '预测项输出表';
f154f0	42
6a5cf8	43	create table t_mm_item_type
f154f0	44	(
4eb113	45	id varchar(36) not null,
潘	46	itemtypename varchar(50),
	47	itemclasstype varchar(100),
	48	assemblyname varchar(64),
	49	primary key (id)
6a5cf8	50	) engine = innodb default character set utf8mb4 COMMENT = '预测项类型表';
f154f0	51
6a5cf8	52	create table t_mm_model_arith_settings
f154f0	53	(
4eb113	54	id varchar(36) not null,
潘	55	modelid varchar(36),
	56	`key` varchar(36),
bacb0d	57	value varchar(1000),
4eb113	58	name varchar(36),
潘	59	valuetype varchar(36),
	60	primary key (id),
	61	INDEX idx_modelid (modelid)
6a5cf8	62	) engine = innodb default character set utf8mb4 COMMENT = '预测模型设置参数表';
f154f0	63
6a5cf8	64	create table t_mm_model_param
f154f0	65	(
4eb113	66	id varchar(36) not null,
潘	67	modelid varchar(36),
	68	modelparamname varchar(36),
	69	modelparamid varchar(36),
	70	modelparamorder integer,
	71	modelparamportorder integer,
	72	datalength integer,
	73	modelparamtype varchar(36),
	74	primary key (id),
	75	INDEX idx_modelid (modelid)
6a5cf8	76	) engine = innodb default character set utf8mb4 COMMENT = '预测模型输入参数表';
f154f0	77
潘	78	create table
4eb113	79	t_mm_predict_item
f154f0	80	(
4eb113	81	id varchar(36) not null,
潘	82	itemno varchar(16),
	83	itemname varchar(50),
	84	caltypeid varchar(36),
	85	itemtypeid varchar(36),
	86	predictlength int,
	87	granularity int,
	88	status tinyint,
	89	isfuse tinyint,
	90	predictphase tinyint,
	91	workchecked tinyint,
	92	unittransfactor decimal(16, 6),
	93	create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
	94	update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
	95	saveindex varchar(16),
	96	primary key (id),
	97	UNIQUE INDEX uk_itemno (itemno),
	98	INDEX uk_itemtypeid (itemtypeid)
137356	99	) engine = innodb default character set utf8mb4 COMMENT = '预测项表';
f154f0	100
潘	101	create table
4eb113	102	t_mm_predict_merge_item
f154f0	103	(
4eb113	104	id varchar(36) not null,
潘	105	itemid varchar(36),
318292	106	expression varchar(1000),
4eb113	107	num integer,
潘	108	primary key (id),
	109	UNIQUE INDEX uk_itemid (itemid)
6a5cf8	110	) engine = innodb default character set utf8mb4 COMMENT = '合并预测项表';
f154f0	111
潘	112	create table
4eb113	113	t_mm_predict_model
f154f0	114	(
4eb113	115	id varchar(36) not null,
潘	116	modelno varchar(32),
	117	modelname varchar(50),
	118	itemid varchar(36),
	119	arithid varchar(36),
	120	trainsamplength decimal(5, 0),
	121	predictsamplength decimal(5, 0),
	122	isonlinetrain decimal(5, 0),
	123	modelpath varchar(256),
	124	isnormal decimal(5, 0),
	125	normalmax decimal(19, 3),
	126	normalmin decimal(19, 3),
	127	status decimal(5, 0),
	128	classname varchar(256),
	129	methodname varchar(64),
	130	modelparamstructure varchar(128),
	131	resultstrid varchar(64),
	132	settingmap varchar(256),
	133	trainmodelpath varchar(256),
	134	pathstatus decimal(5, 0),
	135	pdim smallint,
	136	traninip varchar(16),
	137	comparisonclassname varchar(256),
	138	primary key (id),
	139	INDEX idx_modelno (modelno),
	140	UNIQUE INDEX idx_itemid (itemid)
f154f0	141	) engine = innodb
6a5cf8	142	default character set utf8mb4 COMMENT = '预测项模型表';
f154f0	143
6a5cf8	144	create table t_mm_item_result_json
f154f0	145	(
4eb113	146	id varchar(36) not null,
潘	147	outputid varchar(36),
	148	predicttime datetime,
	149	jsonvalue varchar(6400),
	150	cumulant varchar(36),
	151	primary key (id),
	152	INDEX idx_outputid (outputid),
	153	INDEX idx_predicttime (predicttime)
6a5cf8	154	) engine = innodb default character set utf8mb4 COMMENT = '预测JSON数据表';
f154f0	155
6a5cf8	156	create table t_mm_item_accuracy_rate
f154f0	157	(
4eb113	158	id varchar(36) not null,
潘	159	item_id varchar(36) not null COMMENT '预测项ID',
97d38f	160	out_id varchar(36) not null COMMENT '输出ID',
潘	161	sample_length integer COMMENT '取样长度',
4eb113	162	value_type integer COMMENT '值类型',
97d38f	163	begin_time datetime COMMENT '开始统计时间',
4eb113	164	in_deviation decimal(8, 3) COMMENT '精准误差',
潘	165	in_accuracy_rate decimal(6, 4) COMMENT '精准度',
	166	out_deviation decimal(8, 3) COMMENT '不可信误差',
	167	out_accuracy_rate decimal(6, 4) COMMENT '不可信率',
97d38f	168	is_enable tinyint COMMENT '是否启用',
潘	169	create_time datetime COMMENT '创建时间',
	170	update_time datetime COMMENT '更新时间',
4eb113	171	primary key (id),
潘	172	INDEX idx_item_id (item_id)
f154f0	173	) engine = innodb
6a5cf8	174	default character set utf8mb4 COMMENT = '预测精准度表';
97d38f	175
潘	176	create table t_mm_item_accuracy_his
	177	(
	178	id varchar(36) not null,
	179	rate_id varchar(36) not null COMMENT '预测精准度ID',
	180	in_deviation decimal(8, 3) COMMENT '精准误差',
	181	in_accuracy_rate decimal(6, 4) COMMENT '精准度',
	182	out_deviation decimal(8, 3) COMMENT '不可信误差',
	183	out_accuracy_rate decimal(6, 4) COMMENT '不可信率',
	184	create_time datetime COMMENT '创建时间',
	185	primary key (id),
	186	INDEX idx_rate_id (rate_id)
	187	) engine = innodb
	188	default character set utf8mb4 COMMENT = '预测精准度历史';
f154f0	189
7fd198	190	create table t_mm_predict_alarm_config
f154f0	191	(
4eb113	192	id varchar(36) not null,
潘	193	title varchar(20) COMMENT '消息标题',
	194	alarm_obj varchar(36) COMMENT '监控对象',
	195	item_id varchar(36) COMMENT '预测项ID',
97d38f	196	out_id varchar(36) COMMENT '输出ID',
4eb113	197	comp_length int COMMENT '比较长度',
潘	198	upper_limit decimal(10, 4) COMMENT '上限',
	199	lower_limit decimal(10, 4) COMMENT '下限',
	200	unit varchar(10) COMMENT '单位',
	201	coefficient decimal(10, 4) COMMENT '转换系数',
97d38f	202	schedule_id varchar(36) COMMENT '调度方案',
4eb113	203	is_enable tinyint NOT NULL COMMENT '是否启用（0禁用 1启用）',
潘	204	`creator` varchar(64) NOT NULL DEFAULT '' COMMENT '创建者',
	205	`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
	206	`updater` varchar(64) DEFAULT '' COMMENT '更新者',
	207	`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
	208	primary key (id)
7fd198	209	) engine = innodb
潘	210	default character set utf8mb4 COMMENT = '预警配置表';
	211
	212	create table t_mm_predict_alarm_message
	213	(
4eb113	214	id varchar(36) not null,
b06c21	215	config_id varchar(36) COMMENT '配置ID',
4eb113	216	title varchar(36) COMMENT '消息标题',
潘	217	content varchar(128) COMMENT '消息内容',
	218	alarm_obj varchar(36) COMMENT '监控对象',
	219	point_id varchar(36) COMMENT '监控点位ID',
	220	item_id varchar(36) COMMENT '预测项ID',
97d38f	221	out_id varchar(36) COMMENT '输出ID',
4eb113	222	current_value decimal(18, 4) COMMENT '当前值',
潘	223	out_time datetime COMMENT '超出时间',
	224	out_value decimal(18, 4) COMMENT '超出值',
	225	alarm_type varchar(10) COMMENT '预警类型',
	226	alarm_time datetime COMMENT '预警时间',
	227	create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
	228	primary key (id),
	229	INDEX idx_item_id (item_id),
b06c21	230	INDEX idx_config_id (config_id),
4eb113	231	INDEX idx_alarm_obj (alarm_obj),
潘	232	INDEX idx_alarm_time (alarm_time)
f154f0	233	) engine = innodb
7fd198	234	default character set utf8mb4 COMMENT = '预警消息表';
f154f0	235
6a5cf8	236
潘	237	-- 调度模块
	238
	239	create table t_st_schedule_scheme
f154f0	240	(
4eb113	241	`id` varchar(36) not null COMMENT 'ID',
潘	242	`code` varchar(20) not null COMMENT '编号',
	243	`name` varchar(20) not null COMMENT '名称',
	244	`trigger_method` varchar(20) COMMENT '触发方式',
	245	`trigger_condition` varchar(20) COMMENT '触发条件',
	246	`schedule_obj` varchar(20) COMMENT '调整对象',
	247	`schedule_type` varchar(20) COMMENT '调整类型',
	248	`schedule_strategy` varchar(20) COMMENT '调整策略',
	249	`model_id` varchar(36) COMMENT '调度模型',
	250	`schedule_time` datetime COMMENT '调度时间',
	251	`status` tinyint NOT NULL DEFAULT 0 COMMENT '方案状态（0正常 1停用）',
	252	`remark` varchar(100) COMMENT '备注',
	253	`creator` varchar(64) NOT NULL DEFAULT '' COMMENT '创建者',
	254	`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
	255	`updater` varchar(64) NULL DEFAULT '' COMMENT '更新者',
	256	`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
	257	`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
	258	primary key (id),
	259	UNIQUE INDEX `uk_code` (`code` ASC) USING BTREE
f154f0	260	) engine = innodb
6a5cf8	261	default character set utf8mb4 COMMENT = '调度方案表';
潘	262
	263	create table t_st_schedule_model
	264	(
4eb113	265	`id` varchar(36) not null COMMENT 'ID',
潘	266	`model_code` varchar(64) not null COMMENT '模型编号',
	267	`model_name` varchar(64) not null COMMENT '模型名称',
	268	`model_type` varchar(64) COMMENT '模型类型',
	269	`class_name` varchar(128) COMMENT '类名',
	270	`method_name` varchar(64) COMMENT '方法名',
	271	`port_length` integer COMMENT '输入数量',
	272	`param_structure` varchar(256) COMMENT '参数构造',
	273	`model_path` varchar(256) COMMENT '路径',
	274	`result_str_id` varchar(64) COMMENT '结果ID',
	275	`invocation` varchar(64) COMMENT '调用方式',
	276	`status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0正常 1停用）',
	277	`creator` varchar(64) NOT NULL DEFAULT '' COMMENT '创建者',
	278	`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
	279	`updater` varchar(64) NULL DEFAULT '' COMMENT '更新者',
	280	`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
	281	`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
	282	primary key (id),
	283	UNIQUE INDEX `uk_model_code` (`model_code` ASC) USING BTREE
bbc1ee	284	) engine = innodb default character set utf8mb4 COMMENT = '调度模型表';
f154f0	285
潘	286	create table
4eb113	287	t_st_schedule_model_param
f154f0	288	(
4eb113	289	id varchar(36) not null,
潘	290	modelid varchar(64) not null,
	291	modelparamname varchar(64),
	292	modelparamid varchar(64),
	293	modelparamorder integer,
	294	modelparamportorder integer,
	295	datalength integer,
	296	modelparamtype varchar(64),
	297	primary key (id)
f154f0	298	) engine = innodb
6a5cf8	299	default character set utf8mb4 COMMENT = '调度模型输入参数表';
潘	300
f154f0	301
潘	302	create table
4eb113	303	t_st_schedule_model_setting
6a5cf8	304	(
4eb113	305	`id` varchar(36) not null,
潘	306	`modelid` varchar(64) not null,
	307	`key` varchar(64),
	308	`value` varchar(64),
	309	`valuetype` varchar(64),
	310	`name` varchar(64),
	311	`sort` integer,
	312	primary key (id),
	313	key idx_modelid (modelid)
6a5cf8	314	) engine = innodb
潘	315	default character set utf8mb4 COMMENT = '调度模型设置参数表';
	316
	317	create table
4eb113	318	t_st_schedule_suggest
f154f0	319	(
4eb113	320	id varchar(36) not null,
潘	321	title varchar(50) COMMENT '标题',
	322	content varchar(256) COMMENT '内容',
	323	sort integer COMMENT '排序',
	324	scheme_id varchar(36) COMMENT '方案ID',
	325	alarm_id varchar(36) COMMENT '预警ID',
	326	item_id varchar(36) COMMENT '预测项ID',
	327	model_id varchar(36) COMMENT '模型ID',
	328	schedule_obj varchar(20) COMMENT '调整对象',
	329	schedule_type varchar(20) COMMENT '调整类型',
	330	schedule_strategy varchar(20) COMMENT '调整策略',
	331	adjust_mode varchar(20) COMMENT '调整方式',
	332	adjust_value decimal(18, 4) COMMENT '调整值',
	333	adjust_unit varchar(20) COMMENT '调整单位',
	334	adjust_times decimal(18, 4) COMMENT '持续时长',
	335	adjust_start datetime COMMENT '调整开始时间',
	336	adjust_end datetime COMMENT '调整结束时间',
	337	schedule_time datetime COMMENT '调度时间',
	338	status tinyint NOT NULL COMMENT '状态（0未处理 1已采纳 2已忽略）',
	339	handler varchar(36) COMMENT '处理人',
	340	handle_time datetime COMMENT '处理时间',
	341	create_time datetime default current_timestamp COMMENT '创建时间',
	342	primary key (id),
	343	INDEX idx_scheme_id (scheme_id),
	344	INDEX idx_alarm_id (alarm_id),
	345	INDEX idx_item_id (item_id),
	346	INDEX idx_model_id (model_id),
	347	INDEX idx_schedule_obj (schedule_obj),
	348	INDEX idx_schedule_type (schedule_type)
f154f0	349	) engine = innodb
6a5cf8	350	default character set utf8mb4 COMMENT = '调度建议表';
潘	351
f154f0	352
潘	353	create table
4eb113	354	t_st_schedule_record
f154f0	355	(
4eb113	356	`id` varchar(36) not null,
潘	357	`scheme_id` varchar(36) COMMENT '方案ID',
	358	`model_id` varchar(36) COMMENT '模型ID',
	359	`model_name` varchar(64) COMMENT '模型名称',
	360	`schedule_time` datetime COMMENT '调度时间',
	361	`create_time` datetime default current_timestamp COMMENT '创建时间',
	362	primary key (id),
	363	INDEX idx_scheme_id (scheme_id),
	364	INDEX idx_model_id (model_id),
	365	INDEX idx_schedule_time (schedule_time)
f154f0	366	) engine = innodb
6a5cf8	367	default character set utf8mb4 COMMENT = '调度记录表';
潘	368
	369
	370	create table
4eb113	371	t_st_schedule_record_detail
6a5cf8	372	(
4eb113	373	`id` varchar(36) not null,
潘	374	`record_id` varchar(36),
	375	`scheme_id` varchar(64),
	376	`model_id` varchar(36) COMMENT '模型ID',
	377	`result_key` varchar(64),
	378	`result_value` text,
	379	`schedule_time` datetime COMMENT '调度时间',
	380	primary key (id),
	381	key idx_record_id (record_id),
	382	key idx_scheme_id (scheme_id),
	383	key idx_model_id (model_id)
6a5cf8	384	) engine = innodb
潘	385	default character set utf8mb4 COMMENT = '调度记录详情表';
446130	386
D	387	-- mpk
	388
	389	-- menu
4eb113	390	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
潘	391	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	392	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	393	`deleted`)
	394	VALUES (1803317368415416369, '模型库', '', 2, 20, 1803317368415416363, 'mpk', 'ep:folder', 'mpk/mpk', 'Mpk', 0, b'1',
	395	b'1', b'1', '1', '2024-08-31 16:50:38', '1', '2024-09-10 14:53:17', b'0');
	396	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
	397	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	398	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	399	`deleted`)
	400	VALUES (1803317368415416370, 'MPK查询', 'mpk:query', 3, 0, 1803317368415416369, '', '', '', '', 0, b'1', b'1', b'1',
	401	'1', '2024-09-02 10:14:00', '1', '2024-09-06 11:50:19', b'0');
	402	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
	403	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	404	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	405	`deleted`)
	406	VALUES (1803317368415416371, 'MPK新增', 'mpk:create', 3, 1, 1803317368415416369, '', '', '', '', 0, b'1', b'1', b'1',
	407	'1', '2024-09-02 10:14:25', '1', '2024-09-06 11:50:28', b'0');
	408	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
	409	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	410	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	411	`deleted`)
	412	VALUES (1803317368415416372, 'MPK修改', 'mpk:update', 3, 2, 1803317368415416369, '', '', '', '', 0, b'1', b'1', b'1',
	413	'1', '2024-09-02 10:14:44', '1', '2024-09-06 11:50:38', b'0');
	414	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
	415	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	416	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	417	`deleted`)
	418	VALUES (1803317368415416373, 'MPK删除', 'mpk:delete', 3, 3, 1803317368415416369, '', '', '', '', 0, b'1', b'1', b'1',
	419	'1', '2024-09-02 10:15:04', '1', '2024-09-06 11:50:46', b'0');
	420	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
	421	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	422	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	423	`deleted`)
	424	VALUES (1803317368415416374, '项目管理', '', 2, 30, 1803317368415416363, 'project', 'ep:document-copy', 'mpk/project',
	425	'Project', 0, b'1', b'1', b'1', '1', '2024-09-10 14:44:54', '1', '2024-09-10 14:53:26', b'0');
	426	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
	427	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	428	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	429	`deleted`)
	430	VALUES (1803317368415416375, '项目查询', 'project:query', 3, 0, 1803317368415416374, '', '', '', '', 0, b'1', b'1',
	431	b'1', '1', '2024-09-10 14:45:53', '1', '2024-09-10 14:45:53', b'0');
	432	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
	433	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	434	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	435	`deleted`)
	436	VALUES (1803317368415416376, '项目新增', 'project:create', 3, 1, 1803317368415416374, '', '', '', '', 0, b'1', b'1',
	437	b'1', '1', '2024-09-10 14:46:16', '1', '2024-09-10 14:46:16', b'0');
	438	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
	439	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	440	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	441	`deleted`)
	442	VALUES (1803317368415416377, '项目修改', 'project:update', 3, 2, 1803317368415416374, '', '', '', '', 0, b'1', b'1',
	443	b'1', '1', '2024-09-10 14:46:33', '1', '2024-09-10 14:46:33', b'0');
	444	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
	445	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	446	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	447	`deleted`)
	448	VALUES (1803317368415416378, '项目删除', 'project:delete', 3, 3, 1803317368415416374, '', '', '', '', 0, b'1', b'1',
	449	b'1', '1', '2024-09-10 14:46:47', '1', '2024-09-10 14:46:47', b'0');
446130	450
D	451
	452	-- config
5e6c2d	453	--INSERT INTO `iailab_plat_system`.`infra_config` (`id`, `category`, `type`, `name`, `config_key`, `value`, `visible`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (13, 'model', 2, 'model文件备份路径', 'mpkBakFilePath', 'C:\\DLUT\\mpkBakFile', b'1', 'model文件备份路径', '1', '2024-09-12 11:10:25', '1', '2024-09-12 11:10:25', b'0');
446130	454
3e40f1	455	-- dist
4eb113	456	INSERT INTO `iailab_plat_system`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`,
潘	457	`updater`, `update_time`, `deleted`, `deleted_time`)
	458	VALUES (618, '模型方法', 'model_method', 0, '', '1', '2024-09-09 16:11:55', '1', '2024-09-09 16:11:55', b'0',
	459	'1970-01-01 00:00:00');
	460	INSERT INTO `iailab_plat_system`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`,
	461	`updater`, `update_time`, `deleted`, `deleted_time`)
	462	VALUES (619, '模型类型', 'model_type', 0, '', '1', '2024-09-13 14:14:26', '1', '2024-09-13 14:14:26', b'0',
	463	'1970-01-01 00:00:00');
	464	INSERT INTO `iailab_plat_system`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`,
	465	`updater`, `update_time`, `deleted`, `deleted_time`)
	466	VALUES (620, '模型方法输入类型', 'model_method_setting_type', 0, '', '1', '2024-09-13 15:41:38', '1',
	467	'2024-09-13 15:41:38', b'0', '1970-01-01 00:00:00');
	468	INSERT INTO `iailab_plat_system`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`,
	469	`updater`, `update_time`, `deleted`, `deleted_time`)
	470	VALUES (621, '模型方法参数类型', 'model_method_setting_value_type', 0, '', '1', '2024-09-13 15:42:27', '1',
	471	'2024-09-13 15:42:27', b'0', '1970-01-01 00:00:00');
3e40f1	472
D	473
4eb113	474	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
潘	475	`color_type`, `css_class`, `remark`, `creator`, `create_time`,
	476	`updater`, `update_time`, `deleted`)
	477	VALUES (1536, 1, 'train', 'train', 'model_method', 0, '', '', '', '1', '2024-09-09 16:12:42', '1',
	478	'2024-09-09 16:12:42', b'0');
	479	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
	480	`color_type`, `css_class`, `remark`, `creator`, `create_time`,
	481	`updater`, `update_time`, `deleted`)
	482	VALUES (1537, 3, 'control', 'control', 'model_method', 0, '', '', '', '1', '2024-09-09 16:12:54', '1',
	483	'2024-09-09 16:13:10', b'0');
	484	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
	485	`color_type`, `css_class`, `remark`, `creator`, `create_time`,
	486	`updater`, `update_time`, `deleted`)
	487	VALUES (1538, 2, 'predict', 'predict', 'model_method', 0, '', '', '', '1', '2024-09-09 16:13:05', '1',
	488	'2024-09-09 16:13:05', b'0');
	489	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
	490	`color_type`, `css_class`, `remark`, `creator`, `create_time`,
	491	`updater`, `update_time`, `deleted`)
	492	VALUES (1539, 1, '预测模型', 'predict', 'model_type', 0, '', '', '', '1', '2024-09-13 14:14:58', '1',
	493	'2024-09-13 14:14:58', b'0');
	494	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
	495	`color_type`, `css_class`, `remark`, `creator`, `create_time`,
	496	`updater`, `update_time`, `deleted`)
	497	VALUES (1540, 2, '调度模型', 'schedul', 'model_type', 0, '', '', '', '1', '2024-09-13 14:17:53', '1',
	498	'2024-09-13 14:17:53', b'0');
	499	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
	500	`color_type`, `css_class`, `remark`, `creator`, `create_time`,
	501	`updater`, `update_time`, `deleted`)
	502	VALUES (1541, 1, 'input', 'input', 'model_method_setting_type', 0, '', '', '', '1', '2024-09-13 15:44:08', '1',
	503	'2024-09-13 15:44:08', b'0');
	504	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
	505	`color_type`, `css_class`, `remark`, `creator`, `create_time`,
	506	`updater`, `update_time`, `deleted`)
	507	VALUES (1542, 2, 'select', 'select', 'model_method_setting_type', 0, '', '', '', '1', '2024-09-13 15:44:17', '1',
	508	'2024-09-13 15:44:17', b'0');
	509	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
	510	`color_type`, `css_class`, `remark`, `creator`, `create_time`,
	511	`updater`, `update_time`, `deleted`)
	512	VALUES (1543, 3, 'file', 'file', 'model_method_setting_type', 0, '', '', '', '1', '2024-09-13 15:44:24', '1',
	513	'2024-09-13 15:44:24', b'0');
	514	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
	515	`color_type`, `css_class`, `remark`, `creator`, `create_time`,
	516	`updater`, `update_time`, `deleted`)
	517	VALUES (1544, 1, 'int', 'int', 'model_method_setting_value_type', 0, '', '', '', '1', '2024-09-13 15:44:42', '1',
	518	'2024-09-13 15:44:42', b'0');
	519	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
	520	`color_type`, `css_class`, `remark`, `creator`, `create_time`,
	521	`updater`, `update_time`, `deleted`)
	522	VALUES (1545, 5, 'file', 'file', 'model_method_setting_value_type', 0, '', '', '', '1', '2024-09-13 15:44:57', '1',
	523	'2024-09-14 14:16:24', b'0');
	524	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
	525	`color_type`, `css_class`, `remark`, `creator`, `create_time`,
	526	`updater`, `update_time`, `deleted`)
	527	VALUES (1546, 3, 'decimal', 'decimal', 'model_method_setting_value_type', 0, '', '', '', '1', '2024-09-13 15:45:21',
	528	'1', '2024-09-13 15:45:21', b'0');
	529	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
	530	`color_type`, `css_class`, `remark`, `creator`, `create_time`,
	531	`updater`, `update_time`, `deleted`)
	532	VALUES (1547, 4, 'decimalArray', 'decimalArray', 'model_method_setting_value_type', 0, '', '', '', '1',
	533	'2024-09-13 15:45:26', '1', '2024-09-13 15:45:26', b'0');
	534	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
	535	`color_type`, `css_class`, `remark`, `creator`, `create_time`,
	536	`updater`, `update_time`, `deleted`)
	537	VALUES (1548, 2, 'string', 'string', 'model_method_setting_value_type', 0, '', '', '', '1', '2024-09-13 15:45:36', '1',
	538	'2024-09-14 14:16:30', b'0');
	539	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`,
	540	`color_type`, `css_class`, `remark`, `creator`, `create_time`,
	541	`updater`, `update_time`, `deleted`)
	542	VALUES (1549, 4, 'schedul', 'schedul', 'model_method', 0, '', '', '', '1', '2024-09-14 14:56:44', '1',
	543	'2024-09-14 14:56:44', b'0');
3e40f1	544
D	545
	546	-- 业务表
446130	547	DROP TABLE IF EXISTS `t_mpk_file`;
4eb113	548	CREATE TABLE `t_mpk_file`
潘	549	(
	550	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	551	`py_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型名称',
	552	`py_chinese_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型中文名称',
	553	`file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '源文件保存路径',
	554	`py_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型类型',
	555	`pkg_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '包名',
	556	`class_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '类名',
	557	`py_module` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型路径',
	558	`icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'icon图片名',
	559	`menu_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所属菜单',
	560	`group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所属组',
	561	`remark` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
	562	`creator` bigint NULL DEFAULT NULL COMMENT '创建者',
	563	`create_date` datetime NULL DEFAULT NULL COMMENT '创建时间',
	564	`updater` bigint NULL DEFAULT NULL COMMENT '更新者',
	565	`update_date` datetime NULL DEFAULT NULL COMMENT '更新时间',
	566	PRIMARY KEY (`id`) USING BTREE,
	567	UNIQUE INDEX `uk_py_name`(`py_name` ASC) USING BTREE,
	568	INDEX `idx_create_date`(`create_date` ASC) USING BTREE
446130	569	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'MDK模型文件' ROW_FORMAT = DYNAMIC;
D	570
	571	-- ----------------------------
	572	-- Table structure for t_mpk_generator_code_history
	573	-- ----------------------------
	574	DROP TABLE IF EXISTS `t_mpk_generator_code_history`;
4eb113	575	CREATE TABLE `t_mpk_generator_code_history`
潘	576	(
	577	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	578	`mdk_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'mdk_id',
	579	`file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件名',
	580	`file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件保存路径',
	581	`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
ca7c54	582	`create_time` datetime NULL DEFAULT NULL COMMENT '生成时间',
4eb113	583	PRIMARY KEY (`id`, `mdk_id`) USING BTREE,
潘	584	INDEX `del_code_history`(`mdk_id` ASC) USING BTREE,
	585	CONSTRAINT `del_code_history` FOREIGN KEY (`mdk_id`) REFERENCES `t_mpk_file` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
446130	586	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '生成代码记录表' ROW_FORMAT = DYNAMIC;
3e40f1	587
D	588	-- ----------------------------
f9b109	589	-- Table structure for t_mpk_model_method
D	590	-- ----------------------------
	591	DROP TABLE IF EXISTS `t_mpk_model_method`;
4eb113	592	CREATE TABLE `t_mpk_model_method`
潘	593	(
	594	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	595	`mpk_file_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '模型文件id',
	596	`method_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型方法名',
	597	`data_length` int NULL DEFAULT 1 COMMENT '输入个数',
	598	`model` int NULL DEFAULT 0 COMMENT '是否有model(0:否,1:是)',
	599	`result_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '结果key',
	600	`sort` integer,
	601	PRIMARY KEY (`id`, `mpk_file_id`) USING BTREE,
	602	INDEX `id`(`id` ASC) USING BTREE,
	603	INDEX `idx_method`(`mpk_file_id` ASC) USING BTREE,
	604	CONSTRAINT `del_method` FOREIGN KEY (`mpk_file_id`) REFERENCES `t_mpk_file` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
f9b109	605	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
D	606
	607	-- ----------------------------
3e40f1	608	-- Table structure for t_mpk_method_setting
D	609	-- ----------------------------
	610	DROP TABLE IF EXISTS `t_mpk_method_setting`;
4eb113	611	CREATE TABLE `t_mpk_method_setting`
潘	612	(
	613	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	614	`method_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '方法id',
	615	`setting_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'key',
	616	`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数名称',
4f4b05	617	`value` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数默认值',
4eb113	618	`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '输入类型',
潘	619	`value_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数类型',
	620	`max` int NULL DEFAULT NULL COMMENT '最大值',
	621	`min` int NULL DEFAULT NULL COMMENT '最小值',
	622	`sort` integer,
	623	PRIMARY KEY (`id`, `method_id`) USING BTREE,
	624	INDEX `del_setting`(`method_id` ASC) USING BTREE,
	625	INDEX `id`(`id` ASC) USING BTREE,
	626	CONSTRAINT `del_setting` FOREIGN KEY (`method_id`) REFERENCES `t_mpk_model_method` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
3e40f1	627	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '方法参数关联表' ROW_FORMAT = Dynamic;
446130	628
f9b109	629
446130	630	-- ----------------------------
f9b109	631	-- Table structure for t_mpk_setting_select
446130	632	-- ----------------------------
f9b109	633	DROP TABLE IF EXISTS `t_mpk_setting_select`;
4eb113	634	CREATE TABLE `t_mpk_setting_select`
潘	635	(
	636	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	637	`setting_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '参数id',
	638	`select_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'key',
	639	`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名称',
	640	`sort` integer,
	641	PRIMARY KEY (`id`, `setting_id`) USING BTREE,
	642	INDEX `del_select`(`setting_id` ASC) USING BTREE,
	643	CONSTRAINT `del_select` FOREIGN KEY (`setting_id`) REFERENCES `t_mpk_method_setting` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
f9b109	644	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '参数选项关联表' ROW_FORMAT = Dynamic;
446130	645
D	646	-- ----------------------------
	647	-- Table structure for t_mpk_project
	648	-- ----------------------------
	649	DROP TABLE IF EXISTS `t_mpk_project`;
4eb113	650	CREATE TABLE `t_mpk_project`
潘	651	(
	652	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	653	`project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目名称',
	654	`project_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目编码',
ca7c54	655	`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
D	656	`update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
4eb113	657	PRIMARY KEY (`id`) USING BTREE
446130	658	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目表' ROW_FORMAT = DYNAMIC;
D	659
	660	-- ----------------------------
	661	-- Table structure for t_mpk_project_model
	662	-- ----------------------------
	663	DROP TABLE IF EXISTS `t_mpk_project_model`;
4eb113	664	CREATE TABLE `t_mpk_project_model`
潘	665	(
	666	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	667	`project_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目id',
	668	`model_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '模型id',
	669	PRIMARY KEY (`id`, `project_id`, `model_id`) USING BTREE,
	670	INDEX `del_p`(`project_id` ASC) USING BTREE,
	671	INDEX `del_m`(`model_id` ASC) USING BTREE,
	672	CONSTRAINT `del_m` FOREIGN KEY (`model_id`) REFERENCES `t_mpk_file` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
	673	CONSTRAINT `del_p` FOREIGN KEY (`project_id`) REFERENCES `t_mpk_project` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
446130	674	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目模型关联表' ROW_FORMAT = DYNAMIC;
D	675
	676	-- ----------------------------
	677	-- Table structure for t_mpk_project_package_history
	678	-- ----------------------------
	679	DROP TABLE IF EXISTS `t_mpk_project_package_history`;
4eb113	680	CREATE TABLE `t_mpk_project_package_history`
潘	681	(
	682	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	683	`project_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目id',
	684	`file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件名',
	685	`file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件路径',
	686	`version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '版本号',
	687	`log` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新日志',
5e7dcf	688	`model_names` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '打包模型名称（“，”分割）',
ca7c54	689	`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
4eb113	690	PRIMARY KEY (`id`, `project_id`) USING BTREE,
潘	691	INDEX `del_package_history`(`project_id` ASC) USING BTREE,
	692	CONSTRAINT `del_package_history` FOREIGN KEY (`project_id`) REFERENCES `t_mpk_project` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
446130	693	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目打包历史记录表' ROW_FORMAT = DYNAMIC;
D	694
	695	-- ----------------------------
	696	-- Table structure for t_mpk_project_package_history_model
	697	-- ----------------------------
	698	DROP TABLE IF EXISTS `t_mpk_project_package_history_model`;
4eb113	699	CREATE TABLE `t_mpk_project_package_history_model`
潘	700	(
	701	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	702	`project_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目id',
	703	`package_history_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '打包历史id',
	704	`py_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型名称',
	705	`pkg_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '包名',
	706	`py_module` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型路径',
	707	`remark` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型备注',
	708	`method_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '模型方法信息',
	709	PRIMARY KEY (`id`, `project_id`) USING BTREE,
	710	INDEX `del_package_model`(`project_id` ASC) USING BTREE,
	711	CONSTRAINT `del_package_model` FOREIGN KEY (`project_id`) REFERENCES `t_mpk_project` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
8b3ee3	712	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '打包历史模型关联表' ROW_FORMAT = Dynamic;
潘	713
	714
	715	DROP TABLE IF EXISTS `t_mpk_icon`;
4eb113	716	CREATE TABLE `t_mpk_icon`
潘	717	(
	718	`id` varchar(36) NOT NULL COMMENT 'id',
	719	`icon_name` varchar(36) NOT NULL COMMENT '图标名称',
	720	`icon_desc` varchar(36) DEFAULT NULL COMMENT '图标描述',
	721	`sort` integer DEFAULT NULL COMMENT '排序',
	722	PRIMARY KEY (`id`) USING BTREE
8b3ee3	723	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'MDK平台图标' ROW_FORMAT = Dynamic;
潘	724
	725	DROP TABLE IF EXISTS `t_mpk_file_menu`;
4eb113	726	CREATE TABLE `t_mpk_file_menu`
潘	727	(
	728	`id` varchar(36) NOT NULL COMMENT 'id',
	729	`name` varchar(36) NOT NULL COMMENT '名称',
	730	`sort` integer DEFAULT NULL COMMENT '排序',
	731	PRIMARY KEY (`id`) USING BTREE
8b3ee3	732	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '模型文件菜单' ROW_FORMAT = Dynamic;
潘	733
	734	DROP TABLE IF EXISTS `t_mpk_file_group`;
4eb113	735	CREATE TABLE `t_mpk_file_group`
潘	736	(
	737	`id` varchar(36) NOT NULL COMMENT 'id',
	738	`menu_id` varchar(36) NOT NULL COMMENT '菜单',
	739	`name` varchar(36) NOT NULL COMMENT '名称',
	740	`sort` integer DEFAULT NULL COMMENT '排序',
	741	PRIMARY KEY (`id`) USING BTREE
179f93	742	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '模型文件分组' ROW_FORMAT = Dynamic;
D	743
4eb113	744	alter table t_mm_predict_model
潘	745	add column `mpkprojectid` varchar(36) DEFAULT NULL;
cf2287	746
5e6c2d	747	-- chart 图表配置
D	748
	749	-- menu
4eb113	750	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
潘	751	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	752	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	753	`deleted`, `app_id`, `tenant_id`)
	754	VALUES (1803317368435416399, '图表管理', '', 1, 40, 1803317368415416363, 'chart', 'fa:align-left', '', '', 0, b'1',
	755	b'1', b'1', '1', '2024-11-05 11:57:25', '1', '2024-11-05 11:57:49', b'0', 0, 1);
	756	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
	757	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	758	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	759	`deleted`, `app_id`, `tenant_id`)
	760	VALUES (1803317368435416400, '图表配置', '', 2, 1, 1803317368435416399, 'chartParam', 'fa-solid:cogs',
	761	'model/chart/index', 'ChartParam', 0, b'1', b'1', b'1', '1', '2024-11-05 12:01:59', '1', '2024-11-06 08:45:17',
	762	b'0', 0, 1);
	763	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
	764	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	765	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	766	`deleted`, `app_id`, `tenant_id`)
	767	VALUES (1803317368435416401, '查询', 'model:chart:query', 3, 1, 1803317368435416400, '', '', '', '', 0, b'1', b'1',
	768	b'1', '1', '2024-11-05 15:36:48', '1', '2024-11-05 15:36:48', b'0', NULL, 1);
	769	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
	770	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	771	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	772	`deleted`, `app_id`, `tenant_id`)
	773	VALUES (1803317368435416402, '新增', 'model:chart:create', 3, 2, 1803317368435416400, '', '', '', '', 0, b'1', b'1',
	774	b'1', '1', '2024-11-05 15:37:03', '1', '2024-11-05 15:37:03', b'0', NULL, 1);
	775	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
	776	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	777	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	778	`deleted`, `app_id`, `tenant_id`)
	779	VALUES (1803317368435416403, '修改', 'model:chart:update', 3, 3, 1803317368435416400, '', '', '', '', 0, b'1', b'1',
	780	b'1', '1', '2024-11-05 15:37:20', '1', '2024-11-05 15:37:20', b'0', NULL, 1);
	781	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
	782	`component`, `component_name`, `status`, `visible`, `keep_alive`,
	783	`always_show`, `creator`, `create_time`, `updater`, `update_time`,
	784	`deleted`, `app_id`, `tenant_id`)
	785	VALUES (1803317368435416404, '删除', 'model:chart:delete', 3, 4, 1803317368435416400, '', '', '', '', 0, b'1', b'1',
	786	b'1', '1', '2024-11-05 15:37:38', '1', '2024-11-05 15:37:38', b'0', NULL, 1);
5e6c2d	787
D	788	-- table
4eb113	789	CREATE TABLE `t_chart`
潘	790	(
	791	`id` varchar(36) NOT NULL,
	792	`chart_name` varchar(100) DEFAULT NULL COMMENT '图表名称',
	793	`chart_code` varchar(100) DEFAULT NULL COMMENT '图表编码',
ca7c54	794	`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
D	795	`update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
4eb113	796	PRIMARY KEY (`id`),
潘	797	UNIQUE KEY `uk_chart_code` (`chart_code`),
	798	KEY `index_id` (`id`)
5e6c2d	799	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='图表配置';
680be4	800
4eb113	801	CREATE TABLE `t_chart_param`
潘	802	(
	803	`id` varchar(36) NOT NULL,
	804	`chart_id` varchar(36) NOT NULL COMMENT '图表id',
	805	`param_name` varchar(255) DEFAULT NULL COMMENT '参数名称',
	806	`param_code` varchar(100) DEFAULT NULL COMMENT '参数编码',
	807	`param_value` varchar(1000) DEFAULT NULL COMMENT '参数值',
	808	`remark` varchar(255) DEFAULT NULL COMMENT '备注',
ca7c54	809	`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
D	810	`update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
4eb113	811	PRIMARY KEY (`id`, `chart_id`) USING BTREE,
潘	812	KEY `index_chart_id` (`chart_id`),
	813	CONSTRAINT `chart_id` FOREIGN KEY (`chart_id`) REFERENCES `t_chart` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
5e6c2d	814	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='图表参数配置';
abcfb4	815
潘	816
cf2287	817	DROP TABLE IF EXISTS `t_mpk_pack`;
4eb113	818	CREATE TABLE `t_mpk_pack`
潘	819	(
	820	`id` varchar(36) NOT NULL COMMENT 'id',
	821	`pack_name` varchar(50) NOT NULL COMMENT '包名称',
	822	`pack_desc` varchar(50) DEFAULT NULL COMMENT '包描述',
	823	`model_path` varchar(50) DEFAULT NULL COMMENT '模型路径',
	824	`sort` integer DEFAULT NULL COMMENT '排序',
	825	PRIMARY KEY (`id`) USING BTREE,
	826	UNIQUE INDEX uk_pack_name (pack_name)
	827	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'MDK包名管理' ROW_FORMAT = Dynamic;
	828
	829
	830	create table
	831	t_mm_item_status
	832	(
	833	id varchar(36) not null COMMENT 'id',
	834	item_id varchar(36) COMMENT '预测项ID',
	835	last_time datetime DEFAULT NULL COMMENT '最新运行时间',
	836	status smallint DEFAULT NULL COMMENT '运行状态',
	837	duration bigint(20) DEFAULT NULL COMMENT '耗时(s)',
	838	primary key (id),
	839	UNIQUE INDEX uk_item_id (item_id)
69bd5e	840	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '测项状态表' ROW_FORMAT = Dynamic;
D	841
	842	-- 模型输出
	843	ALTER TABLE t_mm_predict_model DROP COLUMN `resultstrid`;
	844	alter table t_mm_item_output add column `resultstr` varchar(50) DEFAULT NULL;
	845	alter table t_mm_item_output add column `result_type` smallint DEFAULT NULL COMMENT '参数类型{1：一维数组；2：二维数组}';
	846	alter table t_mm_item_output add column `result_index` int DEFAULT NULL;
	847
	848	-- 字典
	849	INSERT INTO `iailab_plat_system`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `deleted_time`) VALUES (644, '模型结果数据类型', 'model_result_type', 0, '', '141', '2024-11-11 15:16:58', '141', '2024-11-11 15:16:58', b'0', '1970-01-01 00:00:00');
	850	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1628, 1, 'double[]', '1', 'model_result_type', 0, '', '', '', '141', '2024-11-11 15:21:05', '141', '2024-11-11 15:21:05', b'0');
	851	INSERT INTO `iailab_plat_system`.`system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1629, 2, 'double[][]', '2', 'model_result_type', 0, '', '', '', '141', '2024-11-11 15:21:17', '141', '2024-11-11 15:21:17', b'0');
b368e6	852
潘	853
51c1c2	854	alter table t_mm_item_output add column `result_name` varchar(50) DEFAULT NULL;
潘	855
	856
8a6b19	857	alter table t_st_schedule_scheme add column `mpkprojectid` varchar(36) DEFAULT NULL;
潘	858
	859	alter table t_st_schedule_record add column `result_code` varchar(10) DEFAULT NULL;
fae9f0	860	alter table t_st_schedule_record add column `result_data` varchar(1000) DEFAULT NULL;
潘	861
	862	CREATE TABLE `t_st_schedule_model_out` (
af0124	863	`id` varchar(36) NOT NULL COMMENT 'id',
潘	864	`model_id` varchar(36) DEFAULT NULL COMMENT '模型ID',
	865	`result_key` varchar(36) DEFAULT NULL COMMENT '输出key',
	866	`result_type` varchar(36) DEFAULT NULL COMMENT '数据类型（double,double[],double[][]）',
	867	`result_port` int DEFAULT NULL COMMENT 'port',
	868	`result_index` int DEFAULT NULL COMMENT 'index',
fae9f0	869	`is_write` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否下发',
潘	870	`point_no` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '下发的点位',
	871	`sort` int DEFAULT NULL COMMENT '排序',
	872	`disturbance_point_no` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '无扰切换点位',
	873	PRIMARY KEY (`id`) USING BTREE,
	874	INDEX `ind_model_id`(`model_id` ASC) USING BTREE
b2bb7d	875	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='模型下发信息表';
潘	876
	877	alter table t_st_schedule_scheme add column `run_status` varchar(4) DEFAULT NULL COMMENT '运行状态';