test
Tables (6)
BANK
- NAME — VARCHAR(200) — Foreign key → LIST.NAME — NOT NULL
- INIT_DATE — DATE — NOT NULL
- LAST_DATE — DATE — NOT NULL
- AVG_PRICE — INT — NOT NULL
- COUNT — INT — NOT NULL
DIARY
- ID — INT — Primary key — NOT NULL
- DATE — DATE — NOT NULL
- COMMENT — VARCHAR(12800) — NOT NULL
DIVIDENDS
- ID — INT — Primary key — NOT NULL
- NAME — VARCHAR(200) — Foreign key → LIST.NAME — NOT NULL
- DATE — DATE — NOT NULL
- DIVIDENDS — INT — NOT NULL
ENDPRICE
- NAME — VARCHAR(200) — Foreign key → LIST.NAME — NOT NULL
- DATE — DATE — NOT NULL
- PRICE — INT — NOT NULL
LIST
- NAME — VARCHAR(200) — Primary key — NOT NULL
- INIT_DATE — DATE — NOT NULL
- COMMENT — VARCHAR(9600)
- TYPE — INT — NOT NULL — stock : 1 etf : 2
- CODE — VARCHAR(100) — NOT NULL
TRADE
- ID — INT — Primary key — NOT NULL
- NAME — VARCHAR(200) — Foreign key → LIST.NAME — NOT NULL
- BUY_SELL — INT — buy : 1 sell : 2
- DATE — DATE
- PRICE — INT — NOT NULL
- COUNT — INT — NOT NULL
- REMAIN_COUNT — INT — NOT NULL
- COMMENT — VARCHAR(9600) — NOT NULL