Database Structure without primary and foreing keys?

14 views
Skip to first unread message

Dominik Bahl

unread,
May 15, 2019, 3:44:55 AM5/15/19
to schedulix
Dear schedulix Team,

is it normal, that the whole database and its tables has no primary and foreign keys?

It is easier for me to understand the database structure if there were primary and foreign keys.

We are currently using Schedulix 2.8.

Best regards
Dominik Bahl

Dieter Stubler

unread,
May 15, 2019, 4:25:18 AM5/15/19
to schedulix
Hi,
You are right, there are no referential integrities defined in the database.
Since the schedulix server is the only instance writing to the database, integrity is enforced by the schedulix server itself.
Having primary key and foreign key definitions in the database would slow down database updates.
Regards
Dieter
Reply all
Reply to author
Forward
0 new messages