주식 거래
테이블 (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