schema.graphql

# Mirrors the Request struct in Cooler.sol
type CoolerLoanRequest @entity {
  id: String! # cooler-requestId
  createdBlock: BigInt!
  createdTimestamp: BigInt!
  createdTransaction: Bytes!
  cooler: Bytes! # address
  requestId: BigInt! # uint256
  borrower: Bytes! # address
  collateralToken: Bytes! # address
  debtToken: Bytes! # address
  amount: BigDecimal! # amount to be borrowed
  interestPercentage: BigDecimal! # annualized percentage to be paid as interest. Represented as a decimal, e.g. 0.1 = 10%
  loanToCollateralRatio: BigDecimal! # ratio of the quantity of debt token to 1 collateral token, e.g. 3000 DAI/gOHM
  durationSeconds: BigInt! # duration of loan in seconds
  isRescinded: Boolean!
  # Related records
  requestEvents: [RequestLoanEvent!]! @derivedFrom(field: "request")
  rescindEvents: [RescindLoanRequestEvent!]! @derivedFrom(field: "request")
  clearEvents: [ClearLoanRequestEvent!]! @derivedFrom(field: "request")
  loans: [CoolerLoan!]! @derivedFrom(field: "request")
}

# Mirrors the Loan struct in Cooler.sol
type CoolerLoan @entity(immutable: true) {
  id: String! # cooler-loanId
  createdBlock: BigInt!
  createdTimestamp: BigInt!
  createdTransaction: Bytes!
  cooler: Bytes! # address
  request: CoolerLoanRequest! # request that created this loan
  loanId: BigInt! # uint256
  borrower: Bytes! # address
  lender: Bytes! # address
  interest: BigDecimal!
  principal: BigDecimal!
  collateral: BigDecimal!
  expiryTimestamp: BigInt!
  hasCallback: Boolean!
  collateralToken: Bytes! # address
  debtToken: Bytes! # address
  # Related records
  creationEvents: [ClearLoanRequestEvent!]! @derivedFrom(field: "loan")
  defaultedClaimEvents: [ClaimDefaultedLoanEvent!]! @derivedFrom(field: "loan")
  repaymentEvents: [RepayLoanEvent!]! @derivedFrom(field: "loan")
  extendEvents: [ExtendLoanEvent!]! @derivedFrom(field: "loan")
}

type ClearinghouseSnapshot @entity {
  id: String! # address-blockNumber-log
  date: String! # YYYY-MM-DD
  blockNumber: BigInt!
  blockTimestamp: BigInt!
  clearinghouse: Bytes! # address
  # Configuration
  coolerFactoryAddress: Bytes!
  collateralAddress: Bytes!
  debtAddress: Bytes!
  # State information
  isActive: Boolean!
  nextRebalanceTimestamp: BigInt!
  interestReceivables: BigDecimal!
  principalReceivables: BigDecimal!
  # Terms
  interestRate: BigDecimal! # Annual interest rate. 0.1 = 10%
  duration: BigInt! # Duration of loans in seconds
  fundCadence: BigInt! # Frequency of rebalances in seconds
  fundAmount: BigDecimal! # Amount of DAI required to be in the clearinghouse
  loanToCollateral: BigDecimal! # Amount of the debt token per collateral token
  # Clearinghouse Capacity
  daiBalance: BigDecimal!
  sDaiBalance: BigDecimal!
  sDaiInDaiBalance: BigDecimal!
  # Treasury Capacity
  treasuryDaiBalance: BigDecimal!
  treasurySDaiBalance: BigDecimal!
  treasurySDaiInDaiBalance: BigDecimal!
  # Related records
  rebalanceEvents: [RebalanceEvent!]! @derivedFrom(field: "clearinghouseSnapshot")
  defundEvents: [DefundEvent!]! @derivedFrom(field: "clearinghouseSnapshot")
}

### Clearinghouse Events

type RebalanceEvent @entity(immutable: true) {
  id: String! # clearinghouse-blockNumber
  date: String! # YYYY-MM-DD
  blockNumber: BigInt!
  blockTimestamp: BigInt!
  transactionHash: Bytes!
  clearinghouse: Bytes! # address
  clearinghouseSnapshot: ClearinghouseSnapshot!
  # State information
  amount: BigDecimal! # Amount of DAI in (positive)/out (negative) of the clearinghouse
}

type DefundEvent @entity(immutable: true) {
  id: String! # clearinghouse-blockNumber
  date: String! # YYYY-MM-DD
  blockNumber: BigInt!
  blockTimestamp: BigInt!
  transactionHash: Bytes!
  clearinghouse: Bytes! # address
  clearinghouseSnapshot: ClearinghouseSnapshot!
  # State information
  amount: BigDecimal! # Amount of DAI out (negative) of the clearinghouse
}

### Loan Events

type RequestLoanEvent @entity(immutable: true) {
  # Context
  id: String! # cooler-requestId
  date: String! # YYYY-MM-DD
  blockNumber: BigInt!
  blockTimestamp: BigInt!
  transactionHash: Bytes!
  request: CoolerLoanRequest!
}

type RescindLoanRequestEvent @entity(immutable: true) {
  # Context
  id: String! # cooler-requestId
  date: String! # YYYY-MM-DD
  blockNumber: BigInt!
  blockTimestamp: BigInt!
  transactionHash: Bytes!
  request: CoolerLoanRequest!
}

type ClearLoanRequestEvent @entity(immutable: true) {
  # Context
  id: String! # cooler-requestId
  date: String! # YYYY-MM-DD
  blockNumber: BigInt!
  blockTimestamp: BigInt!
  transactionHash: Bytes!
  # Event information
  request: CoolerLoanRequest!
  # Loan state
  loan: CoolerLoan!
  # Clearinghouse Capacity
  clearinghouseDaiBalance: BigDecimal!
  clearinghouseSDaiBalance: BigDecimal!
  clearinghouseSDaiInDaiBalance: BigDecimal!
  # Treasury Capacity
  treasuryDaiBalance: BigDecimal!
  treasurySDaiBalance: BigDecimal!
  treasurySDaiInDaiBalance: BigDecimal!
}

type ClaimDefaultedLoanEvent @entity(immutable: true) {
  # Context
  id: String! # cooler-loanId
  date: String! # YYYY-MM-DD
  blockNumber: BigInt!
  blockTimestamp: BigInt!
  transactionHash: Bytes!
  # Income
  collateralQuantityClaimed: BigDecimal!
  collateralPrice: BigDecimal!
  collateralValueClaimed: BigDecimal!
  # Loan state
  loan: CoolerLoan!
  secondsSinceExpiry: BigInt!
}

type RepayLoanEvent @entity(immutable: true) {
  # Context
  id: String! # cooler-loanId-blockNumber
  date: String! # YYYY-MM-DD
  blockNumber: BigInt!
  blockTimestamp: BigInt!
  transactionHash: Bytes!
  # Event information
  amountPaid: BigDecimal!
  # Loan state
  loan: CoolerLoan!
  secondsToExpiry: BigInt!
  principalPayable: BigDecimal!
  interestPayable: BigDecimal!
  collateralDeposited: BigDecimal!
  # Clearinghouse Capacity
  clearinghouseDaiBalance: BigDecimal!
  clearinghouseSDaiBalance: BigDecimal!
  clearinghouseSDaiInDaiBalance: BigDecimal!
  # Treasury Capacity
  treasuryDaiBalance: BigDecimal!
  treasurySDaiBalance: BigDecimal!
  treasurySDaiInDaiBalance: BigDecimal!
}

type ExtendLoanEvent @entity(immutable: true) {
  # Context
  id: String! # cooler-loanId-blockNumber
  date: String! # YYYY-MM-DD
  blockNumber: BigInt!
  blockTimestamp: BigInt!
  transactionHash: Bytes!
  # Event information
  periods: Int! # Number of duration periods the loan has been extended for
  # Loan information
  loan: CoolerLoan!
  # The new expiry timestamp
  expiryTimestamp: BigInt!
  interestDue: BigDecimal!
  # Clearinghouse Capacity
  clearinghouseDaiBalance: BigDecimal!
  clearinghouseSDaiBalance: BigDecimal!
  clearinghouseSDaiInDaiBalance: BigDecimal!
  # Treasury Capacity
  treasuryDaiBalance: BigDecimal!
  treasurySDaiBalance: BigDecimal!
  treasurySDaiInDaiBalance: BigDecimal!
}