{
    "table": "products",
    "primary_key": "product_id",
    "filename": "restaurant_products",
    "columns": [
      "product_id",
      "name",
      "description",
      "price",
      "quantity",
      "barcode",
      "brand",
      "product_number",
      "category_id",
      "tax_rates"
    ],
    "field_mappings": {
      "Product ID": "product_id",
      "Name": "name",
      "Description": "description",
      "Price": "price",
      "Quantity": "quantity",
      "Barcode": "barcode",
      "Brand": "brand",
      "Product Number": "product_number",
      "Category": "category_id",
      "VAT Rate": {"column": "tax_rates", "json_field": "vat"},
      "STT Rate": {"column": "tax_rates", "json_field": "stt"}
    },
    "field_labels": {
      "product_id": "Product ID",
      "name": "Name",
      "description": "Description",
      "price": "Price",
      "quantity": "Quantity",
      "barcode": "Barcode",
      "brand": "Brand",
      "product_number": "Product Number"
    },
    "transforms": {
      "price": {
        "type": "number",
        "decimals": 2
      },
      "quantity": {
        "type": "number",
        "decimals": 0
      },
      "category_id": {
        "type": "lookup",
        "table": "product_categories",
        "key_column": "name",
        "value_column": "category_id"
      }
    },
    "export_transforms": {
      "price": {
        "type": "number",
        "decimals": 2
      },
      "category_id": {
        "type": "lookup",
        "table": "product_categories",
        "key_column": "category_id",
        "display_column": "name"
      }
    },
    "validations": {
      "name": {
        "required": true,
        "max_length": 255
      }
    },
    "unique_fields": ["barcode"],
    "update_existing": true,
    "filters": {
      "isDeleted": false
    }
  }