Research Article
[Retracted] Artificial Intelligence-Based Online Education System for University Music
Table 4
Structure of test topic table ContentTestList.
| | Number | Field name | Data type | Explain |
| | 1 | ContentTestID | CHAR (30) | Courseware ID, primary key, null string allowed (no) | | 2 | Nodeld | CHAR (30) | Courseware node ID, foreign key, null string allowed (no) | | 3 | ContentTestName | VARCHAR (20) | Back dot name, required field (yes), null string allowed (no) | | 4 | Order | CHAR (2) | Courseware sorting number | | 5 | Type | CHAR (2) | Test question type. The default value is 0
0-single choice, 1-multiple choice, 2-judgment | | 6 | TaskContent | VARCHAR (5000) | Title content, required field (yes), null string allowed (no) | | 7 | RightAnswer | CHAR (10) | Title answer, required field (yes), null string allowed (no) | | 8 | ScorePoinet | Char (2) | Title score, required field (yes) allow empty string (no) | | 9 | CREATE_DATE | VARCHAR (20) | Creation date in the format of yyyymmdd. Empty string is allowed (no) | | 10 | CREATE_USER | CHAR (36) | Created by allow empty strings (no) |
|
|
