Tables [dbo].[IDX_User]
Any "User" or "User/Provider" in the system
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_IDX_User_ID: IDForeign Keys FK_IDX_User_ID_Person_ID: [dbo].[Person].IDID[dbo].[uniqueid]9NOT NULLKey to the IDX_User Table
Check Constraints CK_IDX_User_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLIs the User Inactive? An Inative User cannot log into TouchWorks.