Research Article
The Construction of Data Intelligent Search Model and Music Database Management and Control System Based on Machine Learning
Table 4
Type and search field mapping table t_field_define.
| | Field name | Field type | Allow to be empty | Default value | Chinese name | Remarks |
| | CLASS_ID | bigint(20) | No | — | Category id | Primary key | | TYPECLASS | bigint(20) | Yes | — | Owning database ID | — | | FIELD_ID | bigint(20) | No | — | ID of field_ collection such as title, instrument name, etc. | — | | FIELD_NAME | varchar(20) | No | - | Field name (F1, F2), etc. | Primary key | | FIELD_DESC | varchar(50) | Yes | — | Field description | | | ORDER_CODE | int(4) | Yes | — | Sort code | — | | QUERY_STATUS | int(4) | Yes | 0 | Default query status | 0 default no query 1 default query |
|
|
