Create a SQL database and appropriate Schema in GCP

[anighanta]

We have to have a SQL Postgres database with appropriate tables withe following schema available on GCP in-order to make ERT compatible with GCP.

Database name : exchange_rate

Table1:
name: address_book
fields: long:expiration_time, json:address_book, varchar:network_name

Table2:
name: exchange_rate
fields: long:expiration_time, json:exchange_rate_file

Table3:
name: midnight_rate
fields: long:expiration_time, json:exchange_rate_file

Table4:
name: queried_rates
fields: long:expiration_time, json:queried_rates

[steven-sheehy]

Should use snake_case for database name and field names.

[anighanta]

realized it is better to use postgres instead of Mysql server on GCP Cloud SQL as flyway currently requires additional jar to support jdbc connections to mysql server and so json datatype in postgres :D

[anighanta]

Was able to create an instance which I used for a poc.