주식 거래

테이블 (10)

Account (account)

  • Account Id (account_id) — BIGINT(11) — 기본 키 — NOT NULL
  • Item Count (item_count) — INT(11)
  • Open Deposit (open_deposit) — BIGINT(11) — - 장시작전 업데이트 - 장중에는 잔고가 원래 얼마였는지를 확인하는 기준으로 활용
  • Deposit (deposit) — BIGINT(11)

History (history)

  • History Id (history_id) — BIGINT(11) — 기본 키 — NOT NULL
  • Datetime (datetime) — DATETIME()
  • Deposit (deposit) — BIGINT(11)

Market (market)

  • Market Id (market_id) — BIGINT(11) — 기본 키 — NOT NULL
  • Market Name (market_name) — VARCHAR(255)

Shopping Cart (shopping_cart)

  • Cart Id (cart_id) — BIGINT(11) — 기본 키 — NOT NULL
  • Item Count (item_count) — INT(11)

Stock (stock)

  • Stock Id (stock_id) — BIGINT(11) — 기본 키 — NOT NULL
  • Stock Code (stock_code) — VARCHAR(6)
  • Stock Name (stock_name) — VARCHAR(255)
  • Market Id (market_id) — BIGINT(11) — 외래 키 → Market.Market Id — NOT NULL
  • Now Price (now_price) — BIGINT(11)
  • Open Price (open_price) — BIGINT(11)
  • Close Price (close_price) — BIGINT(11) — - 장마감 후 업데이트 - 장중에는 전일 종가로 활용
  • High Price (high_price) — BIGINT(11)
  • Low Price (low_price) — BIGINT(11)
  • Volume (volume) — INT(11)

Stock Buy (stock_buy)

  • Stock Item Id (stock_item_id) — BIGINT(11) — 기본 키 — NOT NULL
  • Stock Id (stock_id) — BIGINT(11) — 외래 키 → Stock.Stock Id — NOT NULL
  • Buy Price (buy_price) — BIGINT(11)
  • Volum (volume) — INT(11)
  • Time (time) — DATETIME()

Stock Buy Account (stock_buy_account)

  • Stock Item Id (stock_item_id) — BIGINT(11) — 외래 키 → Stock Buy.Stock Item Id — NOT NULL
  • Account Id (account_id) — BIGINT(11) — 외래 키 → Account.Account Id — NOT NULL

Stock Cart (stock_cart)

  • Stock Id (stock_id) — BIGINT(11) — 외래 키 → Stock.Stock Id — NOT NULL
  • Cart Id (cart_id) — BIGINT(11) — 외래 키 → Shopping Cart.Cart Id — NOT NULL

Stock Sell (stock_sell)

  • Stock Item Id (stock_item_id) — BIGINT(11) — 기본 키 — NOT NULL
  • Stock Id (stock_id) — BIGINT(11) — 외래 키 → Stock.Stock Id — NOT NULL
  • Sell Price (sell_price) — BIGINT(11)
  • Volum (volume) — INT(11)
  • Time (time) — DATETIME()

Stock Sell Account (stock_sell_account)

  • Stock Item Id (stock_item_id) — BIGINT(11) — 외래 키 → Stock Sell.Stock Item Id — NOT NULL
  • Account Id (account_id) — BIGINT(11) — 외래 키 → Account.Account Id — NOT NULL