iailab-plat.git

Merge remote-tracking branch 'origin/master'

Jay

2024-11-08 02722a3f9eca857ce7fffea352e9f7ee692a1b71

提交 \| 用户 \| 时间
6a5cf8	1	create table t_dm_module
f154f0	2	(
潘	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),
137356	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	(
潘	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	(
	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),
6a5cf8	40	INDEX idx_itemid (itemid)
潘	41	) engine = innodb default character set utf8mb4 COMMENT = '预测项输出表';
f154f0	42
6a5cf8	43	create table t_mm_item_result
f154f0	44	(
潘	45	id varchar(36) not null,
	46	outputid varchar(36),
	47	datatime datetime,
	48	datavalue decimal(19, 3),
	49	primary key (id),
6a5cf8	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	(
潘	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	(
6a5cf8	66	id varchar(36) not null,
潘	67	modelid varchar(36),
	68	`key` varchar(36),
f154f0	69	value varchar(256),
6a5cf8	70	name varchar(36),
潘	71	valuetype varchar(36),
f154f0	72	primary key (id),
6a5cf8	73	INDEX idx_modelid (modelid)
潘	74	) engine = innodb default character set utf8mb4 COMMENT = '预测模型设置参数表';
f154f0	75
6a5cf8	76	create table t_mm_model_param
f154f0	77	(
6a5cf8	78	id varchar(36) not null,
潘	79	modelid varchar(36),
	80	modelparamname varchar(36),
	81	modelparamid varchar(36),
f154f0	82	modelparamorder integer,
潘	83	modelparamportorder integer,
	84	datalength integer,
6a5cf8	85	modelparamtype varchar(36),
f154f0	86	primary key (id),
6a5cf8	87	INDEX idx_modelid (modelid)
潘	88	) engine = innodb default character set utf8mb4 COMMENT = '预测模型输入参数表';
f154f0	89
6a5cf8	90	create table t_mm_model_resultstr
f154f0	91	(
潘	92	id varchar(64) not null,
	93	resultstr varchar(64),
6a5cf8	94	primary key (id)
潘	95	) engine = innodb default character set utf8mb4 COMMENT = '预测模型结果字符串表';
f154f0	96
潘	97	create table
	98	t_mm_predict_item
	99	(
	100	id varchar(36) not null,
	101	itemno varchar(16),
	102	itemname varchar(50),
	103	caltypeid varchar(36),
	104	itemtypeid varchar(36),
137356	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 '更新时间',
f154f0	114	saveindex varchar(16),
潘	115	primary key (id),
137356	116	UNIQUE INDEX uk_itemno (itemno),
潘	117	INDEX uk_itemtypeid (itemtypeid)
	118	) engine = innodb default character set utf8mb4 COMMENT = '预测项表';
f154f0	119
潘	120	create table
	121	t_mm_predict_merge_item
	122	(
	123	id varchar(36) not null,
	124	itemid varchar(36),
6a5cf8	125	expression varchar(255),
f154f0	126	num integer,
潘	127	primary key (id),
6a5cf8	128	UNIQUE INDEX uk_itemid (itemid)
潘	129	) engine = innodb default character set utf8mb4 COMMENT = '合并预测项表';
f154f0	130
潘	131	create table
	132	t_mm_predict_model
	133	(
	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),
6a5cf8	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	(
潘	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	(
6a5cf8	173	id varchar(36) not null,
潘	174	outputid varchar(36),
	175	predicttime datetime,
	176	jsonvalue varchar(6400),
	177	cumulant varchar(36),
f154f0	178	primary key (id),
6a5cf8	179	INDEX idx_outputid (outputid),
潘	180	INDEX idx_predicttime (predicttime)
	181	) engine = innodb default character set utf8mb4 COMMENT = '预测JSON数据表';
f154f0	182
潘	183	create table
6a5cf8	184	t_mm_item_result_last_point
f154f0	185	(
6a5cf8	186	id varchar(36) not null,
潘	187	outputid varchar(36),
	188	datatime datetime,
	189	datavalue decimal(19, 3),
f154f0	190	primary key (id),
6a5cf8	191	INDEX idx_outputid (outputid),
潘	192	INDEX idx_datatime (datatime)
	193	) engine = innodb default character set utf8mb4 COMMENT = '预测T+L数据表';
f154f0	194
6a5cf8	195	create table t_mm_item_accuracy_rate
f154f0	196	(
6a5cf8	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,
f154f0	208	primary key (id),
6a5cf8	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	(
7fd198	215	id varchar(36) not null,
6a5cf8	216	title varchar(20) COMMENT '消息标题',
7fd198	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)
	231	) engine = innodb
	232	default character set utf8mb4 COMMENT = '预警配置表';
	233
	234	create table t_mm_predict_alarm_message
	235	(
	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 '创建时间',
f154f0	248	primary key (id),
6a5cf8	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	(
6a5cf8	260	`id` varchar(36) not null COMMENT 'ID',
056470	261	`code` varchar(20) not null COMMENT '编号',
潘	262	`name` varchar(20) not null COMMENT '名称',
6a5cf8	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 '更新时间',
bbc1ee	276	`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
f154f0	277	primary key (id),
6a5cf8	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	(
	284	`id` varchar(36) not null COMMENT 'ID',
056470	285	`model_code` varchar(64) not null COMMENT '模型编号',
潘	286	`model_name` varchar(64) not null COMMENT '模型名称',
6a5cf8	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 '更新时间',
bbc1ee	300	`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
6a5cf8	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
6a5cf8	306	t_st_schedule_model_param
f154f0	307	(
6a5cf8	308	id varchar(36) not null,
056470	309	modelid varchar(64) not null,
6a5cf8	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
6a5cf8	322	t_st_schedule_model_setting
潘	323	(
	324	`id` varchar(36) not null,
056470	325	`modelid` varchar(64) not null,
6a5cf8	326	`key` varchar(64),
潘	327	`value` varchar(64),
	328	`valuetype` varchar(64),
	329	`name` varchar(64),
bbc1ee	330	`sort` integer,
6a5cf8	331	primary key (id),
潘	332	key idx_modelid (modelid)
	333	) engine = innodb
	334	default character set utf8mb4 COMMENT = '调度模型设置参数表';
	335
	336	create table
bbc1ee	337	t_st_schedule_suggest
f154f0	338	(
潘	339	id varchar(36) not null,
6a5cf8	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 '创建时间',
f154f0	361	primary key (id),
6a5cf8	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
6a5cf8	373	t_st_schedule_record
f154f0	374	(
6a5cf8	375	`id` varchar(36) not null,
潘	376	`scheme_id` varchar(36) COMMENT '方案ID',
	377	`model_id` varchar(36) COMMENT '模型ID',
bbc1ee	378	`model_name` varchar(64) COMMENT '模型名称',
6a5cf8	379	`schedule_time` datetime COMMENT '调度时间',
潘	380	`create_time` datetime default current_timestamp COMMENT '创建时间',
f154f0	381	primary key (id),
6a5cf8	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
	390	t_st_schedule_record_detail
	391	(
	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)
	403	) engine = innodb
	404	default character set utf8mb4 COMMENT = '调度记录详情表';
446130	405
D	406	-- mpk
	407
	408	-- menu
	409	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1803317368415416369, '模型库', '', 2, 20, 1803317368415416363, 'mpk', 'ep:folder', 'mpk/mpk', 'Mpk', 0, b'1', b'1', b'1', '1', '2024-08-31 16:50:38', '1', '2024-09-10 14:53:17', b'0');
	410	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1803317368415416370, 'MPK查询', 'mpk:query', 3, 0, 1803317368415416369, '', '', '', '', 0, b'1', b'1', b'1', '1', '2024-09-02 10:14:00', '1', '2024-09-06 11:50:19', b'0');
	411	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1803317368415416371, 'MPK新增', 'mpk:create', 3, 1, 1803317368415416369, '', '', '', '', 0, b'1', b'1', b'1', '1', '2024-09-02 10:14:25', '1', '2024-09-06 11:50:28', b'0');
	412	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1803317368415416372, 'MPK修改', 'mpk:update', 3, 2, 1803317368415416369, '', '', '', '', 0, b'1', b'1', b'1', '1', '2024-09-02 10:14:44', '1', '2024-09-06 11:50:38', b'0');
	413	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1803317368415416373, 'MPK删除', 'mpk:delete', 3, 3, 1803317368415416369, '', '', '', '', 0, b'1', b'1', b'1', '1', '2024-09-02 10:15:04', '1', '2024-09-06 11:50:46', b'0');
	414	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1803317368415416374, '项目管理', '', 2, 30, 1803317368415416363, 'project', 'ep:document-copy', 'mpk/project', 'Project', 0, b'1', b'1', b'1', '1', '2024-09-10 14:44:54', '1', '2024-09-10 14:53:26', b'0');
	415	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1803317368415416375, '项目查询', 'project:query', 3, 0, 1803317368415416374, '', '', '', '', 0, b'1', b'1', b'1', '1', '2024-09-10 14:45:53', '1', '2024-09-10 14:45:53', b'0');
	416	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1803317368415416376, '项目新增', 'project:create', 3, 1, 1803317368415416374, '', '', '', '', 0, b'1', b'1', b'1', '1', '2024-09-10 14:46:16', '1', '2024-09-10 14:46:16', b'0');
	417	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1803317368415416377, '项目修改', 'project:update', 3, 2, 1803317368415416374, '', '', '', '', 0, b'1', b'1', b'1', '1', '2024-09-10 14:46:33', '1', '2024-09-10 14:46:33', b'0');
	418	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1803317368415416378, '项目删除', 'project:delete', 3, 3, 1803317368415416374, '', '', '', '', 0, b'1', b'1', b'1', '1', '2024-09-10 14:46:47', '1', '2024-09-10 14:46:47', b'0');
	419
	420
	421	-- config
5e6c2d	422	--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	423
3e40f1	424	-- dist
D	425	INSERT INTO `iailab_plat_system`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `deleted_time`) VALUES (618, '模型方法', 'model_method', 0, '', '1', '2024-09-09 16:11:55', '1', '2024-09-09 16:11:55', b'0', '1970-01-01 00:00:00');
	426	INSERT INTO `iailab_plat_system`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `deleted_time`) VALUES (619, '模型类型', 'model_type', 0, '', '1', '2024-09-13 14:14:26', '1', '2024-09-13 14:14:26', b'0', '1970-01-01 00:00:00');
	427	INSERT INTO `iailab_plat_system`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `deleted_time`) VALUES (620, '模型方法输入类型', 'model_method_setting_type', 0, '', '1', '2024-09-13 15:41:38', '1', '2024-09-13 15:41:38', b'0', '1970-01-01 00:00:00');
	428	INSERT INTO `iailab_plat_system`.`system_dict_type` (`id`, `name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `deleted_time`) VALUES (621, '模型方法参数类型', 'model_method_setting_value_type', 0, '', '1', '2024-09-13 15:42:27', '1', '2024-09-13 15:42:27', b'0', '1970-01-01 00:00:00');
	429
	430
	431	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 (1536, 1, 'train', 'train', 'model_method', 0, '', '', '', '1', '2024-09-09 16:12:42', '1', '2024-09-09 16:12:42', b'0');
	432	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 (1537, 3, 'control', 'control', 'model_method', 0, '', '', '', '1', '2024-09-09 16:12:54', '1', '2024-09-09 16:13:10', b'0');
	433	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 (1538, 2, 'predict', 'predict', 'model_method', 0, '', '', '', '1', '2024-09-09 16:13:05', '1', '2024-09-09 16:13:05', b'0');
	434	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 (1539, 1, '预测模型', 'predict', 'model_type', 0, '', '', '', '1', '2024-09-13 14:14:58', '1', '2024-09-13 14:14:58', b'0');
	435	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 (1540, 2, '调度模型', 'schedul', 'model_type', 0, '', '', '', '1', '2024-09-13 14:17:53', '1', '2024-09-13 14:17:53', b'0');
	436	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 (1541, 1, 'input', 'input', 'model_method_setting_type', 0, '', '', '', '1', '2024-09-13 15:44:08', '1', '2024-09-13 15:44:08', b'0');
	437	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 (1542, 2, 'select', 'select', 'model_method_setting_type', 0, '', '', '', '1', '2024-09-13 15:44:17', '1', '2024-09-13 15:44:17', b'0');
	438	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 (1543, 3, 'file', 'file', 'model_method_setting_type', 0, '', '', '', '1', '2024-09-13 15:44:24', '1', '2024-09-13 15:44:24', b'0');
	439	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 (1544, 1, 'int', 'int', 'model_method_setting_value_type', 0, '', '', '', '1', '2024-09-13 15:44:42', '1', '2024-09-13 15:44:42', b'0');
	440	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 (1545, 5, 'file', 'file', 'model_method_setting_value_type', 0, '', '', '', '1', '2024-09-13 15:44:57', '1', '2024-09-14 14:16:24', b'0');
	441	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 (1546, 3, 'decimal', 'decimal', 'model_method_setting_value_type', 0, '', '', '', '1', '2024-09-13 15:45:21', '1', '2024-09-13 15:45:21', b'0');
	442	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 (1547, 4, 'decimalArray', 'decimalArray', 'model_method_setting_value_type', 0, '', '', '', '1', '2024-09-13 15:45:26', '1', '2024-09-13 15:45:26', b'0');
	443	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 (1548, 2, 'string', 'string', 'model_method_setting_value_type', 0, '', '', '', '1', '2024-09-13 15:45:36', '1', '2024-09-14 14:16:30', b'0');
	444	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 (1549, 4, 'schedul', 'schedul', 'model_method', 0, '', '', '', '1', '2024-09-14 14:56:44', '1', '2024-09-14 14:56:44', b'0');
	445
	446
	447	-- 业务表
446130	448	DROP TABLE IF EXISTS `t_mpk_file`;
D	449	CREATE TABLE `t_mpk_file` (
	450	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	451	`py_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型名称',
3e40f1	452	`py_chinese_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型中文名称',
446130	453	`file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '源文件保存路径',
D	454	`py_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型类型',
	455	`pkg_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '包名',
	456	`class_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '类名',
	457	`py_module` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型路径',
3e40f1	458	`icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'icon图片名',
D	459	`menu_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所属菜单',
	460	`group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所属组',
446130	461	`remark` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
D	462	`creator` bigint NULL DEFAULT NULL COMMENT '创建者',
	463	`create_date` datetime NULL DEFAULT NULL COMMENT '创建时间',
	464	`updater` bigint NULL DEFAULT NULL COMMENT '更新者',
	465	`update_date` datetime NULL DEFAULT NULL COMMENT '更新时间',
	466	PRIMARY KEY (`id`) USING BTREE,
	467	UNIQUE INDEX `uk_py_name`(`py_name` ASC) USING BTREE,
	468	INDEX `idx_create_date`(`create_date` ASC) USING BTREE
	469	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'MDK模型文件' ROW_FORMAT = DYNAMIC;
	470
	471	-- ----------------------------
	472	-- Table structure for t_mpk_generator_code_history
	473	-- ----------------------------
	474	DROP TABLE IF EXISTS `t_mpk_generator_code_history`;
	475	CREATE TABLE `t_mpk_generator_code_history` (
	476	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
3e40f1	477	`mdk_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'mdk_id',
446130	478	`file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件名',
D	479	`file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件保存路径',
	480	`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
	481	`create_time` timestamp NULL DEFAULT NULL COMMENT '生成时间',
3e40f1	482	PRIMARY KEY (`id`, `mdk_id`) USING BTREE,
D	483	INDEX `del_code_history`(`mdk_id` ASC) USING BTREE,
	484	CONSTRAINT `del_code_history` FOREIGN KEY (`mdk_id`) REFERENCES `t_mpk_file` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
446130	485	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '生成代码记录表' ROW_FORMAT = DYNAMIC;
3e40f1	486
D	487	-- ----------------------------
f9b109	488	-- Table structure for t_mpk_model_method
D	489	-- ----------------------------
	490	DROP TABLE IF EXISTS `t_mpk_model_method`;
	491	CREATE TABLE `t_mpk_model_method` (
	492	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	493	`mpk_file_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '模型文件id',
	494	`method_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型方法名',
	495	`data_length` int NULL DEFAULT 1 COMMENT '输入个数',
	496	`model` int NULL DEFAULT 0 COMMENT '是否有model(0:否,1:是)',
	497	`result_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '结果key',
8b3ee3	498	`sort` integer,
f9b109	499	PRIMARY KEY (`id`, `mpk_file_id`) USING BTREE,
D	500	INDEX `id`(`id` ASC) USING BTREE,
8b3ee3	501	INDEX `idx_method`(`mpk_file_id` ASC) USING BTREE,
f9b109	502	CONSTRAINT `del_method` FOREIGN KEY (`mpk_file_id`) REFERENCES `t_mpk_file` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
D	503	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
	504
	505	-- ----------------------------
3e40f1	506	-- Table structure for t_mpk_method_setting
D	507	-- ----------------------------
	508	DROP TABLE IF EXISTS `t_mpk_method_setting`;
	509	CREATE TABLE `t_mpk_method_setting` (
	510	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	511	`method_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '方法id',
	512	`setting_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'key',
	513	`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数名称',
	514	`value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数默认值',
	515	`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '输入类型',
	516	`value_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数类型',
	517	`max` int NULL DEFAULT NULL COMMENT '最大值',
	518	`min` int NULL DEFAULT NULL COMMENT '最小值',
8b3ee3	519	`sort` integer,
3e40f1	520	PRIMARY KEY (`id`, `method_id`) USING BTREE,
D	521	INDEX `del_setting`(`method_id` ASC) USING BTREE,
	522	INDEX `id`(`id` ASC) USING BTREE,
	523	CONSTRAINT `del_setting` FOREIGN KEY (`method_id`) REFERENCES `t_mpk_model_method` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
	524	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '方法参数关联表' ROW_FORMAT = Dynamic;
446130	525
f9b109	526
446130	527	-- ----------------------------
f9b109	528	-- Table structure for t_mpk_setting_select
446130	529	-- ----------------------------
f9b109	530	DROP TABLE IF EXISTS `t_mpk_setting_select`;
D	531	CREATE TABLE `t_mpk_setting_select` (
	532	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	533	`setting_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '参数id',
	534	`select_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'key',
	535	`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名称',
8b3ee3	536	`sort` integer,
f9b109	537	PRIMARY KEY (`id`, `setting_id`) USING BTREE,
D	538	INDEX `del_select`(`setting_id` ASC) USING BTREE,
	539	CONSTRAINT `del_select` FOREIGN KEY (`setting_id`) REFERENCES `t_mpk_method_setting` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
	540	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '参数选项关联表' ROW_FORMAT = Dynamic;
446130	541
D	542	-- ----------------------------
	543	-- Table structure for t_mpk_project
	544	-- ----------------------------
	545	DROP TABLE IF EXISTS `t_mpk_project`;
	546	CREATE TABLE `t_mpk_project` (
	547	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	548	`project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目名称',
	549	`project_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目编码',
	550	`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
	551	`update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
	552	PRIMARY KEY (`id`) USING BTREE
	553	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目表' ROW_FORMAT = DYNAMIC;
	554
	555	-- ----------------------------
	556	-- Table structure for t_mpk_project_model
	557	-- ----------------------------
	558	DROP TABLE IF EXISTS `t_mpk_project_model`;
	559	CREATE TABLE `t_mpk_project_model` (
	560	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
3e40f1	561	`project_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目id',
D	562	`model_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '模型id',
	563	PRIMARY KEY (`id`, `project_id`, `model_id`) USING BTREE,
	564	INDEX `del_p`(`project_id` ASC) USING BTREE,
	565	INDEX `del_m`(`model_id` ASC) USING BTREE,
	566	CONSTRAINT `del_m` FOREIGN KEY (`model_id`) REFERENCES `t_mpk_file` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
	567	CONSTRAINT `del_p` FOREIGN KEY (`project_id`) REFERENCES `t_mpk_project` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
446130	568	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目模型关联表' ROW_FORMAT = DYNAMIC;
D	569
	570	-- ----------------------------
	571	-- Table structure for t_mpk_project_package_history
	572	-- ----------------------------
	573	DROP TABLE IF EXISTS `t_mpk_project_package_history`;
	574	CREATE TABLE `t_mpk_project_package_history` (
	575	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
3e40f1	576	`project_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目id',
446130	577	`file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件名',
D	578	`file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件路径',
	579	`version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '版本号',
	580	`log` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新日志',
	581	`model_names` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '打包模型名称（“，”分割）',
	582	`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
3e40f1	583	PRIMARY KEY (`id`, `project_id`) USING BTREE,
D	584	INDEX `del_package_history`(`project_id` ASC) USING BTREE,
	585	CONSTRAINT `del_package_history` FOREIGN KEY (`project_id`) REFERENCES `t_mpk_project` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
446130	586	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目打包历史记录表' ROW_FORMAT = DYNAMIC;
D	587
	588	-- ----------------------------
	589	-- Table structure for t_mpk_project_package_history_model
	590	-- ----------------------------
	591	DROP TABLE IF EXISTS `t_mpk_project_package_history_model`;
	592	CREATE TABLE `t_mpk_project_package_history_model` (
	593	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
3e40f1	594	`project_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目id',
446130	595	`package_history_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '打包历史id',
D	596	`py_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型名称',
	597	`pkg_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '包名',
	598	`py_module` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型路径',
	599	`remark` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型备注',
3e40f1	600	`method_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '模型方法信息',
D	601	PRIMARY KEY (`id`, `project_id`) USING BTREE,
	602	INDEX `del_package_model`(`project_id` ASC) USING BTREE,
	603	CONSTRAINT `del_package_model` FOREIGN KEY (`project_id`) REFERENCES `t_mpk_project` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
8b3ee3	604	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '打包历史模型关联表' ROW_FORMAT = Dynamic;
潘	605
	606
	607	DROP TABLE IF EXISTS `t_mpk_icon`;
	608	CREATE TABLE `t_mpk_icon` (
	609	`id` varchar(36) NOT NULL COMMENT 'id',
	610	`icon_name` varchar(36) NOT NULL COMMENT '图标名称',
	611	`icon_desc` varchar(36) DEFAULT NULL COMMENT '图标描述',
	612	`sort` integer DEFAULT NULL COMMENT '排序',
	613	PRIMARY KEY (`id`) USING BTREE
	614	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'MDK平台图标' ROW_FORMAT = Dynamic;
	615
	616	DROP TABLE IF EXISTS `t_mpk_file_menu`;
	617	CREATE TABLE `t_mpk_file_menu` (
	618	`id` varchar(36) NOT NULL COMMENT 'id',
	619	`name` varchar(36) NOT NULL COMMENT '名称',
	620	`sort` integer DEFAULT NULL COMMENT '排序',
	621	PRIMARY KEY (`id`) USING BTREE
	622	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '模型文件菜单' ROW_FORMAT = Dynamic;
	623
	624	DROP TABLE IF EXISTS `t_mpk_file_group`;
	625	CREATE TABLE `t_mpk_file_group` (
	626	`id` varchar(36) NOT NULL COMMENT 'id',
	627	`menu_id` varchar(36) NOT NULL COMMENT '菜单',
	628	`name` varchar(36) NOT NULL COMMENT '名称',
	629	`sort` integer DEFAULT NULL COMMENT '排序',
	630	PRIMARY KEY (`id`) USING BTREE
179f93	631	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '模型文件分组' ROW_FORMAT = Dynamic;
D	632
cf2287	633	alter table t_mm_predict_model add column `mpkprojectid` varchar(36) DEFAULT NULL;
潘	634
5e6c2d	635	-- chart 图表配置
D	636
	637	-- menu
	638	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `app_id`, `tenant_id`) VALUES (1803317368435416399, '图表管理', '', 1, 40, 1803317368415416363, 'chart', 'fa:align-left', '', '', 0, b'1', b'1', b'1', '1', '2024-11-05 11:57:25', '1', '2024-11-05 11:57:49', b'0', 0, 1);
	639	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `app_id`, `tenant_id`) VALUES (1803317368435416400, '图表配置', '', 2, 1, 1803317368435416399, 'chartParam', 'fa-solid:cogs', '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', b'0', 0, 1);
	640	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `app_id`, `tenant_id`) VALUES (1803317368435416401, '查询', 'model:chart:query', 3, 1, 1803317368435416400, '', '', '', '', 0, b'1', b'1', b'1', '1', '2024-11-05 15:36:48', '1', '2024-11-05 15:36:48', b'0', NULL, 1);
	641	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `app_id`, `tenant_id`) VALUES (1803317368435416402, '新增', 'model:chart:create', 3, 2, 1803317368435416400, '', '', '', '', 0, b'1', b'1', b'1', '1', '2024-11-05 15:37:03', '1', '2024-11-05 15:37:03', b'0', NULL, 1);
	642	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `app_id`, `tenant_id`) VALUES (1803317368435416403, '修改', 'model:chart:update', 3, 3, 1803317368435416400, '', '', '', '', 0, b'1', b'1', b'1', '1', '2024-11-05 15:37:20', '1', '2024-11-05 15:37:20', b'0', NULL, 1);
	643	INSERT INTO `iailab_plat_system`.`system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `app_id`, `tenant_id`) VALUES (1803317368435416404, '删除', 'model:chart:delete', 3, 4, 1803317368435416400, '', '', '', '', 0, b'1', b'1', b'1', '1', '2024-11-05 15:37:38', '1', '2024-11-05 15:37:38', b'0', NULL, 1);
	644
	645	-- table
680be4	646	CREATE TABLE `t_chart` (
D	647	`id` varchar(36) NOT NULL,
	648	`chart_name` varchar(100) DEFAULT NULL COMMENT '图表名称',
	649	`chart_code` varchar(100) DEFAULT NULL COMMENT '图表编码',
	650	`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
	651	`update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
	652	PRIMARY KEY (`id`),
	653	UNIQUE KEY `uk_chart_code` (`chart_code`),
	654	KEY `index_id` (`id`)
5e6c2d	655	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='图表配置';
680be4	656
D	657	CREATE TABLE `t_chart_param` (
	658	`id` varchar(36) NOT NULL,
	659	`chart_id` varchar(36) NOT NULL COMMENT '图表id',
	660	`param_name` varchar(255) DEFAULT NULL COMMENT '参数名称',
	661	`param_code` varchar(100) DEFAULT NULL COMMENT '参数编码',
	662	`param_value` varchar(1000) DEFAULT NULL COMMENT '参数值',
	663	`remark` varchar(255) DEFAULT NULL COMMENT '备注',
	664	`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
	665	`update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
	666	PRIMARY KEY (`id`,`chart_id`) USING BTREE,
	667	KEY `index_chart_id` (`chart_id`),
	668	CONSTRAINT `chart_id` FOREIGN KEY (`chart_id`) REFERENCES `t_chart` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
5e6c2d	669	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='图表参数配置';
abcfb4	670
潘	671
cf2287	672	DROP TABLE IF EXISTS `t_mpk_pack`;
潘	673	CREATE TABLE `t_mpk_pack` (
	674	`id` varchar(36) NOT NULL COMMENT 'id',
	675	`pack_name` varchar(50) NOT NULL COMMENT '包名称',
	676	`pack_desc` varchar(50) DEFAULT NULL COMMENT '包描述',
	677	`model_path` varchar(50) DEFAULT NULL COMMENT '模型路径',
	678	`sort` integer DEFAULT NULL COMMENT '排序',
	679	PRIMARY KEY (`id`) USING BTREE,
	680	UNIQUE INDEX uk_pack_name (pack_name)
	681	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'MDK包名管理' ROW_FORMAT = Dynamic;