Database Diagram of DBSteem (Steemit SQL Server Database by @arcange)

@arcange created a publicly available SQL database with all the blockchain data in it about a year ago. It has been hugely helpful to quite a lot of developers, including me.

• [STEEMSQL.COM] A public SQL server database with all Steemit blockchain data

The more I used his awesome database, the more I wanted to have a full recent diagram.
So, here we are! I have made that for all you guys, including me again :)

• Download DBSteemDiagram.zip

DBSteemDiagram.zip has three files as follows:

• 1.TableCreation.sql
  • You can create all the tables of DBSteem by copying/pasting the result.
• 2.ForeignKeyCreation.sql
  • 1.TableCreation.sql does not show the foreign key constraints but this does.
• DBSteemDiagram.png
  • Clearer version of the diagram in case you do not want to be bothered.

As you can see, you will be able to make your own view of the diagram by using 1 & 2 scripts.
Another benefit of using 1 & 2 scripts is that you could easily make your own set of the database to be a good citizen.

I hope you like this. Cheers!