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

Table 5

Resource metadata information table t_item.

Field name	Field type	Allow to be empty	Default value	Chinese name	Remarks
I_ID	bigint(20)	No	—	—	Primary key, self-growth
ITEM_ID	varchar(50)	Yes	—	Entry number	—
ARRANGER	varchar(50)	Yes	—	Data organizer	—
CLASS_ID	bigint(20)	Yes	—	Category ID	—
CLASS_NAME	varchar(50)	Yes	—	Category name	—
F1	text	Yes	—	Field 1	—
F2	text	Yes	—	Field 2	—
F3	text	Yes	—	Field 3	—
F4	text	Yes	—	Field 4	—
....	....	....	—	....	—
F30	text	Yes	—	Field 30	—
ADD_TIME	datetime	Yes	—	Add time	—
UPDATE_TIME	datetime	Yes	—	Update time	—
APPROVED	int(11)	Yes	—	Review status	0. To be reviewed 1. Approved