Database Schema

Database Schema

Users

Column name	data type	details
id	int	PK, not null
username	string	not null
hashedPassword	string	not null
fullName	string	not null
email	string	not null, unique
cashBalance	decimal	not null

Planets

Column name	data type	details
id	int	PK, not null
planetName	string	not null
currencyPrice	decimal	not null
description	string	not null
laborForce	int	not null

Assets

Column name	data type	details
id	int	PK, not null
userId	int	not null
planetId	int	not null
numberShares	int	not null

• userId references users table
• planetId references planets table

Transactions

Column name	data type	details
id	int	PK, not null
userId	int	not null
planetId	int	not null
numberShares	int	not null
pricePaid	decimal	not null

• userId references users table
• planetId references planets table