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.
For example SQL queries, you can find a detailed run-through of building custom reports with Crystal Reports as an example. Additionally you can refer to the repository of the SQL queries used in the PaperCut reports as starting points for your customized queries.
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 6 June 2024 - Version 24.0.1
Version 24 PaperCut Database Schema 24.0.1 (PDF) - Updated 27th May 2024 - Version 24.0.1
Version 23 PaperCut Database Schema 23.0.9 (PDF) - Updated 6th May 2024 - Version 23.0.9
Version 22 PaperCut Database Schema 22.1.3 (PDF) - Updated 5th July 2023 - Version 22.1.3
Version 21 PaperCut Database Schema 21.0.0 (PDF) - Updated 23rd Mar 2021 - Version 21.0.0
Version 20 PaperCut Database Schema 20.1.0 (PDF) - Updated 29th Oct 2020 - Version 20.1.0
Version 19 PaperCut Database Schema 19.2.0 (PDF) - Updated 14th November 2019 - Version 19.2.0
Version 18 PaperCut Database Schema Revision 18.3 (Build 47391) (PDF) - Updated 19th November 2018 - Version 18.3 (Build 47391)
Version 16 PaperCut Database Schema Revision 40 (PDF) - Updated 17th March 2016 - Version 16.0 (Build 34949)
Version 15 PaperCut Database Schema Revision 38 (PDF) - Updated 30th November 2015 - Version 15.3 (Build 34078)
PaperCut Database Schema Revision 37 (PDF) - Updated 9th September 2015 - Version 15.2 (Build 33661)
PaperCut Database Schema Revision 35 (PDF) - Updated 3rd March 2015 - Version 15.0 (Build 31930)
Version 14 PaperCut Database Schema Revision 34 (PDF) - Updated 22nd October 2014 - Version 14.3 (Build 29819)
Version 13 PaperCut Database Schema Revision 33 (PDF) - Updated 27th November 2013 - Version 13.5 (Build 24862)
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)
Version 11 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)
Version 10 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)
Version 9 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)
Version 8 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:
[app-dir]/server/lib/sql
If you have any questions about the DB Schema, or data access in general, please contact our support team.
Comments
0 comments
Please sign in to leave a comment.