Steemit Database Definition-list of columns
This was a duplicate posting of my Sandbox creation and Database definition post. Here I split up that post to have the Table Names and Column names summarized here.
These are all the available columns excluding sys columns on the steemit database:
Table Name | Column Name |
---|---|
Accounts | name |
Accounts | active |
Accounts | active_challenged |
Accounts | average_bandwidth |
Accounts | average_market_bandwidth |
Accounts | balance |
Accounts | can_vote |
Accounts | comment_count |
Accounts | created |
Accounts | curation_rewards |
Accounts | dirty |
Accounts | id |
Accounts | json_metadata |
Accounts | last_account_recovery |
Accounts | last_account_update |
Accounts | last_active_proved |
Accounts | last_bandwidth_update |
Accounts | last_market_bandwidth_update |
Accounts | last_owner_proved |
Accounts | last_owner_update |
Accounts | last_post |
Accounts | last_root_post |
Accounts | last_vote_time |
Accounts | lifetime_bandwidth |
Accounts | lifetime_vote_count |
Accounts | market_history |
Accounts | memo_key |
Accounts | mined |
Accounts | name |
Accounts | next_vesting_withdrawal |
Accounts | other_history |
Accounts | owner |
Accounts | owner_challenged |
Accounts | post_count |
Accounts | post_history |
Accounts | posting |
Accounts | posting_rewards |
Accounts | proxied_vsf_votes |
Accounts | proxy |
Accounts | recovery_account |
Accounts | reputation |
Accounts | reset_account |
Accounts | savings_balance |
Accounts | savings_sbd_balance |
Accounts | savings_sbd_last_interest_payment |
Accounts | savings_sbd_seconds |
Accounts | savings_sbd_seconds_last_update |
Accounts | savings_withdraw_requests |
Accounts | sbd_balance |
Accounts | sbd_last_interest_payment |
Accounts | sbd_seconds |
Accounts | sbd_seconds_last_update |
Accounts | to_withdraw |
Accounts | transfer_history |
Accounts | TS |
Accounts | vesting_balance |
Accounts | vesting_shares |
Accounts | vesting_withdraw_rate |
Accounts | vote_history |
Accounts | voting_power |
Accounts | withdraw_routes |
Accounts | withdrawn |
Accounts | witness_votes |
Accounts | witnesses_voted_for |
Blocks | block_num |
Blocks | previous |
Blocks | timestamp |
Blocks | transaction_merkle_root |
Blocks | witness |
Blocks | witness_signature |
Comments | abs_rshares |
Comments | active |
Comments | active_votes |
Comments | allow_curation_rewards |
Comments | allow_replies |
Comments | allow_votes |
Comments | author |
Comments | author_reputation |
Comments | author_rewards |
Comments | beneficiaries |
Comments | body |
Comments | body_language |
Comments | body_length |
Comments | cashout_time |
Comments | category |
Comments | children |
Comments | children_abs_rshares |
Comments | created |
Comments | curator_payout_value |
Comments | depth |
Comments | dirty |
Comments | ID |
Comments | json_metadata |
Comments | last_payout |
Comments | last_update |
Comments | max_accepted_payout |
Comments | max_cashout_time |
Comments | mode |
Comments | net_rshares |
Comments | net_votes |
Comments | parent_author |
Comments | parent_permlink |
Comments | pending_payout_value |
Comments | percent_steem_dollars |
Comments | permlink |
Comments | promoted |
Comments | reblogged_by |
Comments | replies |
Comments | reward_weight |
Comments | root_comment |
Comments | root_title |
Comments | title |
Comments | total_payout_value |
Comments | total_pending_payout_value |
Comments | total_vote_weight |
Comments | TS |
Comments | url |
Comments | vote_rshares |
Followers | follower |
Followers | following |
Reblogs | account |
Reblogs | author |
Reblogs | permlink |
Reblogs | timestamp |
Tokens | close |
Tokens | high |
Tokens | hour |
Tokens | id |
Tokens | low |
Tokens | open |
Tokens | symbol |
Tokens | time |
Tokens | volumefrom |
Tokens | volumeto |
Transactions | block_num |
Transactions | expiration |
Transactions | ref_block_num |
Transactions | ref_block_prefix |
Transactions | transaction_num |
Transactions | tx_id |
Transactions | type |
TxAccountCreates | active_key |
TxAccountCreates | creator |
TxAccountCreates | delegation |
TxAccountCreates | fee |
TxAccountCreates | ID |
TxAccountCreates | json_metadata |
TxAccountCreates | memo_key |
TxAccountCreates | new_account_name |
TxAccountCreates | owner_key |
TxAccountCreates | posting_key |
TxAccountCreates | timestamp |
TxAccountCreates | tx_id |
TxAccountRecovers | account_to_recover |
TxAccountRecovers | ID |
TxAccountRecovers | recovered |
TxAccountRecovers | recovery_account |
TxAccountRecovers | timestamp |
TxAccountRecovers | tx_id |
TxAccountUpdates | account |
TxAccountUpdates | ID |
TxAccountUpdates | json_metadata |
TxAccountUpdates | key_auth1 |
TxAccountUpdates | key_auth2 |
TxAccountUpdates | memo_key |
TxAccountUpdates | timestamp |
TxAccountUpdates | tx_id |
TxAccountWitnessProxies | account |
TxAccountWitnessProxies | ID |
TxAccountWitnessProxies | Proxy |
TxAccountWitnessProxies | timestamp |
TxAccountWitnessProxies | tx_id |
TxAccountWitnessVotes | account |
TxAccountWitnessVotes | approve |
TxAccountWitnessVotes | ID |
TxAccountWitnessVotes | timestamp |
TxAccountWitnessVotes | tx_id |
TxAccountWitnessVotes | witness |
TxClaimRewardBalances | account |
TxClaimRewardBalances | ID |
TxClaimRewardBalances | reward_sbd |
TxClaimRewardBalances | reward_steem |
TxClaimRewardBalances | reward_vests |
TxClaimRewardBalances | timestamp |
TxClaimRewardBalances | tx_id |
TxComments | author |
TxComments | body |
TxComments | ID |
TxComments | json_metadata |
TxComments | parent_author |
TxComments | parent_permlink |
TxComments | permlink |
TxComments | timestamp |
TxComments | title |
TxComments | tx_id |
TxCommentsOptions | allow_curation_rewards |
TxCommentsOptions | allow_votes |
TxCommentsOptions | author |
TxCommentsOptions | ID |
TxCommentsOptions | max_accepted_payout |
TxCommentsOptions | percent_steem_dollars |
TxCommentsOptions | permlink |
TxCommentsOptions | timestamp |
TxCommentsOptions | tx_id |
TxConverts | amount |
TxConverts | ID |
TxConverts | owner |
TxConverts | requestid |
TxConverts | timestamp |
TxConverts | tx_id |
TxCustoms | ID |
TxCustoms | json_metadata |
TxCustoms | tid |
TxCustoms | timestamp |
TxCustoms | tx_id |
TxCustomsFollows | follower |
TxCustomsFollows | following |
TxCustomsFollows | timestamp |
TxCustomsFollows | what |
TxCustomsReblogs | account |
TxCustomsReblogs | author |
TxCustomsReblogs | permlink |
TxCustomsReblogs | timestamp |
TxDelegateVestingShares | delegatee |
TxDelegateVestingShares | delegator |
TxDelegateVestingShares | ID |
TxDelegateVestingShares | timestamp |
TxDelegateVestingShares | tx_id |
TxDelegateVestingShares | vesting_shares |
TxDeleteComments | author |
TxDeleteComments | ID |
TxDeleteComments | permlink |
TxDeleteComments | timestamp |
TxDeleteComments | tx_id |
TxEscrowApproves | agent |
TxEscrowApproves | approve |
TxEscrowApproves | escrow_id |
TxEscrowApproves | from |
TxEscrowApproves | ID |
TxEscrowApproves | timestamp |
TxEscrowApproves | to |
TxEscrowApproves | tx_id |
TxEscrowApproves | who |
TxEscrowDisputes | agent |
TxEscrowDisputes | escrow_id |
TxEscrowDisputes | from |
TxEscrowDisputes | ID |
TxEscrowDisputes | timestamp |
TxEscrowDisputes | to |
TxEscrowDisputes | tx_id |
TxEscrowDisputes | who |
TxEscrowReleases | agent |
TxEscrowReleases | escrow_id |
TxEscrowReleases | from |
TxEscrowReleases | ID |
TxEscrowReleases | receiver |
TxEscrowReleases | sdb_amount |
TxEscrowReleases | steem_amount |
TxEscrowReleases | timestamp |
TxEscrowReleases | to |
TxEscrowReleases | tx_id |
TxEscrowReleases | who |
TxEscrowTransfers | agent |
TxEscrowTransfers | escrow_expiration |
TxEscrowTransfers | escrow_id |
TxEscrowTransfers | fee |
TxEscrowTransfers | fee_symbol |
TxEscrowTransfers | from |
TxEscrowTransfers | ID |
TxEscrowTransfers | json_meta |
TxEscrowTransfers | ratification_deadline |
TxEscrowTransfers | sdb_amount |
TxEscrowTransfers | steem_amount |
TxEscrowTransfers | timestamp |
TxEscrowTransfers | to |
TxEscrowTransfers | tx_id |
TxFeeds | exchange_rate_base |
TxFeeds | exchange_rate_quote |
TxFeeds | ID |
TxFeeds | publisher |
TxFeeds | timestamp |
TxFeeds | tx_id |
TxLimitOrders | amount_to_sell |
TxLimitOrders | cancel |
TxLimitOrders | exchange_rate_base |
TxLimitOrders | exchange_rate_quote |
TxLimitOrders | expiration |
TxLimitOrders | fill_or_kill |
TxLimitOrders | ID |
TxLimitOrders | min_to_receive |
TxLimitOrders | orderid |
TxLimitOrders | owner |
TxLimitOrders | timestamp |
TxLimitOrders | tx_id |
TxPows | block_id |
TxPows | ID |
TxPows | timestamp |
TxPows | tx_id |
TxPows | worker_account |
TxTransfers | amount |
TxTransfers | amount_symbol |
TxTransfers | from |
TxTransfers | ID |
TxTransfers | memo |
TxTransfers | request_id |
TxTransfers | timestamp |
TxTransfers | to |
TxTransfers | tx_id |
TxTransfers | type |
TxVotes | author |
TxVotes | ID |
TxVotes | permlink |
TxVotes | timestamp |
TxVotes | tx_id |
TxVotes | voter |
TxVotes | weight |
TxWithdraws | account |
TxWithdraws | ID |
TxWithdraws | timestamp |
TxWithdraws | tx_id |
TxWithdraws | vesting_shares |
TxWithdrawVestingRoutes | auto_vest |
TxWithdrawVestingRoutes | from_account |
TxWithdrawVestingRoutes | ID |
TxWithdrawVestingRoutes | percent |
TxWithdrawVestingRoutes | timestamp |
TxWithdrawVestingRoutes | to_account |
TxWithdrawVestingRoutes | tx_id |
TxWitnessUpdates | block_signing_key |
TxWitnessUpdates | fee |
TxWitnessUpdates | ID |
TxWitnessUpdates | owner |
TxWitnessUpdates | props_account_creation_fee |
TxWitnessUpdates | props_maximum_block_size |
TxWitnessUpdates | props_sbd_interest_rate |
TxWitnessUpdates | timestamp |
TxWitnessUpdates | tx_id |
TxWitnessUpdates | url |
VOAuthorRewards | author |
VOAuthorRewards | block_num |
VOAuthorRewards | ID |
VOAuthorRewards | permlink |
VOAuthorRewards | sdb_payout |
VOAuthorRewards | steem_payout |
VOAuthorRewards | timestamp |
VOAuthorRewards | vesting_payout |
VOCurationRewards | author |
VOCurationRewards | block_num |
VOCurationRewards | curator |
VOCurationRewards | ID |
VOCurationRewards | permlink |
VOCurationRewards | reward |
VOCurationRewards | timestamp |
VOFillConvertRequest | amount_in |
VOFillConvertRequest | amount_out |
VOFillConvertRequest | block_num |
VOFillConvertRequest | ID |
VOFillConvertRequest | owner |
VOFillConvertRequest | requestid |
VOFillConvertRequest | timestamp |
VOFillOrders | block_num |
VOFillOrders | current_orderid |
VOFillOrders | current_owner |
VOFillOrders | current_pays |
VOFillOrders | ID |
VOFillOrders | open_orderid |
VOFillOrders | open_owner |
VOFillOrders | open_pays |
VOFillOrders | timestamp |
VOFillVestingWithdraws | block_num |
VOFillVestingWithdraws | deposited |
VOFillVestingWithdraws | from_account |
VOFillVestingWithdraws | ID |
VOFillVestingWithdraws | timestamp |
VOFillVestingWithdraws | to_account |
VOFillVestingWithdraws | withdrawn |
VOInterests | block_num |
VOInterests | ID |
VOInterests | Interest |
VOInterests | owner |
VOInterests | timestamp |
VOShutdownWitnesses | block_num |
VOShutdownWitnesses | ID |
VOShutdownWitnesses | owner |
VOShutdownWitnesses | timestamp |
I hope to understand better the information these columns contain and document it for others to use also.
Upvoted, thanks for participating in the Engagement Bounty.
Thanks @deveerei!