scrapper

Tables (3)

categories (Untitled)

  • id (Key) — VARCHAR(50) — Primary key — NOT NULL
  • category_name (Field) — VARCHAR(50)
  • ancestor_id (Key2) — VARCHAR(50) — Foreign key → categories.id — NOT NULL

media (Untitled3)

  • id (Key) — VARCHAR(50) — Primary key — NOT NULL
  • original_uri (Field3) — VARCHAR(500) — Primary key
  • file_path (Field) — VARCHAR(500)
  • media_type (Field2) — VARCHAR(10)

pages (Untitled2)

  • id (Key) — VARCHAR(50) — Primary key — NOT NULL
  • scrapped_date (Field) — DATE
  • title (Field2) — VARCHAR(500)
  • original_url (Field3) — VARCHAR(500)
  • Field4