market - Laravel Schema Designer

users

id bigIncrements
timestamps timestamps
softDeletes softDeletes
external_id integer

markets

id increments
timestamps timestamps
softDeletes softDeletes

market_user

timestamps timestamps
user_id ^FK bigInteger
market_id ^FK integer

market_config

id increments
timestamps timestamps
market_id ^FK integer
investment_positive integer
investment_negative integer
investment_step integer
initial_user_wallet_value integer
initial_user_portfolio_slots smallInteger
max_user_influence_percentage float
max_user_influence_treshold integer
min_investment_percentagem float
automatic_sales_days smallInteger

items

id bigIncrements
timestamps timestamps
external_id integer

wallets

id increments
timestamps timestamps
avaliable integer
invested integer
user_id ^FK bigInteger

item_market

market_id ^FK integer
timestamps timestamps
item_id ^FK bigInteger
investment_positive integer
investment_negative integer
belief float

portfolio

id bigIncrements
timestamps timestamps
user_id ^FK bigInteger
item_id ^FK bigInteger
market_id ^FK integer
investment_positive integer
investment_negative integer
investment integer
shares decimal

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01