MRenvoize/Accounts Schema

Koha Accounts Rewrite - DB Schema

My attempt at a normalised database design for an alternative accounts re-write

ac_Journals

Records itemized journals of money owed/credited against actions in koha [Fines, Credits, Invoices]

• id
• created [datetime]
• updated [datetime]
• amount (+Credit/-Debit)
• offset (starts as inverse of amount, tends toward 0)
• type [fine, purchase, refund, credit, debit] - ( ? should this be in it’s own table ? )
• detail [?]
• note [?]

ac_JournalTransactions

Records transactions, money changing hands, against journals. One journal may have multiple transactions recorded against it (partial payments); likewise, one transaction may bit split between multiple journals (bulk payments)

• journal [ac_journals.id]
• transaction [ac_transactions.id]
• amount [+/-]

ac_Transactions

Records transactions, money changing hands.

• id
• amount [+/-]
• type [credit card, cheque, cash, online]

ac_TillTransactions

Records the till and staff member operating it and associates it with a transaction.

• till [ac_tills.id]
• transaction [ac_transactions.id]
• staff [borrowers.id]

ac_Tills

Records virtual till details

• id
• name
• description

ac_BorrowerJournals

• borrower [borrowers.id]
• journal [journals.id]

ac_ItemJournals

Records

• item [items.id]
• journal [journals.id]

ac_Tax

Records tax band configuration

• id
• name
• rate

ac_JournalsTax

Records the tax association of a journal

• journal [journals.id]
• tax [tax.id]