| 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 |
| 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 |
| 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 |
| VARCHAR(200) | EMail of the person | |
| LASTSYNCHRONIZE | TIMESTAMP | Timestamp of the last synchronization |