Open motorollerscalatron opened 6 years ago
The category where questions belongs to.
Field | Type | Null | Key | Default |
---|---|---|---|---|
id | int | NO | ||
name | string | NO |
The junction table between challenge and category
Field | Type | Null | Key | Default |
---|---|---|---|---|
question_id | int | NO | ||
category_id | int | NO |
As users are given a list of questions filtered by only
is_public
flag and the create time, it is hard to make a choice from the list. It is desirable that each question have its category label assigned, such as 'science', 'common knowledge', 'fashion', etc.