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 |