USER_ACTIVITY Table

The USER_ACTIVITY table contains information on the users involved with each activity. This table has an identifying relationship to the ACTIVITY table and the USERINFO table.

If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document.
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.

Legend

Field	Datatype (Length)	Allow Nulls	Indexes	Relationship	Related Table and Field
ACTIVITYID (PK) (FK)	STANDARDID(12)	NOT NULL	USER_ACTIVITY_USERID_ACTID_PK (CA)	(Many) to (One)	ACTIVITY.ACTIVITYID
USERID (PK) (FK)	STANDARDID(12)	NOT NULL	USER_ACTIVITY_USERID_ACTID_PK (CA)	(Many) to (One)	USERSECURITY.USERID
CONFIRMED	BOOLEAN(1)	NULLS
ALARMTIME	datetime(8)	NULLS
ALARM	char(1)	NULLS
MODIFYDATE	datetime(8)	NULLS
MODIFYUSER (FK)	char(12)	NULLS		(Many) to (One)	USERINFO.USERID
CREATEDATE	datetime(8)	NULLS
CREATEUSER (FK)	char(12)	NULLS		(Many) to (One)	USERINFO.USERID
CREATESOURCE	varchar(64)	NULLS
APPID (FK)	char(12)	NULLS		(Many) to (One)	APPIDMAPPING.APPID
GLOBALSYNCID	varchar(36)	NULLS
TICK	int	NULLS