If an index entry appears in multiple table columns, then it is a composite index. A composite index requires multiple columns in order to create a unique index.
The OPPORTUNITY_COMPETITOR table stores information about competitors that are associated with an opportunity. This table links the Opportunity table to the Competitor table.
|
|
If an index entry appears in multiple table columns, then it is a composite index. A composite index requires multiple columns in order to create a unique index. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
OPPORTUNITYID (PK) (FK) |
STANDARDID (12) |
NOT NULL |
OPPORTUNITY_COMPETITOR_OPPID_COMPID_PK (CA) |
(Many) to (One) |
|
|
COMPETITORID (PK) (FK) |
STANDARDID (12) |
NOT NULL |
OPPORTUNITY_COMPETITOR_OPPID_COMPID_PK (CA) |
(Many) to (One) |
|
|
INCUMBENT |
BOOLEAN(1) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
STRENGTHS |
varchar(128) |
NULLS |
|
|
|
|
WEAKNESSES |
varchar(128) |
NULLS |
|
|
|
|
NOTES |
TEXTBLOB(16) |
NULLS |
|
|
|
|
WONLOSS |
BOOLEAN(1) |
NULLS |
|
|
|
|
REASON |
varchar(64) |
NULLS |
|
|
|
|
STRATEGY |
varchar(128) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER(FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
RATING |
int(4) |
NULLS |
|
|
|
|
LOSTREPLACED |
char(1) |
NULLS |
|
|
|