New User Setup - Naming Conventions for tables and columns

Nobody has claimed this yet.

Hello, I would like to contribute to this project and I am having a little trouble getting set up.

I noticed that in the code the database table names are lowercase singular like 'block' and 'claim' while in the database SQL file https://github.com/lbryio/block-explorer/blob/master/sql/lbryexplorer.ddl.sql that is supposed to be used to populate the database schema, the table names are capital and plural, like 'Blocks' and 'Claims'.

Also, similar things are going on for the column names such as 'TransactionHashes' in the database and 'transaction_hashes' in the code.

Is there something I am missing to get CakePHP to convert from one to the other automatically? Also, it seems that this is exactly opposite of their recommended conventions.

Any help would be appreciated. =)

Read sql/lbryexplorer.ddl.sql first, then compare its table and column names with the corresponding database usage in the project. Determine whether CakePHP maps the capitalized plural schema names to the lowercase singular names in code; done means the mismatch is explained and the expected naming convention or required change is clearly established.

Written by the indexing model from the issue text.