actionsteps


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 √ null

Action step ID
owneruser int4 10 √ null
users.ID fk_actionsteps_owneruser C

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
ownergroup int4 10 √ null
groups.ID fk_actionsteps_ownergroup C

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
creator int4 10 √ null
users.ID fk_actionsteps_creator N

Creator user ID (defaults to authenticated user on creation)
assigneduser int4 10 √ null
users.ID fk_actionsteps_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)
task int4 10 √ null
tasks.ID fk_actionsteps_task N

Task ID; is mutually exclusive to ticket and account
ticket int4 10 √ null
tickets.ID fk_actionsteps_ticket N

Ticket ID; is mutually exclusive to task and account
account int4 10 √ null
accounts.ID fk_actionsteps_account N

Account ID; is mutually exclusive to task and ticket
transaction int4 10 √ null
transactions.ID fk_actionsteps_transaction N

Transaction ID
name text 2147483647 null

Name
actionnum text 2147483647 ''::text

Action number
date int8 19 date_part('epoch'::text, now())

Designated date and time as a Unix time stamp (defaults to current date and time on creation)
duedate int8 19 √ null

Due date and time as a Unix time stamp
status int2 5 0

Status (0=DRAFT, 1=COMPLETED, 2=CANCELLED, 3=BOOKED)
effort int4 10 0

Effort in minutes
description text 2147483647 ''::text

Detailed general description

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_actionsteps Primary key Asc ID
fk_actionsteps_account Performance Asc account
fk_actionsteps_task Performance Asc task
fk_actionsteps_ticket Performance Asc ticket
fk_actionsteps_transaction Performance Asc transaction
i_actionsteps_date_ID Performance Desc/Desc date + ID
i_actionsteps_noowner Performance Asc ownergroup
i_actionsteps_owner Performance Asc/Asc/Asc owneruser + ownergroup + assigneduser
s_actionsteps Performance Asc/Asc name + actionnum

Relationships

Close relationships within degrees of separation