1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
from django.db import models
from gm_upload import ImgUrlField, IMG_TYPE
from gm_types.mimas import QUALITY_QUESTION_CLASSIFY_TYPE
class BaseModel(models.Model):
class Meta:
abstract = True
create_time = models.DateTimeField(verbose_name='创建时间', auto_now_add=True)
update_time = models.DateTimeField(verbose_name='更新时间', auto_now=True)
class QualityQuestionPool(BaseModel):
class Meta:
verbose_name = '问题池'
db_table = 'api_quality_question_pool'
app_label = 'qa'
title = models.CharField(max_length=256, null=False, verbose_name=u'问题标题')
is_online = models.BooleanField(verbose_name="是否有效", default=True)
class QualityClassfyQuestion(BaseModel):
class Meta:
verbose_name = '绑定的问题'
db_table = 'api_quality_classfy_question'
app_label = 'qa'
classify_type = models.SmallIntegerField(verbose_name='问题类型', default=QUALITY_QUESTION_CLASSIFY_TYPE.COMMON, choices=QUALITY_QUESTION_CLASSIFY_TYPE)
tag_id = models.IntegerField(verbose_name='标签ID', db_index=True)
tag_group_id = models.IntegerField(verbose_name='标签组ID', db_index=True)
is_online = models.BooleanField(verbose_name="是否有效", default=True)
class QualityQuestionClassifyRelation(BaseModel):
class Meta:
verbose_name = '问题和类别映射'
db_table = 'api_quality_classify_map'
app_label = 'qa'
question_id = models.IntegerField(verbose_name='标签ID', db_index=True)
quality_classify_id = models.IntegerField('绑定的类别id', db_index=True)
class QualityQuestion(BaseModel):
class Meta:
verbose_name = '特殊问答'
db_table = 'api_quality_question'
unique_together = ('answer_id', 'question_id')
app_label = 'qa'
answer_id = models.IntegerField(verbose_name='作者回答ID', db_index=True)
question_id = models.IntegerField(verbose_name='用户追问问题ID', db_index=True)
ask_cnt = models.IntegerField(verbose_name='被提问次数', default=0)
answer_cnt = models.IntegerField(verbose_name='回答次数', default=0)
vote_cnt = models.IntegerField(verbose_name='点赞次数', default=0)
is_online = models.BooleanField(verbose_name="是否在线", default=True)
class QualityUserQuestion(BaseModel):
class Meta:
verbose_name = '用户追问问题'
db_table = 'api_quality_user_question'
index_together = ('answer_id', 'user_id')
app_label = 'qa'
quality_question_id = models.IntegerField(verbose_name='问题下特殊问题ID', db_index=True)
answer_id = models.IntegerField(verbose_name='作者回答ID', db_index=True)
question_id = models.IntegerField(verbose_name='冗余添加用户追问问题ID', db_index=True)
user_id = models.IntegerField(verbose_name='用户ID', db_index=True)
is_online = models.BooleanField(verbose_name="是否在线", default=True)
class QualityQuestionVote(BaseModel):
class Meta:
verbose_name = '特殊问题点赞'
db_table = 'api_quality_question_vote'
app_label = 'qa'
quality_question_id = models.IntegerField(verbose_name='问题下特殊问题ID', db_index=True)
user_id = models.IntegerField(verbose_name='用户ID', db_index=True)
is_online = models.BooleanField(verbose_name="是否有效", default=True)
class QualityAuthorAnswer(BaseModel):
class Meta:
verbose_name = '特殊问答-作者回答'
db_table = 'api_quality_author_answer'
app_label = 'qa'
quality_question_id = models.IntegerField(verbose_name='问题下特殊问题ID', db_index=True)
user_id = models.IntegerField(verbose_name='作者用户ID', db_index=True)
content = models.TextField(verbose_name='回答', null=False)
is_online = models.BooleanField(verbose_name="是否有效", default=True)
class QualityAuthorAnswerImage(BaseModel):
class Meta:
verbose_name = '特殊问答-作者回答图片'
db_table = 'api_quality_author_answer_image'
app_label = 'qa'
quality_answer_id = models.IntegerField(verbose_name='问题下特殊问题ID', db_index=True)
url = ImgUrlField(img_type=IMG_TYPE.TOPICIMAGE, max_length=300, verbose_name=u'图片地址')
width = models.IntegerField(verbose_name="图片宽度", default=0)
height = models.IntegerField(verbose_name="图片高度", default=0)
is_online = models.BooleanField(verbose_name="是否有效", default=True)
class QualityReply(BaseModel):
class Meta:
verbose_name = '评论'
db_table = 'api_quality_reply'
app_label = 'qa'
quality_question_id = models.IntegerField(verbose_name='问题下特殊问题ID', db_index=True)
quality_answer_id = models.IntegerField(verbose_name='被评论的回答ID', db_index=True)
top_id = models.IntegerField(verbose_name='评论的一级评论ID', db_index=True)
replied_id = models.IntegerField(verbose_name='被评论的评论ID', db_index=True)
user_id = models.IntegerField(verbose_name='用户ID', db_index=True)
content = models.TextField(verbose_name='回答', null=False)
is_online = models.BooleanField(verbose_name="是否有效", default=True)
class QualityReplyImage(BaseModel):
class Meta:
verbose_name = '特殊问答-作者回答图片'
db_table = 'api_quality_reply_image'
app_label = 'qa'
quality_reply_id = models.IntegerField(verbose_name='评论ID', db_index=True)
url = ImgUrlField(img_type=IMG_TYPE.TOPICIMAGE, max_length=300, verbose_name=u'图片地址')
width = models.IntegerField(verbose_name="图片宽度", default=0)
height = models.IntegerField(verbose_name="图片高度", default=0)
is_online = models.BooleanField(verbose_name="是否有效", default=True)
class QualityQuestionRead(BaseModel):
class Meta:
verbose_name = '用户提问给作者写未读数据'
db_table = 'api_quality_question_read'
app_label = 'qa'
quality_question_id = models.IntegerField(verbose_name='问题下特殊问题ID', db_index=True)
user_id = models.IntegerField(verbose_name='用户ID', db_index=True)
is_read = models.BooleanField(verbose_name="是否已读", default=False)
class QualityAnswerRead(BaseModel):
class Meta:
verbose_name = '作者回答给用户写未读数据'
db_table = 'api_quality_answer_read'
app_label = 'qa'
quality_question_id = models.IntegerField(verbose_name='问题下特殊问题ID', db_index=True)
user_id = models.IntegerField(verbose_name='用户ID', db_index=True)
is_read = models.BooleanField(verbose_name="是否已读", default=False)