I have made a first draft of MySQL tables diagrams.
But I still miss of knowledge to establish all existing links.
Obviously, as MySQL doesn't support real relational constraints, those
links are purely logical/conceptual and not enforced by embedded DB
As I have built those diagrams only by deducting relations from fields
names and alternate keys, I would be glad if you can have a look on it
and tell me the misses and errors.
These documents would help developers to take care of proper controls to
be done when adding/deleting records.
Because it is very easy with MySQL to loose the relationship's
integrity. In particular when series of updates incurs in one user
action and PHP execution is cancelled before the end. :-(