What do you think about this initial design for the database? Traders are the heart of the system so the more info we collect about them the better:
{
"traders":[
{
"id":"000001",
"nick":"Anakin",
"name":"Anakin Skywalker",
"account":"GANAKIN...",
"avatar":"anakin.png",
"intro":"May the force be with you",
"country":"US",
"state": "CA",
"city": "San Francisco",
"initialBalance": "1200.00",
"currentPortfolio": "4500.00",
"profitRatio": "375%",
"tradesCount": "1234",
"lastTrades07d": "15",
"lastTrades30d": "235",
"lastTrades01y": "1150",
"tradesPositive": "1100",
"tradesNegative": "134",
"tradesRatio": "91%",
"bestTrade": "13.45%",
"worstTrade": "-8.25%",
"trend07d": "25.75%",
"trend30d": "18.20%",
"trend01y": "12.45%",
"followersCount": "12345",
"followersAmount": "1234567.89",
"investorsCount": "1234",
"investorsAmount": "123456.89",
"investorsProfit": "12345.67",
"investmentMultiplier": "10",
"returnOnInvestment":"123%",
"averageTradeTime": "2 days",
"tradingSpeed": "low|med|high",
"riskIndex": "2",
"profileViews": "12540",
"traderSince": "2018-01-20",
"inactive": "false"
}
]
}
This is just the first gathering of data from major social platforms and they won't be implemented from the beginning but that's the kind of information it would be good to collect in order to show relevant info on the site. Trades are next but they can be gathered from the Stellar network.