outbox db schema

outbox.js

const subscriptionEvent = new mongoose.Schema({
  martechId: {
    type: String,
    required: true,
  },
  subscriptionId: {
    type: String,
    required: true,
  },
  clientId: {
    type: String,
    required: true,
  },
  expiresAt: {
    type: String,
    required: true,
  },
  eventType: {
    type: String,
    required: true,
  },
  offerId: {
    type: String,
    required: true,
  },
  productIds: {
    type: Array,
    required: true,
  },
  provider: {
    type: String,
    required: true,
  },
  timestamp: {
    type: String,
    required: true,
  },
  location: {
    type: String,
    required: true,
  },
  price: {
    type: Number,
    required: true,
  },
  currencyCode: {
    type: String,
    required: true,
  },
  cancelReason: {
    type: String,
  },
  paymentState: {
    type: String,
  },
  pushedOn: {
    type: Date,
    default: null,
  },
});
subscriptionEvent.index({ subscriptionId: 1 });