Create Scripts for SQL (sqlite3) database and tables creation.

[EvgeniiaVak]

@leomrocha work on defining the structure of the missing tables @EvgeniiaVak review structure and complete the code (for the moment is only a structure)

[EvgeniiaVak]

@leomrocha I'm guessing we are aiming to have an SQL engine that works in-browser (to use it as a part of the web app), so I'll search the internet on what it has to offer here.

[EvgeniiaVak]

✔️ sql.js

https://github.com/sql-js/sql.js

• can deal with SQLite files
• has API for offloading CPU-intensive stuff to web-worker thread
• potentially very large (might slow down page load)
• example of setting up with react https://github.com/sql-js/react-sqljs-demo

AlaSQL

https://github.com/agershun/alasql

• can read SQLite files
• has nice integrations (e.g. with D3.js)
• not very much integrated with cra webpack - so import is in a separate html script tag
• can work with json1 sqlite plugin (but with some additional settings https://github.com/sql-js/sql.js#compiling)

PouchDB

Would be good if going fancy and building a web-app that works offline.

• uses indexeddb in-browser
• cannot read SQLite files in usual web version (requires Cordova/PhoneGap https://pouchdb.com/adapters.html)

Nano SQL

• written in TypeScript ❤️
• not very clear if it's possible to read sqlite files in browser... adapters list only electron/native stuff, but there is an example of querying sql-like style https://github.com/only-cliches/Nano-SQL/tree/master/packages/Query-SQLite