While this table does not have a field defined as a primary key, the RESPONSEPRODUCTID field should be unique and considered a primary key.
Added in Version 7.5
The RESPONSEPRODUCT table contains products associated with each target's response(s).
|
|
While this table does not have a field defined as a primary key, the RESPONSEPRODUCTID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
RESPONSEPRODUCTID |
char(12) |
NOT NULL |
RESPONSEPRODUCT_PRIMARY (AK) |
|
|
|
TARGETRESPONSEID (FK) |
char(12) |
NOT NULL |
RESPONSEPRODUCT_TARGETRESPID (IE) |
(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 |
|
|
|
|
PRODUCTID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |