Collaborate across the states

I have been having some brainstorm meetings with a friend talking about creating a game. Something pretty simple a turn based RPG in the vein of Final Fantasy Tactics. But where multiple people can play at the same time.

They are in the industry with a prevalent database company and I am the frontend worker for now. combining our knowledge to teach each other and make one cohesive product.

We have decided how we want to build our backend what data will be needed and how we want version 1.0 to look and play. The place we are now is deciding which engine to use.

We are deciding if we want to use Unity or something like the GO-DOT engine. neither of us have used either, but I have spent the last few days reading over and trying to decide.

I think we are both going with Unity. as it has been really well utilized for similar games. and the awesome Unity learn!

We both currently live in different states but thanks to google meet and other things we have been on a tear developing our idea.

We started by whiteboarding the database entities. Building multiple database tables for the characters, dungeon master, monsters and other related and connected tables. There is a 3-tier setup. An elementary version has fewer data sets and fewer tables. Afterwards, if we make progress faster than expected and the functionality is smooth, a second version will be created. In the Golden Child version, we incorporate all of the dream ideas we have to make the full game we are dreaming of.

Basic version

characters {
name:
race:
characterClass:
skills:
health:
armor:
weapons:
spells:
movement:
}

Game_master {
name:
monsters:
characters:
campaigns:
objectives:
}

campaigns {
name:
objectives:
game_master:
characters:
}

monster {
name:
type:
damage:
health:
armor:
skills:
features:
movement:
}

items {
name:
type:
effect:
}

weapon {
name:
type:
requirements:
damage:
magic:
}

armor {
name:
type:
requirements:
armor_class:
magic:
}

These are our basic tables. not including the spells, skill, and feats tables we are still working on. but you can see from this small sample we have a whole lot working off each-other to make everything functional in the way we want it.

This upcoming week we start to implement things and get it from the paper and pen phase into the codebase and see what we can do.

As far as game engines Unity, Go Dot or whatever you use or even not using a game engine what do you all think is a good way to go for a turn based multiplayer RPG?