jef-store-orders

Source

• Repository: jef-systems/jef-store-backend

• Table: jef-store-orders

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

• Commit: 99b0887e35e946655c1cd3b2fc261423c6ac470e

• Generated at: 2026-04-29T12:13:10Z

Attributes

{
  "order_number": "string",
  "cart_id": "string",
  "entity_number": "string",
  "employee_number": "string",
  "customer": "string",
  "buyer_name": "string",
  "buyer_phone": "string",
  "channel": "string",
  "source": "string",
  "status": "string",
  "payment_status": "string",
  "payment_method": "string",
  "payment_reference": "string",
  "items": [
    {
      "id": "string",
      "jsin": "string",
      "barcode": "string",
      "name": "string",
      "category": "string",
      "unit_label": "string",
      "quantity": "number",
      "price": "number",
      "line_total": "number"
    }
  ],
  "total_lines": "number",
  "total_quantity": "number",
  "subtotal": "number",
  "discount": "number",
  "shipping_fee": "number",
  "grand_total": "number",
  "total_amount": "number",
  "amount_paid": "number",
  "delivery_mode": "string",
  "delivery_address": "string",
  "notes": "string",
  "paid_at": "string",
  "cancelled_at": "string",
  "receipt_printed_at": "string",
  "created_at": "string",
  "updated_at": "string",
  "local_version": "number",
  "sync_status": "string",
  "deleted_at": "string",
  "idempotency_key": "string"
}

Main Index

{
  "pk": "order_number"
}

Raw Schema

{
  "table": "jef-store-orders",
  "attributes": {
    "order_number": "string",
    "cart_id": "string",
    "entity_number": "string",
    "employee_number": "string",
    "customer": "string",
    "buyer_name": "string",
    "buyer_phone": "string",
    "channel": "string",
    "source": "string",
    "status": "string",
    "payment_status": "string",
    "payment_method": "string",
    "payment_reference": "string",
    "items": [
      {
        "id": "string",
        "jsin": "string",
        "barcode": "string",
        "name": "string",
        "category": "string",
        "unit_label": "string",
        "quantity": "number",
        "price": "number",
        "line_total": "number"
      }
    ],
    "total_lines": "number",
    "total_quantity": "number",
    "subtotal": "number",
    "discount": "number",
    "shipping_fee": "number",
    "grand_total": "number",
    "total_amount": "number",
    "amount_paid": "number",
    "delivery_mode": "string",
    "delivery_address": "string",
    "notes": "string",
    "paid_at": "string",
    "cancelled_at": "string",
    "receipt_printed_at": "string",
    "created_at": "string",
    "updated_at": "string",
    "local_version": "number",
    "sync_status": "string",
    "deleted_at": "string",
    "idempotency_key": "string"
  },
  "main_index": {
    "pk": "order_number"
  },
  "gsi_1": {
    "gsi_1_pk": "status",
    "gsi_1_sk": "created_at"
  }
}