Added in Version 7.0
The MKTGSVC_USERINFO table stores user login and other related data for a marketing services user. This table contains information including, but not limited to, the user ID, service code, service login, service password, usage count, and owner e-mail.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
USERID (PK) |
char(12) |
NOT NULL |
MKTGSVC_USERINFO_USERID_PK (CA) |
(One) to (Many) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
ISPRIMARY |
char(1) |
NULLS |
MKTG_USERINFO_ISPRIMARY (IE) |
|
|
|
SERVICE_CODE |
varchar(20) |
NULLS |
|
|
|
|
SERVICE_LOGIN |
varchar(20) |
NULLS |
|
|
|
|
SERVICE_PASSWORD |
varchar(128) |
NULLS |
|
|
|
|
USAGE_COUNT |
int(1) |
NULLS |
|
|
|
|
USE_PRIMARY |
char(1) |
NULLS |
|
|
|
|
OWNER_EMAIL |
varchar(128) |
NULLS |
|
|
|
|
AUTO_IMPORT |
char(1) |
NULLS |
|
|
|
|
ENABLED |
char(1) |
NULLS |
|
|
|