schema.graphql

# Base entities
type Donation @entity(immutable: true) {
  id: Bytes!
  from: Account!
  to: Account!
  amount: BigInt!
  createdAtTimestamp: BigInt!
}

type Endorsement @entity(immutable: true) {
  id: Bytes!
  from: Account!
  to: Account!
  endorsementType: String!
  easUid: Bytes!
  donationAmount: BigInt!
  createdAtTimestamp: BigInt!
}

type Withdrawal @entity(immutable: true) {
  id: Bytes!
  address: Account!
  amount: BigInt!
  createdAtTimestamp: BigInt!
}

type FeeWithdrawal @entity(immutable: true) {
  id: Bytes!
  # Event has a uint8 feeType, but we can store it as an Int8 as we will not overflow it
  withdrawalType: String!
  address: Bytes!
  amount: BigInt!
}

# Aggregated entities
# Single account information
type Account @entity(immutable: false) {
  id: Bytes! # address

  # Relationships
  receivedDonations: [Donation!]! @derivedFrom(field: "to")
  receivedEndorsements: [Endorsement!]! @derivedFrom(field: "to")
  withdrawals: [Withdrawal!]! @derivedFrom(field: "address")
  sentDonations: [Donation!]! @derivedFrom(field: "from")
  sentEndorsements: [Endorsement!]! @derivedFrom(field: "from")

  # Aggregated data
  totalDonationsReceived: BigInt!
  totalEndorsementsReceived: BigInt!
  totalDonationsSent: BigInt!
  totalEndorsementsSent: BigInt!

  # Other information
  firstEndorsementReceivedTimestamp: BigInt
  firstDonationReceivedTimestamp: BigInt
  firstEndorsementSentTimestamp: BigInt
  firstDonationSentTimestamp: BigInt
}

# User pair information (from - to)
type AggregatedInformation @entity(immutable: false) {
  id: Bytes! # from - to
  from: Account!
  to: Account!
  donationAmount: BigInt!
  endorsementCount: BigInt!
}

# Global statistics
type GlobalStatistics @entity(immutable: false) {
  id: Bytes!
  totalEndorsements: BigInt!
  totalDonations: BigInt!
  totalDonationAmount: BigInt!
  totalWithdrawnAmount: BigInt!
}