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