db: posts db table

[Drew-Macgibbon]

Articles Tables

{
  "scraped_articles": {
    "id": "Bigint, Primary Key",
    "created_at": "Timestamp",
    "updated_at": "Timestamp",
    "title": "Text",
    "url": "Text, URL",
    "category_id": "Integer, Foreign Key to Categories table",
    "raw": "JSONB (to store the 'original' object with title and body)",
    "summaries": "JSONB (to store summaries with 'beginner', 'intermediate', 'expert' levels)",
    "author": "JSONB (to store author details as a JSON object)"
  },
  "categories": {
    "id": "Integer, Primary Key",
    "name": "Text",
  },
  "tags": {
    "id": "Integer, Primary Key",
    "name": "Text",
  },
  "scraped_article_tags": {
    "article_id": "Bigint, Foreign Key to Articles table",
    "tag_id": "Integer, Foreign Key to Tags table"
  }
}