StockInformation
Timestamp (depends which needed to show the graph)
Price (float)
Quantity (float)
High (float)
Low (float)
Order
order_id
transaction_time/transaction_date
side =buy/sell
order_type =market/limit
order_price
order_quantity
status =new, partial fill pending, complete, partial fill
cancel_flag (int) 0 = not canceled 1 = canceled
cancel_quantity (float)
above are the most minimal field for Order Table
if needed to make query easier can be added:
quantity_filled
avg_price_filled
Client_Database:
StockInformation Timestamp (depends which needed to show the graph) Price (float) Quantity (float) High (float) Low (float)
Order order_id transaction_time/transaction_date side =buy/sell order_type =market/limit order_price order_quantity
status =new, partial fill pending, complete, partial fill cancel_flag (int) 0 = not canceled 1 = canceled cancel_quantity (float)
above are the most minimal field for Order Table if needed to make query easier can be added: quantity_filled avg_price_filled
Order_Result order_id order_transaction_time/order_transaction_date (if it's primary key) result_time quantity price