ponder.schema.ts

import { createSchema } from "@ponder/core"

export default createSchema((p) => ({
  Slicer: p.createTable(
    {
      id: p.bigint(),

      // Values
      name: p.string().optional(),

      slicerVersion: p.bigint(),
      address: p.hex(),
      slices: p.bigint(),
      minimumSlices: p.bigint(),
      createdAtTimestamp: p.bigint(),
      releaseTimelock: p.bigint(),
      transferableTimelock: p.int(),
      protocolFee: p.int(),
      royaltyPercentage: p.int(),
      productsModuleBalance: p.bigint(),
      productsModuleReleased: p.bigint(),
      referralFeeStore: p.bigint(),
      isImmutable: p.boolean(),
      currenciesControlled: p.boolean(),
      productsControlled: p.boolean(),
      resliceAllowed: p.boolean(),
      transferWhileControlledAllowed: p.boolean(),
      acceptsAllCurrencies: p.boolean(),
      storeClosed: p.boolean(),

      // Relations
      creatorId: p.hex().references("Payee.id"),
      creator: p.one("creatorId"),

      controllerId: p.hex().references("Payee.id"),
      controller: p.one("controllerId"),

      royaltyReceiverId: p.hex().references("Payee.id"),
      royaltyReceiver: p.one("royaltyReceiverId"),

      payees: p.many("PayeeSlicer.slicerId"),
      products: p.many("Product.slicerId"),
      acceptedCurrencies: p.many("CurrencySlicer.slicerId"),
      orderSlicers: p.many("OrderSlicer.slicerId"),
      childrenSlicers: p.many("SlicerRelation.parentSlicerId"),
      parentSlicers: p.many("SlicerRelation.childSlicerId")
    },
    {
      slicerAddress: p.index("address")
    }
  ),

  SlicerRelation: p.createTable({
    id: p.string(), //
    parentSlicerId: p.bigint().references("Slicer.id"),
    parentSlicer: p.one("parentSlicerId"),
    childSlicerId: p.bigint().references("Slicer.id"),
    childSlicer: p.one("childSlicerId")
  }),

  Payee: p.createTable({
    id: p.hex(),

    // Relations
    slicersOwned: p.many("PayeeSlicer.payeeId"),
    slicersCreated: p.many("Slicer.creatorId"),
    slicersControlled: p.many("Slicer.controllerId"),
    slicersRoyaltyReceiver: p.many("Slicer.royaltyReceiverId"),
    currencies: p.many("PayeeCurrency.payeeId"),
    ordersMade: p.many("Order.buyerId"),
    ordersPaid: p.many("Order.payerId"),
    ordersReferred: p.many("Order.referrerId")
  }),

  PayeeSlicer: p.createTable({
    id: p.string(), //
    payeeId: p.hex().references("Payee.id"),
    payee: p.one("payeeId"),
    slicerId: p.bigint().references("Slicer.id"),
    slicer: p.one("slicerId"),

    // Values
    slices: p.bigint(),
    transfersAllowedWhileLocked: p.boolean(),

    // Relations
    currencyPayments: p.many("PayeeSlicerCurrency.payeeSlicerId"),
    orderSlicers: p.many("OrderSlicer.buyerSlicerId")
  }),

  Currency: p.createTable({
    id: p.hex(),

    // Relations
    slicers: p.many("CurrencySlicer.currencyId"),
    payees: p.many("PayeeCurrency.currencyId"),
    products: p.many("ProductPrice.currencyId"),
    orderProducts: p.many("OrderProduct.currencyId")
  }),

  CurrencySlicer: p.createTable({
    id: p.string(), //
    currencyId: p.hex().references("Currency.id"),
    currency: p.one("currencyId"),
    slicerId: p.bigint().references("Slicer.id"),
    slicer: p.one("slicerId"),

    // Values
    released: p.bigint(),
    releasedToProtocol: p.bigint(),
    creatorFeePaid: p.bigint(),
    referralFeePaid: p.bigint(),

    // Relations
    payeePayments: p.many("PayeeSlicerCurrency.currencySlicerId"),
    releaseEvents: p.many("ReleaseEvent.currencySlicerId")
  }),

  PayeeCurrency: p.createTable({
    id: p.string(), //
    payeeId: p.hex().references("Payee.id"),
    payee: p.one("payeeId"),
    currencyId: p.hex().references("Currency.id"),
    currency: p.one("currencyId"),

    // Values
    toWithdraw: p.bigint(),
    toPayToProtocol: p.bigint(),
    withdrawn: p.bigint(),
    paidToProtocol: p.bigint(),
    totalCreatorFees: p.bigint(),
    totalReferralFees: p.bigint(),

    // Relations
    slicerPayments: p.many("PayeeSlicerCurrency.payeeCurrencyId")
  }),

  PayeeSlicerCurrency: p.createTable({
    id: p.string(), //
    payeeSlicerId: p.string().references("PayeeSlicer.id"),
    payeeSlicer: p.one("payeeSlicerId"),
    currencySlicerId: p.string().references("CurrencySlicer.id"),
    currencySlicer: p.one("currencySlicerId"),
    payeeCurrencyId: p.string().references("PayeeCurrency.id"),
    payeeCurrency: p.one("payeeCurrencyId"),

    // Values
    paidForProducts: p.bigint()
  }),

  ReleaseEvent: p.createTable({
    id: p.string(), //

    // Values
    amountReleased: p.bigint(),
    timestamp: p.bigint(),

    // Relations
    slicerId: p.bigint().references("Slicer.id"),
    slicer: p.one("slicerId"),

    currencyId: p.hex().references("Currency.id"),
    currency: p.one("currencyId"),

    payeeId: p.hex().references("Payee.id"),
    payee: p.one("payeeId"),

    currencySlicerId: p.string().references("CurrencySlicer.id"),
    currencySlicer: p.one("currencySlicerId")
  }),

  Product: p.createTable({
    id: p.string(),

    // Values
    isRemoved: p.boolean(),
    isFree: p.boolean(),
    isInfinite: p.boolean(),
    availableUnits: p.bigint(),
    maxUnitsPerBuyer: p.int(),
    creator: p.hex(),
    data: p.hex(),
    createdAtTimestamp: p.bigint(),
    extAddress: p.hex().optional(),
    extValue: p.bigint().optional(),
    extCheckSig: p.hex().optional(),
    extExecSig: p.hex().optional(),
    extData: p.hex().optional(),
    extRelativePrice: p.boolean(),
    extPreferredToken: p.boolean(),
    totalPurchases: p.bigint(),
    referralFeeProduct: p.bigint(),
    lastPurchasedAtTimestamp: p.bigint().optional(),

    // Relations
    slicerId: p.bigint().references("Slicer.id"),
    slicer: p.one("slicerId"),

    categoryId: p.bigint().references("CategoryProduct.id"),
    category: p.one("categoryId"),

    orderProducts: p.many("OrderProduct.productId"),
    prices: p.many("ProductPrice.productId"),
    subProducts: p.many("ProductRelation.parentProductId"),
    parentProducts: p.many("ProductRelation.childProductId")
  }),

  CategoryProduct: p.createTable({
    id: p.bigint(),

    // Values
    name: p.string(),

    // Relations
    products: p.many("Product.categoryId")
  }),

  ProductRelation: p.createTable({
    id: p.string(), //
    parentProductId: p.string().references("Product.id"),
    parentProduct: p.one("parentProductId"),
    childProductId: p.string().references("Product.id"),
    childProduct: p.one("childProductId")
  }),

  ProductPrice: p.createTable({
    id: p.string(), //
    productId: p.string().references("Product.id"),
    product: p.one("productId"),
    currencyId: p.hex().references("Currency.id"),
    currency: p.one("currencyId"),

    // Values
    price: p.bigint(),
    isPriceDynamic: p.boolean(),
    externalAddress: p.hex()
  }),

  Order: p.createTable({
    id: p.hex(),

    // Values
    timestamp: p.bigint(),
    totalPaymentEth: p.bigint(),
    totalPaymentCurrency: p.bigint(),
    totalReferralEth: p.bigint(),
    totalReferralCurrency: p.bigint(),

    // Relations
    payerId: p.hex().references("Payee.id"),
    payer: p.one("payerId"),

    buyerId: p.hex().references("Payee.id"),
    buyer: p.one("buyerId"),

    referrerId: p.hex().references("Payee.id"),
    referrer: p.one("referrerId"),

    orderSlicers: p.many("OrderSlicer.orderId"),
    orderProducts: p.many("OrderProduct.orderId"),
    extraCosts: p.many("ExtraCost.orderId")
  }),

  OrderSlicer: p.createTable({
    id: p.string(), //
    orderId: p.hex().references("Order.id"),
    order: p.one("orderId"),
    slicerId: p.bigint().references("Slicer.id"),
    slicer: p.one("slicerId"),

    // Relations
    buyerSlicerId: p.string().references("PayeeSlicer.id"),
    buyerSlicer: p.one("buyerSlicerId"),

    orderProducts: p.many("OrderProduct.orderSlicerId")
  }),

  OrderProduct: p.createTable({
    id: p.string(), //
    orderId: p.hex().references("Order.id"),
    order: p.one("orderId"),
    productId: p.string().references("Product.id"),
    product: p.one("productId"),

    // Values
    quantity: p.bigint(),
    paymentEth: p.bigint(),
    paymentCurrency: p.bigint(),
    externalPaymentEth: p.bigint(),
    externalPaymentCurrency: p.bigint(),
    referralEth: p.bigint(),
    referralCurrency: p.bigint(),

    // Relations
    orderSlicerId: p.string().references("OrderSlicer.id"),
    orderSlicer: p.one("orderSlicerId"),

    currencyId: p.hex().references("Currency.id"),
    currency: p.one("currencyId"),

    orderParentProducts: p.many("OrderProductRelation.orderSubProductId"),
    orderSubProducts: p.many("OrderProductRelation.orderParentProductId")
  }),

  OrderProductRelation: p.createTable({
    id: p.string(), //
    orderParentProductId: p.string().references("OrderProduct.id"),
    orderParentProduct: p.one("orderParentProductId"),
    orderSubProductId: p.string().references("OrderProduct.id"),
    orderSubProduct: p.one("orderSubProductId")
  }),

  ExtraCost: p.createTable({
    id: p.string(), //

    // Values
    recipient: p.hex().optional(),
    amount: p.bigint(),
    description: p.string(),

    // Relations
    orderId: p.hex().references("Order.id"),
    order: p.one("orderId"),

    currencyId: p.hex().references("Currency.id"),
    currency: p.one("currencyId"),

    slicerId: p.bigint().optional().references("Slicer.id"),
    slicer: p.one("slicerId")
  })
}))