undefined

undefined

undefined

[
  {
    "id": "user_123",
    "partitionKey": "user_123",
    "type": "user",
    "name": "John Doe",
    "email": "john@example.com"
  },
  {
    "id": "order_456", 
    "partitionKey": "user_123",
    "type": "order",
    "userId": "user_123",
    "amount": 99.99
  }
]

undefined

// Users container
{ "id": "user_123", "partitionKey": "user_123", "profileId": "profile_456" }
// Profiles container  
{ "id": "profile_456", "partitionKey": "profile_456", "userId": "user_123" }

// Orders container with user_id as partition key
{ "id": "order_789", "partitionKey": "user_123", "type": "order" }
// Find orders for user: SELECT * FROM c WHERE c.partitionKey = "user_123" AND c.type = "order"

// UserCourses container
{ "id": "user_123_course_ABC", "partitionKey": "user_123", "userId": "user_123", "courseId": "ABC" }
{ "id": "course_ABC_user_123", "partitionKey": "course_ABC", "userId": "user_123", "courseId": "ABC" }

// Orders document
{ 
  "id": "order_789", 
  "partitionKey": "user_123", 
  "customerId": "user_123", 
  "customerName": "John Doe" // Include customer name to avoid lookup
}

{
  "id": "chunk_001",
  "partitionKey": "account_test_chunk_001", 
  "chunkId": 1,
  "records": [
    { "recordId": 1, "data": "..." },
    { "recordId": 2, "data": "..." }
    // ... 98 more records
  ],
  "chunkSize": 100
}

[
  {
    "id": "user_123",
    "partitionKey": "user_123", 
    "type": "user",
    "name": "John Doe",
    "email": "john@example.com"
  },
  {
    "id": "order_456",
    "partitionKey": "user_123",
    "type": "order", 
    "userId": "user_123",
    "amount": 99.99
  }
]

[
  {
    "id": "student_123",
    "partitionKey": "student_123",
    "type": "student"
  },
  {
    "id": "course_456", 
    "partitionKey": "student_123",
    "type": "course",
    "courseId": "course_456"
  },
  {
    "id": "lesson_789",
    "partitionKey": "student_123", 
    "type": "lesson",
    "courseId": "course_456",
    "lessonId": "lesson_789"
  }
]

{
  "id": "record_123",
  "partitionKey": "tenant_456_customer_789", 
  "tenantId": "tenant_456",
  "customerId": "customer_789"
}

{
  "indexingPolicy": {
    "includedPaths": [
      { "path": "/name/*" },
      { "path": "/category/*" },
      { "path": "/sale_price/*" }
    ],
    "excludedPaths": [
      { "path": "/*" }
    ]
  }
}

// Stored procedure for creating user with unique email
function createUserWithUniqueEmail(userData) {
    var context = getContext();
    var container = context.getCollection();
    
    // Check if email already exists
    var query = `SELECT * FROM c WHERE c.email = "${userData.email}"`;
    
    var isAccepted = container.queryDocuments(
        container.getSelfLink(),
        query,
        function(err, documents) {
            if (err) throw new Error('Error querying documents: ' + err.message);
            
            if (documents.length > 0) {
                throw new Error('Email already exists');
            }
            
            // Email is unique, create the user
            var isAccepted = container.createDocument(
                container.getSelfLink(),
                userData,
                function(err, document) {
                    if (err) throw new Error('Error creating document: ' + err.message);
                    context.getResponse().setBody(document);
                }
            );
            
            if (!isAccepted) throw new Error('The query was not accepted by the server.');
        }
    );
    
    if (!isAccepted) throw new Error('The query was not accepted by the server.');
}

{
  "partitionKey": "account_123_test_456_chunk_001" // Synthetic composite
}

{
  "partitionKey": {
    "version": 2,
    "kind": "MultiHash", 
    "paths": ["/accountId", "/testId", "/chunkId"]
  }
}

// Hash-based sharding
partitionKey = originalKey + "_" + (hash(identifier) % shardCount)

// Time-based sharding  
partitionKey = originalKey + "_" + (currentHour % shardCount)

{
  "id": "sess_abc123",
  "partitionKey": "user_456",
  "userId": "user_456", 
  "createdAt": "2024-01-01T12:00:00Z",
  "ttl": 86400
}

{
  "defaultTtl": -1,  // Enable TTL, no default expiration
}