Transaction Model

{
  "type": "object",
  "required": ["transaction_id", "shop_id", "region", "savings", "amount"],
  "properties": {
    "transaction_id": {
      "type": "string",
      "format": "uuid",
      "description": "Unique identifier for the transaction"
    },
    "student_id": {
      "type": "string",
      "format": "uuid",
      "nullable": true,
      "description": "ID of the student making the purchase"
    },
    "shop_id": {
      "type": "string",
      "format": "uuid",
      "description": "ID of the shop where the transaction occurred (must reference an existing shop)"
    },
    "offer_id": {
      "type": "string",
      "format": "uuid",
      "nullable": true,
      "description": "ID of the offer used"
    },
    "branch_id": {
      "type": "string",
      "format": "uuid",
      "nullable": true,
      "description": "ID of the branch location"
    },
    "region": {
      "type": "string",
      "description": "Geographic region of the transaction (2-letter country code, ISO 3166-1 alpha-2)"
    },
    "source": {
      "type": "string",
      "nullable": true,
      "description": "Source of the transaction (e.g., 'online', 'in-store')"
    },
    "savings": {
      "type": "number",
      "format": "float",
      "description": "Amount saved in the transaction (must be a non-negative number)"
    },
    "amount": {
      "type": "number",
      "format": "float",
      "description": "Total transaction amount (must be a positive number)"
    },
    "created": {
      "type": "string",
      "format": "date-time",
      "nullable": true,
      "description": "Timestamp when the record was created"
    },
    "updated": {
      "type": "string",
      "format": "date-time",
      "nullable": true,
      "description": "Timestamp when the record was last updated"
    },
    "is_deleted": {
      "type": "boolean",
      "nullable": true,
      "description": "Flag indicating if the record is marked as deleted"
    },
    "discount_name": {
      "type": "string",
      "nullable": true,
      "description": "Name of the discount applied"
    },
    "discount_type": {
      "type": "string",
      "nullable": true,
      "description": "Type of discount (e.g., 'percentage', 'fixed')"
    },
    "discount_value": {
      "type": "number",
      "format": "float",
      "nullable": true,
      "description": "Value of the discount"
    }
  }
}

{
  "transaction_id": "550e8400-e29b-41d4-a716-446655440000",
  "student_id": "550e8400-e29b-41d4-a716-446655440001",
  "shop_id": "550e8400-e29b-41d4-a716-446655440002",
  "offer_id": "550e8400-e29b-41d4-a716-446655440003",
  "branch_id": "550e8400-e29b-41d4-a716-446655440004",
  "region": "CA",
  "source": "online",
  "savings": 10.5,
  "amount": 100.0,
  "created": "2023-01-15T14:30:00Z",
  "updated": "2023-06-22T09:15:30Z",
  "is_deleted": false,
  "discount_name": "Student Discount",
  "discount_type": "percentage",
  "discount_value": 10
}