Steemit Database Definition-list of columns

in #steemph6 years ago (edited)

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 NameColumn Name
Accountsname
Accountsactive
Accountsactive_challenged
Accountsaverage_bandwidth
Accountsaverage_market_bandwidth
Accountsbalance
Accountscan_vote
Accountscomment_count
Accountscreated
Accountscuration_rewards
Accountsdirty
Accountsid
Accountsjson_metadata
Accountslast_account_recovery
Accountslast_account_update
Accountslast_active_proved
Accountslast_bandwidth_update
Accountslast_market_bandwidth_update
Accountslast_owner_proved
Accountslast_owner_update
Accountslast_post
Accountslast_root_post
Accountslast_vote_time
Accountslifetime_bandwidth
Accountslifetime_vote_count
Accountsmarket_history
Accountsmemo_key
Accountsmined
Accountsname
Accountsnext_vesting_withdrawal
Accountsother_history
Accountsowner
Accountsowner_challenged
Accountspost_count
Accountspost_history
Accountsposting
Accountsposting_rewards
Accountsproxied_vsf_votes
Accountsproxy
Accountsrecovery_account
Accountsreputation
Accountsreset_account
Accountssavings_balance
Accountssavings_sbd_balance
Accountssavings_sbd_last_interest_payment
Accountssavings_sbd_seconds
Accountssavings_sbd_seconds_last_update
Accountssavings_withdraw_requests
Accountssbd_balance
Accountssbd_last_interest_payment
Accountssbd_seconds
Accountssbd_seconds_last_update
Accountsto_withdraw
Accountstransfer_history
AccountsTS
Accountsvesting_balance
Accountsvesting_shares
Accountsvesting_withdraw_rate
Accountsvote_history
Accountsvoting_power
Accountswithdraw_routes
Accountswithdrawn
Accountswitness_votes
Accountswitnesses_voted_for
Blocksblock_num
Blocksprevious
Blockstimestamp
Blockstransaction_merkle_root
Blockswitness
Blockswitness_signature
Commentsabs_rshares
Commentsactive
Commentsactive_votes
Commentsallow_curation_rewards
Commentsallow_replies
Commentsallow_votes
Commentsauthor
Commentsauthor_reputation
Commentsauthor_rewards
Commentsbeneficiaries
Commentsbody
Commentsbody_language
Commentsbody_length
Commentscashout_time
Commentscategory
Commentschildren
Commentschildren_abs_rshares
Commentscreated
Commentscurator_payout_value
Commentsdepth
Commentsdirty
CommentsID
Commentsjson_metadata
Commentslast_payout
Commentslast_update
Commentsmax_accepted_payout
Commentsmax_cashout_time
Commentsmode
Commentsnet_rshares
Commentsnet_votes
Commentsparent_author
Commentsparent_permlink
Commentspending_payout_value
Commentspercent_steem_dollars
Commentspermlink
Commentspromoted
Commentsreblogged_by
Commentsreplies
Commentsreward_weight
Commentsroot_comment
Commentsroot_title
Commentstitle
Commentstotal_payout_value
Commentstotal_pending_payout_value
Commentstotal_vote_weight
CommentsTS
Commentsurl
Commentsvote_rshares
Followersfollower
Followersfollowing
Reblogsaccount
Reblogsauthor
Reblogspermlink
Reblogstimestamp
Tokensclose
Tokenshigh
Tokenshour
Tokensid
Tokenslow
Tokensopen
Tokenssymbol
Tokenstime
Tokensvolumefrom
Tokensvolumeto
Transactionsblock_num
Transactionsexpiration
Transactionsref_block_num
Transactionsref_block_prefix
Transactionstransaction_num
Transactionstx_id
Transactionstype
TxAccountCreatesactive_key
TxAccountCreatescreator
TxAccountCreatesdelegation
TxAccountCreatesfee
TxAccountCreatesID
TxAccountCreatesjson_metadata
TxAccountCreatesmemo_key
TxAccountCreatesnew_account_name
TxAccountCreatesowner_key
TxAccountCreatesposting_key
TxAccountCreatestimestamp
TxAccountCreatestx_id
TxAccountRecoversaccount_to_recover
TxAccountRecoversID
TxAccountRecoversrecovered
TxAccountRecoversrecovery_account
TxAccountRecoverstimestamp
TxAccountRecoverstx_id
TxAccountUpdatesaccount
TxAccountUpdatesID
TxAccountUpdatesjson_metadata
TxAccountUpdateskey_auth1
TxAccountUpdateskey_auth2
TxAccountUpdatesmemo_key
TxAccountUpdatestimestamp
TxAccountUpdatestx_id
TxAccountWitnessProxiesaccount
TxAccountWitnessProxiesID
TxAccountWitnessProxiesProxy
TxAccountWitnessProxiestimestamp
TxAccountWitnessProxiestx_id
TxAccountWitnessVotesaccount
TxAccountWitnessVotesapprove
TxAccountWitnessVotesID
TxAccountWitnessVotestimestamp
TxAccountWitnessVotestx_id
TxAccountWitnessVoteswitness
TxClaimRewardBalancesaccount
TxClaimRewardBalancesID
TxClaimRewardBalancesreward_sbd
TxClaimRewardBalancesreward_steem
TxClaimRewardBalancesreward_vests
TxClaimRewardBalancestimestamp
TxClaimRewardBalancestx_id
TxCommentsauthor
TxCommentsbody
TxCommentsID
TxCommentsjson_metadata
TxCommentsparent_author
TxCommentsparent_permlink
TxCommentspermlink
TxCommentstimestamp
TxCommentstitle
TxCommentstx_id
TxCommentsOptionsallow_curation_rewards
TxCommentsOptionsallow_votes
TxCommentsOptionsauthor
TxCommentsOptionsID
TxCommentsOptionsmax_accepted_payout
TxCommentsOptionspercent_steem_dollars
TxCommentsOptionspermlink
TxCommentsOptionstimestamp
TxCommentsOptionstx_id
TxConvertsamount
TxConvertsID
TxConvertsowner
TxConvertsrequestid
TxConvertstimestamp
TxConvertstx_id
TxCustomsID
TxCustomsjson_metadata
TxCustomstid
TxCustomstimestamp
TxCustomstx_id
TxCustomsFollowsfollower
TxCustomsFollowsfollowing
TxCustomsFollowstimestamp
TxCustomsFollowswhat
TxCustomsReblogsaccount
TxCustomsReblogsauthor
TxCustomsReblogspermlink
TxCustomsReblogstimestamp
TxDelegateVestingSharesdelegatee
TxDelegateVestingSharesdelegator
TxDelegateVestingSharesID
TxDelegateVestingSharestimestamp
TxDelegateVestingSharestx_id
TxDelegateVestingSharesvesting_shares
TxDeleteCommentsauthor
TxDeleteCommentsID
TxDeleteCommentspermlink
TxDeleteCommentstimestamp
TxDeleteCommentstx_id
TxEscrowApprovesagent
TxEscrowApprovesapprove
TxEscrowApprovesescrow_id
TxEscrowApprovesfrom
TxEscrowApprovesID
TxEscrowApprovestimestamp
TxEscrowApprovesto
TxEscrowApprovestx_id
TxEscrowApproveswho
TxEscrowDisputesagent
TxEscrowDisputesescrow_id
TxEscrowDisputesfrom
TxEscrowDisputesID
TxEscrowDisputestimestamp
TxEscrowDisputesto
TxEscrowDisputestx_id
TxEscrowDisputeswho
TxEscrowReleasesagent
TxEscrowReleasesescrow_id
TxEscrowReleasesfrom
TxEscrowReleasesID
TxEscrowReleasesreceiver
TxEscrowReleasessdb_amount
TxEscrowReleasessteem_amount
TxEscrowReleasestimestamp
TxEscrowReleasesto
TxEscrowReleasestx_id
TxEscrowReleaseswho
TxEscrowTransfersagent
TxEscrowTransfersescrow_expiration
TxEscrowTransfersescrow_id
TxEscrowTransfersfee
TxEscrowTransfersfee_symbol
TxEscrowTransfersfrom
TxEscrowTransfersID
TxEscrowTransfersjson_meta
TxEscrowTransfersratification_deadline
TxEscrowTransferssdb_amount
TxEscrowTransferssteem_amount
TxEscrowTransferstimestamp
TxEscrowTransfersto
TxEscrowTransferstx_id
TxFeedsexchange_rate_base
TxFeedsexchange_rate_quote
TxFeedsID
TxFeedspublisher
TxFeedstimestamp
TxFeedstx_id
TxLimitOrdersamount_to_sell
TxLimitOrderscancel
TxLimitOrdersexchange_rate_base
TxLimitOrdersexchange_rate_quote
TxLimitOrdersexpiration
TxLimitOrdersfill_or_kill
TxLimitOrdersID
TxLimitOrdersmin_to_receive
TxLimitOrdersorderid
TxLimitOrdersowner
TxLimitOrderstimestamp
TxLimitOrderstx_id
TxPowsblock_id
TxPowsID
TxPowstimestamp
TxPowstx_id
TxPowsworker_account
TxTransfersamount
TxTransfersamount_symbol
TxTransfersfrom
TxTransfersID
TxTransfersmemo
TxTransfersrequest_id
TxTransferstimestamp
TxTransfersto
TxTransferstx_id
TxTransferstype
TxVotesauthor
TxVotesID
TxVotespermlink
TxVotestimestamp
TxVotestx_id
TxVotesvoter
TxVotesweight
TxWithdrawsaccount
TxWithdrawsID
TxWithdrawstimestamp
TxWithdrawstx_id
TxWithdrawsvesting_shares
TxWithdrawVestingRoutesauto_vest
TxWithdrawVestingRoutesfrom_account
TxWithdrawVestingRoutesID
TxWithdrawVestingRoutespercent
TxWithdrawVestingRoutestimestamp
TxWithdrawVestingRoutesto_account
TxWithdrawVestingRoutestx_id
TxWitnessUpdatesblock_signing_key
TxWitnessUpdatesfee
TxWitnessUpdatesID
TxWitnessUpdatesowner
TxWitnessUpdatesprops_account_creation_fee
TxWitnessUpdatesprops_maximum_block_size
TxWitnessUpdatesprops_sbd_interest_rate
TxWitnessUpdatestimestamp
TxWitnessUpdatestx_id
TxWitnessUpdatesurl
VOAuthorRewardsauthor
VOAuthorRewardsblock_num
VOAuthorRewardsID
VOAuthorRewardspermlink
VOAuthorRewardssdb_payout
VOAuthorRewardssteem_payout
VOAuthorRewardstimestamp
VOAuthorRewardsvesting_payout
VOCurationRewardsauthor
VOCurationRewardsblock_num
VOCurationRewardscurator
VOCurationRewardsID
VOCurationRewardspermlink
VOCurationRewardsreward
VOCurationRewardstimestamp
VOFillConvertRequestamount_in
VOFillConvertRequestamount_out
VOFillConvertRequestblock_num
VOFillConvertRequestID
VOFillConvertRequestowner
VOFillConvertRequestrequestid
VOFillConvertRequesttimestamp
VOFillOrdersblock_num
VOFillOrderscurrent_orderid
VOFillOrderscurrent_owner
VOFillOrderscurrent_pays
VOFillOrdersID
VOFillOrdersopen_orderid
VOFillOrdersopen_owner
VOFillOrdersopen_pays
VOFillOrderstimestamp
VOFillVestingWithdrawsblock_num
VOFillVestingWithdrawsdeposited
VOFillVestingWithdrawsfrom_account
VOFillVestingWithdrawsID
VOFillVestingWithdrawstimestamp
VOFillVestingWithdrawsto_account
VOFillVestingWithdrawswithdrawn
VOInterestsblock_num
VOInterestsID
VOInterestsInterest
VOInterestsowner
VOIntereststimestamp
VOShutdownWitnessesblock_num
VOShutdownWitnessesID
VOShutdownWitnessesowner
VOShutdownWitnessestimestamp

I hope to understand better the information these columns contain and document it for others to use also.


ABI.png

follow_luvabi.gif

luvabi.png



Sort:  

Upvoted, thanks for participating in the Engagement Bounty.

Thanks @deveerei!

Coin Marketplace

STEEM 0.36
TRX 0.12
JST 0.040
BTC 70839.13
ETH 3563.41
USDT 1.00
SBD 4.77