...
DB should contain table for each logged object. This will improve performance by reducing the size of the table.
Tables: loans, feesFines, itemBlock, patronBlock, manualBlock, request
Typical table structure:
| id | user | item | action | date | servicePoint | source | description | linkTo | notes |
|---|---|---|---|---|---|---|---|---|---|
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
HL Flow Design
Flow description:
...