as
Tables (9)
User
- user_no — bigint(20) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
pf
- pf_no — bigint(20) — Primary key — NOT NULL
- user_account_no — bigint(20) — Foreign key → user_account.user_account_no — NOT NULL
- name — varchat(255) — NOT NULL
- investment_principal — decimal(21,2) — NOT NULL
- created_dt — datetime — NOT NULL
- cash — decimal(21,2) — NOT NULL
pf_asset
- pf_asset_no — bigint(20) — Primary key — NOT NULL
- pf_no — bigint(20) — Foreign key → pf.pf_no — NOT NULL
- symbol — varchar(10) — NOT NULL
- buy_amt — deciaml(21,2) — NOT NULL
- average_buy_price — decimal(21,2) — NOT NULL
- qty — bigint(20) — NOT NULL
- weight — decimal(5,2) — NOT NULL
- created_dt — datetime — NOT NULL
pf_asset_hist
- pf_asset_value_no — bigint(20) — Primary key — NOT NULL
- pf_asset_no — bigint(20) — Foreign key → pf_asset.pf_asset_no — NOT NULL
- avg_price — decimal(21,2) — NOT NULL
- trx_amt — decimal(21,2) — NOT NULL
- qty — bigint(20) — NOT NULL
- order_side — varchar(4) — NOT NULL
- created_dt — datetime — NOT NULL
pf_asset_value_history
- pf_asset_hist_no — bigint(20) — Primary key — NOT NULL
- pf_no — bigint(20) — Foreign key → pf.pf_no — NOT NULL
- symbol — varchar(10) — NOT NULL
- value — decimal(21,2) — NOT NULL
- created_dt — datetime — NOT NULL
pf_cash_hist
- pf_cash_hist_no — bigint(20) — Primary key — NOT NULL
- pf_no — bigint(20) — Foreign key → pf.pf_no — NOT NULL
- trx_amt — decimal(21, 2)
- trx_type — varchar(10) — deposit, withdraw
- created_dt — datetime — NOT NULL
pf_ver
- pf_ver_no — bigint(20) — Primary key — NOT NULL
- pf_no — bigint(20) — Foreign key → pf.pf_no — NOT NULL
- hold_period — varchar(6) — NOT NULL
- target_rate — decimal(5,2) — NOT NULL
- losscut_rate — demical(5,2) — NOT NULL
- trade_strategy — varchar(20) — NOT NULL
- weight_strategy — varchar(20) — NOT NULL
- rebalance_period — varchar(6) — NOT NULL
- created_dt — datetime — NOT NULL
- closed_dt — datetime
- previous_pf_ver — bigint(20)
pf_ver_asset
- pf_ver_asset_no — bigint(20) — Primary key — NOT NULL
- pf_ver_no — bigint(20) — Foreign key → pf_ver.pf_ver_no — NOT NULL
- symbol — varchr(10) — NOT NULL
- target_rate — demical(5,2) — NOT NULL
- losscut_rate — demical(5,2) — NOT NULL
- weight — decimal(5,2) — NOT NULL
user_account
- user_account_no — bigint(20) — Primary key — NOT NULL
- user_no — bigint(20) — Foreign key → User.user_no — NOT NULL
- broker — varchar(255) — NOT NULL
- broker_account_no — varchar(255) — NOT NULL
- created_dt — datetime — NOT NULL