iailab-plat.git

dengzedong

2024-09-26 587b438f50abb725f3dee63eaf6b586c09085f54

提交 \| 用户 \| 时间
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),
6a5cf8	14	UNIQUE INDEX idx_moduletype (moduletype)
潘	15	) engine = innodb default character set utf8mb4 COMMENT = '管网表';
f154f0	16
潘	17
6a5cf8	18	create table t_dm_module_item
f154f0	19	(
潘	20	id varchar(36) not null,
	21	moduleid varchar(36),
	22	itemid varchar(36),
	23	itemorder bigint,
	24	status bigint,
	25	categoryid varchar(64),
	26	primary key (id),
	27	key idx_moduleid (moduleid)
6a5cf8	28	) engine = innodb default character set utf8mb4 COMMENT = '管网预测项关系表';
f154f0	29
潘	30	create table t_mm_item_output
	31	(
	32	id varchar(36) not null,
	33	itemid varchar(36),
	34	pointid varchar(36),
	35	resulttableid varchar(36),
	36	tagname varchar(50),
	37	outputorder decimal(5, 0),
	38	primary key (id),
6a5cf8	39	INDEX idx_itemid (itemid)
潘	40	) engine = innodb default character set utf8mb4 COMMENT = '预测项输出表';
f154f0	41
6a5cf8	42	create table t_mm_item_result
f154f0	43	(
潘	44	id varchar(36) not null,
	45	outputid varchar(36),
	46	datatime datetime,
	47	datavalue decimal(19, 3),
	48	primary key (id),
6a5cf8	49	INDEX idx_outputid (outputid),
潘	50	INDEX idx_datatime (datatime)
f154f0	51	) engine = innodb
6a5cf8	52	default character set utf8mb4 COMMENT = '预测结果表';
f154f0	53
6a5cf8	54	create table t_mm_item_type
f154f0	55	(
潘	56	id varchar(36) not null,
	57	itemtypename varchar(50),
	58	itemclasstype varchar(100),
	59	assemblyname varchar(64),
	60	primary key (id)
6a5cf8	61	) engine = innodb default character set utf8mb4 COMMENT = '预测项类型表';
f154f0	62
6a5cf8	63	create table t_mm_model_arith_settings
f154f0	64	(
6a5cf8	65	id varchar(36) not null,
潘	66	modelid varchar(36),
	67	`key` varchar(36),
f154f0	68	value varchar(256),
6a5cf8	69	name varchar(36),
潘	70	valuetype varchar(36),
f154f0	71	primary key (id),
6a5cf8	72	INDEX idx_modelid (modelid)
潘	73	) engine = innodb default character set utf8mb4 COMMENT = '预测模型设置参数表';
f154f0	74
6a5cf8	75	create table t_mm_model_param
f154f0	76	(
6a5cf8	77	id varchar(36) not null,
潘	78	modelid varchar(36),
	79	modelparamname varchar(36),
	80	modelparamid varchar(36),
f154f0	81	modelparamorder integer,
潘	82	modelparamportorder integer,
	83	datalength integer,
6a5cf8	84	modelparamtype varchar(36),
f154f0	85	primary key (id),
6a5cf8	86	INDEX idx_modelid (modelid)
潘	87	) engine = innodb default character set utf8mb4 COMMENT = '预测模型输入参数表';
f154f0	88
6a5cf8	89	create table t_mm_model_resultstr
f154f0	90	(
潘	91	id varchar(64) not null,
	92	resultstr varchar(64),
6a5cf8	93	primary key (id)
潘	94	) engine = innodb default character set utf8mb4 COMMENT = '预测模型结果字符串表';
f154f0	95
潘	96	create table
	97	t_mm_predict_item
	98	(
	99	id varchar(36) not null,
	100	itemno varchar(16),
	101	itemname varchar(50),
	102	caltypeid varchar(36),
	103	itemtypeid varchar(36),
	104	predictlength decimal(5, 0),
	105	granularity decimal(5, 0),
	106	status decimal(5, 0),
	107	isfuse decimal(5, 0),
	108	predictphase decimal(5, 0),
	109	workchecked decimal(5, 0),
	110	unittransfactor decimal(31, 6),
	111	create_time datetime default current_timestamp,
	112	update_time datetime default current_timestamp,
	113	saveindex varchar(16),
	114	primary key (id),
6a5cf8	115	UNIQUE INDEX uk_itemno (itemno)
潘	116	) engine = innodb default character set utf8mb4 COMMENT = '预测模型结果字符串表';
f154f0	117
潘	118	create table
	119	t_mm_predict_merge_item
	120	(
	121	id varchar(36) not null,
	122	itemid varchar(36),
6a5cf8	123	expression varchar(255),
f154f0	124	num integer,
潘	125	primary key (id),
6a5cf8	126	UNIQUE INDEX uk_itemid (itemid)
潘	127	) engine = innodb default character set utf8mb4 COMMENT = '合并预测项表';
f154f0	128
潘	129	create table
	130	t_mm_predict_model
	131	(
	132	id varchar(36) not null,
	133	modelno varchar(32),
	134	modelname varchar(50),
	135	itemid varchar(36),
	136	arithid varchar(36),
	137	trainsamplength decimal(5, 0),
	138	predictsamplength decimal(5, 0),
	139	isonlinetrain decimal(5, 0),
	140	modelpath varchar(256),
	141	isnormal decimal(5, 0),
	142	normalmax decimal(19, 3),
	143	normalmin decimal(19, 3),
	144	status decimal(5, 0),
	145	classname varchar(256),
	146	methodname varchar(64),
	147	modelparamstructure varchar(128),
	148	resultstrid varchar(64),
	149	settingmap varchar(256),
	150	trainmodelpath varchar(256),
	151	pathstatus decimal(5, 0),
	152	pdim smallint,
	153	traninip varchar(16),
	154	comparisonclassname varchar(256),
	155	primary key (id),
6a5cf8	156	INDEX idx_modelno (modelno),
潘	157	UNIQUE INDEX idx_itemid (itemid)
f154f0	158	) engine = innodb
6a5cf8	159	default character set utf8mb4 COMMENT = '预测项模型表';
f154f0	160
6a5cf8	161	create table t_mm_result_table
f154f0	162	(
潘	163	id varchar(36) not null,
	164	tablename varchar(30),
	165	primary key (id)
6a5cf8	166	) engine = innodb default character set utf8mb4 COMMENT = '预测结果存放表';
f154f0	167
潘	168
6a5cf8	169	create table t_mm_item_result_json
f154f0	170	(
6a5cf8	171	id varchar(36) not null,
潘	172	outputid varchar(36),
	173	predicttime datetime,
	174	jsonvalue varchar(6400),
	175	cumulant varchar(36),
f154f0	176	primary key (id),
6a5cf8	177	INDEX idx_outputid (outputid),
潘	178	INDEX idx_predicttime (predicttime)
	179	) engine = innodb default character set utf8mb4 COMMENT = '预测JSON数据表';
f154f0	180
潘	181	create table
6a5cf8	182	t_mm_item_result_last_point
f154f0	183	(
6a5cf8	184	id varchar(36) not null,
潘	185	outputid varchar(36),
	186	datatime datetime,
	187	datavalue decimal(19, 3),
f154f0	188	primary key (id),
6a5cf8	189	INDEX idx_outputid (outputid),
潘	190	INDEX idx_datatime (datatime)
	191	) engine = innodb default character set utf8mb4 COMMENT = '预测T+L数据表';
f154f0	192
6a5cf8	193	create table t_mm_item_accuracy_rate
f154f0	194	(
6a5cf8	195	id varchar(36) not null,
潘	196	item_id varchar(36) not null COMMENT '预测项ID',
	197	sample_length integer COMMENT '样本长度',
	198	value_type integer COMMENT '值类型',
	199	in_deviation decimal(8, 3) COMMENT '精准误差',
	200	in_accuracy_rate decimal(6, 4) COMMENT '精准度',
	201	out_deviation decimal(8, 3) COMMENT '不可信误差',
	202	out_accuracy_rate decimal(6, 4) COMMENT '不可信率',
	203	is_enable tinyint,
	204	update_time datetime,
	205	begin_time datetime,
f154f0	206	primary key (id),
6a5cf8	207	INDEX idx_item_id (item_id)
f154f0	208	) engine = innodb
6a5cf8	209	default character set utf8mb4 COMMENT = '预测精准度表';
f154f0	210
7fd198	211	create table t_mm_predict_alarm_config
f154f0	212	(
7fd198	213	id varchar(36) not null,
6a5cf8	214	title varchar(20) COMMENT '消息标题',
7fd198	215	alarm_obj varchar(36) COMMENT '监控对象',
潘	216	item_id varchar(36) COMMENT '预测项ID',
	217	comp_length int COMMENT '比较长度',
	218	upper_limit decimal(10, 4) COMMENT '上限',
	219	lower_limit decimal(10, 4) COMMENT '下限',
	220	unit varchar(10) COMMENT '单位',
	221	coefficient decimal(10, 4) COMMENT '转换系数',
	222	model_id varchar(36) COMMENT '调度建议模型',
	223	is_enable tinyint NOT NULL COMMENT '是否启用（0禁用 1启用）',
	224	`creator` varchar(64) NOT NULL DEFAULT '' COMMENT '创建者',
	225	`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
	226	`updater` varchar(64) DEFAULT '' COMMENT '更新者',
	227	`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
	228	primary key (id)
	229	) engine = innodb
	230	default character set utf8mb4 COMMENT = '预警配置表';
	231
	232	create table t_mm_predict_alarm_message
	233	(
	234	id varchar(36) not null,
	235	title varchar(36) COMMENT '消息标题',
	236	content varchar(128) COMMENT '消息内容',
	237	alarm_obj varchar(36) COMMENT '监控对象',
	238	point_id varchar(36) COMMENT '监控点位ID',
	239	item_id varchar(36) COMMENT '预测项ID',
	240	current_value decimal(18, 4) COMMENT '当前值',
	241	out_time datetime COMMENT '超出时间',
	242	out_value decimal(18, 4) COMMENT '超出值',
	243	alarm_type varchar(10) COMMENT '预警类型',
	244	alarm_time datetime COMMENT '预警时间',
	245	create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
f154f0	246	primary key (id),
6a5cf8	247	INDEX idx_item_id (item_id),
潘	248	INDEX idx_alarm_obj (alarm_obj),
	249	INDEX idx_alarm_time (alarm_time)
f154f0	250	) engine = innodb
7fd198	251	default character set utf8mb4 COMMENT = '预警消息表';
f154f0	252
6a5cf8	253
潘	254	-- 调度模块
	255
	256	create table t_st_schedule_scheme
f154f0	257	(
6a5cf8	258	`id` varchar(36) not null COMMENT 'ID',
056470	259	`code` varchar(20) not null COMMENT '编号',
潘	260	`name` varchar(20) not null COMMENT '名称',
6a5cf8	261	`trigger_method` varchar(20) COMMENT '触发方式',
潘	262	`trigger_condition` varchar(20) COMMENT '触发条件',
	263	`schedule_obj` varchar(20) COMMENT '调整对象',
	264	`schedule_type` varchar(20) COMMENT '调整类型',
	265	`schedule_strategy` varchar(20) COMMENT '调整策略',
	266	`model_id` varchar(36) COMMENT '调度模型',
	267	`schedule_time` datetime COMMENT '调度时间',
	268	`status` tinyint NOT NULL DEFAULT 0 COMMENT '方案状态（0正常 1停用）',
	269	`remark` varchar(100) COMMENT '备注',
	270	`creator` varchar(64) NOT NULL DEFAULT '' COMMENT '创建者',
	271	`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
	272	`updater` varchar(64) NULL DEFAULT '' COMMENT '更新者',
	273	`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
bbc1ee	274	`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
f154f0	275	primary key (id),
6a5cf8	276	UNIQUE INDEX `uk_code` (`code` ASC) USING BTREE
f154f0	277	) engine = innodb
6a5cf8	278	default character set utf8mb4 COMMENT = '调度方案表';
潘	279
	280	create table t_st_schedule_model
	281	(
	282	`id` varchar(36) not null COMMENT 'ID',
056470	283	`model_code` varchar(64) not null COMMENT '模型编号',
潘	284	`model_name` varchar(64) not null COMMENT '模型名称',
6a5cf8	285	`model_type` varchar(64) COMMENT '模型类型',
潘	286	`class_name` varchar(128) COMMENT '类名',
	287	`method_name` varchar(64) COMMENT '方法名',
	288	`port_length` integer COMMENT '输入数量',
	289	`param_structure` varchar(256) COMMENT '参数构造',
	290	`model_path` varchar(256) COMMENT '路径',
	291	`result_str_id` varchar(64) COMMENT '结果ID',
	292	`invocation` varchar(64) COMMENT '调用方式',
	293	`status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0正常 1停用）',
	294	`creator` varchar(64) NOT NULL DEFAULT '' COMMENT '创建者',
	295	`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
	296	`updater` varchar(64) NULL DEFAULT '' COMMENT '更新者',
	297	`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
bbc1ee	298	`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
6a5cf8	299	primary key (id),
潘	300	UNIQUE INDEX `uk_model_code` (`model_code` ASC) USING BTREE
bbc1ee	301	) engine = innodb default character set utf8mb4 COMMENT = '调度模型表';
f154f0	302
潘	303	create table
6a5cf8	304	t_st_schedule_model_param
f154f0	305	(
6a5cf8	306	id varchar(36) not null,
056470	307	modelid varchar(64) not null,
6a5cf8	308	modelparamname varchar(64),
潘	309	modelparamid varchar(64),
	310	modelparamorder integer,
	311	modelparamportorder integer,
	312	datalength integer,
	313	modelparamtype varchar(64),
	314	primary key (id)
f154f0	315	) engine = innodb
6a5cf8	316	default character set utf8mb4 COMMENT = '调度模型输入参数表';
潘	317
f154f0	318
潘	319	create table
6a5cf8	320	t_st_schedule_model_setting
潘	321	(
	322	`id` varchar(36) not null,
056470	323	`modelid` varchar(64) not null,
6a5cf8	324	`key` varchar(64),
潘	325	`value` varchar(64),
	326	`valuetype` varchar(64),
	327	`name` varchar(64),
bbc1ee	328	`sort` integer,
6a5cf8	329	primary key (id),
潘	330	key idx_modelid (modelid)
	331	) engine = innodb
	332	default character set utf8mb4 COMMENT = '调度模型设置参数表';
	333
	334	create table
bbc1ee	335	t_st_schedule_suggest
f154f0	336	(
潘	337	id varchar(36) not null,
6a5cf8	338	title varchar(50) COMMENT '标题',
潘	339	content varchar(256) COMMENT '内容',
	340	sort integer COMMENT '排序',
	341	scheme_id varchar(36) COMMENT '方案ID',
	342	alarm_id varchar(36) COMMENT '预警ID',
	343	item_id varchar(36) COMMENT '预测项ID',
	344	model_id varchar(36) COMMENT '模型ID',
	345	schedule_obj varchar(20) COMMENT '调整对象',
	346	schedule_type varchar(20) COMMENT '调整类型',
	347	schedule_strategy varchar(20) COMMENT '调整策略',
	348	adjust_mode varchar(20) COMMENT '调整方式',
	349	adjust_value decimal(18, 4) COMMENT '调整值',
	350	adjust_unit varchar(20) COMMENT '调整单位',
	351	adjust_times decimal(18, 4) COMMENT '持续时长',
	352	adjust_start datetime COMMENT '调整开始时间',
	353	adjust_end datetime COMMENT '调整结束时间',
	354	schedule_time datetime COMMENT '调度时间',
	355	status tinyint NOT NULL COMMENT '状态（0未处理 1已采纳 2已忽略）',
	356	handler varchar(36) COMMENT '处理人',
	357	handle_time datetime COMMENT '处理时间',
	358	create_time datetime default current_timestamp COMMENT '创建时间',
f154f0	359	primary key (id),
6a5cf8	360	INDEX idx_scheme_id (scheme_id),
潘	361	INDEX idx_alarm_id (alarm_id),
	362	INDEX idx_item_id (item_id),
	363	INDEX idx_model_id (model_id),
	364	INDEX idx_schedule_obj (schedule_obj),
	365	INDEX idx_schedule_type (schedule_type)
f154f0	366	) engine = innodb
6a5cf8	367	default character set utf8mb4 COMMENT = '调度建议表';
潘	368
f154f0	369
潘	370	create table
6a5cf8	371	t_st_schedule_record
f154f0	372	(
6a5cf8	373	`id` varchar(36) not null,
潘	374	`scheme_id` varchar(36) COMMENT '方案ID',
	375	`model_id` varchar(36) COMMENT '模型ID',
bbc1ee	376	`model_name` varchar(64) COMMENT '模型名称',
6a5cf8	377	`schedule_time` datetime COMMENT '调度时间',
潘	378	`create_time` datetime default current_timestamp COMMENT '创建时间',
f154f0	379	primary key (id),
6a5cf8	380	INDEX idx_scheme_id (scheme_id),
潘	381	INDEX idx_model_id (model_id),
	382	INDEX idx_schedule_time (schedule_time)
f154f0	383	) engine = innodb
6a5cf8	384	default character set utf8mb4 COMMENT = '调度记录表';
潘	385
	386
	387	create table
	388	t_st_schedule_record_detail
	389	(
	390	`id` varchar(36) not null,
	391	`record_id` varchar(36),
	392	`scheme_id` varchar(64),
	393	`model_id` varchar(36) COMMENT '模型ID',
	394	`result_key` varchar(64),
	395	`result_value` text,
	396	`schedule_time` datetime COMMENT '调度时间',
	397	primary key (id),
	398	key idx_record_id (record_id),
	399	key idx_scheme_id (scheme_id),
	400	key idx_model_id (model_id)
	401	) engine = innodb
	402	default character set utf8mb4 COMMENT = '调度记录详情表';
446130	403
D	404	-- mpk
	405
	406	-- menu
	407	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');
	408	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');
	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 (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');
	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 (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');
	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 (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');
	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 (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');
	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 (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');
	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 (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');
	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 (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');
	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 (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');
	417
	418
	419	-- config
	420	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');
	421
3e40f1	422	-- dist
D	423	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');
	424	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');
	425	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');
	426	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');
	427
	428
	429	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');
	430	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');
	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 (1538, 2, 'predict', 'predict', 'model_method', 0, '', '', '', '1', '2024-09-09 16:13:05', '1', '2024-09-09 16:13:05', 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 (1539, 1, '预测模型', 'predict', 'model_type', 0, '', '', '', '1', '2024-09-13 14:14:58', '1', '2024-09-13 14:14:58', 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 (1540, 2, '调度模型', 'schedul', 'model_type', 0, '', '', '', '1', '2024-09-13 14:17:53', '1', '2024-09-13 14:17:53', 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 (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');
	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 (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');
	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 (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');
	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 (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');
	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 (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');
	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 (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');
	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 (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');
	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 (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');
	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 (1549, 4, 'schedul', 'schedul', 'model_method', 0, '', '', '', '1', '2024-09-14 14:56:44', '1', '2024-09-14 14:56:44', b'0');
	443
	444
	445	-- 业务表
446130	446	DROP TABLE IF EXISTS `t_mpk_file`;
D	447	CREATE TABLE `t_mpk_file` (
	448	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	449	`py_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型名称',
3e40f1	450	`py_chinese_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型中文名称',
446130	451	`file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '源文件保存路径',
D	452	`py_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型类型',
	453	`pkg_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '包名',
	454	`class_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '类名',
	455	`py_module` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型路径',
3e40f1	456	`icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'icon图片名',
D	457	`menu_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所属菜单',
	458	`group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所属组',
446130	459	`remark` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
D	460	`creator` bigint NULL DEFAULT NULL COMMENT '创建者',
	461	`create_date` datetime NULL DEFAULT NULL COMMENT '创建时间',
	462	`updater` bigint NULL DEFAULT NULL COMMENT '更新者',
	463	`update_date` datetime NULL DEFAULT NULL COMMENT '更新时间',
	464	PRIMARY KEY (`id`) USING BTREE,
	465	UNIQUE INDEX `uk_py_name`(`py_name` ASC) USING BTREE,
	466	INDEX `idx_create_date`(`create_date` ASC) USING BTREE
	467	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'MDK模型文件' ROW_FORMAT = DYNAMIC;
	468
	469	-- ----------------------------
	470	-- Table structure for t_mpk_generator_code_history
	471	-- ----------------------------
	472	DROP TABLE IF EXISTS `t_mpk_generator_code_history`;
	473	CREATE TABLE `t_mpk_generator_code_history` (
	474	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
3e40f1	475	`mdk_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'mdk_id',
446130	476	`file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件名',
D	477	`file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件保存路径',
	478	`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
	479	`create_time` timestamp NULL DEFAULT NULL COMMENT '生成时间',
3e40f1	480	PRIMARY KEY (`id`, `mdk_id`) USING BTREE,
D	481	INDEX `del_code_history`(`mdk_id` ASC) USING BTREE,
	482	CONSTRAINT `del_code_history` FOREIGN KEY (`mdk_id`) REFERENCES `t_mpk_file` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
446130	483	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '生成代码记录表' ROW_FORMAT = DYNAMIC;
3e40f1	484
D	485	-- ----------------------------
f9b109	486	-- Table structure for t_mpk_model_method
D	487	-- ----------------------------
	488	DROP TABLE IF EXISTS `t_mpk_model_method`;
	489	CREATE TABLE `t_mpk_model_method` (
	490	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	491	`mpk_file_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '模型文件id',
	492	`method_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型方法名',
	493	`data_length` int NULL DEFAULT 1 COMMENT '输入个数',
	494	`model` int NULL DEFAULT 0 COMMENT '是否有model(0:否,1:是)',
	495	`result_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '结果key',
8b3ee3	496	`sort` integer,
f9b109	497	PRIMARY KEY (`id`, `mpk_file_id`) USING BTREE,
D	498	INDEX `id`(`id` ASC) USING BTREE,
8b3ee3	499	INDEX `idx_method`(`mpk_file_id` ASC) USING BTREE,
f9b109	500	CONSTRAINT `del_method` FOREIGN KEY (`mpk_file_id`) REFERENCES `t_mpk_file` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
D	501	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
	502
	503	-- ----------------------------
3e40f1	504	-- Table structure for t_mpk_method_setting
D	505	-- ----------------------------
	506	DROP TABLE IF EXISTS `t_mpk_method_setting`;
	507	CREATE TABLE `t_mpk_method_setting` (
	508	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	509	`method_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '方法id',
	510	`setting_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'key',
	511	`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数名称',
	512	`value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数默认值',
	513	`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '输入类型',
	514	`value_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数类型',
	515	`max` int NULL DEFAULT NULL COMMENT '最大值',
	516	`min` int NULL DEFAULT NULL COMMENT '最小值',
8b3ee3	517	`sort` integer,
3e40f1	518	PRIMARY KEY (`id`, `method_id`) USING BTREE,
D	519	INDEX `del_setting`(`method_id` ASC) USING BTREE,
	520	INDEX `id`(`id` ASC) USING BTREE,
	521	CONSTRAINT `del_setting` FOREIGN KEY (`method_id`) REFERENCES `t_mpk_model_method` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
	522	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '方法参数关联表' ROW_FORMAT = Dynamic;
446130	523
f9b109	524
446130	525	-- ----------------------------
f9b109	526	-- Table structure for t_mpk_setting_select
446130	527	-- ----------------------------
f9b109	528	DROP TABLE IF EXISTS `t_mpk_setting_select`;
D	529	CREATE TABLE `t_mpk_setting_select` (
	530	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	531	`setting_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '参数id',
	532	`select_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'key',
	533	`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名称',
8b3ee3	534	`sort` integer,
f9b109	535	PRIMARY KEY (`id`, `setting_id`) USING BTREE,
D	536	INDEX `del_select`(`setting_id` ASC) USING BTREE,
	537	CONSTRAINT `del_select` FOREIGN KEY (`setting_id`) REFERENCES `t_mpk_method_setting` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
	538	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '参数选项关联表' ROW_FORMAT = Dynamic;
446130	539
D	540	-- ----------------------------
	541	-- Table structure for t_mpk_project
	542	-- ----------------------------
	543	DROP TABLE IF EXISTS `t_mpk_project`;
	544	CREATE TABLE `t_mpk_project` (
	545	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
	546	`project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目名称',
	547	`project_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目编码',
	548	`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
	549	`update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
	550	PRIMARY KEY (`id`) USING BTREE
	551	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目表' ROW_FORMAT = DYNAMIC;
	552
	553	-- ----------------------------
	554	-- Table structure for t_mpk_project_model
	555	-- ----------------------------
	556	DROP TABLE IF EXISTS `t_mpk_project_model`;
	557	CREATE TABLE `t_mpk_project_model` (
	558	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
3e40f1	559	`project_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目id',
D	560	`model_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '模型id',
	561	PRIMARY KEY (`id`, `project_id`, `model_id`) USING BTREE,
	562	INDEX `del_p`(`project_id` ASC) USING BTREE,
	563	INDEX `del_m`(`model_id` ASC) USING BTREE,
	564	CONSTRAINT `del_m` FOREIGN KEY (`model_id`) REFERENCES `t_mpk_file` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
	565	CONSTRAINT `del_p` FOREIGN KEY (`project_id`) REFERENCES `t_mpk_project` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
446130	566	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目模型关联表' ROW_FORMAT = DYNAMIC;
D	567
	568	-- ----------------------------
	569	-- Table structure for t_mpk_project_package_history
	570	-- ----------------------------
	571	DROP TABLE IF EXISTS `t_mpk_project_package_history`;
	572	CREATE TABLE `t_mpk_project_package_history` (
	573	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
3e40f1	574	`project_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目id',
446130	575	`file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件名',
D	576	`file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件路径',
	577	`version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '版本号',
	578	`log` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新日志',
	579	`model_names` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '打包模型名称（“，”分割）',
	580	`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
3e40f1	581	PRIMARY KEY (`id`, `project_id`) USING BTREE,
D	582	INDEX `del_package_history`(`project_id` ASC) USING BTREE,
	583	CONSTRAINT `del_package_history` FOREIGN KEY (`project_id`) REFERENCES `t_mpk_project` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
446130	584	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目打包历史记录表' ROW_FORMAT = DYNAMIC;
D	585
	586	-- ----------------------------
	587	-- Table structure for t_mpk_project_package_history_model
	588	-- ----------------------------
	589	DROP TABLE IF EXISTS `t_mpk_project_package_history_model`;
	590	CREATE TABLE `t_mpk_project_package_history_model` (
	591	`id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
3e40f1	592	`project_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目id',
446130	593	`package_history_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '打包历史id',
D	594	`py_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型名称',
	595	`pkg_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '包名',
	596	`py_module` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型路径',
	597	`remark` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型备注',
3e40f1	598	`method_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '模型方法信息',
D	599	PRIMARY KEY (`id`, `project_id`) USING BTREE,
	600	INDEX `del_package_model`(`project_id` ASC) USING BTREE,
	601	CONSTRAINT `del_package_model` FOREIGN KEY (`project_id`) REFERENCES `t_mpk_project` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
8b3ee3	602	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '打包历史模型关联表' ROW_FORMAT = Dynamic;
潘	603
	604
	605	DROP TABLE IF EXISTS `t_mpk_icon`;
	606	CREATE TABLE `t_mpk_icon` (
	607	`id` varchar(36) NOT NULL COMMENT 'id',
	608	`icon_name` varchar(36) NOT NULL COMMENT '图标名称',
	609	`icon_desc` varchar(36) DEFAULT NULL COMMENT '图标描述',
	610	`sort` integer DEFAULT NULL COMMENT '排序',
	611	PRIMARY KEY (`id`) USING BTREE
	612	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'MDK平台图标' ROW_FORMAT = Dynamic;
	613
	614	DROP TABLE IF EXISTS `t_mpk_file_menu`;
	615	CREATE TABLE `t_mpk_file_menu` (
	616	`id` varchar(36) NOT NULL COMMENT 'id',
	617	`name` varchar(36) NOT NULL COMMENT '名称',
	618	`sort` integer DEFAULT NULL COMMENT '排序',
	619	PRIMARY KEY (`id`) USING BTREE
	620	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '模型文件菜单' ROW_FORMAT = Dynamic;
	621
	622	DROP TABLE IF EXISTS `t_mpk_file_group`;
	623	CREATE TABLE `t_mpk_file_group` (
	624	`id` varchar(36) NOT NULL COMMENT 'id',
	625	`menu_id` varchar(36) NOT NULL COMMENT '菜单',
	626	`name` varchar(36) NOT NULL COMMENT '名称',
	627	`sort` integer DEFAULT NULL COMMENT '排序',
	628	PRIMARY KEY (`id`) USING BTREE
	629	) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '模型文件分组' ROW_FORMAT = Dynamic;