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