Versions Compared

Old Version 3

changes.mady.by.user Pawel Mastalerz

Saved on

compared with

New Version 4

changes.mady.by.user Pawel Mastalerz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Add only. Every block is a new entry.

Field

Description

Data stream field name

Relationship

number

Block number as generated by FIO Nodeblock_num

transactions->block_num

id

Block ID as generated by FIO Nodeid

timestamp

Timestamp as generated by FIO Node

timestamp

producer

Account name of producer which produced the block

producer

schedule_version

Version of BP schedule schedule_version

transactions

Add only. Every transaction is a new entry.

Field

Description

Data stream field name

Relationship

block_number

Block which contained this transactionblock_num

blocks->number

id

Transaction id

id

traces->transaction_id

action_account

Account name for action

account

action_name

Action namename

account

actor

Actor Account which executed the transactionactor

tpid

TPID which was recorded in tranactiontpid

fee

FIO Chain fee paid for this transaction

fee_collected

request_data

Raw request data for primary trace

data

response_data

Raw response data for primary traceresponse

traces

Add only. Every trace is a new entry.

Field

Description

Data stream field name

Relationship

id

Trace id

account_activity->trace_id

domain_activity->trace_id

handle_activity->trace_id

token_transfers->trace_id

fio_requests->trace_id

fio_data->trace_id

transaction_id

Transaction ID

transactions->id

action_ordinal

Sequential order of trace in transaction

action_ordinalaccount

Account name for traceaccount

action_name

Action name fro tracename

request_data

Raw request data for tracedata

accounts

Add only. Every account created is a new entry.

Field

Description

Data stream field name

Relationship

account

Account name

account_activity->account

domains->account

handles->account

token_transfers->payer_account

token_transfers->payee_account

fio_requests->payee_account

fio_requests->payer_account

fio_data->payee_account

fio_data->payer_account

public_key

Primary public key

...

Add only. Every activity is a new entry.

Field

Description

Data stream field name

Relationship

account

Account name

accounts->account

trace_id

Trace ID

traces->id

type

Type of activity

...

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

DescriptionData stream field name

Relationship

domain

Domain name

domain_activity->domain

account

Account name of current owner

accounts->account

is_public

Is domain public

expiration

Timestamp of domain expiration

status

Current status of domain

...

Add only. Every activity is a new entry

Field

Description

Data stream field name

Relationship

domain

Domain name

domains->domain

trace_id

Trace ID

traces->id

type

Type of activity

...

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

Data stream field name

Relationship

handle

Handle name

handle_activity->handle

pub_addresses->handle

nft_signatures->handle

fio_requests->payer_handle

fio_requests->payee_handle

fio_data->payer_handle

fio_data->payee_handle

account

Account name of current owner

accounts->account

encryption_key

Encryption public key

bundled_tx

Bundled tx count

...

Add only. Every activity is a new entry

Field

Description

Data stream field name

Relationship

handle

Handle name

handles->handle

trace_id

Trace ID

traces->id

type

Type of activity

...

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

Field

DescriptionData stream field name

Relationship

handle

Handle name

handles->handle

chain_code

Chain code

accounts->account

token_code

Token code

traces->id

public_address

Public Address

...

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

Field

DescriptionData stream field name

Relationship

handle

Handle name

handles->handle

chain_code

Chain code

accounts->account

token_code

Token code

traces->id

public_address

Public Address

...

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

Field

Description

Data stream field name

Relationship

payer_account

Account of payer (sender)

accounts->account

payee_account

Account of payee (receiver)

accounts->account

trace_id

Trace ID

traces->id

amount

Token amount in FIO

type

Type of transfer

memo

Memo in transfer

...

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

Field

DescriptionData stream field name

Relationship

id

FIO Request ID

fio_data->request_id

payee_account

Account of payee

accounts->account

payer_account

Account of payer

accounts->account

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

trace_id

Trace ID

traces->id

...

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

Field

Description

Data stream field name

Relationship

request_id

FIO Request ID (optional)

fio_requests->id

payee_account

Account of payee

accounts->account

payer_account

Account of payer

accounts->account

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

trace_id

Trace ID

traces->id

...

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

Field

Description

Data stream field name

Relationship

account

Owner account

accounts->account

handle

Registered handle

handles->handle

is_active

Encryption public key

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

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

Trigger: every block

table: blocks

Field

Source Data

number

block_num

timestamp

block_timestamp

producer

producer

schedule_version

schedule_version

Trigger: every transaction

Field

Source Data

block_number

block_num

id

trace → id

action_account

account

trace → action_traces → act → authorization → actor

for action_ordinal = 1

action

schedule_version