PaperCut NG and PaperCut MF share a common database schema. Organizations running PaperCut on an external database system such as Microsoft SQL Server, PostgreSQL, or Oracle may find the following schema diagrams useful when designing custom SQL queries and reports.
By default PaperCut stores its data in an internal database format that is not accessible for external reporting. To access the database for reporting PaperCut must be running on an external database. Instructions for moving to an external database can be found in the manual here: https://www.papercut.com/products/ng/manual/ch-ext-db.html
Where possible we strongly recommend read-only data access. Any modifications should be done either via the PaperCut interface, or via the XML-Web Services API. Direct database manipulation outside PaperCut may lead to data inconsistencies - for example, transactions logs not matching account balances.
Schema Diagrams:Up-to-date since 19th November 2018 - Version 18.3 (Build 47391)
PaperCut Database Schema Revision 32 - Updated 1st October 2013 - Version 13.4 (Build 24032)
PaperCut Database Schema Revision 31 - Updated 18th July 2013 - Version 13.3 (Build 23137)
PaperCut Database Schema Revision 30 - Updated 19th March 2013 - Version 13.1 (Build 21453)
PaperCut Database Schema Revision 29 - Updated 24th January 2013 - Version 13.0 (Build 20697)
PaperCut Database Schema Revision 28 - Updated 12th October 2011 - Version 11.5 (Build 15204)
PaperCut Database Schema Revision 27 - Updated 2nd June 2011 - Version 11.3 (Build 14148)
PaperCut Database Schema Revision 26 - Updated 11th April 2011 - Version 11.2 (Build 13713)
PaperCut Database Schema Revision 25 - Updated 11th August 2010 - Version 10.5 (Build 11527)
PaperCut Database Schema Revision 24 - Updated 24th June 2010 - Version 10.4 (Build 10808)
PaperCut Database Schema Revision 23 - Updated 17th May 2010 - Version 10.3 (Build 10448)
PaperCut Database Schema Revision 21 - Updated 25th February 2010 - Version 10.1 (Build 9802)
PaperCut Database Schema Revision 20 - Updated 28th January 2010 - Version 10.0 (Build 9546)
PaperCut Database Schema Revision 19 - Updated 28th September 2009 - Version 9.0 (Build 8855)
PaperCut Database Schema Revision 17 - Updated 27th January 2009 - Version 9.1 (Build 7117)
PaperCut Database Schema Revision 16 - Updated 22nd December 2008 - Version 9.0 (Build 6998)
PaperCut Database Schema Revision 15 - Updated 11th August 2008 - Version 8.4 (Build 6255)
PaperCut Database Schema Revision 14 - Updated 6th March 2008 - Version 8.2 (Build 5695)
Note:Site-Servers have the same schema as the Primary Server.
Database administrators or query developers may also find the SQL database creation scripts useful. These present the schema in standard SQL create statements. The scripts are located in sub directories of:
If you have any questions about the DB Schema, or data access in general, please contact our support team.
This release contains an updated Java version which no longer supports 32-bit workstations. If you have any 32-bit users launching the User Client or Release Station from a network share, see this Knowledge Base article for more information.