Overview

FIO Relic is an application which connects to to the FIO Chain node to receive all transaction data, transforms this data into FIO Protocol specific data, inserts int into a relational database and makes the content available via HTTP API. The following document is intended to be functional specification for the FIO Relic System.

Components

Application Components

Data Pipeline

Data Pipeline (FIO.Chronicle) is a software application designed to connect to FIO Chain State History, receive the data and transform it to JSON. It is a fork of the EOSChronicle project.

receiver – a new receiver will be made that will meet RELIC specific needs. the receiver will process only relic relevant events from the fio state history node.
decoder – a decoder component will be made that meets relic specific needs, converting relic bin data collected and queued from history node receiver into json to be consumed by a relic specific exporter.
exporter – a new exporter will be made that will export data directly into the relic Postgres relational database.

Database

Postgres Relational Database to store FIO Chain information.

API

HTTP server to return information from database.

Push Notification System

This component will be developed in Phase 2.

This component allows an API user to subscribe to specific events and then receive notification if such event has occurred during data transformation.

Examples

“Notify supplied webhook on every new FIO Domain registration”
“Notify when a FIO Request for specific FIO Handle is observed”

Specification

Deployment Requirements

FIO Relic will likely be run on the same environment as the FIO Chain node. Therefore, it should be compatible with that environment
It should be very easy to configure and deploy FIO Relic as a product.
- Avoid:
  - Long installation instructions
  - Requiring install of multiple components which may have their own versions and dependancies
- Consider:
  - Clear instructions on installation and dependency requirementgs
  - Single repo
  - Single install and run script

Data Model

blocks

Add only. Every block is a new entry.

Field	Description	Relationship
number	Block number as generated by FIO Node	transactions → block_num
id	Block ID as generated by FIO Node
timestamp	Timestamp as generated by FIO Node
producer	Account name of producer which produced the block
schedule_version	Version of BP schedule

transactions

Add only. Every transaction is a new entry.

Field	Description	Relationship
block_number	Block which contained this transaction	blocks → number
id	Transaction id	traces → transaction_id
action_account	Account name for action
action_name	Action name
account	Account which executed the transaction
tpid	TPID which was recorded in tranaction
fee	FIO Chain fee paid for this transaction
request_data	Raw request data for primary trace
response_data	Raw response data for primary trace
status	Transaction status

traces

Add only. Every trace is a new entry.

Field	Description	Relationship
id	Trace ID - generated.
transaction_id	Transaction ID	transactions → id
receiver	Receiver of trace
action_ordinal	Sequential order of trace in transaction
action_account	Account name for trace
action_name	Action name fro trace
request_data	Raw request data for trace

accounts

Add only. Every account created is a new entry.

Field	Description	Relationship
account	Account name	account_activity → account domains → account handles → account token_transfers → payer_account token_transfers → payee_account token_staking → staker_account fio_requests → payee_account fio_requests → payer_account fio_data → payee_account fio_data → payer_account
public_key	Primary public key
balance	Running FIO Token balance. Default: 0
timestamp	Block timestamp of when account was created

account_activity

Add only. Every activity is a new entry.

Field

Description

Relationship

account

Account name

accounts → account

transaction_id

Transaction ID

transactions → id

type

Type of activity. Options:

sender
receiver

domains

Add and update. Represents current state of domains. Will be updated every time domain info changes. Records will not be removed, just marked burned.

Field	Description	Relationship
domain	Domain name	domain_activity → domain
account	Account name of current owner	accounts → account
is_public	Is domain public
expiration	Timestamp of domain expiration
status	Current status of domain. Options: active burnt

domain_activity

Add only. Every activity is a new entry

Field

Description

Relationship

domain

Domain name

domains → domain

transaction_id

Transaction ID

transactions → id

type

Type of activity. Options:

register
renew
transfer
wrap
unwrap
auto_burn
public
non-public

handles

Add and update. Represents current state of handles. Will be updated every time handle info changes. Records will not be removed, just marked burned.

Field	Description	Relationship
handle	Handle name	handle_activity → handle pub_addresses → handle nft_signatures → handle fio_requests → payer_handle fio_requests → payee_handle fio_data → payer_handle fio_data → payee_handle
domain	Domain on which handle is registered. Right of @ in user@domain	domains → domain
account	Account name of current owner	accounts → account
encryption_key	Encryption public key
encryption_key_set	Defines if encryption key was specifically set. Options: false (default) true
expiration	Timestamp of handle expiration
status	Current status of handle. Options: active burnt

handle_activity

Add only. Every activity is a new entry

Field

Description

Relationship

handle

Handle name

handles → handle

transaction_id

Transaction ID

transactions → id

type

Type of activity. Options:

register
renew
transfer
add_bundles
add_pubbadd
rem_pubbadd
rem_all_pubbadd
add_nft
rem_nft
rem_all_nft
upd_encryptkey
self_burn
new_request
cancel_request
reject_request
record_obt

pub_addresses

Add, update, delete. Represents current state of mapped public addresses. Will be updated every time mapping changes. Records will be removed if needed.

Field	Description	Relationship
handle	Handle name	handles → handle
chain_code	Chain code
token_code	Token code
public_address	Public Address

nft_signatures

Add, update, delete. Represents current state of NFT signatures. Will be updated every time signatures are changed. Records will be removed if needed.

Field	Description	Relationship
handle	Handle name	handles → handle
chain_code	Chain code
contract_address	Contract address
token_id	Token ID
url	url
hash	hash
metadata	metadata

token_transfers

Add only. Every transfer is a new entry. Includes internal transfers.

Field	Description	Relationship
payer_account	Account of payer (sender)	accounts → account
payee_account	Account of payee (receiver)	accounts → account
transaction_id	Transaction ID	transactions → id
amount	Token amount in FIO
type	Type of transfer. Options: transfer transfer_locked blockchain_fee tpid_reward staking_reward bp_reward foundation_reward oracle_fee unwrap token_mint wrap retire
memo	Memo in transfer

Update accounts → balance

Every time an entry is inserted into token_transfers the accounts → balance should be updated as follows:

amount should be subtracted from accounts → balance for payer_account
amount should be added to accounts → balance for payee_account

token_staking

Add only. Every stake or unstake is a new entry. Includes internal transfers.

Field	Description	Relationship
staker_account	Account of staker	accounts → account
transaction_id	Transaction ID	transactions → id
amount	Token amount in FIO, unstake will be negative

fio_requests

Add and update. Represents current state of requests. Will be updated every time request status changes. Records will not be removed.

Field	Description	Relationship
id	FIO Request ID	fio_data → request_id
payee_handle	Handle of payer	handles → handle
payer_handle	Handle of payee	handles → handle
content	Encrypted blob
payee_pub_key	Public Key of payee
payer_pub_key	Public Key of payer
status	Status of request. Options: pending cancelled rejected sent_to_blockchain
transaction_id	Transaction ID	transactions → id

fio_data

Add and update. Represents current state of FIO Data. Will be updated every time request status changes. Records will not be removed.

Field	Description	Relationship
request_id	FIO Request ID (optional)	fio_requests → id
payee_handle	Handle of payer	handles → handle
payer_handle	Handle of payee	handles → handle
content	Encrypted blob
payee_pub_key	Public Key of payee
payer_pub_key	Public Key of payer
status	Status of data. Currently always “sent_to_blockchain”.
transaction_id	Transaction ID	transactions → id

Parsing Rules

The parsing rules below are triggered by any of the following:

block
transaction
trace
specific account and name inside trace → action_traces → act. It will be presented as Trigger: action_account:action:name, e.g. Trigger: eosio:newaccount
table deltas

and are organized by defining the table where record needs to be added as well as data source, typically from the trace.

Please pay attention to sequence of traces to accommodate relationships, e.g. when transferring tokens to a new account, the account has to be inserted into accounts table, before transfer is recorded.

Trigger: every block

Table: blocks

Field	Source Data
number	`block_num`
id	`block_id`
timestamp	`block_timestamp`
producer	`producer`
schedule_version	`schedule_version`

Trigger: every trace where `action_ordinal = 1`

Table: transactions

Field	Source Data
block_number	`block_num`
id	`trace` → `id`
action_account	`trace` → `action_traces` → `act` → `account`
action_name	`trace` → `action_traces` → `act` → `name`
account	`trace` → `action_traces` → `act` → `authorization` → `actor`
tpid	`trace` → `action_traces` → `act` → `data` → `tpid`
fee	`response` → `fee_collected` / 1000000000
request_data	`trace` → `action_traces` → `act` → `data`
response_data	`response`
status	`trace` → `status`

Table: account_activity

This is skipped in code as the sending actor is in the transaction table

Field	Source Data
account	`trace` → `action_traces` → `act` → `data` → `actor`
transaction_id	Transaction ID
type	“sender”

Trigger: every trace where `action_ordinal > 1`

Table: traces

Field	Source Data
id	Trace id. Auto-generated ID or transaction_id + action_ordinal, e.g. 770989df18fac96e48ca03d6702991d4462bebacceab8cf6b389507e998ca7fe-2
transaction_id	`trace` → `id`
receiver	`trace` → `action_traces` → `receiver`
action_ordinal	`trace` → `action_traces` → `action_ordinal`
action_account	`trace` → `action_traces` → `act` → `account`
action_name	`trace` → `action_traces` → `act` → `name`
request_data	`trace` → `action_traces` → `act` → `data`

Trigger: fio.address:bind2eosio

Table: accounts

Field	Source Data
account	`trace` → `action_traces` → `act` → `data` → `account`
public_key	`trace` → `action_traces` → `act` → `data` → `client_key`
timestamp	`block_timestamp`

Table: account_activity

Field	Source Data
account	`trace` → `action_traces` → `act` → `data` → `account`
transaction_id	`trace` → `id`
type	“receiver”

Trigger: fio.token:trnsfiopubky and `action_ordinal = 1`

Table: token_transfers

Field	Source Data
payer_account	`trace` → `action_traces` → `act` → `data` → `actor`
payee_account	`trace` → `action_traces` → `act` → `data` → `payee_public_key` hashed to account
transaction_id	`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` → `amount` / 1000000000
type	“transfer”
memo

Trigger: fio.token:trnsloctoks and `action_ordinal = 1`

Table: token_transfers

Field	Source Data
payer_account	`trace` → `action_traces` → `act` → `data` → `actor`
payee_account	`trace` → `action_traces` → `act` → `data` → `payee_public_key` hashed to account
transaction_id	`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` → `amount` / 1000000000
type	“transfer_locked”
memo

Trigger: fio.token:transfer and `receiver = fio.token`

Table: token_transfers

Field	Source Data
payer_account	`trace` → `action_traces` → `act` → `data` → `from`
payee_account	`trace` → `action_traces` → `act` → `data` → `to`
transaction_id	`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` → `quantity` (strip " FIO")
type	If `memo:FIO fee*` type is “blockchain_fee” If `memo:Paying TPID from treasury.` type is “tpid_reward” If `memo:Paying Staking Rewards` type is “staking_reward” If `memo:Paying producer from treasury.` type is “bp_reward” If `memo:Paying foundation from treasury.` type is “foundation_reward” If `memo:Token Wrapping Oracle Fee` type is “oracle_fee” If `memo:Token Unwrapping` type is “unwrap”
memo	`trace` → `action_traces` → `act` → `data` → `memo`

Trigger: fio.token:issue and `receiver = fio.token`

Table: token_transfers

Field	Source Data
payer_account	“fio.token”
payee_account	“eosio”
transaction_id	`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` → `quantity` (strip " FIO")
type	“token_mint”
memo	`trace` → `action_traces` → `act` → `data` → `memo`

Trigger: fio.token:wraptokens and `action_ordinal = 1`

Table: token_transfers

Field	Source Data
payer_account	`trace` → `action_traces` → `act` → `data` → `actor`
payee_account	“fio.oracle"
transaction_id	`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` → `amount` / 1000000000
type	“wrap”
memo

Trigger: fio.token:stakefio and `action_ordinal = 1`

Table: token_staking

Field	Source Data
staker_account	`trace` → `action_traces` → `act` → `data` → `actor`
transaction_id	`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` → `amount` / 1000000000

Trigger: fio.token:retire and `action_ordinal = 1`

Table: token_transfers

Field	Source Data
payer_account	`trace` → `action_traces` → `act` → `data` → `actor`
payee_account	“fio.token”
transaction_id	`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` → `quantity` / 1000000000
type	“retire”
memo	`trace` → `action_traces` → `act` → `data` → `memo`

Trigger: fio.token:unstakefio and `action_ordinal = 1`

Table: token_staking

Field	Source Data
staker_account	`trace` → `action_traces` → `act` → `data` → `actor`
transaction_id	`trace` → `id`
amount	Negative of (`trace` → `action_traces` → `act` → `data` → `amount` / 1000000000)

Trigger: fio.address:regdomain and `action_ordinal = 1`

Table: domains or (if exists based on `domain`)

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
account	`trace` → `action_traces` → `act` → `data` → `owner_fio_public_key` hashed to account. If empty `trace` → `action_traces` → `act` → `data` → `actor`
is_public	“false”
expiration	`response` → `expiration`
status	“active"

Table: domain_activity

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
transaction_id	`trace` → `id`
type	“register”

Table: account_activity

Only insert if trace → action_traces → act → data → actor is not trace → action_traces → act → data → owner_fio_public_key hashed to account.

Field	Source Data
account	`trace` → `action_traces` → `act` → `data` → `owner_fio_public_key` hashed to account
transaction_id	`trace` → `id`
type	“receiver”

Trigger: fio.address:renewdomain and `action_ordinal = 1`

Table: domains

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
expiration	`response` → `expiration`

Table: domain_activity

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
transaction_id	`trace` → `id`
type	“renew”

Trigger: fio.address:xferdomain and `action_ordinal = 1`

Table: domains

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
account	`trace` → `action_traces` → `act` → `data` → `new_owner_fio_public_key` hashed to account

Table: domain_activity

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
transaction_id	`trace` → `id`
type	“transfer”

Table: account_activity

Field	Source Data
account	`trace` → `action_traces` → `act` → `data` → `new_owner_fio_public_key` hashed to account
transaction_id	`trace` → `id`
type	“receiver”

Trigger: fio.address:setdomainpub and `action_ordinal = 1`

Table: domains

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
is_public	`trace` → `action_traces` → `act` → `data` → `is_public` (1 - true; 0 - false)

Table: domain_activity

Field

Source Data

domain

trace → action_traces → act → data → fio_domain

transaction_id

trace → id

type

is_public: 1 type is “public”

is_public: 0 type is “non-public”

Trigger: fio.address:wrapdomain and `action_ordinal = 1`

Table: domains

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
account	“fio.oracle”

Table: domain_activity

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
transaction_id	`trace` → `id`
type	“wrap”

Table: account_activity

Field	Source Data
account	“fio.oracle”
transaction_id	`trace` → `id`
type	“receiver”

Trigger: fio.address:xferescrow

Table: domains

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
account	`trace` → `action_traces` → `act` → `data` → `public_key` hashed to account

Table: domain_activity

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
transaction_id	`trace` → `id`
type	“unwrap”

Table: account_activity

Field	Source Data
account	`trace` → `action_traces` → `act` → `data` → `public_key` hashed to account
transaction_id	`trace` → `id`
type	“receiver”

Field	Source Data
account	“fio.oracle”
transaction_id	`trace` → `id`
type	“sender”

Trigger: fio.address:regaddress and `action_ordinal = 1`

Table: handles or (if exists based on `handle`)

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
domain	Domain from (`trace` → `action_traces` → `act` → `data` → `fio_address`) split by @ and take second param.
account	`trace` → `action_traces` → `act` → `data` → `owner_fio_public_key` hashed to account. If empty `trace` → `action_traces` → `act` → `data` → `actor`
encryption_key	`trace` → `action_traces` → `act` → `data` → `owner_fio_public_key`. If empty `public_key` from `accounts` for `trace` → `action_traces` → `act` → `data` → `actor`
encryption_key_set	“false”
bundled_tx	“100”
expiration	`response` → `expiration`
status	“active"

Table: handle_activity

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
transaction_id	`trace` → `id`
type	“register”

Table: account_activity

Only insert if trace → action_traces → act → data → actor is not trace → action_traces → act → data → owner_fio_public_key hashed to account.

Field	Source Data
account	`trace` → `action_traces` → `act` → `data` → `owner_fio_public_key` hashed to account
transaction_id	`trace` → `id`
type	“receiver”

Table: pub_addresses

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
chain_code	“FIO”
token_code	“FIO”
public_address	`trace` → `action_traces` → `act` → `data` → `owner_fio_public_key`. If empty `public_key` from `accounts` for `trace` → `action_traces` → `act` → `data` → `actor`

Trigger: fio.address:renewaddress and `action_ordinal = 1`

Table: handles

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
expiration	`response` → `expiration`

Table: handle_activity

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
transaction_id	`trace` → `id`
type	“renew”

Trigger: fio.address:xferaddress and `action_ordinal = 1`

Table: handles

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
account	`trace` → `action_traces` → `act` → `data` → `new_owner_fio_public_key` hashed to account
encryption_key	`trace` → `action_traces` → `act` → `data` → `new_owner_fio_public_key`
encryption_key_set	“false”

Table: handle_activity

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
transaction_id	`trace` → `id`
type	“transfer”

Table: account_activity

Field	Source Data
account	`trace` → `action_traces` → `act` → `data` → `new_owner_fio_public_key` hashed to account
transaction_id	`trace` → `id`
type	“receiver”

Table: pub_addresses and

Remove all objects matching in trace → action_traces → act → data → fio_address and add:

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
chain_code	“FIO”
token_code	“FIO”
public_address	`trace` → `action_traces` → `act` → `data` → `new_owner_fio_public_key`

Table: nft_signatures

Remove all objects matching in trace → action_traces → act → data → fio_address

Trigger: fio.address:addbundles and `action_ordinal = 1`

Table: handle_activity

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
transaction_id	`trace` → `id`
type	“add_bundles”

Trigger: fio.address:addaddress and `action_ordinal = 1`

Table: handle_activity

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
transaction_id	`trace` → `id`
type	“add_pubbadd”

Table: pub_addresses or (if exists)

For each object in trace → action_traces → act → data → public_addresses update or insert new record

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
chain_code	`trace` → `action_traces` → `act` → `data` → `public_addresses` → `chain_code`
token_code	`trace` → `action_traces` → `act` → `data` → `public_addresses` → `token_code`
public_address	`trace` → `action_traces` → `act` → `data` → `public_addresses` → `public_address`

Table: handles

Update only if encryption_key_set = false and chain_code = “FIO” and (token_code = “FIO” or token_code = “*”)

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
encryption_key	`trace` → `action_traces` → `act` → `data` → `public_addresses` → `public_address`

Trigger: fio.address:remaddress and `action_ordinal = 1`

Table: handle_activity

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
transaction_id	`trace` → `id`
type	“rem_pubbadd”

Table: pub_addresses

Remove each object in trace → action_traces → act → data → public_addresses which matches

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
chain_code	`trace` → `action_traces` → `act` → `data` → `public_addresses` → `chain_code`
token_code	`trace` → `action_traces` → `act` → `data` → `public_addresses` → `token_code`
public_address	`trace` → `action_traces` → `act` → `data` → `public_addresses` → `public_address`

Trigger: fio.address:remalladdr and `action_ordinal = 1`

Table: handle_activity

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
transaction_id	`trace` → `id`
type	“rem_all_pubbadd”

Table: pub_addresses

Remove all objects matching in trace → action_traces → act → data → fio_address except FIO - FIO

Trigger: fio.address:addnft and `action_ordinal = 1`

Table: handle_activity

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
transaction_id	`trace` → `id`
type	“add_nft”

Table: nft_signatures or (if exists)

For each object in trace → action_traces → act → data → nfts update or insert new record

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
chain_code	`trace` → `action_traces` → `act` → `data` → `nfts`-> `chain_code`
contract_address	`trace` → `action_traces` → `act` → `data` → `nfts`→ `contract_address`
token_id	`trace` → `action_traces` → `act` → `data` → `nfts`→ `token_id`
url	`trace` → `action_traces` → `act` → `data` → `nfts`→ `url`
hash	`trace` → `action_traces` → `act` → `data` → `nfts`→ `hash`
metadata	`trace` → `action_traces` → `act` → `data` → `nfts`→ `metadata`

Trigger: fio.address:remnft and `action_ordinal = 1`

Table: handle_activity

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
transaction_id	`trace` → `id`
type	“rem_nft”

Table: nft_signatures

Remove each object in trace → action_traces → act → data → nfts which matches

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
chain_code	`trace` → `action_traces` → `act` → `data` → `nfts`-> `chain_code`
contract_address	`trace` → `action_traces` → `act` → `data` → `nfts`→ `contract_address`
token_id	`trace` → `action_traces` → `act` → `data` → `nfts`→ `token_id`
url	`trace` → `action_traces` → `act` → `data` → `nfts`→ `url`
hash	`trace` → `action_traces` → `act` → `data` → `nfts`→ `hash`
metadata	`trace` → `action_traces` → `act` → `data` → `nfts`→ `metadata`

Trigger: fio.address:remallnfts and `action_ordinal = 1`

Table: handle_activity

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
transaction_id	`trace` → `id`
type	“rem_all_nft”

Table: nft_signatures

Remove all objects matching in trace → action_traces → act → data → fio_address

Trigger: fio.address:updcryptkey and `action_ordinal = 1`

Table: handles

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
encryption_key	`trace` → `action_traces` → `act` → `data` → `encrypt_public_key`
encryption_key_set	“true”

Table: handle_activity

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
transaction_id	`trace` → `id`
type	“upd_encryptkey”

Trigger: fio.address:regdomadd and `action_ordinal = 1`

Execute same as for trigger fio.address:regdomain and fio.address:regaddress except insert only once into account_activity with type “receiver”.

Trigger: fio.address:burnaddress and `action_ordinal = 1`

Table: handles

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
account	empty
encryption_key	empty
status	“burnt”

Table: handle_activity

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
transaction_id	`trace` → `id`
type	“self_burn”

Table: pub_addresses

Remove all objects matching in trace → action_traces → act → data → fio_address

Table: nft_signatures

Remove all objects matching in trace → action_traces → act → data → fio_address

Trigger: fio.address:newfundsreq and `action_ordinal = 1`

Table: handle_activity

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `payee_fio_address`
transaction_id	`trace` → `id`
type	“new_request”

Table: account_activity

Field	Source Data
account	Look-up `handles`→ `account` where `handle` is `trace` → `action_traces` → `act` → `data` → `payer_fio_address`
transaction_id	`trace` → `id`
type	“receiver”

Table: fio_requests

Field	Source Data
id	`response` → `fio_request_id`
payee_handle	`trace` → `action_traces` → `act` → `data` → `payee_fio_address`
payer_handle	`trace` → `action_traces` → `act` → `data` → `payer_fio_address`
content	`trace` → `action_traces` → `act` → `data` → `content`
payee_pub_key	Look-up `handles` → `encrypt_key` where account is owner of `trace` → `action_traces` → `act` → `data` → `payee_fio_address`
payer_pub_key	Look-up `handles` → `encrypt_key` where account is owner of `trace` → `action_traces` → `act` → `data` → `payer_fio_address`
status	“pending”
transaction_id	`trace` → `id`

Trigger: fio.address:cancelfndreq and `action_ordinal = 1`

Table: handle_activity

Field	Source Data
handle	Look-up `fio_request` → `payee_handle` where `id` is `trace` → `action_traces` → `act` → `data` → `fio_request_id`
transaction_id	`trace` → `id`
type	“cancel_request”

Table: fio_requests

Field	Source Data
id	`trace` → `action_traces` → `act` → `data` → `fio_request_id`
status	“cancelled”

Trigger: fio.address:rejectfndreq and `action_ordinal = 1`

Table: handle_activity

Field	Source Data
handle	Look-up `fio_request` → `payer_handle` where `id` is `trace` → `action_traces` → `act` → `data` → `fio_request_id`
transaction_id	`trace` → `id`
type	“reject_request”

Table: fio_requests

Field	Source Data
id	`trace` → `action_traces` → `act` → `data` → `fio_request_id`
status	“rejected”

Trigger: fio.address:recordobt and `action_ordinal = 1`

Table: handle_activity

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `payer_fio_address`
transaction_id	`trace` → `id`
type	“record_obt”

Table: account_activity

Field	Source Data
account	Look-up `handles`→ `account` where `handle` is `trace` → `action_traces` → `act` → `data` → `payee_fio_address`
transaction_id	`trace` → `id`
type	“receiver”

Table: fio_data

Field	Source Data
request_id	`trace` → `action_traces` → `act` → `data` → `fio_request_id`
payee_handle	`trace` → `action_traces` → `act` → `data` → `payee_fio_address`
payer_handle	`trace` → `action_traces` → `act` → `data` → `payer_fio_address`
content	`trace` → `action_traces` → `act` → `data` → `content`
payee_pub_key	Look-up `handles` → `encrypt_key` where account is owner of `trace` → `action_traces` → `act` → `data` → `payee_fio_address`
payer_pub_key	Look-up `handles` → `encrypt_key` where account is owner of `trace` → `action_traces` → `act` → `data` → `payer_fio_address`
status	“sent_to_blockchain”
transaction_id	`trace` → `id`

Table: fio_requests

Update only if trace → action_traces → act → data → fio_request_id is present

Field	Source Data
id	`trace` → `action_traces` → `act` → `data` → `fio_request_id`
status	“sent_to_blockchain”

Trigger: Table Deltas: `added:false` and `kvo->table:domains`

Secondary conditions (all must be true):

There must be a transaction in the block_num which has action_name: burnexpired
is_public for kvo → value → name in domains table has not changed
expiration for kvo → value → name in domains table has not changed

Table: domains

Field	Source Data
domain	`kvo` → `value` → `name`
account	empty
status	“burnt”

Table: domain_activity

Field	Source Data
domain	`kvo` → `value` → `name`
transaction_id	transaction id of transaction with `action_name: burnexpired`
type	“auto_burn”

Trigger: Table Deltas: `added:false` and `kvo->table:fionames`

Secondary conditions (all must be true):

There must be a transaction in the block_num which has action_name: burnexpired and its traces do not have a trace with action_name: burnaddress and action_ordinal = 1
pubaddreses has not changed
bundlecount has not changed
encryoption_key has not changed

Table: handles

Field	Source Data
handle	`kvo` → `value` → `name`
account	empty
encryption_key	empty
status	“burnt”

Table: handle_activity

Field	Source Data
handle	`kvo` → `value` → `name`
transaction_id	transaction id of transaction with `action_name: burnexpired`
type	“auto_burn”

Trigger: Action in list

API

/get_blocks

Returns block information.

Request

Parameter	Description
time_start	Filters block by `timestamp`
time_end	Filters block by `timestamp`
producer	Filters block by `producer`
sort	Sorting: block_num_asc (default) block_num_desc timestamp_asc (default) timestamp_desc

Query

Return records from blocks which match all request parameters.

Sort by:

block_num_asc: blocks → number ASC
block_num_desc: blocks → number DESC
timestamp_asc: blocks → timestamp ASC
timestamp_desc: blocks → timestamp DESC

Response

Group	Field	Source Data
blocks	number	`blocks` → `number`
blocks	id	`blocks` → `id`
blocks	timestamp	`blocks` → `timestamp`
blocks	producer	`blocks` → `producer`
blocks	schedule_version	`blocks` → `schedule_version`
pagination	limit	Supplied limit
pagination	offset	Supplied offset
pagination	total_records	Total number of transactions which meet the criteria
pagination	next_offset	Offset to supply for next set of records: supplied offset + limit
pagination	previous_offset	Offset to supply for previous set of records: supplied offset - limit

Example

{
	"blocks": [
		{
			"number": "2",
			"id": "00000002953a8ab87a1855c0c40786e6a910a86cb2dd160f181418d05d233ea7",
			"timestamp": "2020-03-25T00:05:21.000",
			"producer": "eosio",
			"schedule_version": "1"
		}
	],
	"pagination": {
		"limit": 100,
		"offset": 0,
		"total_records": 1,
		"next_offset": "",
		"previous_offset": ""
	}
}

/get_transactions

Returns transaction information.

Request

Parameter	Description
time_start	Filters block by `timestamp`
time_end	Filters block by `timestamp`
block_number	Filters block by `block_number`
action_account	Filters block by `action_account`
action_name	Filters block by `action_name`
impacted_account	Filters by impacted account (see below)
impacted_account_direction	Filters by impacted account direction (see below) both (default) sender receiver
include_traces	If true include traces true (default) false
sort	Sorting of results: timestamp_asc (default) timestamp_desc
limit	Number of results to include. Default: 100
offset	Offset for pagination. Default: 0

Query

Return records from transactions which match all request parameters except:

impacted_account is supplied:
- impacted_account_direction is supplied and is “sender”
  - Records from transactions where impacted_account = account_activity->account and type is “sender”
- impacted_account_direction is supplied and is “receiver”
  - Records from transactions where impacted_account = account_activity->account and type is “receiver”
- impacted_account_direction is supplied and is “both” or not supplied
  - Records from transactions where impacted_account = account_activity->account
- Please note: a single transaction can be affecting the same account as sender and receiver! In this case the same transaction should be returned twice.

Also include related data from:

blocks
- timestamp
traces
- All traces for transaction
token_transfers
- id matches transaction_id
- Include
  - payer_account
  - payee_account
  - amount
  - type
  - memo
domain_activity
- id matches transaction_id
- Include
  - domain
  - type
handle_activity
- id matches transaction_id
- Include
  - handle
  - type
token_staking
- id matches transaction_id
- Include
  - staker_account
  - amount
fio_requests
- id matches transaction_id
- Include
  - id
  - payee_handle
  - payer_handle
  - content
  - payee_pub_key
  - payer_pub_key
  - status
fio_data
- id matches transaction_id
- Include
  - request_id
  - payee_handle
  - payer_handle
  - content
  - payee_pub_key
  - payer_pub_key
  - status

Sort by:

timestamp_asc: blocks → timestamp ASC
timestamp_desc: blocks → timestamp DESC

Response

Group	Field	Source Data
transactions	id	`transactions` → `id`
transactions	block_number	`transactions` → `block_number`
transactions	timestamp	`blocks` → `timestamp`
transactions	action_account	`transactions` → `action_account`
transactions	action_name	`transactions`→ `action_name`
transactions	sender_account	`account_activity` → `account` where type is “sender”
transactions	receiver_account	`account_activity` → `account` where type is “receiver”
transactions	impacted_account_direction	See `impacted_account` above: “sender” “receiver” Blank if impacted_account not supplied.
transactions	tpid	`transactions`→ `tpid`
transactions	fee	`transactions`→ `fee`
transactions	request_data	`transactions`→ `request_data`
transactions	request_data	`transactions`→ `response_data`
transactions	status	`transactions`→ `status`
transactions	type_specific_data	This element contains data which is specific to certain types of transactions from the joint tables: token_transfers payer_account payee_account amount type memo domain_activity domain type handle_activity handle type token_staking staker_account amount fio_requests payee_handle payer_handle content payee_pub_key payer_pub_key status fio_data payee_handle payer_handle content payee_pub_key payer_pub_key status
transactions	traces array	`traces` where `traces` → `transaction_id` matches. For each trace: id receiver action_ordinal action_account action_name request_data
pagination	limit	Supplied limit
pagination	offset	Supplied offset
pagination	total_records	Total number of transactions which meet the criteria
pagination	next_offset	Offset to supply for next set of records: supplied offset + limit
pagination	previous_offset	Offset to supply for previous set of records: supplied offset - limit

Example

{
	"transactions": [
		{
			"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e",
			"block_number": "259024750",
			"timestamp": "2024-05-03T17:00:02.500",
			"action_account": "fio.address",
			"action_name": "regaddress",
			"sender_account": "xghrmfdenyu5",
			"receiver_account": "1hpxnziaw2ec",
			"impacted_account_direction": "",
			"tpid": "tpid@opera",
			"fee": "55.399150882",
			"request_data": {
				"fio_address": "turandb@opera",
				"owner_fio_public_key": "FIO5PJdEsMQ5Qd2otKVFSXru72KcMx4G2Vafo9MZ6NHttqYCiV5JP",
				"max_fee": 55399150882,
				"actor": "xghrmfdenyu5",
				"tpid": "tpid@opera"
			},
			"response_data": "{\"status\": \"OK\",\"expiration\":\"2105-02-07T06:28:15\",\"fee_collected\":55399150882}",
			"status": "executed",
			"type_specific_data": {
				"token_transfers": [
					{
						"payer_account": "xghrmfdenyu5",
						"payee_account": "fio.treasury",
						"amount": "55.399150882",
						"type": "blockchain_fee",
						"memo": "FIO fee: register_fio_address"
					},
					{
						"payer_account": "eosio",
						"payee_account": "fio.treasury",
						"amount": "22.159660352",
						"type": "token_mint",
						"memo": "New tokens produced from reserves"
					}
				],
				"domain_activity": [],
				"handle_activity": [
					{
						"handle": "turandb@opera",
						"type": "register"
					}
				],
				"token_staking": [],
				"fio_requests": [],
				"fio_data": []
			},
			"traces": [
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-2",
					"receiver": "eosio",
					"action_ordinal": 2,
					"action_account": "eosio",
					"action_name": "newaccount",
					"request_data": {
						"creator": "fio.address",
						"name": "1hpxnziaw2ec",
						"owner": {
							"threshold": 1,
							"keys": [
								{
									"key": "FIO5PJdEsMQ5Qd2otKVFSXru72KcMx4G2Vafo9MZ6NHttqYCiV5JP",
									"weight": 1
								}
							],
							"accounts": [],
							"waits": []
						},
						"active": {
							"threshold": 1,
							"keys": [
								{
									"key": "FIO5PJdEsMQ5Qd2otKVFSXru72KcMx4G2Vafo9MZ6NHttqYCiV5JP",
									"weight": 1
								}
							],
							"accounts": [],
							"waits": []
						}
					}
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-3",
					"receiver": "fio.token",
					"action_ordinal": 3,
					"action_account": "fio.token",
					"action_name": "transfer",
					"request_data": {
						"from": "xghrmfdenyu5",
						"to": "fio.treasury",
						"quantity": "55.399150882 FIO",
						"memo": "FIO fee: register_fio_address"
					}
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-4",
					"receiver": "fio.treasury",
					"action_ordinal": 4,
					"action_account": "fio.treasury",
					"action_name": "fdtnrwdupdat",
					"request_data": {
						"amount": 2769957544
					}
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-5",
					"receiver": "fio.token",
					"action_ordinal": 5,
					"action_account": "fio.token",
					"action_name": "mintfio",
					"request_data": {
						"to": "fio.treasury",
						"amount": 22159660352
					}
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-6",
					"receiver": "fio.tpid",
					"action_ordinal": 6,
					"action_account": "fio.tpid",
					"action_name": "updatebounty",
					"request_data": {
						"amount": 22159660352
					}
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-7",
					"receiver": "fio.tpid",
					"action_ordinal": 7,
					"action_account": "fio.tpid",
					"action_name": "updatetpid",
					"request_data": {
						"tpid": "tpid@opera",
						"owner": "xghrmfdenyu5",
						"amount": 27699575440
					}
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-8",
					"receiver": "fio.treasury",
					"action_ordinal": 8,
					"action_account": "fio.treasury",
					"action_name": "bppoolupdate",
					"request_data": {
						"amount": 33239490529
					}
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-9",
					"receiver": "fio.staking",
					"action_ordinal": 9,
					"action_account": "fio.staking",
					"action_name": "incgrewards",
					"request_data": "48fd823903000000"
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-10",
					"receiver": "eosio",
					"action_ordinal": 10,
					"action_account": "eosio",
					"action_name": "incram",
					"request_data": {
						"accountmn": "xghrmfdenyu5",
						"amount": 2560
					}
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-11",
					"receiver": "fio.token",
					"action_ordinal": 11,
					"action_account": "xghrmfdenyu5",
					"action_name": "transfer",
					"request_data": {
						"from": "xghrmfdenyu5",
						"to": "fio.treasury",
						"quantity": "55.399150882 FIO",
						"memo": "FIO fee: register_fio_address"
					}
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-12",
					"receiver": "fio.treasury",
					"action_ordinal": 12,
					"action_account": "xghrmfdenyu5",
					"action_name": "transfer",
					"request_data": {
						"from": "xghrmfdenyu5",
						"to": "fio.treasury",
						"quantity": "55.399150882 FIO",
						"memo": "FIO fee: register_fio_address"
					}
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-13",
					"receiver": "eosio",
					"action_ordinal": 13,
					"action_account": "eosio",
					"action_name": "updlocked",
					"request_data": {
						"owner": "xghrmfdenyu5",
						"amountremaining": 165900009925342
					}
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-14",
					"receiver": "fio.token",
					"action_ordinal": 14,
					"action_account": "fio.token",
					"action_name": "issue",
					"request_data": {
						"to": "fio.treasury",
						"quantity": "22.159660352 FIO",
						"memo": "New tokens produced from reserves"
					}
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-15",
					"receiver": "eosio",
					"action_ordinal": 15,
					"action_account": "fio.token",
					"action_name": "issue",
					"request_data": {
						"to": "fio.treasury",
						"quantity": "22.159660352 FIO",
						"memo": "New tokens produced from reserves"
					}
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-16",
					"receiver": "fio.treasury",
					"action_ordinal": 16,
					"action_account": "fio.token",
					"action_name": "issue",
					"request_data": {
						"to": "fio.treasury",
						"quantity": "22.159660352 FIO",
						"memo": "New tokens produced from reserves"
					}
				},
				{
					"id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e-17",
					"receiver": "eosio",
					"action_ordinal": 17,
					"action_account": "eosio",
					"action_name": "crautoproxy",
					"request_data": {
						"proxy": "2m11cvdizsrg",
						"owner": "xghrmfdenyu5"
					}
				}
			]
		}
	],
	"pagination": {
		"limit": 100,
		"offset": 0,
		"total_records": 1,
		"next_offset": "",
		"previous_offset": ""
	}
}

/get_accounts

Returns account information.

Request

Parameter	Description
time_start	Filters accounts by `timestamp`
time_end	Filters accounts by `timestamp`
sort	Sorting: timestamp_asc (default) timestamp_desc
limit	Number of results to include. Default: 100
offset	Offset for pagination. Default: 0

Query

Return records from accounts which match all request parameters.

Sort by:

timestamp_asc: timestamp ASC
timestamp_desc: timestamp DESC

Response

Group	Field	Source Data
accounts	account	`accounts`→ `account`
accounts	public_key	`accounts`→ `public_key`
accounts	timestamp	`accounts`→ `timestamp`
pagination	limit	Supplied limit
pagination	offset	Supplied offset
pagination	total_records	Total number of transactions which meet the criteria
pagination	next_offset	Offset to supply for next set of records: supplied offset + limit
pagination	previous_offset	Offset to supply for previous set of records: supplied offset - limit

Example

{
	"accounts": [
		{
			"account": "1hpxnziaw2ec",
			"public_key": "FIO5PJdEsMQ5Qd2otKVFSXru72KcMx4G2Vafo9MZ6NHttqYCiV5JP"
		}
	],
	"pagination": {
		"limit": 100,
		"offset": 0,
		"total_records": 1,
		"next_offset": "",
		"previous_offset": ""
	}
}

/get_domains

Returns domain information.

Request

Parameter	Description
account	Account of domain owner
is_public	is_public flag. Default is not present (both are returned) true false
status	Status of domain active (default) burnt both
sort	Sorting: alphabetical (default) expiration_asc expiration_desc
limit	Number of results to include. Default: 100
offset	Offset for pagination. Default: 0

Query

Return records from domains which match all request parameters.

Sort by:

alphabetical: domain ASC
expiration_asc: expiration ASC
expiration_asc: expiration DESC

Response

Group	Field	Source Data
domains	domain	`domains`→ `domain`
domains	account	`domains`→ `account`
domains	is_public	`domains`→ `is_public`
domains	expiration	`domains`→ `expiration`
domains	status	`domains`→ `status`
pagination	limit	Supplied limit
pagination	offset	Supplied offset
pagination	total_records	Total number of transactions which meet the criteria
pagination	next_offset	Offset to supply for next set of records: supplied offset + limit
pagination	previous_offset	Offset to supply for previous set of records: supplied offset - limit

Example

{
	"domains": [
		{
			"domain": "bob",
			"account": "1hpxnziaw2ec",
			"is_public": false,
			"expiration": "2024-05-03T17:00:02.500",
			"status": "active"
		}
	],
	"pagination": {
		"limit": 100,
		"offset": 0,
		"total_records": 1,
		"next_offset": "",
		"previous_offset": ""
	}
}

/get_handles

Returns handle information.

Request

Parameter	Description
handle	Handle name
account	Account of handle owner
domain	Domain of handle
status	Status of handle active (default) burnt both
limit	Number of results to include. Default: 100
offset	Offset for pagination. Default: 0

Query

Return records from handles which match all request parameters.

Sort by:

alphabetical: handle ASC

Response

Group	Field	Source Data
handles	handle	`handles`→ `handle`
handles	account	`handles`→ `account`
handles	domain	`handles`→ `domain`
handles	encryption_key	`handles`→ `encryption_key`
handles	encryption_key_set	`handles`→ `encryption_key_set`
handles	expiration	`handles`→ `expiration`
handles	status	`handles`→ `status`
pagination	limit	Supplied limit
pagination	offset	Supplied offset
pagination	total_records	Total number of transactions which meet the criteria
pagination	next_offset	Offset to supply for next set of records: supplied offset + limit
pagination	previous_offset	Offset to supply for previous set of records: supplied offset - limit

Example

{
	"handles": [
		{
			"handle": "turandb@opera",
			"account": "1hpxnziaw2ec",
			"domain": "opera",
			"encryption_key": "FIO5PJdEsMQ5Qd2otKVFSXru72KcMx4G2Vafo9MZ6NHttqYCiV5JP",
			"encryption_key_set": false,
			"expiration": "2025-05-03T17:00:02.500",
			"status": "active"
		}
	],
	"pagination": {
		"limit": 100,
		"offset": 0,
		"total_records": 1,
		"next_offset": "",
		"previous_offset": ""
	}
}

/get_pub_addresses

Returns pub_addresses information.

Request

Parameter	Description
handle	Handle name
account	Account of handle owner
chain_code	Chain code
token_code	Token code
public_address	Public Address
limit	Number of results to include. Default: 100
offset	Offset for pagination. Default: 0

Query

Return records from pub_addresses which match all request parameters.

account requires join on handles

handle status must be active

Sort by:

alphabetical: handle ASC

Response

Group	Field	Source Data
handles	handle	`handles`→ `handle`
handles	account	`handles`→ `account`
handles → pub_addresses	chain_code	`pub_addresses`→ `chain_code`
handles → pub_addresses	token_code	`pub_addresses`→ `token_code`
handles → pub_addresses	public_address	`pub_addresses`→ `public_address`
pagination	limit	Supplied limit
pagination	offset	Supplied offset
pagination	total_records	Total number of transactions which meet the criteria
pagination	next_offset	Offset to supply for next set of records: supplied offset + limit
pagination	previous_offset	Offset to supply for previous set of records: supplied offset - limit

Example

{
	"handles": [
		{
			"handle": "turandb@opera",
			"account": "1hpxnziaw2ec",
			"pub_addresses": [
				{
					"chain_code": "FIO",
					"token_code": "FIO",
					"public_address": "FIO5PJdEsMQ5Qd2otKVFSXru72KcMx4G2Vafo9MZ6NHttqYCiV5JP"
				},
				{
					"chain_code": "ETH",
					"token_code": "*",
					"public_address": "0x00000000"
				}
			]
		}
	],
	"pagination": {
		"limit": 100,
		"offset": 0,
		"total_records": 1,
		"next_offset": "",
		"previous_offset": ""
	}
}

/get_nft_signatures

Returns nft_signatures information.

Request

Parameter	Description
handle	Handle name
account	Account of handle owner
chain_code	Chain code
contract_address	Contract Address
token_id	Token ID
limit	Number of results to include. Default: 100
offset	Offset for pagination. Default: 0

Query

Return records from nft_signatures which match all request parameters.

account requires join on handles

handle status must be active

Sort by:

alphabetical: handle ASC

Response

Group	Field	Source Data
handles	handle	`handles`→ `handle`
handles	account	`handles`→ `account`
handles → nft_signatures	chain_code	`nft_signatures`→ `chain_code`
handles → nft_signatures	contract_address	`nft_signatures`→ `contract_address`
handles → nft_signatures	token_id	`nft_signatures`→ `token_id`
handles → nft_signatures	url	`nft_signatures`→ `url`
handles → nft_signatures	hash	`nft_signatures`→ `hash`
handles → nft_signatures	metadata	`nft_signatures`→ `metadata`
pagination	limit	Supplied limit
pagination	offset	Supplied offset
pagination	total_records	Total number of transactions which meet the criteria
pagination	next_offset	Offset to supply for next set of records: supplied offset + limit
pagination	previous_offset	Offset to supply for previous set of records: supplied offset - limit

Example

{
	"handles": [
		{
			"handle": "turandb@opera",
			"account": "1hpxnziaw2ec",
			"nft_signatures": [
				{
					"chain_code": "MATIC",
					"contract_address": "0x7bfc7492B32E40D7Dd9B0A241B5d0Ba9CCf1632B",
					"token_id": "24254130",
					"url": "",
					"hash": "",
					"metadata": ""
				}
			]
		}
	],
	"pagination": {
		"limit": 100,
		"offset": 0,
		"total_records": 1,
		"next_offset": "",
		"previous_offset": ""
	}
}

/get_token_transfers

Returns token_transfers information.

Request

Parameter	Description
time_start	Filters by `timestamp` of associated transaction
time_end	Filters by `timestamp` of associated transaction
payer_account	Payer account
payee_account	Payee account
type	Tranfser type
limit	Number of results to include. Default: 100
offset	Offset for pagination. Default: 0

Query

Return records from token_transfers which match all request parameters.

timestamp requires join on transactions

Sort by:

alphabetical: timestamp ASC

Response

Group	Field	Source Data
token_transfers	transaction_id	`transactions`→ `id`
token_transfers	timestamp	`transactions`→ `timestamp`
token_transfers	payer_account	`token_transfers`→ `payer_account`
token_transfers	payee_account	`token_transfers`→ `payee_account`
token_transfers	amount	`token_transfers`→ `amount`
token_transfers	type	`token_transfers`→ `type`
token_transfers	memo	`token_transfers`→ `memo`
pagination	limit	Supplied limit
pagination	offset	Supplied offset
pagination	total_records	Total number of transactions which meet the criteria
pagination	next_offset	Offset to supply for next set of records: supplied offset + limit
pagination	previous_offset	Offset to supply for previous set of records: supplied offset - limit

Example

{
	"token_transfers": [
		{
			"transaction_id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e",
			"timestamp": "2024-05-03T17:00:02.500",
			"payer_account": "xghrmfdenyu5",
			"payee_account": "fio.treasury",
			"amount": "55.399150882",
			"type": "blockchain_fee",
			"memo": "FIO fee: register_fio_address"
		}
	],
	"pagination": {
		"limit": 100,
		"offset": 0,
		"total_records": 1,
		"next_offset": "",
		"previous_offset": ""
	}
}

/get_fio_requests

Returns fio_request information.

Request

Parameter	Description
time_start	Filters by `timestamp` of associated transaction
time_end	Filters by `timestamp` of associated transaction
payee_handle	Payee FIO Handle
payer_handle	Payer FIO Handle
payee_account	Payee account
payer_account	Payer account
status	Request status
limit	Number of results to include. Default: 100
offset	Offset for pagination. Default: 0

Query

Return records from fio_request which match all request parameters.

timestamp requires join on transactions

payee_account and payer_account requires join on handles

Sort by:

alphabetical: timestamp ASC

Response

Group	Field	Source Data
fio_requests	id	`fio_requests`→ `id`
fio_requests	timestamp	`transactions`→ `timestamp`
fio_requests	payer_account	`handles`→ `account`
fio_requests	payee_account	`handles`→ `account`
fio_requests	payee_handle	`fio_requests`→ `payee_handle`
fio_requests	payer_handle	`fio_requests`→ `payer_handle`
fio_requests	content	`fio_requests`→ `content`
fio_requests	payee_pub_key	`fio_requests`→ `payee_pub_key`
fio_requests	payer_pub_key	`fio_requests`→ `payer_pub_key`
fio_requests	status	`fio_requests`→ `status`
fio_requests	transaction_id	`transactions`→ `id`
pagination	limit	Supplied limit
pagination	offset	Supplied offset
pagination	total_records	Total number of transactions which meet the criteria
pagination	next_offset	Offset to supply for next set of records: supplied offset + limit
pagination	previous_offset	Offset to supply for previous set of records: supplied offset - limit

Example

{
	"fio_requests": [
		{
			"id": 88,
			"timestamp": "2020-03-13T19:52:08",
			"payee_account": "xghrmfdenyu5",
			"payer_account": "1hpxnziaw2ec",
			"payee_handle": "pawel@fiotestnet",
			"payer_handle": "pawel@person",
			"content": "v6Kvk+CvQBGua4V1YpYjBekOzqA9LHWFfKXhfBnhewdGGm5PhPbwC8YQAIISpu/4mGDGR9JhCkyxLFH42Ei/EpSlUUsLD+3H5ckqQm9xFQc+lZdeOW9+6sMnePLsVTGvGF55Hqd1CE3xZaj6OjBz9A==",
			"payee_pub_key": "FIO8h1Aan6DZJsFjH91BGsQfNt2FsYbVyKeXFETNvYtTW9vaU81ay",
			"payer_pub_key": "FIO55BB3WmX7F1VDX7s8LjevJrU8g9G9ptpAmoZu7szYYBw19EZW4",
			"status": "requested",
			"transaction_id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e"
		}
	],
	"pagination": {
		"limit": 100,
		"offset": 0,
		"total_records": 1,
		"next_offset": "",
		"previous_offset": ""
	}
}

/get_fio_data

Returns fio_data information.

Request

Parameter	Description
time_start	Filters by `timestamp` of associated transaction
time_end	Filters by `timestamp` of associated transaction
payee_handle	Payee FIO Handle
payer_handle	Payer FIO Handle
payee_account	Payee account
payer_account	Payer account
status	Data status
limit	Number of results to include. Default: 100
offset	Offset for pagination. Default: 0

Query

Return records from fio_data which match all request parameters.

timestamp requires join on transactions

payee_account and payer_account requires join on handles

Sort by:

alphabetical: timestamp ASC

Response

Group	Field	Source Data
fio_data	request_id	`fio_data`→ `request_id`
fio_data	timestamp	`transactions`→ `timestamp`
fio_data	payer_account	`handles`→ `account`
fio_data	payee_account	`handles`→ `account`
fio_data	payee_handle	`fio_data`→ `payee_handle`
fio_data	payer_handle	`fio_data`→ `payer_handle`
fio_data	content	`fio_data`→ `content`
fio_data	payee_pub_key	`fio_data`→ `payee_pub_key`
fio_data	payer_pub_key	`fio_data`→ `payer_pub_key`
fio_data	status	`fio_data`→ `status`
fio_data	transaction_id	`transactions`→ `id`
pagination	limit	Supplied limit
pagination	offset	Supplied offset
pagination	total_records	Total number of transactions which meet the criteria
pagination	next_offset	Offset to supply for next set of records: supplied offset + limit
pagination	previous_offset	Offset to supply for previous set of records: supplied offset - limit

Example

{
	"fio_data": [
		{
			"request_id": 88,
			"timestamp": "2020-03-13T19:52:08",
			"payee_account": "xghrmfdenyu5",
			"payer_account": "1hpxnziaw2ec",
			"payee_handle": "pawel@fiotestnet",
			"payer_handle": "pawel@person",
			"content": "v6Kvk+CvQBGua4V1YpYjBekOzqA9LHWFfKXhfBnhewdGGm5PhPbwC8YQAIISpu/4mGDGR9JhCkyxLFH42Ei/EpSlUUsLD+3H5ckqQm9xFQc+lZdeOW9+6sMnePLsVTGvGF55Hqd1CE3xZaj6OjBz9A==",
			"payee_pub_key": "FIO8h1Aan6DZJsFjH91BGsQfNt2FsYbVyKeXFETNvYtTW9vaU81ay",
			"payer_pub_key": "FIO55BB3WmX7F1VDX7s8LjevJrU8g9G9ptpAmoZu7szYYBw19EZW4",
			"status": "sent_to_blockchain",
			"transaction_id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e"
		}
	],
	"pagination": {
		"limit": 100,
		"offset": 0,
		"total_records": 1,
		"next_offset": "",
		"previous_offset": ""
	}
}

/get_domain_activity

Returns domain_activity information.

Request

Parameter	Description
time_start	Filters by `timestamp` of associated transaction
time_end	Filters by `timestamp` of associated transaction
domain	Domain name
type	Type
owner_account	Domain owner account
limit	Number of results to include. Default: 100
offset	Offset for pagination. Default: 0

Query

Return records from domain_activity which match all request parameters.

timestamp requires join on transactions

owner_account requires join on domains

Sort by:

alphabetical: timestamp ASC

Response

Group	Field	Source Data
domain_activity	domain	`domain_activity`→ `domain`
domain_activity	transaction_id	`transactions`→ `id`
domain_activity	timestamp	`transactions`→ `timestamp`
domain_activity	account	`domains`→ `account`
domain_activity	type	`domain_activity`→ `type`
pagination	limit	Supplied limit
pagination	offset	Supplied offset
pagination	total_records	Total number of transactions which meet the criteria
pagination	next_offset	Offset to supply for next set of records: supplied offset + limit
pagination	previous_offset	Offset to supply for previous set of records: supplied offset - limit

Example

{
	"domain_activity": [
		{
			"domain": "bob",
			"transaction_id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e",
			"timestamp": "2020-03-13T19:52:08",
			"account": "1hpxnziaw2ec",
			"type": "register"
		}
	],
	"pagination": {
		"limit": 100,
		"offset": 0,
		"total_records": 1,
		"next_offset": "",
		"previous_offset": ""
	}
}

/get_handle_activity

Returns handle_activity information.

Request

Parameter	Description
time_start	Filters by `timestamp` of associated transaction
time_end	Filters by `timestamp` of associated transaction
handle	Handle name
type	Type
owner_account	Handle owner account
limit	Number of results to include. Default: 100
offset	Offset for pagination. Default: 0

Query

Return records from handle_activity which match all request parameters.

timestamp requires join on transactions

owner_account requires join on handles

Sort by:

alphabetical: timestamp ASC

Response

Group	Field	Source Data
handle_activity	domain	`handle_activity`→ `handle`
handle_activity	transaction_id	`transactions`→ `id`
handle_activity	timestamp	`transactions`→ `timestamp`
handle_activity	account	`handle_activity`→ `account`
handle_activity	type	`handle_activity`→ `type`
pagination	limit	Supplied limit
pagination	offset	Supplied offset
pagination	total_records	Total number of transactions which meet the criteria
pagination	next_offset	Offset to supply for next set of records: supplied offset + limit
pagination	previous_offset	Offset to supply for previous set of records: supplied offset - limit

Example

{
	"handle_activity": [
		{
			"handle": "turandb@opera",
			"transaction_id": "d3dcd291eb7caadab12f2b9bcacdc5df6b8a5c1455072d9454a3b43956677b6e",
			"timestamp": "2024-05-03T17:00:02.500",
			"account": "1hpxnziaw2ec",
			"type": "register"
		}
	],
	"pagination": {
		"limit": 100,
		"offset": 0,
		"total_records": 1,
		"next_offset": "",
		"previous_offset": ""
	}
}

Table of Contents

Overview

Components

Application Components

Data Pipeline

Database

API

Push Notification System

Specification

Deployment Requirements

Data Model

blocks

transactions

traces

accounts

account_activity

domains

domain_activity

handles

handle_activity

pub_addresses

nft_signatures

token_transfers

token_staking

fio_requests

fio_data

Parsing Rules

Trigger: every block

Table: blocks

Trigger: every trace where action_ordinal = 1

Table: transactions

Table: account_activity ​

Trigger: every trace where action_ordinal > 1

Table: traces

Trigger: fio.address:bind2eosio

Table: accounts

Table: account_activity

Trigger: fio.token:trnsfiopubky and action_ordinal = 1

Table: token_transfers

Trigger: fio.token:trnsloctoks and action_ordinal = 1

Table: token_transfers

Trigger: fio.token:transfer and receiver = fio.token

Table: token_transfers

Trigger: fio.token:issue and receiver = fio.token

Table: token_transfers

Trigger: fio.token:wraptokens and action_ordinal = 1

Table: token_transfers

Trigger: fio.token:stakefio and action_ordinal = 1

Table: token_staking

Trigger: fio.token:retire and action_ordinal = 1

Table: token_transfers ​

Trigger: fio.token:unstakefio and action_ordinal = 1

Table: token_staking

Trigger: fio.address:regdomain and action_ordinal = 1

Table: domains or (if exists based on domain)

Table: domain_activity

Table: account_activity

Trigger: fio.address:renewdomain and action_ordinal = 1

Table: domains

Table: domain_activity

Trigger: fio.address:xferdomain and action_ordinal = 1

Table: domains

Table: domain_activity

Table: account_activity

Trigger: fio.address:setdomainpub and action_ordinal = 1

Table: domains

Table: domain_activity

Trigger: fio.address:wrapdomain and action_ordinal = 1

Table: domains

Table: domain_activity

Table: account_activity

Trigger: fio.address:xferescrow

Table: domains

Table: domain_activity

Table: account_activity ​

Trigger: fio.address:regaddress and action_ordinal = 1

Table: handles or (if exists based on handle)

Table: handle_activity

Table: account_activity

Table: pub_addresses

Trigger: every trace where `action_ordinal = 1`

Table: account_activity

Trigger: every trace where `action_ordinal > 1`

Trigger: fio.token:trnsfiopubky and `action_ordinal = 1`

Trigger: fio.token:trnsloctoks and `action_ordinal = 1`

Trigger: fio.token:transfer and `receiver = fio.token`

Trigger: fio.token:issue and `receiver = fio.token`

Trigger: fio.token:wraptokens and `action_ordinal = 1`

Trigger: fio.token:stakefio and `action_ordinal = 1`

Trigger: fio.token:retire and `action_ordinal = 1`

Table: token_transfers

Trigger: fio.token:unstakefio and `action_ordinal = 1`

Trigger: fio.address:regdomain and `action_ordinal = 1`

Table: domains or (if exists based on `domain`)

Trigger: fio.address:renewdomain and `action_ordinal = 1`

Trigger: fio.address:xferdomain and `action_ordinal = 1`

Trigger: fio.address:setdomainpub and `action_ordinal = 1`

Trigger: fio.address:wrapdomain and `action_ordinal = 1`

Table: account_activity

Trigger: fio.address:regaddress and `action_ordinal = 1`

Table: handles or (if exists based on `handle`)

Trigger: fio.address:renewaddress and `action_ordinal = 1`

Trigger: fio.address:xferaddress and `action_ordinal = 1`

Table: account_activity

Trigger: fio.address:addbundles and `action_ordinal = 1`

Trigger: fio.address:addaddress and `action_ordinal = 1`

Trigger: fio.address:remaddress and `action_ordinal = 1`

Trigger: fio.address:remalladdr and `action_ordinal = 1`

Trigger: fio.address:addnft and `action_ordinal = 1`

Trigger: fio.address:remnft and `action_ordinal = 1`

Trigger: fio.address:remallnfts and `action_ordinal = 1`

Trigger: fio.address:updcryptkey and `action_ordinal = 1`

Trigger: fio.address:regdomadd and `action_ordinal = 1`

Trigger: fio.address:burnaddress and `action_ordinal = 1`

Trigger: fio.address:newfundsreq and `action_ordinal = 1`

Trigger: fio.address:cancelfndreq and `action_ordinal = 1`

Trigger: fio.address:rejectfndreq and `action_ordinal = 1`

Trigger: fio.address:recordobt and `action_ordinal = 1`

Trigger: Table Deltas: `added:false` and `kvo->table:domains`

Trigger: Table Deltas: `added:false` and `kvo->table:fionames`