actionsteps
Time-tracked action steps linked to tasks, tickets, or accounts.
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
PKID | integer | Action step 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) | |
task tasks.ID | integer | Task ID; is mutually exclusive to `ticket` and `account` | ||
ticket tickets.ID | integer | Ticket ID; is mutually exclusive to `task` and `account` | ||
account accounts.ID | integer | Account ID; is mutually exclusive to `task` and `ticket` | ||
transaction transactions.ID | integer | Transaction ID | ||
name | text | Name | ||
actionnum | text | '' | Action number | |
date | bigint | date_part('epoch', now()) | Designated date and time as a Unix timestamp (defaults to current date and time on creation) | |
duedate | bigint | Due date and time as a Unix timestamp | ||
status | smallint | 0 | Status (`0`=DRAFT, `1`=COMPLETED, `2`=CANCELLED, `3`=BOOKED) | |
effort | integer | 0 | Effort in minutes | |
description | text | '' | Detailed general description |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| fk_actionsteps_account | btree | account | ||||
| fk_actionsteps_assigneduser | gin | assigneduser | ||||
| fk_actionsteps_fork | gin | fork | ||||
| fk_actionsteps_ownergroup | gin | ownergroup | ||||
| fk_actionsteps_owneruser | gin | owneruser | ||||
| fk_actionsteps_task | btree | task | ||||
| fk_actionsteps_ticket | btree | ticket | ||||
| fk_actionsteps_transaction | btree | transaction | ||||
| i_actionsteps_date | btree | date | ||||
| i_actionsteps_nofork | gin | fork | ||||
| i_actionsteps_noowner | gin | ownergroup | ||||
| pk_actionsteps | btree | ID | ||||
| s_actionsteps_actionnum | gin | actionnum | ||||
| s_actionsteps_name | gin | name |
| Name | Type |
|---|---|
| c_actionsteps_association | check |
| c_actionsteps_owner | check |
| dc_actionsteps_actionnum | check |
| dc_actionsteps_description | check |
| dc_actionsteps_effort | check |
| dc_actionsteps_name | check |
| dc_actionsteps_status | check |
| fk_actionsteps_account | foreign_key |
| fk_actionsteps_assigneduser | foreign_key |
| fk_actionsteps_fork | foreign_key |
| fk_actionsteps_ownergroup | foreign_key |
| fk_actionsteps_owneruser | foreign_key |
| fk_actionsteps_task | foreign_key |
| fk_actionsteps_ticket | foreign_key |
| fk_actionsteps_transaction | foreign_key |
| pk_actionsteps | primary_key |
Loading...