data structures - GenusDev/genie-portal GitHub Wiki

The original approach to this site was to have some data on on a blockchain, and most data on a rails based database. As the project has developed, we have made the strategic choice to host all project related data onChain, and to use Metamask and Ethereum wallets as the basis for the user authentication.

• Upload pdf through AWS and reference link in code

Database	OnChain	AWS
Title	Title
	Valuation
	Summary
	Capital Required
	Cashflow
	Projections
	Actuals
		Business Plan
	Lat
	long
	Continent
	City
Country
Date of Creation	Date of Creation

column name	data type	details
id	integer	not null, primary key
email	string	not null, unique
username	string
first_name	string
last_name	string
password_digest	string	not null, unique
session_token	string	not null, unique
bylaw_agreement	boolean	default, false
poa.INX.A	decimal
money_made	decimal
poa.INX.B	decimal
value_of_pos	decimal
latitude	decimal	not null
longitude	decimal	not null
zipcode	integer	not null
poa.TXW	decimal
poa.OMD	decimal
poa.OPS	decimal
poa_awards	integer
project_affiliation	string

column name	data type	details
id	integer	not null, primary key
date	date	not null
name	string	not null, unique
tokens_bought	decimal
price	decimal
value	decimal
diff_earned	decimal
token	string

column name	data type	details
id	integer	not null, primary key
date	date	not null
account	string	not null, unique
invested	decimal
cash	decimal
liabilities	decimal
total	decimal

column name	data type	details
id	integer	not null, primary key
token_name	string	not null, unique
token_symbol	string	not null, unique
shares_outstanding	integer
price_per_share	decimal
market_cap	decimal
market_percentage	decimal
price_over_earnings	decimal
beta	decimal
industry	string	not null
location	string	not null
latitude	decimal	not null
longitude	decimal	not null
cf_to_date	decimal
avg_mo_cf	decimal
liabilities	decimal
valuation	decimal
val_market_cap	decimal
u_hard_exp	decimal
u_soft_exp	decimal
mo_exp	decimal
employees	integer	not null
prop_exist	string	not null
mo_staff_exp	decimal
mo_supplies_exp	decimal
IRR	decimal
units	integer
mo_paid_taxes	decimal
vacancy	decimal

---