Question: What do the codes in the accounttype field in the accountlines table stand for?
Answer:
A = acc't management fee
C = credit
F = overdue fine
FOR =forgiven
FU = overdue, still acccruing
L = Lost Item
M = Sundry
N = New Card
PAY = payment
W = writeoff
Question: What are the possible codes for the type field in the statistics table?
Answer:
localuse
Registers if an item that had been checked out to a statistics patron (category type = 'X') is returned
issue
return
renew
writeoff
payment
CreditXXX
stores different types of fee credits, so a query to catch them all would include a clause like "type LIKE 'Credit%'"