projects
Project records for organizing tasks and tickets.
Status codes
| Status | Activity | ID |
|---|---|---|
| Draft | DRAFT | 0 |
| Not started | DRAFT | 1 |
| Awaiting approval | DRAFT | 2 |
| Approved | OPEN | 3 |
| Dismissed | CANCELLED | 4 |
| Active | OPEN | 5 |
| Inactive | OPEN | 6 |
| Testing | OPEN | 7 |
| Cancelled | CANCELLED | 8 |
| Completed | CLOSED | 9 |
| Failed | CLOSED | 10 |
| Booked | CLOSED | 11 |
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
PKID | integer | Project ID | ||
fork forks.ID | integer | Fork ID (`null` for base module) | ||
owneruser users.ID | integer | Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`) | ||
ownergroup groups.ID | integer | Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`) | ||
creator | integer | Creator user ID (defaults to authenticated user on creation) | ||
assigneduser users.ID | integer | Assigned user ID | ||
creationdate | bigint | date_part('epoch', now()) | Creation date and time as a Unix timestamp (defaults to current date and time on creation) | |
lastmodified | bigint | date_part('epoch', now()) | Last modification date and time as a Unix timestamp (auto-reset on modification) | |
account accounts.ID | integer | Account ID | ||
visibility | smallint | 0 | Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED) | |
name | text | Name | ||
projectnum | text | '' | Project number | |
status | smallint | 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 | '' | Detailed general description |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| fk_projects_account | btree | account | ||||
| fk_projects_assigneduser | gin | assigneduser | ||||
| fk_projects_fork | gin | fork | ||||
| fk_projects_ownergroup | gin | ownergroup | ||||
| fk_projects_owneruser | gin | owneruser | ||||
| i_projects_nofork | gin | fork | ||||
| i_projects_noowner | gin | ownergroup | ||||
| pk_projects | btree | ID | ||||
| s_projects_name | gin | name | ||||
| s_projects_projectnum | gin | projectnum |
| Name | Type |
|---|---|
| dc_projects_description | check |
| dc_projects_name | check |
| dc_projects_projectnum | check |
| dc_projects_status | check |
| dc_projects_visibility | check |
| fk_projects_account | foreign_key |
| fk_projects_assigneduser | foreign_key |
| fk_projects_fork | foreign_key |
| fk_projects_ownergroup | foreign_key |
| fk_projects_owneruser | foreign_key |
| pk_projects | primary_key |
Loading...