Feed Database Design - sirtristancomtedeartois/note GitHub Wiki

FeedSource:

• feedurl: PK
• title
• description
• weight
• tags
• fulltext 1/0
• type: atom or rss
• language: en, cn or other language

TagGraph:

• tag: PK. tag string.
• root: PK. root category, like business, tech, etc.
• level: 节点的深度
• parent: 当前节点的parent 节点tag string.

FeedGraph:

• feedurl:
• root:
• level:
• parent:

tag2level:

• tag: PK. tag string
• root: PK. root category, like business, tech, etc.
• language: PK. language

Feed article will be stored in ElasticSearch.

• feedurl:
• feedtitle:
• 其他parse出来的字段 uniqueid = MD5（feedurl+articletitle）