CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
Added in Version 6.0
The PLUGINATTACHMENT table stores information about attachments for the E-mail, Fax, and Letter template plugins used in Infor CRM Mail Merge.
Table Relationships
The PLUGINATTACHMENT table has a (Many) to (Zero or One) relationship with the PLUGIN table.
|
|
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table. |
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
PLUGINATTACHID |
char(12) |
NULLS |
PLUGINATTACHMENT_ID (IE) |
|
PLUGINID(FK) |
char(12) |
NULLS |
PLUGINATTACHMENT_PLUGINID (IE) |
|
FILEID(FK) |
char(12) |
NULLS |
PLUGINATTACHMENT_FILEID (IE) |
|
USERID(FK) |
char(12) |
NULLS |
PLUGINATTACHMENT_USERID (IE) |
|
ATTACHDATE |
datetime(8) |
NULLS |
|
|
EXPIREDATE |
datetime(8) |
NULLS |
|
|
REVISIONDATE |
datetime(8) |
NULLS |
|
|
FILEDATE |
datetime(8) |
NULLS |
|
|
FILENAME |
varchar(255) |
NULLS |
|
|
FILESIZE |
int(4) |
NULLS |
|
|
DESCRIPTION |
varchar(128) |
NULLS |
|
|
CRC32 |
int(4) |
NULLS |
|
|
BASEDON |
char(12) |
NULLS |
|
|
TYPE |
int(4) |
NULLS |
|
|
DATA |
image(16) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|