schema.graphql

enum LiquidityPoolContractType {
  V1
  V2
}

type LiquidityPoolContract @entity {
  id: ID!
  chainId: Int!
  chainName: String!
  address: String!
  cores: [CoreContract!]! @derivedFrom(field: "liquidityPool") # todo
  coreAddresses: [String!]
  type_: LiquidityPoolContractType!
  version: String! # previously "type" but type is a reserved word so going with version
  token: String!
  tokenDecimals: Int!
  asset: String!
  betsAmount: BigInt!
  betsCount: BigInt!
  wonBetsAmount: BigInt!
  wonBetsCount: BigInt!
  firstCalculatedBlockNumber: BigInt!
  firstCalculatedBlockTimestamp: BigInt!
  lastCalculatedBlockNumber: BigInt!
  lastCalculatedBlockTimestamp: BigInt!
  daysSinceDeployment: BigInt!
  depositedAmount: BigInt!
  withdrawnAmount: BigInt!
  withdrawTimeout: BigInt!
  "all funds on Liquidity Pool"
  rawTvl: BigInt!
  # tvl: BigDecimal!
  # "(betsAmount - wonBetsAmount) * Xprofit / (depositedAmount - withdrawnAmount) / daysSinceDeployment * 365"
  rawApr: BigInt!
  apr: String! # will need to handle big decimals
  nfts: [LiquidityPoolNft!]! @derivedFrom(field: "liquidityPool")
  liquidityManager: String
  depositedWithStakingAmount: BigInt!
  withdrawnWithStakingAmount: BigInt!
}

type FreebetContract @entity {
  id: ID! # contractAddress-chainId
  liquidityPool: LiquidityPoolContract!
  address: String!
  name: String
  affiliate: String
  manager: String
}

enum FreebetStatus {
  Created
  Reissued
  Redeemed
  Withdrawn
}

type Freebet @entity {
  "Freebet Contract address + Freebet Id"
  id: ID!
  owner: String!
  freebetContractAddress: String!
  freebetContractName: String
  freebetContractAffiliate: String
  freebet: FreebetContract!
  azuroBetId: BigInt
  core: CoreContract
  freebetId: BigInt!
  status: FreebetStatus!
  expiresAt: BigInt!
  # amount: BigDecimal!  // BigDecimal
  rawAmount: BigInt!
  tokenDecimals: Int!
  durationTime: BigInt!
  rawMinOdds: BigInt!
  # minOdds: BigDecimal!
  createdBlockNumber: BigInt!
  createdBlockTimestamp: BigInt!
  createdTxHash: String!
  isResolved: Boolean!
  burned: Boolean!
  _updatedAt: BigInt!
}

type CoreContract @entity {
  id: ID!
  liquidityPool: LiquidityPoolContract!
  address: String!
  type_: String!
}

enum ConditionStatus {
  Created
  Resolved
  Canceled
  Paused
}

type Condition @entity {
  "Core Contract address + Condition Id"
  id: ID!
  core: CoreContract!
  coreAddress: String!
  conditionId: BigInt!
  game: Game!
  outcomes: [Outcome!]! @derivedFrom(field: "condition")
  outcomesIds: [BigInt!]
  # wonOutcomes: [Outcome!] @derivedFrom(field: "condition")
  wonOutcomeIds: [BigInt!]
  margin: BigInt!
  reinforcement: BigInt!
  status: ConditionStatus!
  turnover: BigInt!
  provider: BigInt!
  createdBlockNumber: BigInt!
  createdBlockTimestamp: BigInt!
  createdTxHash: String!
  resolvedBlockNumber: BigInt
  resolvedBlockTimestamp: BigInt
  resolvedTxHash: String
  internalStartsAt: BigInt
  isExpressForbidden: Boolean!
  _updatedAt: BigInt!
  _winningOutcomesCount: Int!
}

type Selection @entity {
  id: ID!
  bet: Bet!
  rawOdds: BigInt!
  # odds: BigDecimal!
  _oddsDecimals: Int!
  result: SelectionResult
  _outcomeId: BigInt!
  outcome: Outcome!
}

enum BetStatus {
  Accepted
  Canceled
  Resolved
}

enum BetResult {
  Won
  Lost
}

enum BetType {
  Ordinar
  Express
}

type Bet @entity {
  "Core contract address + Bet Id"
  id: ID!
  core: CoreContract!
  type_: BetType!
  betId: BigInt!
  bettor: String!
  owner: String!
  actor: String!
  affiliate: String
  # _conditions: [Condition!]!
  _conditionIds: [BigInt!]!
  rawAmount: BigInt!
  amount: String!
  _tokenDecimals: Int!
  rawPotentialPayout: BigInt!
  potentialPayout: String!
  rawPayout: BigInt
  payout: String
  rawOdds: BigInt!
  odds: String!
  _oddsDecimals: Int!
  rawSettledOdds: BigInt
  settledOdds: String
  "when the last game from all sub bets starts at + 2h"
  approxSettledAt: BigInt!
  selections: [Selection!]! @derivedFrom(field: "bet")
  # _games: [Game!]!
  createdBlockNumber: BigInt!
  createdBlockTimestamp: BigInt!
  createdTxHash: String!
  resolvedBlockNumber: BigInt
  resolvedBlockTimestamp: BigInt
  resolvedTxHash: String
  status: BetStatus!
  result: BetResult
  isRedeemable: Boolean!
  isRedeemed: Boolean!
  redeemedBlockNumber: BigInt
  redeemedBlockTimestamp: BigInt
  redeemedTxHash: String
  _subBetsCount: Int!
  _wonSubBetsCount: Int!
  _lostSubBetsCount: Int!
  _canceledSubBetsCount: Int!
  _isFreebet: Boolean!
  freebet: Freebet
  _updatedAt: BigInt!
}

enum GameStatus {
  Created
  Resolved
  Canceled
  Paused
}

type Game @entity {
  "LP Contract address + Game Id"
  id: ID!
  liquidityPool: LiquidityPoolContract!
  gameId: BigInt!
  title: String
  slug: String
  league: League!
  sport: Sport!
  status: GameStatus!
  participants: [Participant!]! @derivedFrom(field: "game")
  conditions: [Condition!]! @derivedFrom(field: "game")
  hasActiveConditions: Boolean!
  _activeConditionsEntityIds: [String!]
  _resolvedConditionsEntityIds: [String!]
  _canceledConditionsEntityIds: [String!]
  _pausedConditionsEntityIds: [String!]
  startsAt: BigInt!
  provider: BigInt!
  turnover: BigInt!
  createdBlockNumber: BigInt!
  createdBlockTimestamp: BigInt!
  createdTxHash: String!
  shiftedBlockNumber: BigInt
  shiftedBlockTimestamp: BigInt
  shiftedTxHash: String
  resolvedBlockNumber: BigInt
  resolvedBlockTimestamp: BigInt
  resolvedTxHash: String
  _updatedAt: BigInt!
}

enum SelectionResult {
  Won
  Lost
}

type Outcome @entity {
  "Condition entity Id (Core Contract address + Condition Id) + outcome Id"
  id: ID!
  core: CoreContract!
  outcomeId: BigInt!
  condition: Condition!
  fund: BigInt!
  rawCurrentOdds: BigInt!
  # currentOdds: BigDecimal!
  sortOrder: Int!
  _betsEntityIds: [String!]
  selections: [Selection!]! @derivedFrom(field: "outcome")
  _updatedAt: BigInt!
}

type Participant @entity(immutable: true) {
  "Game entity Id (LP Contract address + Game Id) + participant sortOrder"
  id: ID!
  game: Game!
  name: String!
  image: String
  sortOrder: Int!
}

type Sport @entity {
  id: ID!
  sportId: BigInt!
  name: String!
  slug: String!
  sporthub: SportHub!
  countries: [Country!]! @derivedFrom(field: "sport")
  games: [Game!]! @derivedFrom(field: "sport")
}

type SportHub @entity {
  id: ID!
  name: String!
  slug: String!
  sports: [Sport!]! @derivedFrom(field: "sporthub")
}

type League @entity {
  id: ID!
  name: String!
  slug: String!
  country: Country!
  games: [Game!]! @derivedFrom(field: "league")
  hasActiveGames: Boolean!
  activeGamesEntityIds: [String!]
  turnover: BigInt!
}

type Country @entity {
  id: ID!
  name: String!
  slug: String!
  sport: Sport!
  leagues: [League!]! @derivedFrom(field: "country")
  hasActiveLeagues: Boolean!
  activeLeaguesEntityIds: [String!]
  turnover: BigInt!
}

type AzuroBetContract @entity {
  id: ID!
  core: CoreContract!
  address: String!
}

type LiveBet @entity {
  "Core contract address + Bet Id"
  id: ID!
  core: CoreContract!
  betId: BigInt!
  bettor: String!
  owner: String!
  actor: String!
  affiliate: String
  # _conditions: [LiveCondition!]!
  _conditionIds: [BigInt!]!
  rawAmount: BigInt!
  # amount: BigDecimal!
  _tokenDecimals: Int!
  rawPotentialPayout: BigInt!
  # potentialPayout: BigDecimal!
  rawPayout: BigInt
  # payout: BigDecimal
  rawPayoutLimit: BigInt!
  # payoutLimit: BigDecimal!
  rawOdds: BigInt!
  # odds: BigDecimal!
  _oddsDecimals: Int!
  rawSettledOdds: BigInt
  # settledOdds: BigDecimal
  "when the last game from all sub bets starts at + 2h"
  selections: [LiveSelection!]! @derivedFrom(field: "bet")
  _gamesIds: [String!]!
  createdBlockNumber: BigInt!
  createdBlockTimestamp: BigInt!
  createdTxHash: String!
  resolvedBlockNumber: BigInt
  resolvedBlockTimestamp: BigInt
  resolvedTxHash: String
  status: BetStatus!
  result: BetResult
  isRedeemable: Boolean!
  isRedeemed: Boolean!
  redeemedBlockNumber: BigInt
  redeemedBlockTimestamp: BigInt
  redeemedTxHash: String
  _subBetsCount: Int!
  _wonSubBetsCount: Int!
  _lostSubBetsCount: Int!
  _canceledSubBetsCount: Int!
  _updatedAt: BigInt!
}

type LiveSelection @entity {
  id: ID!
  bet: LiveBet!
  rawOdds: BigInt!
  # odds: BigDecimal!
  _oddsDecimals: Int!
  result: SelectionResult
  _outcomeId: BigInt!
  outcome: LiveOutcome!
}

type LiveOutcome @entity {
  "Condition entity Id (Core Contract address + Condition Id) + outcome Id"
  id: ID!
  core: CoreContract!
  outcomeId: BigInt!
  condition: LiveCondition!
  sortOrder: Int!
  _betsEntityIds: [String!]
  selections: [LiveSelection!]! @derivedFrom(field: "outcome")
  _updatedAt: BigInt!
}

type LiveCondition @entity {
  "Core Contract address + Condition Id"
  id: ID!
  core: CoreContract!
  coreAddress: String!
  conditionId: BigInt!
  gameId: BigInt!
  outcomes: [LiveOutcome!]! @derivedFrom(field: "condition")
  outcomesIds: [BigInt!]
  # wonOutcomes: [LiveOutcome!]
  wonOutcomeIds: [BigInt!]
  status: ConditionStatus!
  turnover: BigInt!
  createdBlockNumber: BigInt!
  createdBlockTimestamp: BigInt!
  createdTxHash: String!
  resolvedBlockNumber: BigInt
  resolvedBlockTimestamp: BigInt
  resolvedTxHash: String
  _updatedAt: BigInt!
  _winningOutcomesCount: Int!
}

type LiquidityPoolNft @entity {
  id: ID!
  nftId: BigInt!
  owner: String!
  historicalOwners: [String!]!
  liquidityPool: LiquidityPoolContract!
  rawDepositedAmount: BigInt!
  # depositedAmount: BigDecimal!
  rawWithdrawnAmount: BigInt!
  # withdrawnAmount: BigDecimal!
  isFullyWithdrawn: Boolean!
  transactions: [LiquidityPoolTransaction!]! @derivedFrom(field: "nft")
  createBlockNumber: BigInt!
  createBlockTimestamp: BigInt!
  withdrawTimeout: BigInt!
}

enum LiquidityPoolTransactionType {
  Deposit
  Withdrawal
}

type LiquidityPoolTransaction @entity {
  id: ID!
  account: String!
  nft: LiquidityPoolNft!
  type_: LiquidityPoolTransactionType!
  liquidityPool: LiquidityPoolContract!
  rawAmount: BigInt!
  # amount: BigDecimal!
  blockNumber: BigInt!
  blockTimestamp: BigInt!
  txHash: String!
}

type ExpressPrematchRelation @entity(immutable: true) {
  "Express (core) contract address"
  id: ID!
  prematchAddress: String!
}