Added in Version 7.0
The QUALIFICATION_CATEGORY table stores information pertaining to the categories of lead qualification. This table contains information including, but not limited to, the qualification category ID and category name.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
QUALIFICATION_CATEGORYID (PK) |
char(12) |
NOT NULL |
QUALIFICATION_CATEGORY_ID_PK (CA) |
(One) to (Many) |
|
|
(One) to (Many) |
QUALIFICATION.QUALIFICATION_CATEGORYID
|
||||
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
CATEGORYNAME |
varchar(64) |
NULLS |
QUALIFICATION_CATEGORY_NAME (AK) |
|
|