Table of Contents

maxLevel	6
minLevel	1
include
outline	false
indent
exclude
style	none
type	list
printable	true
class

Overview

TODO

burned addresses and domains pre JAN-2024 - maybe table deltas?

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 API. The following document is intended to be functional specification for the FIO Relic System.

...

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

...

Table: traces
Status
colour Green
title NEW RECORD

Field	Source Data
id	Trace id. Auto-generated ID or transaction_id + action_ordinal, e.g. 770989df18fac96e48ca03d6702991d4462bebacceab8cf6b389507e998ca7fe-2
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
payer_account	`trace` → `action_traces` → `act` → `data` → `actor`
payee_account	`trace` → `action_traces` → `act` → `data` → `payee_public_key` hashed to account
transaction_id	`trace` → `id`
amount	`trace` → `action_traces` → `act` → `data` → `amount` / 1000000000
type	“transfer_locked”
memo

Trigger: fio.token:transfer and `receiver`

...

`= fio.token`

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

...

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"

...

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`
account	`trace` → `action_traces` → `act` → `data` → `owner_fio_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"

...

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
id	`trace` → `action_traces` → `act` → `data` → `fio_request_id`
status	“sent_to_blockchain”

Trigger: fio.address:burndomain

Table: domains
Status
colour Yellow
title update

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `domainname`
status	“burnt”

Table: domain_activity
Status
colour Green
title NEW RECORD

Field	Source Data
domain	`trace` → `action_traces` → `act` → `data` → `domainname`
transaction_id	`trace` → `id`
type	“auto_burn”

Versions Compared

Old Version 9

New Version 10

Key

Overview

Table: traces
Status
colour Green
title NEW RECORD

Trigger: fio.token:transfer and `receiver`

`= fio.token`

Table: token_transfers
Status
colour Green
title NEW RECORD

Trigger: fio.token:issue and `receiver`

`= fio.token`

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 based on `domain`)

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

Trigger: fio.address:

cancelfndreq and `action_ordinal = 1`

Table: handle_activity
Status
colour Green
title NEW RECORD

Trigger: fio.address:burndomain

Table: domains
Status
colour Yellow
title update

Table: domain_activity
Status
colour Green
title NEW RECORD

Page Comparison

Versions Compared

Old Version 9

New Version 10

Key

Overview

Table: traces 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 based on domain)

Trigger: fio.address:regaddress and action_ordinal = 1

Table: handles StatuscolourGreentitleNEW RECORD or StatuscolourYellowtitleupdate (if exists based on handle)

Trigger: fio.address:

cancelfndreq and action_ordinal = 1

Table: handle_activity StatuscolourGreentitleNEW RECORD

Trigger: fio.address:burndomain

Table: domains StatuscolourYellowtitleupdate

Table: domain_activity StatuscolourGreentitleNEW RECORD

Table: traces
Status
colour Green
title NEW RECORD

Trigger: fio.token:transfer and `receiver`

`= fio.token`

Table: token_transfers
Status
colour Green
title NEW RECORD

Trigger: fio.token:issue and `receiver`

`= fio.token`

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 based on `domain`)

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

cancelfndreq and `action_ordinal = 1`

Table: handle_activity
Status
colour Green
title NEW RECORD

Table: domains
Status
colour Yellow
title update

Table: domain_activity
Status
colour Green
title NEW RECORD