| 208 |
- |
1 |
## Table: general_survey_answer
|
|
|
2 |
#
|
|
|
3 |
# +----------+------------------+------+-----+---------+----------------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +----------+------------------+------+-----+---------+----------------+
|
|
|
6 |
# | aid | int(10) unsigned | NO | PRI | NULL | auto_increment |
|
|
|
7 |
# | qid | int(10) unsigned | NO | MUL | NULL | |
|
|
|
8 |
# | uid | int(11) unsigned | NO | | NULL | |
|
|
|
9 |
# | response | varchar(1024) | YES | | NULL | |
|
|
|
10 |
# | added | datetime | NO | | NULL | |
|
|
|
11 |
# | page | int(11) | NO | | NULL | |
|
|
|
12 |
# | maxpage | int(11) unsigned | NO | | NULL | |
|
|
|
13 |
# +----------+------------------+------+-----+---------+----------------+
|
|
|
14 |
|
|
|
15 |
CREATE TABLE `general_survey_answer` (
|
|
|
16 |
`aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
17 |
`qid` int(10) unsigned NOT NULL,
|
|
|
18 |
`uid` int(11) unsigned NOT NULL,
|
|
|
19 |
`response` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
20 |
`added` datetime NOT NULL,
|
|
|
21 |
`page` int(11) NOT NULL,
|
|
|
22 |
`maxpage` int(11) unsigned NOT NULL,
|
|
|
23 |
PRIMARY KEY (`aid`),
|
|
|
24 |
UNIQUE KEY `aid_UNIQUE` (`aid`),
|
|
|
25 |
UNIQUE KEY `qid_RCid_page_UNIQUE` (`qid`,`uid`,`page`)
|
|
|
26 |
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
|