RdsDiagram
investor
investor_id: VARCHAR(20)
name: VARCHAR(20)
address: VARCHAR(50)
account: INTEGER
company
company_id: VARCHAR(20)
num_shares: INTEGER
current_price: INTEGER
admin
admin_id: VARCHAR(20)
password: VARCHAR(20)
stock
stock_id: VARCHAR(20)
company: VARCHAR(20)
date_of_purchase: TIMESTAMP
purchase_price: INTEGER
current_price: INTEGER
portfolio
investor: VARCHAR(20)
stock_id: VARCHAR(20)
quanty: INTEGER
purchase_value: INTEGER
current_value: INTEGER
historical_data
company_id: VARCHAR(20)
share_price: INTEGER
date: TIMESTAMP
bank_account
account_num: INTEGER
bank_id: VARCHAR(20)
savings_balance: INTEGER
lien_balance: INTEGER
bank
bank_id: VARCHAR(20)
name: INTEGER
total_assets: INTEGER