Spec of the current cyberindex version

cyberindex_current_state.md

Current state of cyberindex

block

column	description
id	SERIAL PRIMARY KEY
height	integer NOT NULL UNIQUE
hash	character varying(64) NOT NULL UNIQUE
total_gas	integer DEFAULT 0
proposer_address	character varying(40) NOT NULL REFERENCES validator(address)
pre_commits	integer NOT NULL
timestamp	timestamp without time zone NOT NULL

cyberlink

column	description
object_from	VARCHAR(256) NOT NULL
object_to	VARCHAR(256) NOT NULL
subject	CHAR(44) NOT NULL
timestamp	timestamp without time zone NOT NULL
height	integer NOT NULL REFERENCES block(height)
txhash	CHAR(64) NOT NULL REFERENCES transaction(txhash)
karma	integer NOT NULL

message

column	description
id	SERIAL PRIMARY KEY
subject	CHAR(44) NOT NULL
type	character varying(64) NOT NULL
value	jsonb NOT NULL DEFAULT '{}'::jsonb
timestamp	timestamp without time zone NOT NULL
height	integer NOT NULL REFERENCES block(height)
txhash	CHAR(64) NOT NULL REFERENCES transaction(txhash)
code	integer DEFAULT 0
codespace	character varying(64)

object

column	description
id	SERIAL PRIMARY KEY
object	VARCHAR(256) NOT NULL
subject	CHAR(44) NOT NULL
timestamp	timestamp without time zone NOT NULL
height	integer NOT NULL REFERENCES block(height)
txhash	CHAR(64) NOT NULL REFERENCES transaction(txhash)

pre_commit

column	description
id	SERIAL PRIMARY KEY
validator_address	character varying(40) NOT NULL REFERENCES validator(address)
timestamp	timestamp without time zone NOT NULL
voting_power	integer NOT NULL
proposer_priority	integer NOT NULL
height	integer NOT NULL

transaction

column	description
id	SERIAL PRIMARY KEY
timestamp	timestamp without time zone NOT NULL
gas_wanted	integer DEFAULT 0
gas_used	integer DEFAULT 0
height	integer NOT NULL REFERENCES block(height)
txhash	character varying(64) NOT NULL UNIQUE
subject	CHAR(44) NOT NULL
events	jsonb DEFAULT '[]'::jsonb
messages	jsonb NOT NULL DEFAULT '[]'::jsonb
fee	jsonb NOT NULL DEFAULT '{}'::jsonb
signatures	jsonb NOT NULL DEFAULT '[]'::jsonb
memo	character varying(256)
code	integer DEFAULT 0
codespace	character varying(64)
rawlog	jsonb NOT NULL DEFAULT '[]'::jsonb

validator

column	description
id	SERIAL PRIMARY KEY
address	character varying(40) NOT NULL UNIQUE
consensus_pubkey	character varying(83) NOT NULL UNIQUE

relevance

column	description
id	SERIAL PRIMARY KEY
object	VARCHAR(256) NOT NULL
height	integer NOT NULL
rank	numeric NOT NULL

relevance_leaderboard

short description: rewards_view group by address and sum shares

column	description
subject	CHAR(44) NOT NULL
share	real

built by:

• top_1000
• top_stats
• rewards_view

depends on:

• relevance
• cyberlink

accs_by_act

short description:

account activity by major events

column	description
subject	CHAR(44) NOT NULL
first_delegation	timestamp
first_send	timestamp
first_link	timestamp
first_tweet	timestamp
first_follow	timestamp
first_avatar	timestamp
follows	integer
cyberlinks	integer
tweets	integer
first_5_folls	timestamp
first_25_folls	timestamp
first_10_links	timestamp
first_100_links	timestamp

depends on:

• transaction
• message
• cyberlink

karma_view

short description:

account summary karma. Grouped by account from cyberlinks table

column	description
subject	CHAR(44) NOT NULL
karma	integer

depends on:

• cyberlink

pre_commit_view

short description:

validator summary pre_commits. Grouped by validator from pre_commits and old_pre_commits tables by consensus_pubkey

column	description
consensus_pubkey	character varying(83) NOT NULL UNIQUE
precommits	integer

depends on:

• old_pre_commits
• validator
• pre_commit

gift_info

short description:

static table with information about gifted addresses by the distribution company

column	description
subject	CHAR(44) NOT NULL UNIQUE PRIMARY KEY
euler4	CHAR(51)
urbit	CHAR(42)
cosmos	CHAR(45)
ethereum	CHAR(42)

depends on:

• gift_info.csv

old_pre_commits

short description:

static table with information about euler-5 pre_commits

column	description
consensus_pubkey	character varying(83) NOT NULL UNIQUE PRIMARY KEY
precommits	NUMERIC

depends on:

• old_pre_commits.csv

Analytics views

short description:

storing daily analytic data with accumulating. General view:

column	description
data	timestamp
instance_per_day	integer
instance_total(accumulated)	integer

List of views:

• euler4_per_day
• euler4_total
• ethereum_per_day
• ethereum_total
• urbit_per_day
• urbit_total
• cosmos_per_day
• cosmos_total
• new_per_day
• new_total
• unique_per_day
• unique_total
• objects_per_day
• objects_total
• txs_per_day
• txs_total
• tweets_per_day
• tweets_total
• cyberlinks_per_day
• cyberlinks_total

depends on:

• transaction
• message
• cyberlink

Support views for cohort API (in progress)

• tx_order
• cohorts

cyberindex_future_design.md

Future design of cyberindex

Regular tables

• validator (what exactly is consensus address?)
• pre_commit
• block (sum of pre commits?)
• transaction (subject needed)
• message
• cyberlink (?)

auth module

account

List of accounts in the network

column	description
address	TEXT NOT NULL PRIMARY KEY

bank module

supply. Historical supply change. Can follow it with views by coins denom.

column	description
coins	COIN[] NOT NULL
height	BIGINT NOT NULL UNIQUE PRIMARY KEY

account_balance. Historical account balance changing. Possible to follow account balance changing, also make a richlist by denom.

column	description
address	TEXT NOT NULL REFERENCES account (address)
coins	COIN[] NOT NULL DEFAULT '{}'
height	BIGINT NOT NULL

staking module

validator_info

column	description
consensus_address	TEXT NOT NULL UNIQUE PRIMARY KEY REFERENCES validator(consensus_address)
operator_address	TEXT NOT NULL UNIQUE
self_delegate_address	TEXT REFERENCES account (address)
max_change_rate	TEXT NOT NULL
max_rate	TEXT NOT NULL

validator_status. Histrorical

column	description
validator_address	TEXT NOT NULL REFERENCES validator (consensus_address)
status	INT NOT NULL
jailed	BOOLEAN NOT NULL
height	BIGINT
PRIMARY KEY	(validator_address, height)

consensus module

list of tables:

• average_block_time_per_minute
• average_block_time_per_hour
• average_block_time_per_day
• average_block_time_from_genesis

mint module

inflation

column	description
value	DECIMAL NOT NULL
height	BIGINT NOT NULL
PRIMARY KEY	(value, height)

slashing

validator_signing_info

column	description
validator_address	TEXT NOT NULL
start_height	BIGINT NOT NULL
index_offset	BIGINT NOT NULL
jailed_until	TIMESTAMP WITHOUT TIME ZONE NOT NULL
tombstoned	BOOLEAN NOT NULL
missed_blocks_counter	BIGINT NOT NULL
height	BIGINT NOT NULL REFERENCES block (height)

slashing_params. Historical. Can understand lost values by validator.

column	description
signed_block_window	BIGINT NOT NULL
min_signed_per_window	DECIMAL NOT NULL
downtime_jail_duration	BIGINT NOT NULL
slash_fraction_double_sign	DECIMAL NOT NULL
slash_fraction_downtime	DECIMAL NOT NULL
height	BIGINT NOT NULL REFERENCES block (height)

additional views for analytics

Analytics views

short description:

storing daily analytic data with accumulating. General view:

column	description
data	timestamp
instance_per_day	integer
instance_total(accumulated)	integer

List of views:

• euler4_per_day
• euler4_total
• ethereum_per_day
• ethereum_total
• urbit_per_day
• urbit_total
• cosmos_per_day
• cosmos_total
• new_per_day
• new_total
• unique_per_day
• unique_total
• objects_per_day
• objects_total
• txs_per_day
• txs_total
• tweets_per_day
• tweets_total
• cyberlinks_per_day
• cyberlinks_total

depends on:

• transaction
• message
• cyberlink

Support views for cohort API (in progress)

• tx_order
• cohorts