Database structure

[jaonoctus]

• Migrations are in /database/migrations
• Models are in /app

TODO

• [x] Fix decimals precision and scale.
• [ ] Move models to /app/models folder. in progress
• [ ] Use laravel-auditing to track changes.

[jaonoctus]

@vjoao @ibrunotome

What about it, guys?

[ibrunotome]

Hi, I think the decimal fields can't be 8,2, because much of the orders will be a big fraction like 0,00724 for example. I suggest a 16,8 like the binance uses.

• I suggest move the models to a folder called Models in /app too.
• Not related to the structure, but I suggest to use the laravel-auditing package too to track every single change on the models.

[jaonoctus]

@ibrunotome I totally agree!

I've updated this issue with a "TODO" section.

Thanks

[vinyvicente]

@jaonoctus, uses uuid in public reference (orders, by example), id integer is vulnerable, principally to inspect element, etc :)

[vjoao]

@vinyvicente Order information is already public. As UUIDs are 4 times larger than integers, this might reflect in storage problems in the future.

[jaonoctus]

@vinyvicente, I agree with @vjoao. But, for sensitive data, we can use hashids.