jef-fulfillment-associate-orders

Source

• Repository: jef-systems/jef-fulfillment-associate-backend

• Table: jef-fulfillment-associate-orders

• Schema path: dynamodb/jef-fulfillment-associate-orders/schema.json

• Commit: 5e7e5672c9abaf5188ec498b5d76603c6a221bc2

• Generated at: 2026-04-23T20:01:31Z

Attributes

{
  "pk": "string-{id}",
  "gsi_1_pk": "string-{status}",
  "gsi_1_sk": "string-{createdAt}",
  "id": "string-order-number-{8-digits}",
  "customer": "string",
  "channel": "string",
  "createdAt": "string-datetime",
  "status": "string-enum-pending|in_progress|fulfilled|packed|ready_for_pickup|ready_for_delivery|completed",
  "items": [
    {
      "id": "string-{order_item_id}",
      "name": "string",
      "barcode": "string",
      "quantity": "number-integer",
      "fulfilled": "number-integer",
      "price": "number-two-decimals"
    }
  ],
  "fulfilled_at": "string-iso8601|null",
  "fulfilled_by": "string|null",
  "packed_at": "string-iso8601|null",
  "packed_by": "string|null",
  "completed_at": "string-iso8601|null",
  "completed_by": "string|null",
  "handoff_type": "string-enum-pickup|delivery|store_transfer|null",
  "notes": "string",
  "source_store_pk": "string|null",
  "destination_store_pk": "string|null",
  "assigned_associate_pk": "string|null",
  "total_lines": "number-integer",
  "total_quantity": "number-integer",
  "total_fulfilled_quantity": "number-integer",
  "total_amount": "number-two-decimals",
  "created_at": "string-iso8601",
  "updated_at": "string-iso8601",
  "local_version": "number-integer",
  "sync_status": "string-enum-local_only|dirty|synced|sync_error",
  "deleted_at": "string-iso8601|null",
  "idempotency_key": "string-uuidv4"
}

Main Index

{
  "pk": "pk"
}

Raw Schema

{
  "table": "jef-fulfillment-associate-orders",
  "attributes": {
    "pk": "string-{id}",
    "gsi_1_pk": "string-{status}",
    "gsi_1_sk": "string-{createdAt}",
    "id": "string-order-number-{8-digits}",
    "customer": "string",
    "channel": "string",
    "createdAt": "string-datetime",
    "status": "string-enum-pending|in_progress|fulfilled|packed|ready_for_pickup|ready_for_delivery|completed",
    "items": [
      {
        "id": "string-{order_item_id}",
        "name": "string",
        "barcode": "string",
        "quantity": "number-integer",
        "fulfilled": "number-integer",
        "price": "number-two-decimals"
      }
    ],
    "fulfilled_at": "string-iso8601|null",
    "fulfilled_by": "string|null",
    "packed_at": "string-iso8601|null",
    "packed_by": "string|null",
    "completed_at": "string-iso8601|null",
    "completed_by": "string|null",
    "handoff_type": "string-enum-pickup|delivery|store_transfer|null",
    "notes": "string",
    "source_store_pk": "string|null",
    "destination_store_pk": "string|null",
    "assigned_associate_pk": "string|null",
    "total_lines": "number-integer",
    "total_quantity": "number-integer",
    "total_fulfilled_quantity": "number-integer",
    "total_amount": "number-two-decimals",
    "created_at": "string-iso8601",
    "updated_at": "string-iso8601",
    "local_version": "number-integer",
    "sync_status": "string-enum-local_only|dirty|synced|sync_error",
    "deleted_at": "string-iso8601|null",
    "idempotency_key": "string-uuidv4"
  },
  "main_index": {
    "pk": "pk"
  },
  "gsi_1": {
    "pk": "gsi_1_pk",
    "sk": "gsi_1_sk"
  }
}