Database Designer

{
  "queries": [
    {
      "id": "user_login",
      "type": "SELECT",
      "table": "users",
      "description": "User authentication lookup by email",
      "where_conditions": [
        {
          "column": "email",
          "operator": "=",
          "selectivity": 0.95
        }
      ],
      "join_conditions": [],
      "order_by": [],
      "group_by": [],
      "frequency": 5000,
      "avg_execution_time_ms": 2.5
    },
    {
      "id": "product_search_category",
      "type": "SELECT",
      "table": "products",
      "description": "Product search within category with pagination",
      "where_conditions": [
        {
          "column": "category_id",
          "operator": "=",
          "selectivity": 0.2
        },
        {
          "column": "is_active",
          "operator": "=",
          "selectivity": 0.1
        }
      ],
      "join_conditions": [],
      "order_by": [
        {"column": "created_at", "direction": "DESC"}
      ],
      "group_by": [],
      "frequency": 2500,
      "avg_execution_time_ms": 15.2
    },
    {
      "id": "product_search_price_range",
      "type": "SELECT",
      "table": "products",
      "description": "Product search by price range and brand",
      "where_conditions": [
        {
          "column": "price",
          "operator": "BETWEEN",
          "selectivity": 0.3
        },
        {
          "column": "brand",
          "operator": "=",
          "selectivity": 0.05
        },
        {
          "column": "is_active",
          "operator": "=",
          "selectivity": 0.1
        }
      ],
      "join_conditions": [],
      "order_by": [
        {"column": "price", "direction": "ASC"}
      ],
      "group_by": [],
      "frequency": 800,
      "avg_execution_time_ms": 25.7
    },
    {
      "id": "user_orders_history",
      "type": "SELECT",
      "table": "orders",
      "description": "User order history with pagination",
      "where_conditions": [
        {
          "column": "user_id",
          "operator": "=",
          "selectivity": 0.8
        }
      ],
      "join_conditions": [],
      "order_by": [
        {"column": "created_at", "direction": "DESC"}
      ],
      "group_by": [],
      "frequency": 1200,
      "avg_execution_time_ms": 8.3
    },
    {
      "id": "order_details_with_items",
      "type": "SELECT",
      "table": "orders",
      "description": "Order details with order items (JOIN query)",
      "where_conditions": [
        {
          "column": "id",
          "operator": "=",
          "selectivity": 1.0
        }
      ],
      "join_conditions": [
        {
          "local_column": "id",
          "foreign_table": "order_items",
          "foreign_column": "order_id",
          "join_type": "INNER"
        }
      ],
      "order_by": [],
      "group_by": [],
      "frequency": 3000,
      "avg_execution_time_ms": 12.1
    },
    {
      "id": "pending_orders_processing",
      "type": "SELECT",
      "table": "orders",
      "description": "Processing queue - pending orders by date",
      "where_conditions": [
        {
          "column": "status",
          "operator": "=",
          "selectivity": 0.15
        },
        {
          "column": "created_at",
          "operator": ">=",
          "selectivity": 0.3
        }
      ],
      "join_conditions": [],
      "order_by": [
        {"column": "created_at", "direction": "ASC"}
      ],
      "group_by": [],
      "frequency": 150,
      "avg_execution_time_ms": 45.2
    },
    {
      "id": "user_orders_by_status",
      "type": "SELECT",
      "table": "orders",
      "description": "User orders filtered by status",
      "where_conditions": [
        {
          "column": "user_id",
          "operator": "=",
          "selectivity": 0.8
        },
        {
          "column": "status",
          "operator": "IN",
          "selectivity": 0.4
        }
      ],
      "join_conditions": [],
      "order_by": [
        {"column": "created_at", "d