How to create a table to store information about Order on the exchange?

K

kajarukami2019-09-09 14:22:23

Database design

kajarukami, 2019-09-09 14:22:23

I just can’t figure out how to correctly create a structure / tables for Orders on the exchange.
so far only 2 cases for simplicity:
* I want to buy 500 USD for 0.7 EUR / 1 USD
* I want to sell 800 GBP for 1.6 USD / 1 GBP
How do I create a structure/table to store this information without redundancy? That is, buy and sell.
Created one. I can't figure out if it's right or not.

orders:
  - amount_want
  - currency_want
  - amount_per_unit_offer
  - currency_offer

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

E

Enj0y, 2019-09-09
@Enj0y

Well, I think it’s worth adding an AI counter id, otherwise I’m not strong in the exchange, but I don’t really understand how you define the sale and purchase