Development and Application of an Intelligent Evaluation and Control Platform for Tunnel Smooth Blasting

Table 1

Set of data types of the database.

Index type	Data name	Field name	Type
	Number	_id	INTEGER
	Section number	No_blasthole	CHAR(20)
Control index	Rock mass classification	rock_classification	DOUBLE
	Detonation velocity (m/s)	blast_speed	DOUBLE
	Peripheral hole spacing (mm)	hole_space	DOUBLE
	Minimum resistance line (m)	least_resistance	DOUBLE
	Relative distance	relative_distance	DOUBLE
	Linear charge density (kg/m)	charge_density	DOUBLE
	Initiation order	blast_order	DOUBLE
	Excavation method	excavate_method	DOUBLE
	Site measurement	measurement	DOUBLE
Point index	Maximum overbreak (m)	max_overbreak	DOUBLE
	Maximum underbreak (m)	max_underbreak	DOUBLE
	Average linear overbreak (m)	ave_overbreak	DOUBLE
Line index	Maximum size of the hole steps (cm)	gun_stepsize	DOUBLE
Area index	Area of the section for measurement (m^2)	area	DOUBLE
	Overbreak area (m^2)	overbreak_area	DOUBLE
	Overbreak rate (%)	overbreak_rate	DOUBLE
Volume index	Overbreak volume (m^3)	overbreak_volume	DOUBLE
	Hole utilization ratio (%)	blasthole_utilization	DOUBLE
Evaluation level	Evaluation score 1	effect_1	DOUBLE
	Evaluation score 2	effect_2	DOUBLE
	Evaluation grade 1	class_1	INTEGER
	Evaluation grade 2	class_2	INTEGER
Control suggestion	BP recommendation	bp_suggestion	CHAR(100)
	ANFIS recommendation	anfis_suggestion	CHAR(100)
	Elman recommendation	elman_suggestion	CHAR(100)
	Control suggestion	control_suggestion	CHAR(100)