Add vaults to squid

[nud3l]

Goal

Add a vaults endpoint where we can the data available at https://app.interlay.io/dashboard/vaults

Implementation

Vaults have:

• AccountId
• Identity
• Locked collateral (updated on registration, deposit and withdraw collateral)
• Locked BTC (added by Jacob lmk if this is not needed)
• Pending BTC
• Collateralization (based on current collateral and exchange rate)
• Status issuing (enabled disabled)
• Status collateral (see https://docs.interlay.io/#/vault/overview?id=collateral-thresholds)

Replaces

[jtfirek]

Would you like me to add onto the existing vault object in squid or is should this be an entirely new object?

interbtc-squid/schema.graphql

Lines 51 to 59 in e0ed448

	type Vault @entity {
	id: ID!
	accountId: String! @index
	collateralToken: Currency!
	wrappedToken: Currency!
	registrationBlock: Height!
	registrationTimestamp: DateTime!
	lastActivity: Height
	}

If adding to this existing is this what you are looking for?

type Vault @entity {
    id: ID!
    accountId: String! @index
    collateralToken: Currency!
    collateralAmount: BigInt!
    wrappedToken: Currency!
    pendingBtcAmount: BigInt!
    collateralization: String!
    statusIssuing: Bool!
    statusCollateral: Bool!
    registrationBlock: Height!
    registrationTimestamp: DateTime!
    lastActivity: Height
}

[nud3l]

Adding it to the existing vault object is the right approach. Thank you!

[jtfirek]

Sounds good!

[jtfirek]

@nud3l The locked collateral in the dashboard displays the collateral as DOT. Is the collateral in the multi-collateral system all converted to DOT equivalent value for displaying here?

[nud3l]

No, there are individual dashboards for each collateral asset. The DOT is just due to Interlay only having DOT as collateral right now. See Kintsugi as an example: https://kintsugi.interlay.io/dashboard/vaults

There's then a summary dashboard that converts all collateral assets to USD but that would be an add on and I'd consider it out of scope for this PR.

[jtfirek]

Ok thanks that clears up all my confusion.

[jtfirek]

Looks like the proposed goal does not included locked btc amount just the a pending btc amount. I feel that we need locked btc to calculation the collateratlization:
collateralization = colleratalAmount (converted to btc value) / locked btc
I have added this to the schema, but lmk if this is not needed/wanted.

[nud3l]

great catch, I forgot to add it.

[jtfirek]

@nud3l For the status issuing, Is this referring to
status | VaultStatus | Current status of the vault (Active, Liquidated, CommittedTheft)
from the iBTC spec?

[nud3l]

Almost:

StatusIssuing - Active or Inactive (just that part basically: https://github.com/interlay/interbtc/blob/master/crates/vault-registry/src/types.rs#L132)

StatusCollateral - AboveSecureThreshold, BelowSecureThreshold, BelowPremiumRedeemThreshold, Liquidated. The parachain just tracks if a vault is liquidated but the UI/frontend would also track if a vault is above or below certain collateral thresholds as determined by the ones here: https://docs.interlay.io/#/vault/overview?id=collateral-thresholds

[jtfirek]

Ok I see Active is a bool within the VaultStatus struct