| ID |
int4 |
10 |
|
√ |
null |
|
tasks.project
|
fk_tasks_project N
|
|
tickets.project
|
fk_tickets_project N
|
|
|
Project ID |
| owneruser |
int4 |
10 |
√ |
|
null |
|
|
users.ID
|
fk_projects_owneruser C
|
|
Owner user ID (PUBLIC if owneruser=null and ownergroup=null) |
| ownergroup |
int4 |
10 |
√ |
|
null |
|
|
groups.ID
|
fk_projects_ownergroup C
|
|
Owner group ID (PUBLIC if owneruser=null and ownergroup=null) |
| creator |
int4 |
10 |
√ |
|
null |
|
|
users.ID
|
fk_projects_creator N
|
|
Creator user ID (defaults to authenticated user on creation) |
| assigneduser |
int4 |
10 |
√ |
|
null |
|
|
users.ID
|
fk_projects_assigneduser N
|
|
Assigned user ID |
| creationdate |
int8 |
19 |
|
|
date_part('epoch'::text, now()) |
|
|
Creation date and time as a Unix time stamp (defaults to current date and time on creation) |
| lastmodified |
int8 |
19 |
|
|
date_part('epoch'::text, now()) |
|
|
Last modification date and time as a Unix time stamp (auto-reset on modification) |
| visibility |
int2 |
5 |
|
|
0 |
|
|
Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED) |
| name |
text |
2147483647 |
|
|
null |
|
|
Name |
| projectnum |
text |
2147483647 |
|
|
''::text |
|
|
Project number |
| status |
int2 |
5 |
|
|
0 |
|
|
Status (0=DRAFT, 1=NOTSTARTED, 2=AWAITINGAPPROVAL, 3=APPROVED, 4=DISMISSED, 5=ACTIVE, 6=INACTIVE, 7=TESTING, 8=CANCELLED, 9=COMPLETED, 10=FAILED, 11=BOOKED) |
| description |
text |
2147483647 |
|
|
''::text |
|
|
Detailed general description |
