projects


Details

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"projects_ID_seq"'::regclass)
tasks.project FK_tasks_project N
tickets.project FK_tickets_project N
owneruser int4 10 null
users.ID FK_projects_owneruser C

The owner user

ownergroup int4 10 null
groups.ID FK_projects_ownergroup C

The owner group (if owneruser and ownergroup are NULL, the element is public)

creator int4 10 null
users.ID FK_projects_creator N

The object creator

assigneduser int4 10 null
users.ID FK_projects_assigneduser N

The assigned user

creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

name text 2147483647 null
projectnum text 2147483647 ''::text
status int2 5 0

0: Draft, 1: Not started, 2: Awaiting approval, 3: Approved, 4: Dismissed, 5: Active, 6: Inactive, 7: Testing, 8: Cancelled, 9: Completed, 10: Failed, 11: Booked

description text 2147483647 ''::text

The general description field

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_projects_ID Primary key Asc ID

Relationships