Document toolboxDocument toolbox

Creating the Database

Owned by Matthew Wren
Jan 29, 2024
1 min read

On This Page:

Creating a Schema

SQLServer

SQL Server databases will be supplied and configured by ServicePower consultants.

Oracle

ServiceScheduling requires the use of a UTF-8 character set. The database user & schema below must be created in an Oracle database with the NLS_CHARACTERSET set to AL32UTF8 (using the CREATE DATABASE statement).

  1. Create a Database User.
  2. Create a Database Schema.

 

Preloaded Data

The following database tables are preloaded with a default set data. These data may or may not remain in place for use by your business, but the relevant tables are mentioned here.

DataDatabase Table
Postcode look up algorithms to support differing geographies/countries (e.g. UK/USA)sp046_postcode_patterns
Time zone datasp056_time_zones