Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"actionsteps_ID_seq"'::regclass)
owneruser int4 10 null
users.ID FK_actionsteps_owneruser C

The owner user

ownergroup int4 10 null
groups.ID FK_actionsteps_ownergroup C

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

creator int4 10 null
users.ID FK_actionsteps_creator N

The object creator

assigneduser int4 10 null
users.ID FK_actionsteps_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)

task int4 10 null
tasks.ID FK_actionsteps_task N

Acion steps can belong to a task

ticket int4 10 null
tickets.ID FK_actionsteps_ticket N

Reference to the associated ticket

account int4 10 null
accounts.ID FK_actionsteps_account N

Acion steps can also be assigned to a account

transaction int4 10 null
transactions.ID FK_actionsteps_transaction N

Linked billing transaction - if the transaction is cancelled, the action step status will reset to Completed (1)

name text 2147483647 null
actionnum text 2147483647 ''::text

A unique transaction number

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

Unix timestamp in seconds

duedate int8 19 null

Unix timestamp in seconds

status int2 5 0

0: Draft, 1: Completed, 2: Cancelled, 3: Booked (e.g. if the action step is billed - see column transaction)

effort int4 10 null

The booked time effort in minutes

description text 2147483647 ''::text

The general description field

Table contained 0 rows


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