If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document.
The Attachment table stores all identifying information about the letters, faxes, e-mail messages, URLs and other files that are attached to accounts, contacts, opportunities, tickets, defects, contracts, and procedures. The table stores information such as description, date attached, file size and name, and identifying data.
|
|
If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ATTACHID (PK) |
STANDARDID |
NOT NULL |
ATTACHMENT_ATTACHID_PK (CA) |
(One) to (Many) |
|
|
ATTACHDATE |
datetime |
NULLS |
|
|
|
|
ACCOUNTID (FK) |
STANDARDID |
NULLS |
ATTACHMENT_ACCOUNTID (IE) |
(Many) to (One) |
|
|
CONTACTID (FK) |
STANDARDID |
NULLS |
ATTACHMENT_CONTACTID (IE) |
(Many) to (One) |
|
|
OPPORTUNITYID (FK) |
STANDARDID |
NULLS |
ATTACHMENT_OPPORTUNITYID (IE) |
(Many) to (One) |
|
|
DESCRIPTION |
varchar(128) |
NULLS |
|
|
|
|
DATATYPE |
BOOLEAN |
NULLS |
|
|
|
|
FILESIZE |
int |
NULLS |
|
|
|
|
FILENAME |
varchar(255) |
NULLS |
|
|
|
|
USERID (FK) |
STANDARDID |
NULLS |
|
(Many) to (One)
|
|
|
DATA |
DATABLOB |
NULLS |
|
|
|
|
CONTRACTID (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
DEFECTID (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
DOCUMENTTYPE |
varchar(80) |
NULLS |
|
|
|
|
PROCEDUREID (FK) |
STANDARDID |
NULLS |
ATTACHMENT_PROCEDUREID (IE) |
(Many) to (One)
|
|
|
PRODUCTID (FK) |
STANDARDID |
NULLS |
ATTACHMENT_PRODUCTID (IE) |
(Many) to (One)
|
|
|
RMAID (FK) |
STANDARDID |
NULLS |
ATTACHMENT_RMAID (IE) |
(Many) to (One) |
|
|
TICKETID (FK) |
STANDARDID |
NULLS |
ATTACHMENT_TICKETID (IE) |
(Many) to (One) |
|
|
HISTORYID (FK) |
char(12) |
NULLS |
ATTACHMENT_HISTORYID (IE) |
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
LEADID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ACTIVITYID (FK) |
varchar(12) |
NULLS |
|
(Many) to (One) |
|
|
SALESORDERID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
| QUOTEID (FK) |
varchar(12) |
NULLS |
(Many) to (One) |