team2
Tables (10)
ATSSTOCKASKINGPRICE
- ID — NUMBER — Primary key — NOT NULL
- STOCK_CODE — VARCHAR2(20 BYTE)
- TRADING_TIME — VARCHAR2(10 BYTE)
- SELL_PRICE_10 — NUMBER
- SELL_QUANTITY_10 — NUMBER
- SELL_PRICE_9 — NUMBER
- SELL_QUANTITY_9 — NUMBER
- SELL_PRICE_8 — NUMBER
- SELL_QUANTITY_8 — NUMBER
- SELL_PRICE_7 — NUMBER
- SELL_QUANTITY_7 — NUMBER
- SELL_PRICE_6 — NUMBER
- SELL_QUANTITY_6 — NUMBER
- SELL_PRICE_5 — NUMBER
- SELL_QUANTITY_5 — NUMBER
- SELL_PRICE_4 — NUMBER
- SELL_QUANTITY_4 — NUMBER
- SELL_PRICE_3 — NUMBER
- SELL_QUANTITY_3 — NUMBER
- SELL_PRICE_2 — NUMBER
- SELL_QUANTITY_2 — NUMBER
- SELL_PRICE_1 — NUMBER
- SELL_QUANTITY_1 — NUMBER
- BUY_PRICE_1 — NUMBER
- BUY_QUANTITY_1 — NUMBER
- BUY_PRICE_2 — NUMBER
- BUY_QUANTITY_2 — NUMBER
- BUY_PRICE_3 — NUMBER
- BUY_QUANTITY_3 — NUMBER
- BUY_PRICE_4 — NUMBER
- BUY_QUANTITY_4 — NUMBER
- BUY_PRICE_5 — NUMBER
- BUY_QUANTITY_5 — NUMBER
- BUY_PRICE_6 — NUMBER
- BUY_QUANTITY_6 — NUMBER
- BUY_PRICE_7 — NUMBER
- BUY_QUANTITY_7 — NUMBER
- BUY_PRICE_8 — NUMBER
- BUY_QUANTITY_8 — NUMBER
- BUY_PRICE_9 — NUMBER
- BUY_QUANTITY_9 — NUMBER
- BUY_PRICE_10 — NUMBER
- BUY_QUANTITY_10 — NUMBER
- RECEIVED_AT — TIMESTAMP
STOCKASKINGPRICE
- ID — NUMBER — Primary key — NOT NULL
- STOCK_CODE — VARCHAR2(20 BYTE)
- TRADING_TIME — VARCHAR2(10 BYTE)
- SELL_PRICE_10 — NUMBER
- SELL_QUANTITY_10 — NUMBER
- SELL_PRICE_9 — NUMBER
- SELL_QUANTITY_9 — NUMBER
- SELL_PRICE_8 — NUMBER
- SELL_QUANTITY_8 — NUMBER
- SELL_PRICE_7 — NUMBER
- SELL_QUANTITY_7 — NUMBER
- SELL_PRICE_6 — NUMBER
- SELL_QUANTITY_6 — NUMBER
- SELL_PRICE_5 — NUMBER
- SELL_QUANTITY_5 — NUMBER
- SELL_PRICE_4 — NUMBER
- SELL_QUANTITY_4 — NUMBER
- SELL_PRICE_3 — NUMBER
- SELL_QUANTITY_3 — NUMBER
- SELL_PRICE_2 — NUMBER
- SELL_QUANTITY_2 — NUMBER
- SELL_PRICE_1 — NUMBER
- SELL_QUANTITY_1 — NUMBER
- BUY_PRICE_1 — NUMBER
- BUY_QUANTITY_1 — NUMBER
- BUY_PRICE_2 — NUMBER
- BUY_QUANTITY_2 — NUMBER
- BUY_PRICE_3 — NUMBER
- BUY_QUANTITY_3 — NUMBER
- BUY_PRICE_4 — NUMBER
- BUY_QUANTITY_4 — NUMBER
- BUY_PRICE_5 — NUMBER
- BUY_QUANTITY_5 — NUMBER
- BUY_PRICE_6 — NUMBER
- BUY_QUANTITY_6 — NUMBER
- BUY_PRICE_7 — NUMBER
- BUY_QUANTITY_7 — NUMBER
- BUY_PRICE_8 — NUMBER
- BUY_QUANTITY_8 — NUMBER
- BUY_PRICE_9 — NUMBER
- BUY_QUANTITY_9 — NUMBER
- BUY_PRICE_10 — NUMBER
- BUY_QUANTITY_10 — NUMBER
- RECEIVED_AT — TIMESTAMP
STOCKPRICE
- ID — number — Primary key — NOT NULL
- STOCKCODE — VARCHAR2(20 BYTE)
- TRADINGTIME — VARCHAR2(20 BYTE)
- CURRENTPRICE — NUMBER
- NETCHANGECODE — VARCHAR2(20 BYTE)
- NETCHANGE — NUMBER
- NETCHANGERATE — NUMBER
- OPENPRICE — NUMBER
- HIGHPRICE — NUMBER
- LOWPRICE — NUMBER
- CNTGVOL — NUMBER
- ACMLVOL — NUMBER
- RECEIVED_AT — TIMESTAMP
accounts
- accountNumber — VARCHAR(64) — Primary key — NOT NULL
- userId — VARCHAR(64) — NOT NULL
- status — VARCHAR(4)
- type — VARCHAR(4)
- name — VARCHAR(20)
- password — VARCHAR(64)
- openDate — VARCHAR(8)
- closeDate — VARCHAR(8)
- deposit — BIGINT
- withholding — BIGINT
- creationTimestamp — TIMESTAMP
- updateTimestamp — TIMESTAMP
holdings
- accountNumber — VARCHAR(64) — Foreign key → accounts.accountNumber — NOT NULL
- stockTicker — VARCHAR(10) — Foreign key → stocks.stockTicker — NOT NULL
- quantity — BIGINT
- totalPrice — BIGINT
- creationTimestamp — TIMESTAMP
- updateTimestamp — TIMESTAMP
offers
- offerNumber — NUMBER — Primary key — NOT NULL
- accountNumber — VARCHAR(64) — NOT NULL
- stockTicker — VARCHAR(10) — NOT NULL
- offerDate — VARCHAR(8) — NOT NULL
- exchangeCode — NUMBER
- status — VARCHAR(4)
- type — VARCHAR(4)
- quantity — BIGINT
- price — BIGINT
- traded — BIGINT
- notTraded — BIGINT
- creationTimestamp — TIMESTAMP
- updateTimestamp — TIMESTAMP
reports
- reportDate — VARCHAR(8) — Primary key — NOT NULL
- stockTicker — VARCHAR(10) — Foreign key → stocks.stockTicker — NOT NULL
- previousClose — BIGINT
- open — BIGINT
- high — BIGINT
- low — BIGINT
- volume — BIGINT
- creationTimestamp — TIMESTAMP
- updateTimestamp — TIMESTAMP
stocks
- stockTicker — VARCHAR(10) — Primary key — NOT NULL
- status — VARCHAR(4)
- name — VARCHAR(20)
- description — TEXT
- sector — VARCHAR(4)
- listDate — VARCHAR(8)
- delistDate — VARCHAR(8)
- creationTimestamp — TIMESTAMP
- updateTimestamp — TIMESTAMP
trades
- tradeNumber — NUMBER — Primary key — NOT NULL
- offerNumber2 — NUMBER — NOT NULL
- tradeDate — VARCHAR(8) — NOT NULL
- exchangeActual — NUMBER
- sellerAccountNumber — VARCHAR(64)
- buyerAccountNumber — VARCHAR(64)
- quantity — BIGINT
- price — BIGINT
- charge — INT
- creationTimestamp — TIMESTAMP
- updateTimestamp — TIMESTAMP
users
- userId — VARCHAR(64) — Primary key — NOT NULL
- password — VARCHAR(64)
- name — VARCHAR(20)
- status — VARCHAR(4)
- type — VARCHAR(4)
- email — VARCHAR(40)
- phoneNumber — VARCHAR(20)
- gender — VARCHAR(4)
- age — TINYINT
- birthDate — VARCHAR(8)
- income — INT
- riskTolerance — VARCHAR(4)
- creationTimestamp — TIMESTAMP
- updateTimestamp — TIMESTAMP