opportunities

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	integer	plain			Opportunity ID
fork	integer	plain		forks.ID	Fork ID (`null` for base module)
ownergroup	integer	plain		groups.ID	Owner group ID (`null`=PUBLIC)
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)
account	integer	plain		accounts.ID	Account ID
contact	integer	plain		contacts.ID	Contact ID
campaign	integer	plain		campaigns.ID	Campaign ID
visibility	smallint	plain			Default: 0Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
name	text	main			Name
opportunitynum	text	main			Default: ''Opportunity number
date	bigint	plain			Default: EXTRACT(epoch FROM now())Designated date and time as a Unix timestamp (defaults to current date and time on creation)
duedate	bigint	plain			Due date as a Unix timestamp
status	smallint	plain			Default: 0Status (`0`=UNEVALUATED, `1`=ELIGIBLE, `2`=FEEDBACKREQUIRED, `3`=INNEGOTIATION, `4`=OFFERED, `5`=ACCEPTED, `6`=REJECTED)
priority	smallint	plain			Default: 2Priority (`0`=LOWEST, `1`=LOW, `2`=MEDIUM, `3`=HIGH, `4`=HIGHEST)
probability	smallint	plain			Default: 0Probability of success in percent; must be `100` for ACCEPTED
worstcase	double precision	plain			Default: 0Worst-case monetary outcome
mostlikely	double precision	plain			Default: 0Most likely monetary outcome
upside	double precision	plain			Default: 0Upside monetary outcome
description	text	extended			Default: ''Detailed general description

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_opportunities_account					btree	account
fk_opportunities_assigneduser					gin	assigneduser
fk_opportunities_campaign					btree	campaign
fk_opportunities_contact					btree	contact
fk_opportunities_fork					gin	fork
fk_opportunities_ownergroup					gin	ownergroup
i_opportunities_date					btree	date
i_opportunities_nofork					gin	fork
i_opportunities_noowner					gin	ownergroup
pk_opportunities					btree	ID
s_opportunities_name					gin	name
s_opportunities_opportunitynum					gin	opportunitynum

Name	Type
c_opportunities_probability	check
dc_opportunities_description	check
dc_opportunities_mostlikely	check
dc_opportunities_name	check
dc_opportunities_opportunitynum	check
dc_opportunities_priority	check
dc_opportunities_probability	check
dc_opportunities_status	check
dc_opportunities_upside	check
dc_opportunities_visibility	check
dc_opportunities_worstcase	check
fk_opportunities_account	foreign_key
fk_opportunities_assigneduser	foreign_key
fk_opportunities_campaign	foreign_key
fk_opportunities_contact	foreign_key
fk_opportunities_creator	foreign_key
fk_opportunities_fork	foreign_key
fk_opportunities_ownergroup	foreign_key
pk_opportunities	primary_key

Loading...