Research Article

The Construction of Data Intelligent Search Model and Music Database Management and Control System Based on Machine Learning

Table 1

Database category table t_class.

Field nameField typeAllow to be emptyDefault valueChinese nameRemarks

CLASS_IDbigint(20)NoCategory idPrimary key, self-growth
CLASS_NAMEvarchar(255)YesCategory name
CLASS_DESCvarchar(255)YesCategory description
PATHvarchar(255)YesLevel
CLASS_CODEvarchar(20)YesResource function code
ORDER_CODEvarchar(20)YesSort code
USESTATEInt(1)YesIs it currently in use0 no, 1 yes