ganttproject
ganttproject copied to clipboard
Server-side Colloboque database schema
On the server-side we'll have to deal with concurrent updates of properties of the same task by different users. Such updates will be technically conflicting if all properties are stored in the same table.
The idea of resolving such conflicts is to spread the task properties over a few stored tables, and provide an updatable view for running queries and update statements as if they were in the same table.