Overview

FIO Relic is a fork of Antelope Memento and is intended to receive FIO Chain data stream from the FIO Chain Node via EOS Chronicle. FIO specific data is extracted from the stream and stored in a Relational Database (RDB) for future query via 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

...

This component is responsible for reading the data in the data stream and looking for FIO-specific data, parsing it, and inserting into RDB.

Example:

When an action registering FIO Domain is observed, insert it into domains table.

Query API

This component is responsible for receiving an API request, fetching relevant data from the RDB and returning to the API user.

Example:

Fetch all FIO Domains registered in specific time-frame.

Push Notification System

This component will be developed in Phase 2.

...

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.

...

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

Specification

Data Model

blocks

...

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

Status

colour	Green
title	FROM CHAIN DATA

Block number as generated by FIO Node

transactions → block_num

id

Status

colour	Green
title	FROM CHAIN DATA

Block ID as generated by FIO Node

timestamp

Status

colour	Green
title	FROM CHAIN DATA

Timestamp as generated by FIO Node

producer

Account name

Status

colour	Green
title	FROM CHAIN DATA

Account name of producer which produced the block

schedule_version

Status

colour	Green
title	FROM CHAIN DATA

Version of BP schedule

transactions

Add only. Every transaction is a new entry.

Field

Description

Relationship

block_number

Status

colour	Green
title	FROM CHAIN DATA

Block which contained this transaction

blocks → number

id

Status

colour	Green
title	FROM CHAIN DATA

Transaction id

traces → transaction_id

action_account

Status

colour	Green
title	FROM CHAIN DATA

Account name for action

action_name

Status

colour	Green
title	FROM CHAIN DATA

Action name

account

Status

colour	Green
title	FROM CHAIN DATA

Account which executed the transaction

tpid

Status

colour	Green
title	FROM CHAIN DATA

TPID which was recorded in tranaction

fee

Status

colour	Green
title	FROM CHAIN DATA

FIO Chain fee paid for this transaction

request_data

Raw request data for primary trace

response_data

Status

colour	Green
title	FROM CHAIN DATA

Raw request data for primary trace

response_data

Status

colour	Green
title	FROM CHAIN DATA

Raw response data for primary trace

status

Status

colour	Green
title	FROM CHAIN DATA

Transaction status

traces

Add only. Every trace is a new entry.

Field

Description

Relationship

idTrace id. Auto-generated ID or transaction_id + action_ordinal, e.g. 770989df18fac96e48ca03d6702991d4462bebacceab8cf6b389507e998ca7fe-2

Status

colour	Yellow
title	GENERATED

Trace ID - generated.

transaction_id

Status

colour	Green
title	FROM CHAIN DATA

Transaction ID

transactions → id

receiver

Status

colour	Green
title	FROM CHAIN DATA

Receiver of trace

action_ordinal

Status

colour	Green
title	FROM CHAIN DATA

Sequential order of trace in transaction

action_account

Account

Status

colour	Green
title	FROM CHAIN DATA

Account name for trace

action_name

Status

colour	Green
title	FROM CHAIN DATA

Action name fro trace

request_data

Status

colour	Green
title	FROM CHAIN DATA

Raw request data for trace

accounts

Add only. Every account created is a new entry.

Field

Description

Relationship

account

Status

colour	Green
title	FROM CHAIN DATA

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

Status

colour	Green
title	FROM CHAIN DATA

Primary public key

timestamp

Status

colour	Green
title	FROM CHAIN DATA

Block timestamp of when account was created

account_activity

Add only. Every activity is a new entry.

Field

Description

Relationship

account

Status

colour	Green
title	FROM CHAIN DATA

Account name

accounts → account

transaction_id

Status

colour	Green
title	FROM CHAIN DATA

Transaction ID

transactions → id

type

Status

Type of activity

colour

domains

...

Blue
title	DEFINED BY RULES

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

Status

colour	Green
title	FROM CHAIN DATA

Domain name

domain_activity → domain

account

Status

colour	Green
title	FROM CHAIN DATA

Status

colour	Blue
title	DEFINED BY RULES

Account name of current owner

accounts → account

is_public

Status

colour	Green
title	FROM CHAIN DATA

Is domain public

expiration

Status

colour	Green
title	FROM CHAIN DATA

Timestamp of domain expiration

status

Status

colour	Blue
title	DEFINED BY RULES

Current status of domain. Options:

active
burnt

domain_activity

Add only. Every activity is a new entry

Field

Description

Relationship

domain

Status

colour	Green
title	FROM CHAIN DATA

Domain name

domains → domain

transaction_id

Transaction ID

Status

colour	Green
title	FROM CHAIN DATA

Transaction ID

transactions → id

type

Status

colour	Blue
title	DEFINED BY RULES

Type of activity. Options:

register
renew
transfer
wrap
unwrap
auto_burn

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

Status

colour	Green
title	FROM CHAIN DATA

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

Status

colour	Blue
title	DEFINED BY RULES

Domain on which handle is registered. Right of @ in user@domain

domains → domain

account

Status

colour	Green
title	FROM CHAIN DATA

Account name of current owner

accounts → account

encryption_key

Status

colour	Green
title	FROM CHAIN DATA

Encryption public key

encryption_key_setDefines if encryption

Status

colour	Blue
title	DEFINED BY RULES

Defines if encryption key was specifically set. Options:

false (default)
true

bundled_tx

Status

colour	Green
title	FROM CHAIN DATA

Status

colour	Blue
title	DEFINED BY RULES

Bundled tx count

expiration

Status

colour	Green
title	FROM CHAIN DATA

Status

colour	Blue
title	DEFINED BY RULES

Timestamp of handle expiration

status

Status

colour	Blue
title	DEFINED BY RULES

Current status of handle. Options:

active
burnt

handle_activity

Add only. Every activity is a new entry

Field

Description

Relationship

handle

Status

colour	Green
title	FROM CHAIN DATA

Handle name

handles → handle

transaction_id

Status

colour	Green
title	FROM CHAIN DATA

Transaction ID

transactions → id

type

Type of activity

Status

colour	Blue
title	DEFINED BY RULES

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
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

Status

colour	Green
title	FROM CHAIN DATA

Handle name

handles → handle

chain_code

Status

colour	Green
title	FROM CHAIN DATA

Chain code

token_code

Status

colour	Green
title	FROM CHAIN DATA

Token code

public_address

Status

Public Address

...

colour	Green
title	FROM CHAIN DATA

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

Status

colour	Green
title	FROM CHAIN DATA

Handle name

handles → handle

chain_code

Status

colour	Green
title	FROM CHAIN DATA

Chain code

contract_address

Status

colour	Green
title	FROM CHAIN DATA

Contract address

token_id

Status

colour	Green
title	FROM CHAIN DATA

Token ID

url

Status

colour	Green
title	FROM CHAIN DATA

url

hash

Status

colour	Green
title	FROM CHAIN DATA

hash

metadata

Status

colour	Green
title	FROM CHAIN DATA

metadata

token_transfers

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

Field

Description

Relationship

staker_account

Account of staker

Field

Description

Relationship

payer_account

Account of payer (sender)

accounts → account

payee_account

Account of payee (receiver

Status

colour	Green
title	FROM CHAIN DATA

Status

colour	Blue
title	DEFINED BY RULES

Account of payer (sender)

accounts → account

transactionpayee_idaccount

Transaction ID

transactions → id

amount

Token amount in FIO

type

Type of transfer

memo

Memo in transfer

token_staking

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

Status

colour	Green
title	FROM CHAIN DATA

Status

colour	Blue
title	DEFINED BY RULES

Account of payee (receiver)

accounts → account

transaction_id

Status

colour	Green
title	FROM CHAIN DATA

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

...

transaction_id

...

Transaction ID

...

transactions → id

fio_data

...

Status

colour	Green
title	FROM CHAIN DATA

Status

colour	Blue
title	DEFINED BY RULES

Token amount in FIO

type

Status

colour	Blue
title	DEFINED BY RULES

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

Status

colour	Green
title	FROM CHAIN DATA

Memo in transfer

token_staking

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

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

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

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

Note
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

...

staker_account

Status

colour	Green
title	FROM CHAIN DATA

Account of staker

accounts → account

transaction_id

Status

colour	Green
title	FROM CHAIN DATA

Transaction ID

transactions → id

amount

Status

colour	Green
title	FROM CHAIN DATA

Status

colour	Blue
title	DEFINED BY RULES

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

Status

title
colour	Green

...

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`

...

FROM CHAIN DATA

FIO Request ID

fio_data → request_id

payee_handle

Status

colour	Green
title	FROM CHAIN DATA

Handle of payer

handles → handle

payer_handle

Status

title
colour	Green

...

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`
request_data	`trace` → `action_traces` → `act` → `data`
response_data	`response`
status	`trace` → `status`

Table: account_activity
Status
colour Green
title NEW RECORD

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

Trigger: every trace where `action_ordinal > 1`

...

FROM CHAIN DATA

Handle of payee

handles → handle

content

Status

colour	Green
title	FROM CHAIN DATA

Encrypted blob

payee_pub_key

Status

colour	Green
title	FROM CHAIN DATA

Public Key of payee

payer_pub_key

Status

colour	Green
title	FROM CHAIN DATA

Public Key of payer

status

Status

colour	Green
title	FROM CHAIN DATA

Status

colour	Blue
title	DEFINED BY RULES

Status of request. Options:

pending
cancelled
sent_to_blockchain

transaction_id

Status

colour	Green
title	FROM CHAIN DATA

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

Source Data

id

Trace ID

transaction_id

trace

Field

Description

Relationship

request_id

Status

title
colour	Green

...

FROM CHAIN DATA

FIO Request ID (optional)

fio_requests → id

action

payee_

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

...

handle

Status

colour	Green
title	FROM CHAIN DATA

Handle of payer

handles → handle

payer_handle

Status

title
colour	Green

...

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

...

FROM CHAIN DATA

Handle of payee

handles → handle

content

Status

title
colour	Green

...

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

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

...

FROM CHAIN DATA

Encrypted blob

payee_pub_key

Status

colour	Green
title	FROM CHAIN DATA

Public Key of payee

payer_pub_key

Status

title
colour	Green

...

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
Status
colour Green
title NEW RECORD

...

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

...

	FROM CHAIN DATA

Public Key of payer

status

Status

colour	Green
title	FROM CHAIN DATA

Status of data. Currently always “sent_to_blockchain”.

transaction_id

Status

colour	Green
title	FROM CHAIN DATA

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.

Note
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
Status
colour Green
title NEW RECORD

Field	Source Data
number

payer

block_

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
Status
colour Green
title NEW RECORD

Field

Source Data

payer_account

“eosio”

payee_

`num`
id	`block_id`
timestamp	`block_timestamp`
producer	`producer`
schedule_version	`schedule_version`

Trigger: every trace where `action_ordinal = 1`

Table: transactions
Status
colour Green
title NEW RECORD

...

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` →

data

authorization →

to

actor

transaction_id

tpid

trace →

id

amount

trace →

action_traces → act → data →

quantity (strip " FIO")

type

“token_mint”

memo

`tpid`
fee	`response` → `fee_collected` / 1000000000
request_data	`trace` → `action_traces` → `act` → `data`

→ memo

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

...


response_data	`response`
status	`trace` → `status`

Table: account_activity
Status
colour Green
title NEW RECORD

...

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

...

Transaction ID
type	“sender”

Trigger: every trace where `action_ordinal > 1`

Table:

...

traces
Status
colour Green
title NEW RECORD

Field	Source Data

staker_account

trace → action_traces → act → data → actor


id	Trace id. Auto-generated ID or transaction_id + action_ordinal, e.g. 770989df18fac96e48ca03d6702991d4462bebacceab8cf6b389507e998ca7fe-2
transaction_id	`trace` → `id`

amount

receiver

trace → action_traces →

act → data → amount / 1000000000

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

Table: token_transfers
Status
colour Green
title NEW RECORD

Field

Source Data

payer

`receiver`
action_ordinal	`trace` → `action_traces` → `action_ordinal`
action_account	`trace` → `action_traces` → `act` →

data → actorpayee_

account

transaction_id

trace → id

amount

type

“retire”

memo

action_name

trace → action_traces → act →

data → quantity / 1000000000

`name`
request_data	`trace` → `action_traces` → `act` → `data`

→ memo

Trigger: fio.

...

address:bind2eosio

Table:

...

accounts
Status
colour Green
title NEW RECORD

Field	Source Data

staker_

account

trace → action_traces → act → data →

actor

account

transaction_id

trace → id

amount

Negative of (

public_key

trace → action_traces → act → data →

amount / 1000000000)

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

...

`client_key`
timestamp	`block_timestamp`

Table: account_activity
Status
colour Green
title NEW RECORD

...

Status

colour	Yellow
title	update

...

Field	Source Data

domain

account

trace → action_traces → act → data →

fio

name

transaction_

domain

id

account

trace →

action_traces → act → data → owner_fio_public_key hashed to account

is_public

“false”

expiration

response → expiration

status

“active"

...

`id`
type	“receiver”

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

Table: token_transfers
Status
colour Green
title NEW RECORD

Field	Source Data

domain

payer_account

trace → action_traces → act → data →

fio_domain

actor

transaction

payee_

id

account

trace

→ id

type

“register”

→ `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
Status
colour

...

Green
title

...

NEW RECORD

Field	Source Data

domain

Field

Source Data

domain

payer_account

trace → action_traces → act → data →

fio_domain

expiration

response → expiration

Table: domain_activity
Status
colour Green
title NEW RECORD

`actor`
payee_account	`trace` → `action_traces` → `act` → `data` →

fio_domain

`payee_public_key` hashed to account
transaction_id	`trace` → `id`

type

“renew”

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

...

amount	`trace` → `action_traces` → `act` → `data` → `amount` / 1000000000
type	“transfer_locked”
memo

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

Table: token_transfers
Status
colour

...

Green
title

...

NEW RECORD

Field	Source Data

domain

payer_account

trace → action_traces → act → data →

fio

from

payee_

domain

account

trace → action_traces → act → data →

new_owner_fio_public_key hashed

to

account

...

transaction_

...

id

...

Field

Source Data

domain

trace → id

...

colour	Green
title	NEW RECORD

amount

trace → action_traces → act → data →

fio_domain

transaction_id

trace → id

Field

Source Data

domain

quantity (strip " FIO")

type

“transfer”

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

Table: domains
Status
colour Yellow
title update

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`

...

is_public

...

trace → action_traces → act → data → is_public (1 - true; 0 - false)

...

`.token`

Table: token_transfers
Status
colour Green
title NEW RECORD

Field	Source Data

domain


payer_account	“eosio”
payee_account	`trace` → `action_traces` → `act` → `data` →

fio_domain

`to`
transaction_id	`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` → `quantity` (strip " FIO")
type

is_public: 1 type is “public”

is_public: 0 type is “non-public”

“token_mint”
memo	`trace` → `action_traces` → `act` → `data` → `memo`

Trigger: fio.

...

token:

...

wraptokens and `action_ordinal = 1`

Table:

...

token_transfers
Status
colour

...

Green
title

...

NEW RECORD

Field	Source Data

domain

payer_account

trace → action_traces → act → data →

fio

actor

payee_

domain

account

“fio.

oracle”

Table: domain_activity
Status
colour Green
title NEW RECORD

Field

Source Data

domain

transaction_id

trace → id

oracle"
transaction_id	`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` →

fio_domain

`amount` / 1000000000
type	“wrap”
memo

Trigger: fio.

...

token:stakefio and `action_ordinal = 1`

Table:

...

token_staking
Status
colour

...

Green
title

...

NEW RECORD

Field	Source Data

domain

staker_account

trace → action_traces → act → data →

fio_domainaccount

`actor`
transaction_id	`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` →

public_key hashed to account

amount / 1000000000

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

Table:

...

token_

...

transfers
Status
colour Green
title NEW RECORD

Field	Source Data

domain

payer_account

trace → action_traces → act → data →

fio

actor

payee_

domain

account
transaction_id	`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` → `quantity` / 1000000000
type

“unwrap”

	“retire”
memo	`trace` → `action_traces` → `act` → `data` → `memo`

Trigger: fio.

...

token:

...

unstakefio and `action_ordinal = 1`

Table:

...

token_staking
Status
colour Green
title NEW RECORD

...

Field	Source Data

handle

staker_account

trace → action_traces → act → data →

fio

actor

transaction_

address

id

account

encryption_key

trace →

action_traces → act → data → owner_fio_public_key hashed to account

`id`
amount	Negative of (`trace` → `action_traces` → `act` → `data` →

owner_fio_public_key

encryption_key_set

“false”

bundled_tx

“100”

amount / 1000000000)

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

Table: domains
Status
colour Green
title NEW RECORD
or
Status
colour Yellow
title update
(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
is_public	“false”
expiration	`response` → `expiration`
status	“active"

Table:

...

domain_activity
Status
colour Green
title NEW RECORD

Field	Source Data

handle

domain

trace → action_traces → act → data → fio_

address

`domain`
transaction_id	`trace` → `id`
type	“register”

Table:

...

account_

...

activity
Status
colour Green
title NEW RECORD

...

Field

...

Source Data

...

handle

...

Only insert if trace → action_traces → act → data →

...

chain_code

...

“FIO”

...

token_code

...

“FIO”

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
Status
colour Yellow
title update

Field	Source Data

handle

domain

trace → action_traces → act → data → fio_

address

bundled_tx

Increment current value by “100”

`domain`
expiration	`response` → `expiration`

Table:

...

domain_activity
Status
colour Green
title NEW RECORD

Field	Source Data

handle

domain

trace → action_traces → act → data → fio_

address

`domain`
transaction_id	`trace` → `id`
type	“renew”

Trigger: fio.address:

...

xferdomain and `action_ordinal = 1`

Table:

...

domains
Status
colour Yellow
title update

Field	Source Data

handle

domain

trace → action_traces → act → data → fio_

address

`domain`
account	`trace` → `action_traces` → `act` → `data` → `new_owner_fio_public_key` hashed to account

encryption_key

Table: domain_activity
Status
colour Green
title NEW RECORD

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` →

new_owner_

fio_

public_key

encryption_key_set

“false”

`domain`
transaction_id	`trace` → `id`
type	“transfer”

Table:

...

account_activity
Status
colour Green
title NEW RECORD

...

Field	Source Data

handle

account

trace → action_traces → act → data → new_owner_fio

_address

`_public_key` hashed to account
transaction_id	`trace` → `id`
type

“transfer”

...

Status

colour	Red
title	DELETE

...

“receiver”

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

Table: domains
Status
colour

...

Yellow
title

...

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

update

Field	Source Data

handle

domain

trace → action_traces → act → data → fio_

address

chain_code

“FIO”

token_code

“FIO”

public_address

`domain`
is_public	`trace` → `action_traces` → `act` → `data` →

new_owner_fio_public_key

is_public (1 - true; 0 - false)

Table:

...

domain_

...

activity
Status
colour

...

Green
title

...

NEW RECORD

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
Status
colour Yellow
title update

Field	Source Data

handle

domain

trace → action_traces → act → data → fio_

addressIncrement current value by trace → action_traces → act → data → bundle_sets * 100

domain

bundled_tx

account

“fio.oracle”

Table:

...

domain_activity
Status
colour Green
title NEW RECORD

Field	Source Data

handle

domain

trace → action_traces → act → data → fio_

address

`domain`
transaction_id	`trace` → `id`
type

“add_bundles”

“wrap”

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

...

Table: account_activity
Status
colour Green
title NEW RECORD

Field	Source Data

handle

trace → action_traces → act → data → fio_address

account	“fio.oracle”
transaction_id	`trace` → `id`
type

“add_pubbadd”

“receiver”

Trigger: fio.address:xferescrow

Table:

...

domains
Status
colour

...

Yellow
title

...

update

...

Field

...

Source Data

...

colour	Yellow
title	update

...

domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
account	`trace` → `action_traces` → `act` → `data` → `public_`

...

key hashed to account

Table: domain_activity
Status
colour Green
title NEW RECORD

Field	Source Data

handle

domain

trace → action_traces → act → data → fio_

address

domain

chain

transaction_

code

id

trace →

action_traces → act → data → public_addresses → chain_codetoken_code

`id`
type	“unwrap”

Table: account_activity
Status
colour Green
title NEW RECORD

Field	Source Data
account	`trace` → `action_traces` → `act` → `data` → `public`

_addresses → token_code

public_address

trace → action_traces → act → data → public_addresses → public_address

`_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
Status
colour

...

Green
title

...

NEW RECORD
or
Status
colour Yellow
title update
(if exists based on `handle`)

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

encryption_key

domain

Domain from (trace → action_traces → act → data →

public

fio_

addresses → public_address

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

Table: handle_activity
Status
colour Green
title NEW RECORD

Field

Source Data

handle

`address`) split by @ and take second param.
account	`trace` → `action_traces` → `act` → `data` → `owner_fio_`

address

transaction_id

trace → id

type

“rem_pubbadd”

...

`public_key` hashed to account
encryption_key	`trace` → `action_traces` → `act` → `data` → `owner_fio_public_key`
encryption_key_set	“false”
bundled_tx	“100”
expiration	`response` → `expiration`
status	“active"

Table: handle_activity
Status
colour

...

Green
title

...

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

NEW RECORD

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

chain_code


transaction_id	`trace` → `id`
type	“register”

Table: account_activity
Status
colour Green
title NEW RECORD

...

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
Status
colour Green
title NEW RECORD

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

public

owner_fio_

addresses →

public_

address

key

Trigger: fio.address:

...

renewaddress and `action_ordinal = 1`

Table:

...

handles
Status
colour

...

Yellow
title

...

update

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

transaction

bundled_

id

trace → id

type

“rem_all_pubbadd”

tx	Increment current value by “100”
expiration	`response` → `expiration`

Table:

...

handle_

...

activity
Status
colour

...

Green
title

...

NEW RECORD

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
Status
colour

...

Yellow
title

...

update

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

transaction_id

account

trace →

id

type

“add_nft”

Table: nft_signatures
Status
colour Green
title NEW RECORD
or
Status
colour Yellow
title update
(if exists)

...

Field

Source Data

handle

action_traces → act → data →

...

`new_owner_fio_public_key` hashed to account
encryption_key	`trace` → `action_traces` → `act` → `data` → `new_owner_fio_`

addresschain

public_

code

key

trace → action_traces → act → data → nfts-> chain_code

contract_address

encryption_key_set

“false”

Table: handle_activity
Status
colour Green
title NEW RECORD

...

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` →

nfts→ contract

fio_address

token

transaction_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`

...

type	“transfer”

Table: account_activity
Status
colour Green
title NEW RECORD

Field	Source Data

handle

account

trace → action_traces → act → data → new_owner_fio

_address

`_public_key` hashed to account
transaction_id	`trace` → `id`
type

“rem_nft”

“receiver”

Table:

...

pub_

...

addresses
Status
colour Red
title DELETE
and
Status
colour

...

Green
title NEW RECORD

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

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

trace → action_traces → act → data → nfts-> chain_code

contract

“FIO”
token_code	“FIO”
public_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

new_owner_fio_public_key

Table: nft_signatures
Status
colour Red
title DELETE

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

...

fio_address

Trigger: fio.address:

...

addbundles and `action_ordinal = 1`

Table:

...

handles
Status
colour

...

Yellow
title

...

update

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

transaction

bundled_

id

tx	Increment current value by `trace` →

id

type

“rem_all_nft”

action_traces → act → data → bundle_sets * 100

Table:

...

handle_

...

activity
Status
colour

...

Green
title

...

NEW RECORD

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
Status
colour

...

Green
title

...

NEW RECORD

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

encryption

transaction_

key

id

trace →

action_traces → act → data → encrypt_public_key

encryption_key_set

“true”

...

`id`
type	“add_pubbadd”

Table: pub_addresses
Status
colour Green
title NEW RECORD

...

Field

...

Source Data

...

handle

or
Status
colour Yellow
title update
(if exists)

...

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

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

...

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`

status

“burnt”

Table: handle_activity
Status
colour Green
title NEW RECORD

Field

Source Data

handle

chain_code

trace → action_traces → act → data → public_addresses →

fio

chain_

address

code

transaction

token_

id

code

trace →

id

type

“self_burn”

Table: pub_addresses
Status
colour Red
title DELETE

...

`action_traces` → `act` → `data` → `public_addresses` → `token_code`
public_address	`trace` → `action_traces` → `act` → `data` →

...

public_addresses → public_address

Table:

...

handles
Status
colour

...

Yellow
title

...

update

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
Status
colour Green
title NEW RECORD

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

“new

“rem_

request”

pubbadd”

Table:

...

pub_

...

addresses
Status
colour

...

Red
title

...

DELETE

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

Field	Source Data

id

response → fio_request_id

payee_

handle

trace → action_traces → act → data →

payee_

fio_address

payer

chain_

handle

code	`trace` → `action_traces` → `act` → `data` →

payer

public_

fio

addresses → chain_

address

code

content

token_code

trace → action_traces → act → data →

content

payee_pub_key

Look-up accounts → encrypt_key where account is owner of

payer_pub_key

Look-up accounts → encrypt_key where account is owner of trace → action_traces → act → data → payer_fio_address

status

“pending”

transaction_id

trace → id

`public_addresses` → `token_code`
public_address	`trace` → `action_traces` → `act` → `data` →

payee_fio_address

public_addresses → public_address

Trigger: fio.address:

...

remalladdr and `action_ordinal = 1`

Table: handle_activity
Status
colour Green
title NEW RECORD

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

“cancel

“rem_all_

request”

pubbadd”

Table:

...

pub_

...

addresses
Status
colour

...

Red
title

...

Field

...

Source Data

...

id

DELETE

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

...

status

...

“cancelled”

address

Trigger: fio.address:

...

addnft and `action_ordinal = 1`

Table: handle_activity
Status
colour Green
title NEW RECORD

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

“record

“add_

obt”

nft”

Table:

...

nft_

...

signatures
Status
colour Green
title NEW RECORD

...

Field

...

Source Data

...

request_id

...

trace → action_traces → act → data → fio_request_id

...

or
Status
colour Yellow
title update
(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` →

payee_

fio_address

payer

chain_

handle

code	`trace` → `action_traces` → `act` → `data` →

payer_fio

nfts-> chain_code

contract_address

content

trace → action_traces → act → data → nfts→

content

contract_address

payee

token_

pub_keyLook-up accounts → encrypt_key where account is owner of

id	`trace` → `action_traces` → `act` → `data` → `nfts`→

payee

token_

fio_address

payer_pub_key

Look-up accounts → encrypt_key where account is owner of

`id`
url	`trace` → `action_traces` → `act` → `data`

→ payer_fio_address

status

“sent_to_blockchain”

→ `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
Status
colour Green
title NEW RECORD

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

Table:

...

nft_

...

signatures
Status
colour

...

Red
title

...

DELETE

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

Field	Source Data

id

handle

trace → action_traces → act → data → fio_

request_id

status

“sent_to_blockchain”

`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
Status
colour Green
title NEW RECORD

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

Table: nft_signatures
Status
colour Red
title DELETE

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

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

Table: handles
Status
colour Yellow
title update

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
Status
colour Green
title NEW RECORD

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
Status
colour Yellow
title update

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

Table: handle_activity
Status
colour Green
title NEW RECORD

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

Table: pub_addresses
Status
colour Red
title DELETE

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

Table: nft_signatures
Status
colour Red
title DELETE

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

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

Table: handle_activity
Status
colour Green
title NEW RECORD

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

Table: account_activity
Status
colour Green
title NEW RECORD

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

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
Status
colour Green
title NEW RECORD

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 `accounts` → `encrypt_key` where account is owner of `trace` → `action_traces` → `act` → `data` → `payee_fio_address`
payer_pub_key	Look-up `accounts` → `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
Status
colour Green
title NEW RECORD

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

Table: fio_requests
Status
colour Yellow
title UPDATE

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

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

Table: handle_activity
Status
colour Green
title NEW RECORD

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

Table: account_activity
Status
colour Green
title NEW RECORD

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

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_data
Status
colour Green
title NEW RECORD

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 `accounts` → `encrypt_key` where account is owner of `trace` → `action_traces` → `act` → `data` → `payee_fio_address`
payer_pub_key	Look-up `accounts` → `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
Status
colour Yellow
title UPDATE

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
Status
colour Yellow
title update

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

Table: domain_activity
Status
colour Green
title NEW RECORD

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

Table: handles
Status
colour Yellow
title update

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

Table: handle_activity
Status
colour Green
title NEW RECORD

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

API

/get_blocks

Returns block information.

Request

Parameter

Description

time_start

Status

colour	Green
title	OPTIONAL

Filters block by timestamp

time_end

Status

colour	Green
title	OPTIONAL

Filters block by timestamp

producer

Status

colour	Green
title	OPTIONAL

Filters block by producer

sort

Status

colour	Green
title	OPTIONAL

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

Code Block

language	json

{
	"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

Status

colour	Green
title	OPTIONAL

Filters block by timestamp

time_end

Status

colour	Green
title	OPTIONAL

Filters block by timestamp

block_number

Status

colour	Green
title	OPTIONAL

Filters block by block_number

action_account

Status

colour	Green
title	OPTIONAL

Filters block by action_account

action_name

Status

colour	Green
title	OPTIONAL

Filters block by action_name

impacted_account

Status

colour	Green
title	OPTIONAL

Filters by impacted account (see below)

impacted_account_direction

Status

colour	Green
title	OPTIONAL

Filters by impacted account direction (see below)

both (default)
sender
receiver

include_traces

Status

colour	Green
title	OPTIONAL

If true include traces

true (default)
false

sort

Status

colour	Green
title	OPTIONAL

Sorting of results:

timestamp_asc (default)
timestamp_desc

limit

Status

colour	Green
title	OPTIONAL

Number of results to include. Default: 100

offset

Status

colour	Green
title	OPTIONAL

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

Code Block

language	json

{
	"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

Status

colour	Green
title	OPTIONAL

Filters accounts by timestamp

time_end

Status

colour	Green
title	OPTIONAL

Filters accounts by timestamp

sort

Status

colour	Green
title	OPTIONAL

Sorting:

timestamp_asc (default)
timestamp_desc

limit

Status

colour	Green
title	OPTIONAL

Number of results to include. Default: 100

offset

Status

colour	Green
title	OPTIONAL

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

Code Block

language	json

{
	"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

Status

colour	Green
title	OPTIONAL

Account of domain owner

is_public

Status

colour	Green
title	OPTIONAL

is_public flag. Default is not present (both are returned)

true
false

status

Status

colour	Green
title	OPTIONAL

Status of domain

active (default)
burnt
both

sort

Status

colour	Green
title	OPTIONAL

Sorting:

alphabetical (default)
expiration_asc
expiration_desc

limit

Status

colour	Green
title	OPTIONAL

Number of results to include. Default: 100

offset

Status

colour	Green
title	OPTIONAL

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

Code Block

language	json

{
	"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

Status

colour	Green
title	OPTIONAL

Handle name

account

Status

colour	Green
title	OPTIONAL

Account of handle owner

domain

Status

colour	Green
title	OPTIONAL

Domain of handle

status

Status

colour	Green
title	OPTIONAL

Status of handle

active (default)
burnt
both

bundled_tx_max

Status

colour	Green
title	OPTIONAL

Maximum number of bundled_tx. When supplied only handles which have less than or equal number of bundled_tx will be returned.

limit

Status

colour	Green
title	OPTIONAL

Number of results to include. Default: 100

offset

Status

colour	Green
title	OPTIONAL

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	bundled_tx	`handles`→ `bundled_tx`
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

Code Block

language	json

{
	"handles": [
		{
			"handle": "turandb@opera",
			"account": "1hpxnziaw2ec",
			"domain": "opera",
			"encryption_key": "FIO5PJdEsMQ5Qd2otKVFSXru72KcMx4G2Vafo9MZ6NHttqYCiV5JP",
			"encryption_key_set": false,
			"bundled_tx": 100,
			"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

Status

colour	Green
title	OPTIONAL

Handle name

account

Status

colour	Green
title	OPTIONAL

Account of handle owner

chain_code

Status

colour	Green
title	OPTIONAL

Chain code

token_code

Status

colour	Green
title	OPTIONAL

Token code

public_address

Status

colour	Green
title	OPTIONAL

Public Address

limit

Status

colour	Green
title	OPTIONAL

Number of results to include. Default: 100

offset

Status

colour	Green
title	OPTIONAL

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

Code Block

language	json

{
	"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

Status

colour	Green
title	OPTIONAL

Handle name

account

Status

colour	Green
title	OPTIONAL

Account of handle owner

chain_code

Status

colour	Green
title	OPTIONAL

Chain code

contract_address

Status

colour	Green
title	OPTIONAL

Contract Address

token_id

Status

colour	Green
title	OPTIONAL

Token ID

limit

Status

colour	Green
title	OPTIONAL

Number of results to include. Default: 100

offset

Status

colour	Green
title	OPTIONAL

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

Code Block

language	json

{
	"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

Status

colour	Green
title	OPTIONAL

Filters by timestamp of associated transaction

time_end

Status

colour	Green
title	OPTIONAL

Filters by timestamp of associated transaction

payer_account

Status

colour	Green
title	OPTIONAL

Payer account

payee_account

Status

colour	Green
title	OPTIONAL

Payee account

type

Status

colour	Green
title	OPTIONAL

Tranfser type

limit

Status

colour	Green
title	OPTIONAL

Number of results to include. Default: 100

offset

Status

colour	Green
title	OPTIONAL

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

Code Block

language	json

{
	"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

Status

colour	Green
title	OPTIONAL

Filters by timestamp of associated transaction

time_end

Status

colour	Green
title	OPTIONAL

Filters by timestamp of associated transaction

payee_handle

Status

colour	Green
title	OPTIONAL

Payee FIO Handle

payer_handle

Status

colour	Green
title	OPTIONAL

Payer FIO Handle

payee_account

Status

colour	Green
title	OPTIONAL

Payee account

payer_account

Status

colour	Green
title	OPTIONAL

Payer account

status

Status

colour	Green
title	OPTIONAL

Request status

limit

Status

colour	Green
title	OPTIONAL

Number of results to include. Default: 100

offset

Status

colour	Green
title	OPTIONAL

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

Code Block

language	json

{
	"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

Status

colour	Green
title	OPTIONAL

Filters by timestamp of associated transaction

time_end

Status

colour	Green
title	OPTIONAL

Filters by timestamp of associated transaction

payee_handle

Status

colour	Green
title	OPTIONAL

Payee FIO Handle

payer_handle

Status

colour	Green
title	OPTIONAL

Payer FIO Handle

payee_account

Status

colour	Green
title	OPTIONAL

Payee account

payer_account

Status

colour	Green
title	OPTIONAL

Payer account

status

Status

colour	Green
title	OPTIONAL

Data status

limit

Status

colour	Green
title	OPTIONAL

Number of results to include. Default: 100

offset

Status

colour	Green
title	OPTIONAL

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

Code Block

language	json

{
	"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

Status

colour	Green
title	OPTIONAL

Filters by timestamp of associated transaction

time_end

Status

colour	Green
title	OPTIONAL

Filters by timestamp of associated transaction

domain

Status

colour	Green
title	OPTIONAL

Domain name

type

Status

colour	Green
title	OPTIONAL

Type

owner_account

Status

colour	Green
title	OPTIONAL

Domain owner account

limit

Status

colour	Green
title	OPTIONAL

Number of results to include. Default: 100

offset

Status

colour	Green
title	OPTIONAL

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

Code Block

language	json

{
	"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

Status

colour	Green
title	OPTIONAL

Filters by timestamp of associated transaction

time_end

Status

colour	Green
title	OPTIONAL

Filters by timestamp of associated transaction

handle

Status

colour	Green
title	OPTIONAL

Handle name

type

Status

colour	Green
title	OPTIONAL

Type

owner_account

Status

colour	Green
title	OPTIONAL

Handle owner account

limit

Status

colour	Green
title	OPTIONAL

Number of results to include. Default: 100

offset

Status

colour	Green
title	OPTIONAL

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

Code Block

language	json

{
	"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": ""
	}
}

Page Comparison

Versions Compared

Old Version 9

New Version Current

Key

Table of Contents

Overview

Components

Application Components

Data

Query API

Push Notification System

Pipeline

Database

API

Push Notification System

Specification

Data Model

blocks

Deployment Requirements

Data Model

blocks

transactions

traces

accounts

account_activity

domains

domains

domain_activity

handles

handle_activity

pub_addresses

nft_signatures

token_transfers

token_staking

fio_requests

fio_data

token_staking

Parsing Rules

Trigger: every block

fio_requests

Trigger: every trace where action_ordinal = 1

Table: account_activity ​ StatuscolourGreentitleNEW RECORD

Trigger: every trace where action_ordinal > 1

fio_data

Trigger: fio.address:bind2eosio

Trigger: fio.token:trnsfiopubky and action_ordinal = 1

Trigger: fio.token:trnsloctoks and action_ordinal = 1

Table: token_transfers StatuscolourGreentitleNEW RECORD

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

Parsing Rules

Trigger: every block

Table: blocks StatuscolourGreentitleNEW RECORD

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

Table: token_transfers StatuscolourGreentitleNEW RECORD

Trigger: every trace where action_ordinal = 1

Table: transactions StatuscolourGreentitleNEW RECORD

Trigger: fio.token:wraptokens and action_ordinal = 1

Table: account_activity ​ StatuscolourGreentitleNEW RECORD

Trigger: every trace where action_ordinal > 1

Table:

traces StatuscolourGreentitleNEW RECORD

Trigger: fio.token:retire and action_ordinal = 1

Table: token_transfers ​ StatuscolourGreentitleNEW RECORD

Trigger: fio.

address:bind2eosio

Table:

accounts StatuscolourGreentitleNEW RECORD

Trigger: fio.address:regdomain and action_ordinal = 1

Table: account_activity StatuscolourGreentitleNEW RECORD

Trigger: fio.token:trnsfiopubky and action_ordinal = 1

Table: token_transfers StatuscolourGreentitleNEW RECORD

Trigger: fio.

token:

trnsloctoks and action_ordinal = 1

Table:

token_transfers Statuscolour

Greentitle

NEW RECORD

Table: domain_activity StatuscolourGreentitleNEW RECORD

Trigger: every trace where `action_ordinal = 1`

Table: account_activity
Status
colour Green
title NEW RECORD

Trigger: every trace where `action_ordinal > 1`

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

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

Table: token_transfers
Status
colour Green
title NEW RECORD

Table: blocks
Status
colour Green
title NEW RECORD

Table: token_transfers
Status
colour Green
title NEW RECORD

Trigger: every trace where `action_ordinal = 1`

Table: transactions
Status
colour Green
title NEW RECORD

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

Table: account_activity
Status
colour Green
title NEW RECORD

Trigger: every trace where `action_ordinal > 1`

traces
Status
colour Green
title NEW RECORD

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

Table: token_transfers
Status
colour Green
title NEW RECORD

accounts
Status
colour Green
title NEW RECORD

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

Table: account_activity
Status
colour Green
title NEW RECORD

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

Table: token_transfers
Status
colour Green
title NEW RECORD

trnsloctoks and `action_ordinal = 1`

token_transfers
Status
colour

Green
title

Table: domain_activity
Status
colour Green
title NEW RECORD

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

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

Table: token_transfers
Status
colour

Green
title

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

Table: domains
Status
colour Yellow
title update

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

`.token`

Table: token_transfers
Status
colour Green
title NEW RECORD

wraptokens and `action_ordinal = 1`

token_transfers
Status
colour

Green
title

Table: domain_activity
Status
colour Green
title NEW RECORD

token:stakefio and `action_ordinal = 1`

token_staking
Status
colour

Green
title

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

transfers
Status
colour Green
title NEW RECORD

unstakefio and `action_ordinal = 1`

token_staking
Status
colour Green
title NEW RECORD

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

Table: domains
Status
colour Green
title NEW RECORD
or
Status
colour Yellow
title update
(if exists based on `domain`)

domain_activity
Status
colour Green
title NEW RECORD

activity
Status
colour Green
title NEW RECORD

renewdomain and `action_ordinal = 1`

domains
Status
colour Yellow
title update

domain_activity
Status
colour Green
title NEW RECORD

xferdomain and `action_ordinal = 1`

domains
Status
colour Yellow
title update

Table: domain_activity
Status
colour Green
title NEW RECORD

account_activity
Status
colour Green
title NEW RECORD

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

Table: domains
Status
colour

Yellow
title

activity
Status
colour

Green
title

wrapdomain and `action_ordinal = 1`

domains
Status
colour Yellow
title update

domain_activity
Status
colour Green
title NEW RECORD