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