| 229 | like_count = Column(Text, comment='点赞数') |
| 230 | |
| 231 | class TiebaNote(Base): |
| 232 | __tablename__ = 'tieba_note' |
| 233 | id = Column(Integer, primary_key=True, comment='主键ID') |
| 234 | note_id = Column(String(644), index=True, comment='笔记ID') |
| 235 | title = Column(Text, comment='笔记标题') |
| 236 | desc = Column(Text, comment='笔记描述') |
| 237 | note_url = Column(Text, comment='笔记URL') |
| 238 | publish_time = Column(String(255), index=True, comment='发布时间') |
| 239 | creator_hash = Column(String(64), index=True, comment='创作者匿名哈希') |
| 240 | user_nickname = Column(Text, default='', comment='用户昵称(已脱敏)') |
| 241 | tieba_id = Column(String(255), default='', comment='贴吧ID') |
| 242 | tieba_name = Column(Text, comment='贴吧名称') |
| 243 | tieba_link = Column(Text, comment='贴吧链接') |
| 244 | total_replay_num = Column(Integer, default=0, comment='总回复数') |
| 245 | total_replay_page = Column(Integer, default=0, comment='总回复页数') |
| 246 | add_ts = Column(BigInteger, comment='添加时间戳') |
| 247 | last_modify_ts = Column(BigInteger, comment='最后修改时间戳') |
| 248 | source_keyword = Column(Text, default='', comment='来源关键词') |
| 249 | |
| 250 | class TiebaComment(Base): |
| 251 | __tablename__ = 'tieba_comment' |