Artificial Intelligence of Internet of Things Based on Machine Learning and College Student Management

Table 3

Student achievement information structure.

Field description	Field identification	Field Type	Width	Whether it is allowed to be empty	Primary key
Student ID	admin	Integer	--	N	Y
Classification	lessonname	Varchar	20	N	Y
Name	name	Varchar	20	Y	N
Semester	xueqi	Varchar	20	Y	N
Class	banno	Integer	—	Y	N
Professional number	zhuanyeno	Integer	—	N	Y
Professional name	zhuanyename	Varchar	20	Y	N
System	xmo	Integer	—	Y	N
Classification	lessonname	Varchar	—	Y	N
Fraction	fenshu	Integer	—	Y	N
Type	leixing	Varchar	8	Y	N