opportunities


Details

Status codes

Status Activity ID Color
Unevaluated DRAFT 0 green
Eligible DRAFT 1 green
Feedback required OPEN 2 orange
In negotation OPEN 3 orange
Offered OPEN 4 orange
Accepted CLOSED 5 black
Rejected CLOSED 6 black

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 √ null
messages.opportunity fk_messages_opportunity N

Opportunity ID
ownergroup int4 10 √ null
groups.ID fk_opportunities_ownergroup C

Owner group ID (null=PUBLIC)
creator int4 10 √ null
users.ID fk_opportunities_creator N

Creator user ID (defaults to authenticated user on creation)
assigneduser int4 10 √ null
users.ID fk_opportunities_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)
account int4 10 √ null
accounts.ID fk_opportunities_account N

Account ID
contact int4 10 √ null
contacts.ID fk_opportunities_contact N

Contact ID
campaign int4 10 √ null
campaigns.ID fk_opportunities_campaign N

Campaign ID
visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
name text 2147483647 null

Name
opportunitynum text 2147483647 ''::text

Opportunity number
duedate int8 19 √ null

Due date as a Unix time stamp
status int2 5 0

Status (0=UNEVALUATED, 1=ELIGIBLE, 2=FEEDBACKREQUIRED, 3=INNEGOTIATION, 4=OFFERED, 5=ACCEPTED, 6=REJECTED)
priority int2 5 2

Priority (0=LOWEST, 1=LOW, 2=MEDIUM, 3=HIGH, 4=HIGHEST)
probability int2 5 0

Probability of success in percent; must be 100 for ACCEPTED
worstcase float8 17,17 0

Worst-case monetary outcome
mostlikely float8 17,17 0

Most likely monetary outcome
upside float8 17,17 0

Upside monetary outcome
description text 2147483647 ''::text

Detailed general description

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_opportunities Primary key Asc ID
fk_opportunities_account Performance Asc account
fk_opportunities_campaign Performance Asc campaign
fk_opportunities_contact Performance Asc contact
i_opportunities_noowner Performance Asc ownergroup
i_opportunities_owner Performance Asc/Asc ownergroup + assigneduser
s_opportunities Performance Asc/Asc name + opportunitynum

Relationships

Close relationships within degrees of separation