actionsteps

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	integer	plain			Action step ID
fork	integer	plain		forks.ID	Fork ID (`null` for base module)
owneruser	integer	plain		users.ID	Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
ownergroup	integer	plain		groups.ID	Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
creator	integer	plain		users.ID	Creator user ID (defaults to authenticated user on creation)
assigneduser	integer	plain		users.ID	Assigned user ID
creationdate	bigint	plain			Default: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint	plain			Default: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification)
task	integer	plain		tasks.ID	Task ID; is mutually exclusive to `ticket` and `account`
ticket	integer	plain		tickets.ID	Ticket ID; is mutually exclusive to `task` and `account`
account	integer	plain		accounts.ID	Account ID; is mutually exclusive to `task` and `ticket`
transaction	integer	plain		transactions.ID	Transaction ID
name	text	main			Name
actionnum	text	main			Default: ''Action number
date	bigint	plain			Default: date_part('epoch', now())Designated date and time as a Unix timestamp (defaults to current date and time on creation)
duedate	bigint	plain			Due date and time as a Unix timestamp
status	smallint	plain			Default: 0Status (`0`=DRAFT, `1`=COMPLETED, `2`=CANCELLED, `3`=BOOKED)
effort	integer	plain			Default: 0Effort in minutes
description	text	extended			Default: ''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_creator	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...