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.
The ACCOUNTPRODUCT table stores information about products that are associated to an account.
table relationships
The ACCOUNTPRODUCT table has a (Zero or One) to (Many) relationship with the CONTRACTITEM table.
The ACCOUNTPRODUCT table has a (Many) to (One) relationship with the ACCOUNT and PRODUCT tables.
|
|
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 |
|---|---|---|---|---|---|
|
ACCOUNTPRODUCTID (PK) |
STANDARDID |
NOT NULL |
ACCOUNTPRODUCT_ACCOUNTPRODUCTID_PK |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
ACCOUNTID (FK) |
STANDARDID |
NULLS |
ACCOUNT_PRODUCT_ACCOUNTID (IE) |
(Many) to (One) |
|
|
PRODUCTID (FK) |
STANDARDID |
NULLS |
ACCOUNT_PRODUCT_ACCOUNTID (IE) |
(Many) to (One) |
|
|
ACCOUNTPRODUCTPARENTID (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
(represents the parent account product for hierarchy purposes)ACCOUNTPRODUCT.ACCOUNTPRODUCTID |
|
SERIALNUMBER |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD1 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD2 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD3 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD4 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD5 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD6 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD7 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD8 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD9 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD10 |
varchar(80) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
RETURNED |
BOOLEAN |
NULLS |
|
|
|
|
EVALUATION |
BOOLEAN |
NULLS |
|
|
|
|
OPPORTUNITYID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
OPPPRODUCTID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
QUANTITY |
float(8) |
NULLS |
|
|
|
|
PRODUCTNAME |
varchar(64) |
NULLS |
|
|
|
|
SALESORDERID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ACTUALID |
varchar(64) |
NULLS |
|
|
|
|
NOTES |
text(16) |
NULLS |
|
|
|
|
CONTACTID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ASSETCODE |
varchar(32) |
NULLS |
|
|
|
|
LOCATION |
varchar(64) |
NULLS |
|
|
|
|
ENVIRONMENT |
varchar(64) |
NULLS |
|
|
|
|
ASSETSYSTEM |
varchar(64) |
NULLS |
|
|
|
|
ASSETVERSION |
varchar(64) |
NULLS |
|
|
|
|
PRDDESCRIPTION |
text(16) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|