dyman / LazyPortfolioTracker

Lazy Portfolio Tracker
http://lazyportfoliotracker.com
1 stars 0 forks source link

db model #13

Closed dyman closed 8 years ago

dyman commented 8 years ago

dbmodel https://en.wikipedia.org/wiki/Asset_classes

user id email lastactivity isadmin

aboutme user_id recordingfrequency gender age country_id

country id name code

assetclassratio id name description stocks fic mm - cash guaranteed
realestate other property

0 - not fix ratio 1 - fix stocks 2 - fix fic 3 - fix mm - cash - guranteed 4 - fix realestate 5 - fix other property

accounttype id name country_id not foreign key description url amortization(0- no amortization, %)

HUN:

TBSZ, ONYP, EP, OSP, LTP, NYESZ NYugdij Biztositas

Real Estate, Bank Account Debit, Bank Account Credit Car,

mortgage car loan,

USA: IRA, 401K,

account (property) id type_id user_id name description defaultcurrency assetclassratio

recording id account_id date

inventory id recording_id
assetclassratio_id currency amount

rate id currency_id date
rate

currency id name

See cash in the portfolio,

LPT loggedin profile email ... quote title