14.1 Creating the Database

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).

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.

Data	Database Table
Postcode look up algorithms to support differing geographies/countries (e.g. UK/USA)	`sp046_postcode_patterns`
Time zone data	`sp056_time_zones`