Database Overview

The Database has the following schema:

  • Client schema ([client]) - All tables created and maintained in the Client Extension. These have Read/Write access.
  • DBO schema ([dbo]) - dbo is the default schema in Microsoft SQL Server and indicates DirectScale tables that clients have read-only access from the Client Extension. However, you can edit these tables, as well as custom client tables, using the UI Data Editor.

Table Categories

Many of the tables have a prefix in their name to help categorize them. The label convention is three capital letters and an underscore. The three categories are:

  • CRM – Customer Relationship Management
  • INV – Inventory
  • ORD – Order

Other tables with no prefixes are either system tables or tables that span all three categories. For example, Countries is a table with no prefix as it is equally important to Associate addresses as well as shipping information in orders.

Where is Associate/Distributor info?

CRM_Distributors is the Associates' base set of information. From there, other tables that store an Associate's record use the recordnumber from CRM_Distributors as the Associate ID.

Note: Over time, as the table structure evolved, the common name has changed from Distributor to Associate. Because of this, on some tables, the key field is named Distributor ID and in some, it is called Associate ID. Read more in Understanding Platform IDs

Replicated Databases

DirectScale offers Database replicas for business intelligence purposes, but clients can technically use them for whatever they want. Just like the master Database, replicas are read-only. Clients can have as many replicas as they want. If clients want a reporting database, spun up in a data center closer to their corporate offices, they can.