Patriot Database Schema
In some cases, it may be useful to access the Patriot database directly.
Patriot has an open database, which means that direct access is allowed as long
as the following restrictions are followed.
- Reading Data
- There is no problem with reading data from the Patriot database, the
only concern you should have is the additional workload of running
queries on the server. Poorly written queries can have a dramatic impact
on server performance.
- Inserting / Updating / Deleting Data
- Changing data in the Patriot database is not recommended. While the
database does have some integrity built in, we cannot protect against all
possible invalid data being inserted into the database. Serious caution
must be taken before any data is changed in the database. Patriot takes
no responsibility from the consequences of invalid data inserted or
changed outside of Patriot itself. A much safer way to alter the data in
the database is by using the JSON
Services or Patriot
SDKs.
- Altering the database structure
- Under no circumstances should the database structure be altered in any
way. Altering the database structure includes adding tables, fields to
tables, altering keys etc.
Schema File
A Microsoft Excel spreadsheet containing details about the Patriot database
structure can be downloaded here:
Download Schema
Spreadsheet
You will need a copy of Microsoft Excel to view the spreadsheet, or
alternatively you can use the Microsoft
Excel Viewer for readonly access to the file.