Genesys 5.1 Database scheme

[Peter]

Hi

I've seen several posts on this forum by people wanting to get hold of a copy of the Genesys database model. I've prepared a database model which shows the database tables related to:

Configuration Server
StatServer
Campaign Manager
List Manager
Call Concentrator

The model can be found at:
http://www.circleconsulting.co.nz/gcti/gcti51db.htm

Keep an eye on this site. I'll have a Genesys 6.0 database model posted within the next few weeks.

Peter,

[Wang Xiang]

I love it! Can you please also post relations between different tables and what some of those fields mean?

Thanks!!!

[Peter]

Wang

Thanks for the positive feedback.

Unlike most databases there are no "formal" relationships (ie; foreign keys) between the database tables. Configuration Server and the other applications that interact directly with the database manage all data integrity through code. This is why it's dangerous to start editing the data particularly within the configuration tables.

There's no inherent data protection in the database design. The later versions of Configuration Server perform data integrity checking. If you've edited the configuration tables incorrectly and destroyed a relationship that is relied upon then
Configuration Server will crash at startup.

Most tables are related via their DBID field. Each configuration object (ie; person, application, skill, etc) has a unique DBID. Once you understand this you can begin to make sense of the database design.

Which fields in particular were you interested in getting an explanation for? Life is too short to list them all!

Peter,

[Peter]

Since posting this message, the http://www.circleconsulting.co.nz/gcti/gcti51db.htm web page has been updated with a more "useable" PDF document which can be downloaded and printed.

Anyone who visited the page before 3 July 2001 may want to check back to get a copy of the PDF file.