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 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

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_projects Primary key Asc ID
i_projects_noowner Performance Asc ownergroup
i_projects_owner Performance Asc/Asc/Asc owneruser + ownergroup + assigneduser
s_projects Performance Asc/Asc name + projectnum

Relationships

Close relationships within degrees of separation