Database Status
🗄️
Click "Refresh Status" to check database connection
Database Schema
📦 Products Table
- • entity_id (BigCommerce product ID)
- • name, sku, price, categories
- • description, brand_name
- • sync timestamps and source
🐟 Species Status Table
- • product_id reference
- • status (no-file, created, errored)
- • generation counts and timestamps
- • error tracking and file paths
🔔 Notifications Table
- • notification_id, type, priority
- • title, message, source
- • read status and timestamps
- • JSON data and actions
📝 Change Log Table
- • product_id reference
- • field_name, old_value, new_value
- • change timestamps
- • detected_by tracking
Database Benefits
⚡
Faster Performance
Local caching reduces API calls and improves response times
📊
Analytics & Insights
Track generation success rates and identify patterns
🔔
Change Tracking
Automatically detect product changes and notify users