iailab-plat.git

潘志宝

2024-11-11 4eb113d1149e61ae193ebd60296f2984c56c2f46

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