DB Sync objects

The DB Sync database schema defines the structure of your SQL database, describing the SQL tables containing data that is shared by the central database and the local databases used by DB Sync client apps.

A DB Sync client app defines a nomad app that can work offline, which uses a local database containing a set of SQL tables. These SQL tables need to be associated to the app, in the app definition. The association of an SQL table with a DB Sync client app defines the concept of app/table pair.

A DB Sync user represents an end user, that can execute one or more DB Sync client apps. The association of a DB Sync user with a DB Sync client app defines the concept of user/app pair.

The DB Sync central change log is a DB Sync system table that contains all modifications done by DB Sync client apps and DB Sync server-side apps, throught the DB Sync system.

A given DB Sync user executing a DB Sync client app can change rows in an SQL table used by this app. This defines the concept of user/app/table trio, which is used to register modification events in the central change log, and define permissions.

The DB Sync administrator defines apps, associates SQL tables to apps, and defines which app(s) a user can execute.

The DB Sync administrator uses DB Sync configuration apps to setup the system.

With the GAS/SSO/GIP solution, DB Sync user objects are automatically created by the DB Sync system during the first sync procedure with the DB Sync server.

A DB Sync client app (with its local database) needs to be identified by a unique id such as app_employee.