Love Istanbul

Database Schema

Complete visualization of Istanbul Explorer's SEO-optimized database structure

15 Tables
4 Categories
SEO Optimized
Universal Relations
Activities
2 Tables

activities, activity_schedules

Restaurants
2 Tables

restaurants, restaurant_menus

Hotels
2 Tables

hotels, hotel_rooms

Shopping
2 Tables

shopping_venues, shopping_products

Universal Tables
Polymorphic tables that work across all categories for maximum efficiency

Content Management

  • • universal_media
  • • universal_reviews
  • • visitor_guides

Analytics & SEO

  • • universal_insights
  • • universal_nearby_recommendations
  • • api_usage_tracking

Automation

  • • automation_logs
  • • categories
  • • SEO schema fields
Database Architecture Overview
Complete schema structure with SEO optimization and automation capabilities

Core Category Tables

🏛️activities
32 fields
Tourist attractions and experiences
SEO schema
Wikipedia integration
Multi-language
Accessibility info
🍽️restaurants
28 fields
Dining establishments and cuisine
Menu management
Dietary options
Price ranges
Booking integration
🏨hotels
30 fields
Accommodation options
Room types
Amenities
Star ratings
View categories
🛍️shopping_venues
25 fields
Markets, bazaars, and stores
Bargaining tips
Authenticity tracking
Product categories
Payment methods

Universal Tables (Polymorphic)

📸universal_media
18 fields
Images, videos, and social content for all entities
Works with: All categories
⭐universal_reviews
22 fields
Reviews and ratings from all platforms
Works with: All categories
📊universal_insights
20 fields
Analytics and automation data
Works with: All categories
🎯universal_nearby_recommendations
19 fields
Smart cross-category suggestions
Works with: All categories

Automation & Management Tables

📋visitor_guides
25
Top 10 lists and curated content
Auto-generation
SEO optimization
Multi-audience
📡api_usage_tracking
12
Monitor free API usage and limits
Rate limiting
Cost tracking
Error monitoring
⚙️automation_logs
16
Track all automated processes
Performance metrics
Error tracking
Quality scoring
Key Architecture Features

SEO Optimization

  • • JSON-LD schema fields
  • • Meta tags management
  • • FAQ data storage
  • • Keyword tracking

Automation Ready

  • • Data source tracking
  • • Confidence scoring
  • • API usage monitoring
  • • Quality validation

Scalable Design

  • • Universal relationships
  • • Polymorphic tables
  • • Indexed for performance
  • • RLS security