| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
CONTACTLINKID (PK) |
STANDARDID(12) |
NOT NULL |
CONTACTLINK_CONTACTLINKID_PK (CA) |
|
|
|
CONTACTID (FK) |
STANDARDID(12) |
NOT NULL |
|
(Many) to (One) |
|
|
RCSEQNO |
int(4) |
NOT NULL |
|
|
|
|
RCCOMMANDSTRING |
varchar(80) |
NULLS |
|
|
|
|
RCDESC |
varchar(80) |
NULLS |
|
|
|
|
RCSERVERID |
varchar(80) |
NULLS |
|
|
|
|
RCINVENTORYPATH |
varchar(128) |
NULLS |
|
|
|
|
RCAPPLICATIONPATH |
varchar(128) |
NULLS |
|
|
|
|
RCNICID |
varchar(80) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
RCPARAMETERSTRING |
varchar(128) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|