Database model

T4U_PROJECTS

ID VARCHAR(36) PRIMARY KEY Primary key
REVISION NUMBER(20) NOT NULL Revision number
LASTMODIFIEDBYCLIENT NUMBER(20) NOT NULL Id of the client doing the last modification
NAME VARCHAR(40) NOT NULL Name of the project
DESCRIPTION VARCHAR(1000) Description of the project
ACTIVE NUMBER(1) NOT NULL Flag if the project is active
DELETED NUMBER(1) NOT NULL Flag if the project is deleted
PARENT_ID VARCHAR(36)
REFERENCES T4U_PROJECTS(ID)
Id of the parent project (NULL if root project)
PARENTKEY VARCHAR(1000) NOT NULL ':' separated list of IDs of all parent
projects including self

T4U_TASKS

ID VARCHAR(36) PRIMARY KEY Primary key
REVISION NUMBER(20) NOT NULL Revision number
LASTMODIFIEDBYCLIENT NUMBER(20) NOT NULL Id of the client doing the last modification
NAME VARCHAR(40) NOT NULL Name of the task
DESCRIPTION VARCHAR(1000) Description of the task
ACTIVE NUMBER(1) NOT NULL Flag if the task is active
DELETED NUMBER(1) NOT NULL Flag if the task is deleted
PROJECT_ID VARCHAR(36)
REFERENCES T4U_PROJECTS(ID)
Id of the project the task belongs to

T4U_PERSONS

ID VARCHAR(36) PRIMARY KEY Primary key
REVISION NUMBER(20) NOT NULL Revision number
LASTMODIFIEDBYCLIENT NUMBER(20) NOT NULL Id of the client doing the last modification
DELETED NUMBER(1) NOT NULL Flag if the person is deleted
SURNAME VARCHAR(50) NOT NULL Surname of the person
GIVENNAME VARCHAR(50) Given name of the person
EMAIL VARCHAR(200) EMail of the person
LASTSYNCHRONIZE TIMESTAMP Timestamp of the last synchronization