Generate schema files for database

[Rainiefantasy]

Description:
Consider creating schema files for database/table setup so that users can replicate structure easily

Additional context or further questions:

• Some things to consider:
• previously replicated a different database using: pg_dump to dump database and data contents into a source file. I.e. pg_dump -U <user> -d <database> -f <file to dump contents into>
• when using the above command, the data was also replicated, which we need to double check doesn't happen here!
• there was also an error flagged around the roles not matching (the role creating the replica, and the role using the replica), so need to check