| 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 |
|
|
Account ID |
| contact |
int4 |
10 |
√ |
|
null |
|
|
Contact ID |
| campaign |
int4 |
10 |
√ |
|
null |
|
|
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 |
