Income-expense accounting module - what to look for?

Question

API

I am writing a module that will deal with the accounting of income and expenses.
Each income-expense has four properties:
- amount (in rubles) - required
- user id - required
- foreign key - optional
- status (pending|confirmed|canceled) - required
foreign key is needed to bind to the entity on which money is spent.
transaction statuses are related to the status of the external entity (if the external entity has been confirmed, then all its transactions have been confirmed).
How to better organize the code, " based on the fact that all programmers who will maintain the program are psychopaths prone to violence"and crooked monkeys? What should I pay attention to when designing to ensure data integrity?

Answer 1

User ID

What user is this: a storekeeper or someone who requests an item (entity)?
It's not very clear why this is.
Shrinkage-shrinkage-shrinkage ratio?
Also, the fields for quantity and dimension are not visible - tons-kilometers-pieces, etc.
Missing transaction date field.
It is not entirely clear how to distinguish income from expenses.
p.s. Well, it’s probably not very productive to consider someone a “crooked monkey” a priori. Not the gods burn the pots.
pps. It is worth finding a book on the subject area and using the terms from there right in the code. This will make life easier for you, users, and programmers alike. "Common language" decides.