Page Comparison

...

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`	`block_num`
`id`	`block_id`
`timestamp`	`block_timestamp`
`producer`	`producer`
`schedule_version`	`schedule_version`

Trigger: every

...

trace and `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` → `authorization` → `actor` for `action_ordinal = 1`
`tpid`	`trace` → `action_traces` → `act` → `data` → `tpid`
`fee`	`response` → `fee_collected`
`request_data`	`trace` → `action_traces` → `act` → `data`for `action_ordinal = 1`
`response_data`	`response`
`status`	`trace` → `status`

Trigger: every trace

Table: traces
Status
colour Green
title NEW RECORD

Field	Source Data
`id`	Auto-generated ID
`transaction_id`	`trace` → `id`
`action_account`	`trace` → `action_traces` → `act` → `account`
`action_name`	`trace` → `action_traces` → `act` → `name`
`request_data`	`trace` → `action_traces` → `act` → `data`

Trigger:

...

fio.address:

...

bind2eosio

Table: accounts
Status
colour Green
title NEW RECORD

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

Table: account_activity
Status
colour Green
title NEW RECORD

Field	Source Data
`account`	`trace` → `action_traces` → `act` → `data` → `name`
`trace_id`	Reference to trace table record
`type`	`account_created`

Trigger: fio.token:trnsfiopubky 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
trace_id	Trace ID
amount	`trace` → `action_traces` → `act` → `data` → `amount` / 1000000000
type	“transfer”
memo

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

Table: token_transfers
Status
colour Green
title NEW RECORD

Field	Source Data
payer_account	`trace` → `action_traces` → `act` → `data` → `from`
payee_account	`trace` → `action_traces` → `act` → `data` → `to`
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”
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_account	`trace` → `action_traces` → `act` → `data` → `to`
trace_id	Trace ID
amount	`trace` → `action_traces` → `act` → `data` → `quantity` (strip " FIO")
type	“token_mint”
memo	`trace` → `action_traces` → `act` → `data` → `memo`

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

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

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
account	`trace` → `action_traces` → `act` → `data` → `owner_fio_public_key`

OR

hashed to account
is_public	“false”
expiration	`response` → `expiration`
status	“active"

Table: domain_activity
Status
colour Green
title NEW RECORD

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
trace_id	Trace ID
type	“registered”

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

Table: domains
Status
colour Yellow
title update

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

Table: domain_activity
Status
colour Green
title NEW RECORD

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
trace_id	Trace ID
type	“renewed”

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

Table: domains
Status
colour Yellow
title update

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

OR payee_public_key ) for

hashed to account

Table: domain_activity
Status
colour Green
title NEW RECORD

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
trace_id	Trace ID
type	“transferred”

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

Table: domains
Status
colour Yellow
title update

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

Table: domain_activity
Status
colour Green
title NEW RECORD

Field

Source Data

domain

trace → action_traces → act → data → fio_domain

trace_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
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
account	“fio.oracle”

Table: domain_activity
Status
colour Green
title NEW RECORD

Field	Source Data

account

domain

trace → action_traces → act → data →

name

type

account_created

fio_domain

trace_id

Reference to trace table record

Trace ID
type	“wrapped”

Trigger: fio.address:xferescrow

Table: domains
Status
colour Yellow
title update

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

Table: domain_activity
Status
colour Green
title NEW RECORD

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `fio_domain`
trace_id	Trace ID
type	“unwrapped”

Page Comparison

Versions Compared

Old Version 6

New Version 7

Key

Trigger: every block

Table: blocks StatuscolourGreentitleNEW RECORD

Trigger: every

trace and action_ordinal = 1

Table: transactions StatuscolourGreentitleNEW RECORD

Trigger: every trace

Table: traces StatuscolourGreentitleNEW RECORD

Trigger:

fio.address:

bind2eosio

Table: accounts StatuscolourGreentitleNEW RECORD

Table: account_activity StatuscolourGreentitleNEW RECORD

Trigger: fio.token:trnsfiopubky and action_ordinal = 1

Table: token_transfers StatuscolourGreentitleNEW RECORD

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

Table: token_transfers StatuscolourGreentitleNEW RECORD

Trigger: fio

.token:issue and receiver:fio.token

Table: token_transfers StatuscolourGreentitleNEW RECORD

Trigger: fio.address:regdomain and action_ordinal = 1

Table: domains StatuscolourGreentitleNEW RECORD or StatuscolourYellowtitleupdate (if exists)

Table: domain_activity StatuscolourGreentitleNEW RECORD

Trigger: fio.address:renewdomain and action_ordinal = 1

Table: domains StatuscolourYellowtitleupdate

Table: domain_activity StatuscolourGreentitleNEW RECORD

Trigger: fio.address:xferdomain and action_ordinal = 1

Table: domains StatuscolourYellowtitleupdate

Table: domain_activity StatuscolourGreentitleNEW RECORD

Trigger: fio.address:setdomainpub and action_ordinal = 1

Table: domains StatuscolourYellowtitleupdate

Table: domain_activity StatuscolourGreentitleNEW RECORD

Trigger: fio.address:wrapdomain and action_ordinal = 1

Table: domains StatuscolourYellowtitleupdate

Table: domain_activity StatuscolourGreentitleNEW RECORD

Trigger: fio.address:xferescrow

Table: domains StatuscolourYellowtitleupdate

Table: domain_activity StatuscolourGreentitleNEW RECORD

Table: blocks
Status
colour Green
title NEW RECORD

trace and `action_ordinal = 1`

Table: transactions
Status
colour Green
title NEW RECORD

Table: traces
Status
colour Green
title NEW RECORD

Table: accounts
Status
colour Green
title NEW RECORD

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

Table: token_transfers
Status
colour Green
title NEW RECORD

Table: token_transfers
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)

Table: domain_activity
Status
colour Green
title NEW RECORD

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

Table: domains
Status
colour Yellow
title update

Table: domain_activity
Status
colour Green
title NEW RECORD

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

Table: domains
Status
colour Yellow
title update

Table: domain_activity
Status
colour Green
title NEW RECORD

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

Table: domains
Status
colour Yellow
title update

Table: domain_activity
Status
colour Green
title NEW RECORD

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

Table: domains
Status
colour Yellow
title update

Table: domain_activity
Status
colour Green
title NEW RECORD

Table: domains
Status
colour Yellow
title update

Table: domain_activity
Status
colour Green
title NEW RECORD