SteemSQL is a public MS-SQL database with all the blockchain data in it.
Previous posts:
- Introduction post
- SteemSQL - Update 1
- SteemSQL - Update 2
- SteemSQL - Update 3
- SteemSQL - Update 4
- SteemSQL - Update 5
- SteemSQL - Update 6
- SteemSQL - Update 7
- SteemSQL - Update 8
- SteemSQL - Update 9
- SteemSQL - Update 10
- SteemSQL - Update 11
- SteemSQL - Update 12
- SteemSQL - Update 13
What's new
A new Witnesses table has been added to the database.
The Witnesses table is a non-transactional table which contains a list of all witnesses and related information. The table content is updated every witness round (i.e. every 63 seconds as there are 21 witnesses producing a block every 3 seconds in each round)
This table will allow my friend 
Witnesses table description
The table contains the following columns:
| Name | Description |
|---|---|
| name | Account name of the witness |
| votes_count | Number of votes the witness received |
| url | The URL of the witness presentation post |
| votes | Total amount of VEST from voters |
| total_missed | Number of blocks missed |
| last_aslot | This value indicate when the witness was last scheduled for block production |
| last_confirmed_block_num | Block number of the last block signed by the witness |
| signing_key | Current signing key use by the Witness. A value of STM1111111111111111111111111111111114T1Anm means the witness has been deactivated and will no more be scheduled for block production |
| account_creation_fee | Proposed cost for the creation of a new account |
| account_creation_fee_symbol | STEEM |
| maximum_block_size | Proposed maximum block size. The greater, the more information and transactions the blockchain can store in each block |
| sbd_interest_rate | Proposed interest rate to rewards users holding SBD |
| sbd_exchange_rate_base | Proposed cost in SBD to buy 1 STEEM |
| sbd_exchange_rate_base_symbol | SBD |
| sbd_exchange_rate_quote | Proposed value for the ratio between SBD and STEEM for rewards |
| sbd_exchange_rate_quote_symbol | STEEM |
| last_sbd_exchange_update | Last time the witness updated its pricefeed |
| running_version | Current version of the witness node |
| hardfork_version_vote | Current version of the hardfork supported by the witness |
| hardfork_time_vote | Time of vote from the witness for the latest supported hardfork |
Here an updated diagram of the database:
Visit SteemSQL.com website for more information.
Thanks for reading.
footer created with steemitboard - click any award to see my board of honor
Support me and my work as a witness by voting for me here!
