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


Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"opportunities_ID_seq"'::regclass)
messages.opportunity FK_messages_opportunity N
ownergroup int4 10 null
groups.ID FK_opportunities_ownergroup C

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

creator int4 10 null
users.ID FK_opportunities_creator N

The object creator

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

account int4 10 null
accounts.ID FK_opportunities_account N

Reference to the associated account

contact int4 10 null
contacts.ID FK_opportunities_contact N

Reference to the associated contact

campaign int4 10 null
campaigns.ID FK_opportunities_campaign N
visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

name text 2147483647 null
opportunitynum text 2147483647 ''::text

Unique number

duedate int8 19 null

Unix timestamp in seconds

status int2 5 0

0: Unveluated, 1: Eligible, 2: Feedback required, 3: In negotation, 4: Offered, 5: Accepted, 6: Rejected

priority int2 5 2

priority status (0: Lowest, 1: Low, 2: Medium, 3: High, 4: Highest)

probability int2 5 0

Conversion probability

worstcase float8 17,17 0

Worst possible revenue

mostlikely float8 17,17 0

Most likely revenue

upside float8 17,17 0

Upside revenue

description text 2147483647 ''::text

The general description field

Table contained 0 rows


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