Table documentlog

Storage space for printed documents. To be filled by the client whenever something is printed, to be emptied by auditors.

Column NameTypePropertiesDocu
docidseq64Primary-Key automatic key for this table
logtimeint64time at which the data was logged
unamestring:64NULL-able Foreign-Key=user(uname) user who printed the document
orderidint32NULL-able Foreign-Key=order(orderid) the order it refers to
doctypestring:32type of document (bill, eventoverview, etc.)
docbodyblobthe document