iailab-plat.git

潘志宝

2024-12-12 bd90850664bfe4b43df094321e811f3bb398f97f

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