Home >Backend Development >PHP Problem >How to design the PHP multiple-choice question database
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!