| 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 |