If an index entry appears in multiple table columns, then it is a composite index. A composite index requires multiple columns in order to create a unique index.
Added in Version 7.0
The REMOTEATTACHMENTS table stores information and status to identify attachments that a remote has received or requested. This is the mechanism for synchronizing attachments between a remote and Host database.
This table contains information including, but not limited to the Remote Attachment ID, Attachment ID, create user, site code and status.
|
|
If an index entry appears in multiple table columns, then it is a composite index. A composite index requires multiple columns in order to create a unique index. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
REMOTEATTACHMENTSID (PK) |
char(12) |
NOT NULL |
REMOTEATTACHMENTS_PK (AK) |
|
|
|
ATTACHID (FK) |
char(12) |
NOT NULL |
REMOTEATTACHMENTS_COMP(CA) |
(Many) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
(Many) to (One) |
||
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
(Many) to (One) |
||
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
SITECODE |
varchar(4) |
NOT NULL |
REMOTEATTACHMENTS_COMP(CA) |
|
|
|
STATUS |
varchar(32) |
NULLS |
|
|