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

Table 1

Student information structure.

Field description	Field identification	Field type	Width	Whether it is allowed to be empty	Primary key
Student ID	studno	Integer	—	N	Y
Name	studname	Varchar	20	Y	N
System	xino	Integer	—	N	Y
Professional number	zhuanyeno	Integer	—	N	Y
Class number	banno	Integer	—	N	Y
Age	age	Integer	—	Y	N
Gender	sex	Integer	—	Y	N
Nationality	minzuno	Integer	—	Y	N
Student category	ksno	Integer	—	N	Y
Address	address	Varchar	—	Y	N
Telephone	telph	Varchar	8	Y	N
Photo	ptotono	Varchar	8	Y	N