| 189 | parent_comment_id = Column(String(255), comment='父评论ID') |
| 190 | |
| 191 | class XhsNote(Base): |
| 192 | __tablename__ = 'xhs_note' |
| 193 | id = Column(Integer, primary_key=True, comment='主键ID') |
| 194 | creator_hash = Column(String(64), index=True, comment='创作者匿名哈希') |
| 195 | nickname = Column(Text, comment='用户昵称(已脱敏)') |
| 196 | add_ts = Column(BigInteger, comment='添加时间戳') |
| 197 | last_modify_ts = Column(BigInteger, comment='最后修改时间戳') |
| 198 | note_id = Column(String(255), index=True, comment='笔记ID') |
| 199 | type = Column(Text, comment='笔记类型') |
| 200 | title = Column(Text, comment='笔记标题') |
| 201 | desc = Column(Text, comment='笔记描述') |
| 202 | video_url = Column(Text, comment='视频URL') |
| 203 | time = Column(BigInteger, index=True, comment='时间戳') |
| 204 | last_update_time = Column(BigInteger, comment='最后更新时间戳') |
| 205 | liked_count = Column(Text, comment='点赞数') |
| 206 | collected_count = Column(Text, comment='收藏数') |
| 207 | comment_count = Column(Text, comment='评论数') |
| 208 | share_count = Column(Text, comment='分享数') |
| 209 | image_list = Column(Text, comment='图片列表') |
| 210 | tag_list = Column(Text, comment='标签列表') |
| 211 | note_url = Column(Text, comment='笔记URL') |
| 212 | source_keyword = Column(Text, default='', comment='来源关键词') |
| 213 | xsec_token = Column(Text, comment='Xsec Token') |
| 214 | |
| 215 | class XhsNoteComment(Base): |
| 216 | __tablename__ = 'xhs_note_comment' |