Stock trade Service

Tables (4)

ORDER (Untitled2)

  • ORDER_NO (PK) — VARCHAR2 — Primary key — NOT NULL
  • USER_ID (FK) — VARCHAR2 — Foreign key → USERS.USER_ID — NOT NULL
  • STOCK_CODE (Key) — VARCHAR2 — Foreign key → STOCK.STOCK_CODE — NOT NULL
  • PRICE (Field2) — DECIMAL
  • QUANTITY (Field3) — DECIMAL
  • MACHING_QUANTITY (Field8) — DECIMAL
  • ORDER_TYPE (Field6) — VARCAHR2
  • ORDER_STATUS (Field4) — VARCHAR
  • CREATE_DATE (Field5) — DATE
  • TRADE_DATE (Field7) — DATE

ORDER_BOOK (Untitled4)

  • ORDER_NO (PK) — VARCHAR2 — Foreign key → ORDER.ORDER_NO — NOT NULL
  • USER_ID (FK) — VARCHAR2 — Foreign key → ORDER.USER_ID — NOT NULL
  • STOCK_CODE (Key) — VARCHAR2 — Foreign key → ORDER.STOCK_CODE — NOT NULL
  • ORDER_TYPE (Field)
  • ORDER_STATUS (Field2) — VARCHAR

STOCK (Untitled3)

  • STOCK_CODE (Key) — VARCHAR2 — Primary key — NOT NULL
  • STOCK_NAME (Field) — VARCHAR2

USERS (Untitled)

  • USER_ID (Key) — VARCHAR2 — Primary key — NOT NULL
  • USER_NAME (Field) — VARCHAR2
  • USER_PASSWORD (Field2) — VARCHAR2
  • CREATE_DATE (Field3) — DATE
  • LAST_LOGIN_DATE (Field4) — DATE