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 8.2
The CONTACTAUDIT table contains information about a contact's Infor CRMsign in and usage history.
|
|
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 |
|---|---|---|---|---|---|
| CONTACTAUDITID (PK) | char(12) | NOT NULL | CONTACTAUDIT_PRIMARY (AK) | ||
| char(12) | NOT NULL | CONTACTAUDIT_CONTACTID (IE) | |||
| CREATEUSER | char(12) | NULLS | |||
| CREATEDATE | datetime(8) | NULLS | |||
| MODIFYUSER | char(12) | NULLS | |||
| MODIFYDATE | datetime(8) | NULLS | |||
| EVENTNAME | varchar(64) | NULLS | |||
| EVENTDATETIME | datetime(8) | NULLS | |||
| EVENTSOURCE | varchar(64) | NULLS | |||
| IPADDRESS | varchar(64) | NULLS | |||
| LANGUAGE | varchar(16) | NULLS | |||
| TIMEZONE | varchar(64) | NULLS | |||
| ADDITIONALINFO | varchar(64) | NULLS | |||
| BROWSERVERSION | varchar(32) | NULLS |