How to design the php multiple-choice question database
php multiple-choice question data table can be designed as follows:
E-R diagram
##Multiple choice data table
##Column Name |
Description |
##Data type |
constraint |
|||
ChoiceQst_id |
##Question number
| ##tinyint|||||
##Question model |
int |
##not null |
##foreign key ##ChoiceQst_Info |
|||
#Content |
text |
##not null |
##ChoiceQst_OP1 |
|||
| ##Operation 1 |
#text | ##not null##ChoiceQst_OP2
|
||||
| 2
| # #textnot null |
Operation3 |
##text |
##not null |
||
##ChoiceQst_OP4 |
##Operation 4 | ##text|||||
|
#Answer |
char |
##not null |
For more PHP related knowledge, please visit PHP Chinese website ! |
The above is the detailed content of How to design the PHP multiple-choice question database. For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
