STOCKPROJECT

테이블 (8)

API User info (TestAccount)

  • Key & Account_Number (accountnumber) — VARCHAR — 기본 키 — NOT NULL
  • Account_name (accountnickname) — VARCHAR
  • Account_User_ID (accountuserid) — VARCHAR

CopyOfUntitled

  • ID — INT — 기본 키 — NOT NULL
  • STOCK_CODE — INT
  • Market — VARCHAR
  • Name — VARCHAR — NOT NULL

FinanceDataReader

  • ID — INT — 기본 키 — NOT NULL
  • ID2 — INT — 외래 키 → Untitled.ID — NOT NULL
  • ID3 — INT — 외래 키 → CopyOfUntitled.ID — NOT NULL
  • STOCK_CODE — INT — 외래 키 → Untitled.STOCK_CODE
  • STOCK_CODE2 — INT — 외래 키 → CopyOfUntitled.STOCK_CODE
  • Date — DATETIME
  • Open — INT
  • Close — INT — NOT NULL
  • High — INT
  • Low — INT
  • Volume — INT
  • Change — FLOAT

Market Name (market)

  • Key (name) — VARCHAR — 기본 키 — NOT NULL

Stock Code (Code)

  • Key — INT — 기본 키 — NOT NULL
  • Market (market) — VARCHAR — 외래 키 → Market Name.Key — NOT NULL
  • Code (code) — VARCHAR
  • Name (name) — VARCHAR

Untitled

  • ID — INT — 기본 키 — NOT NULL
  • STOCK_CODE — INT
  • Market — VARCHAR
  • Name — VARCHAR(255) — NOT NULL

User Deposit Info (deposit)

  • Key — INT — 기본 키 — NOT NULL
  • Key & Account_Number (account) — VARCHAR — 외래 키 → API User info.Key & Account_Number — NOT NULL
  • My_deposit (mydeposit) — INT
  • My_withdraw_deposit (mywithdrawdeposit) — INT
  • My_order_deposit (myorder_deposit) — INT

사용자

  • USER_ID — VARCHAR — 기본 키 — NOT NULL
  • USER_NAME — VARCHAR
  • USER_PW — VARCHAR
  • EMAIL — VARCHAR