The Competitor table stores information about competitors. This information includes the competitor name, phone number, the rating you would give the competitor, the strengths and weaknesses of the competitor, products of the competitor and possible strategy. This information is entered in Infor CRM.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
COMPETITORID (PK) |
STANDARDID |
NOT NULL |
COMPETITOR_COMPETITORID_PK(CA) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
COMPETITOR |
varchar(128) |
NULLS |
|
|
|
|
CONTACT |
varchar(64) |
NULLS |
|
|
|
|
PHONE |
varchar(32) |
NULLS |
|
|
|
|
RATING |
int |
NULLS |
|
|
|
|
PRODUCTS |
varchar(64) |
NULLS |
|
|
|
|
STRENGTHS |
varchar(128) |
NULLS |
|
|
|
|
WEAKNESSES |
varchar(128) |
NULLS |
|
|
|
|
NOTES |
Textblob |
NULLS |
|
|
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
ACCOUNTID (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
STRATEGY |
varchar(128) |
NULLS |
|
|
|
|
WEBADDRESS |
varchar(128) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|