Page Comparison

...

Field	Description	Relationship
number	Block number as generated by FIO Node	transactions ->block→ 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

...

Field	Description	Relationship
block_number	Block which contained this transaction	blocks ->number→ number
id	Transaction id	traces ->transaction→ 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

...

Field	Description	Relationship
id	Trace id. Auto-generated ID or transaction_id + action_ordinal, e.g. 770989df18fac96e48ca03d6702991d4462bebacceab8cf6b389507e998ca7fe-2
transaction_id	Transaction ID	transactions ->id→ id
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

...

Field

Description

Relationship

account

Account name

account_activity ->account→ account

domains ->account→ account

handles ->account→ account

token_transfers ->payer→ payer_account

token_transfers ->payee→ payee_account

token_staking → staker_account

fio_requests ->payee→ payee_account

fio_requests ->payer→ payer_account

fio_data ->payee→ payee_account

fio_data ->payer→ payer_account

public_key

Primary public key

...

Field	Description	Relationship
account	Account name	accounts ->account→ account
transaction_id	Transaction ID	transactions ->id→ id
type	Type of activity

domains

...

Field	Description	Relationship
domain	Domain name	domain_activity ->domain→ domain
account	Account name of current owner	accounts ->account→ account
is_public	Is domain public
expiration	Timestamp of domain expiration
status	Current status of domain

...

Field	Description	Relationship
domain	Domain name	domains ->domain→ domain
tracetransaction_id	Trace Transaction ID	traces->idtransactions → id
type	Type of activity

handles

...

Field	Description	Relationship
handle	Handle name	handle_activity ->handle→ handle pub_addresses ->handle→ handle nft_signatures ->handle→ handle fio_requests ->payer→ payer_handle fio_requests ->payee→ payee_handle fio_data ->payer→ payer_handle fio_data ->payee→ payee_handle
account	Account name of current owner	accounts ->account→ account
encryption_key	Encryption public key
encryption_key_set	Defines if encryption key was specifically set
bundled_tx	Bundled tx count
expiration	Timestamp of handle expiration
status	Current status of handle

...

Field	Description	Relationship
handle	Handle name	handles ->handle→ handle
tracetransaction_id	Trace Transaction ID	traces->idtransactions → id
type	Type of activity

pub_addresses

...

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

...

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

...

Field	Description	Relationship
payer_account	Account of payer (sender)	accounts ->account→ account
payee_account	Account of payee (receiver)	accounts ->account→ account
tracetransaction_id	Trace Transaction ID	traces->idtransactions → id
amount	Token amount in FIO
type	Type of transfer
memo	Memo in transfer

...

Field	Description	Relationship
staker_account	Account of staker	accounts ->account→ account
tracetransaction_id	Trace Transaction ID	traces->idtransactions → id
amount	Token amount in FIO, unstake will be negative

...

Field	Description	Relationship
id	FIO Request ID	fio_data ->request→ request_id
payee_handle	Handle of payer	handles ->handle→ handle
payer_handle	Handle of payee	handles ->handle→ handle
content	Encrypted blob
payee_pub_key	Public Key of payee
payer_pub_key	Public Key of payer
status	Status of request
tracetransaction_id	Trace Transaction ID	traces->idtransactions → 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→ id
payee_handle	Handle of payer	handles ->handle→ handle
payer_handle	Handle of payee	handles ->handle→ handle
content	Encrypted blob
payee_pub_key	Public Key of payee
payer_pub_key	Public Key of payer
status	Status of data
tracetransaction_id	Trace Transaction ID	traces->idtransactions → id

Parsing Rules

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

...

Table: traces
Status
colour Green
title NEW RECORD

Field	Source Data
idAuto-	generated ID or transaction_id + action_ordinal, e.g. 770989df18fac96e48ca03d6702991d4462bebacceab8cf6b389507e998ca7fe-2Trace ID
transaction_id	`trace` → `id`
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`

...

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

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

...

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

...

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

...

Field	Source Data
payer_account	`trace` → `action_traces` → `act` → `data` → `from`
payee_account	`trace` → `action_traces` → `act` → `data` → `to`
tracetransaction_id	Trace 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`

...

Field	Source Data
payer_account	“eosio”
payee_account	`trace` → `action_traces` → `act` → `data` → `to`
tracetransaction_id	Trace ID`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` → `quantity` (strip " FIO")
type	“token_mint”
memo	`trace` → `action_traces` → `act` → `data` → `memo`

...

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

...

Field	Source Data
staker_account	`trace` → `action_traces` → `act` → `data` → `actor`
tracetransaction_id	Trace ID`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` → `amount` / 1000000000

...

Field	Source Data
payer_account	`trace` → `action_traces` → `act` → `data` → `actor`
payee_account
tracetransaction_id	Trace ID`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` → `quantity` / 1000000000
type	“retire”
memo	`trace` → `action_traces` → `act` → `data` → `memo`

...

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

...

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

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

...

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

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

...

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

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

...

Field

Source Data

domain

trace → action_traces → act → data → fio_domain

tracetransaction_id

Trace IDtrace → id

type

is_public: 1 type is “public”

is_public: 0 type is “non-public”

...

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

Trigger: fio.address:xferescrow

...

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

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

...

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

Table: pub_addresses
Status
colour Green
title NEW RECORD

...

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

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

...

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

Table: pub_addresses
Status
colour Red
title DELETE
and
Status
colour Green
title NEW RECORD

...

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

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

...

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

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

...

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

Table: pub_addresses
Status
colour Red
title DELETE

...

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

Table: pub_addresses
Status
colour Red
title DELETE

...

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
transaction_id	`trace`_ → `id`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	`trace` → `action_traces` → `act` → `data` → `fio_address`
tracetransaction_id	Trace ID`trace` → `id`
type	“rem_nft”

Table: nft_signatures
Status
colour Red
title DELETE

...

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

Table: nft_signatures
Status
colour Red
title DELETE

...

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

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

...

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

Table: pub_addresses
Status
colour Red
title DELETE

...

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
tracetransaction_id	Trace ID`trace` → `id`
type	“new_request”

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”
tracetransaction_id	Trace ID`trace` → `id`

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

...

Field	Source Data
handle	`trace` → `action_traces` → `act` → `data` → `fio_address`
tracetransaction_id	Trace 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”trace_id	Trace ID

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

...

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

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”
tracetransaction_id	Trace ID`trace` → `id`

Table: fio_requests
Status
colour Yellow
title UPDATE

...

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

Versions Compared

Old Version 8

New Version 9

Key

domains

handles

pub_addresses

fio_data

Parsing Rules

Table: traces
Status
colour Green
title NEW RECORD

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

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

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

Table: pub_addresses
Status
colour Green
title NEW RECORD

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

Table: pub_addresses
Status
colour Red
title DELETE
and
Status
colour Green
title NEW RECORD

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

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

Table: pub_addresses
Status
colour Red
title DELETE

Table: pub_addresses
Status
colour Red
title DELETE

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

Table: nft_signatures
Status
colour Red
title DELETE

Table: nft_signatures
Status
colour Red
title DELETE

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

Table: pub_addresses
Status
colour Red
title DELETE

Table: fio_requests
Status
colour Green
title NEW RECORD

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

Table: fio_requests
Status
colour Yellow
title UPDATE

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

Table: fio_data
Status
colour Green
title NEW RECORD

Table: fio_requests
Status
colour Yellow
title UPDATE

Page Comparison

Versions Compared

Old Version 8

New Version 9

Key

domains

handles

pub_addresses

fio_data

Parsing Rules

Table: traces StatuscolourGreentitleNEW RECORD

Trigger: fio.token:trnsfiopubky and action_ordinal = 1

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

Trigger: fio.address:regaddress and action_ordinal = 1

Table: pub_addresses StatuscolourGreentitleNEW RECORD

Trigger: fio.address:xferaddress and action_ordinal = 1

Table: pub_addresses StatuscolourRedtitleDELETE and StatuscolourGreentitleNEW RECORD

Trigger: fio.address:addaddress and action_ordinal = 1

Table: pub_addresses StatuscolourGreentitleNEW RECORD or StatuscolourYellowtitleupdate (if exists)

Table: pub_addresses StatuscolourRedtitleDELETE

Table: pub_addresses StatuscolourRedtitleDELETE

Table: nft_signatures StatuscolourGreentitleNEW RECORD or StatuscolourYellowtitleupdate (if exists)

Table: nft_signatures StatuscolourRedtitleDELETE

Table: nft_signatures StatuscolourRedtitleDELETE

Trigger: fio.address:regdomadd and action_ordinal = 1

Table: pub_addresses StatuscolourRedtitleDELETE

Table: fio_requests StatuscolourGreentitleNEW RECORD

Trigger: fio.address:newfundsreq and action_ordinal = 1

Table: fio_requests StatuscolourYellowtitleUPDATE

Trigger: fio.address:recordobt and action_ordinal = 1

Table: fio_data StatuscolourGreentitleNEW RECORD

Table: fio_requests StatuscolourYellowtitleUPDATE

Table: traces
Status
colour Green
title NEW RECORD

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

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:regaddress and `action_ordinal = 1`

Table: pub_addresses
Status
colour Green
title NEW RECORD

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

Table: pub_addresses
Status
colour Red
title DELETE
and
Status
colour Green
title NEW RECORD

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

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

Table: pub_addresses
Status
colour Red
title DELETE

Table: pub_addresses
Status
colour Red
title DELETE

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

Table: nft_signatures
Status
colour Red
title DELETE

Table: nft_signatures
Status
colour Red
title DELETE

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

Table: pub_addresses
Status
colour Red
title DELETE

Table: fio_requests
Status
colour Green
title NEW RECORD

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

Table: fio_requests
Status
colour Yellow
title UPDATE

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

Table: fio_data
Status
colour Green
title NEW RECORD

Table: fio_requests
Status
colour Yellow
title UPDATE