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 CONTRACTINCIDENT table records information on type and number of incidents (tickets) assigned to a support contract.
|
|
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 |
|---|---|---|---|---|---|
|
CONTRACTINCIDENTID (PK) |
STANDARDID(12) |
NOT NULL |
CONTRACTINCIDENT_CONTRACTINCIDENTID_PK (AK) |
||
|
CONTRACTID (FK) |
STANDARDID(12) |
NOT NULL |
CONTRACTINCIDENT_COMPOSITE (CA) |
(Many) to (One) |
|
|
TICKETID (FK) |
STANDARDID(12) |
NOT NULL |
CONTRACTINCIDENT_COMPOSITE (CA) |
(Many) to (One) |
|
|
TICKETACTIVITYID (FK) |
STANDARDID(12) |
NULLS |
CONTRACTINCIDENT_COMPOSITE (CA) |
(Many) to (One) |
|
|
HOURS |
float(8) |
NULLS |
|
|
|
|
DOLLARS |
decimal(17,4) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |