Database Schema Diagrams

KB Home   |   Database Schema Diagrams

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:

PaperCut Database Schema Revision 40 (PDF) - Updated 17th March 2016 - Version 16.0 (Build 34949)
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)
PaperCut Database Schema Revision 34 (PDF) - Updated 22nd October 2014 - Version 14.3 (Build 29819)
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)
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:

[app-dir]/server/lib/sql

If you have any questions about the DB Schema, or data access in general, please contact our support team.


Categories: Databases, Architecture


keywords: direct data, odbc, jdbc, database drivers, table structure, data base layout, fields

Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.

Article last modified on November 18, 2016, at 12:58 AM
Printable View   |   Article History   |   Edit Article