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