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