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

Table 5

Student discipline violation information registration form.

Field description	Field identification	Field Type	Width	Whether it is allowed to be empty	Primary key
Semester	xueqi	Varchar	20	N	Y
System	xmo	Integer	—	Y	N
Professional number	zhuanyeno	Integer	—	Y	N
Grade number	Imo	Integer	—	Y	N
Class number	banno	Integer	—	Y	N
Student number	studnum	Integer	—	Y	N
Accommodation information	roominfo	Varchar	—	Y	N
Disciplinary date	wjrq	Varchar	—	Y	N
Disciplinary type	wjlx	Varchar	—	Y	N
Cause of discipline	wjyy	Varchar	—	Y	N
Remark	wjbz	Varchar	8	Y	N
Add a person	addman	Varchar	8	Y	N